I'm actuallly using Aspose.Excel to process generated Excel files and import the value contained in database. Those Excel files contain formulas.
I have noticed a problem with the ROUND() Function which doesn't return the same value in Excel and in Aspose.Excel.
For example in the Excel file i have the following formula in Cell 0,0 : "=ROUND(42.80;0)". Excel diplays 43
When i open this Excel file with aspose and that i run following code, it will diplay 42 :
Worksheet ws = excel.Worksheets ;
MessageBox.Show("Value : " + ws.Cells[0, 0].Value) ;
Am I doing something wrong ?