I'm using the LoadData function of the workbook class to pull data from an excel spreadsheet. The cell's im trying to pull data from are formulas, but I'm trying to pull the calculated value from that formula.
Example: I have a pre-made worksheet with cell a1 containing the formula =a2+b2
I then do workbook.loaddata and retrieve the value from cell a1 using the value property of the Cells class.
For some reason, in some instances I get a different value from Aspose than if I open the spreadsheet directly. In particular this seems to happen with complicated formulas. Is it possible that this is because Aspose.Cells does the calculation itself outside of Excel, and could be using a different number of decimal places in the calculation of the result? If so, is there any way to set the number of decimal places used in the calculation?
This message was posted using Aspose.Live 2 Forum