This is for Cells v4.4.0.22
Sorry, I wasn't very clear. here is the failure as an NUnit test.
I cannot upload the sample excel file, but you can create it by opening up Excel 2007 and putting "=1+1" in the first cell
[Test]
public void Excel2007GetValueForEquation()
{
string filename = "C:\\test.xlsx";
Aspose.Cells.Workbook wb = new Aspose.Cells.Workbook();
wb.Open(filename, Aspose.Cells.FileFormatType.Excel2007Xlsx);
Aspose.Cells.Worksheet ws = wb.Worksheets[0];
Aspose.Cells.Cell cell = ws.Cells[0, 0];
String s = cell.StringValue;
// Assert.AreEqual("2", s);
Console.Out.WriteLine(string.Format("s = {0}, expect s = 2", s));
int integerValue = cell.IntValue;
Console.Out.WriteLine(string.Format("integerValue = {0}, expect integerValue = 2", integerValue));
// Assert.AreEqual(2, integerValue);
}
I get s = "0" and integerValue = 0
thanks for your quick responses, let me know if you need any clarification.