Input string was not in a correct format when reading cell value

Jun 20, 2013 at 9:50 AM
Hi,
Gettting "Input string was not in a correct format" exception when reading value from cell.
Also tried "GetDouble()" as this cell contains formula that returns number, but the same exception is thrown.
var requestedFundingStr = worksheet.Cell("C6").GetString();
File that is causing this error - file download link

ClosedXML version 0.68.1.0, DocumentFormat.OpenXml version 2.0.5022.0
Jun 26, 2013 at 10:41 PM
I just encountered this bug as well. I think it happens when a formula references an empty cell. Excel evaluates an empty cell as zero, but ClosedXML throws an exception.
Aug 7, 2013 at 4:52 PM
Has anyone found a work around for this?
Coordinator
Aug 7, 2013 at 5:07 PM
I'll work on it. It shouldn't be hard to fix... (famous last words I know)
Coordinator
Aug 8, 2013 at 2:41 AM
Pick up the latest check-in.