FormatException when loading CSV file


#1

When I load a CSV file using Excel.Open() in which one of the cells contains just a hyphen ("-"), I get a FormatException. Apparently it's treating this like a negative sign and expecting that digits will follow, however I want it be treated just as text. I can load the CSV file in MS Excel no problem (it doesn't show a #VALUE or anything like that). I don't want to have to search through the file and check all columns before loading it.

You can reproduce this error by loading a file that has just a single hyphen as the entire file contents.

thanks,

Brian


#2

Hi Brian,

I think you used an old version. This bug is fixed in the latest version. You can also try this attached fix.


#3

that fixed it.

thanks,

Brian