I've noticed that when reading from a CSV file to a worksheet using the LoadFromText method, the values of cells that should contain an empty string are set to the string qualifier. For example, is the text qualifier is a double quote, the value "" in the CSV becomes " in the worksheet. I've already submitted a quick fix on the fork at : https://hg.codeplex.com/forks/patrick1/csvreadfix, but the unit test I added is very basic and doesn't really conform to any standard. I couldn't find any other tests for this method, so I don't know if this had any side-effects that I'm not seeing.

All I did was remove both occurences of the lines :

if (QCount > 1)
{

v += new string(Format.TextQualifier, QCount / 2);

}
I'm not sure what these were meant to do.

Can someone please have a look at this issue an see if this fix works?