This project has moved and is read-only. For the latest updates, please go here.

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

Jun 20, 2013 at 10:50 AM
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, DocumentFormat.OpenXml version 2.0.5022.0
Jun 26, 2013 at 11: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 5:52 PM
Has anyone found a work around for this?
Aug 7, 2013 at 6:07 PM
I'll work on it. It shouldn't be hard to fix... (famous last words I know)
Aug 8, 2013 at 3:41 AM
Pick up the latest check-in.