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

Get value error

Nov 25, 2014 at 2:09 AM
I found when you set the cell style is Percent then closedXml can't get the value.

e.g. To input the value like 12 in to the cell A1 and then display 12%

I try get the value in A1 like this.
 ClosedXML.Excel.XLWorkbook wb = new ClosedXML.Excel.XLWorkbook(new FileStream(@"New Microsoft Excel Test.xlsx", FileMode.OpenOrCreate));
            var testCell = wb.Worksheet("Sheet1").Cell("A1");
Then I try to get the testCell value it will throw the format exception and the valuecached is null.

Is an issue? Thanks.
Nov 25, 2014 at 5:18 AM
Edited Nov 25, 2014 at 5:27 AM
And when i got the last update code and modify the XLCell.cs to get value from InnerText, it's ok.
But its not correct way to fixed.
Dec 4, 2014 at 3:25 AM
And I had put the issus on this