We have an application in .net core 3.1 that reads data from excel files and performs some operations based on these readings. This application works fine for simple excel data. But, if there is any mathematical equation (i.e. subtraction, addition, multiplication, division, etc.), then the output is different than the expected value.
To prove this, we created one sample POC in .net core 3.1 that reads excel cells and writes the values in console. The excel file has two decimal numbers (1.035, 2.897) on cell A1 and B1 and summation of the same in cell C1
Aspose.OMR for .NET v19.9.0
Download: https://tweeat.com/2vFyKs
@tirtht,The fact that cell.Value does not return 3.932 but 3.9319999999999995 is because in the template file it is saved as 3.9319999999999995, not 3.932. What you see in ms excel is not always the actual value in the data model and template file. As we have said, ms excel uses 15 digits to display numeric values, so if you need to get the same with ms excel, you should format the numeric value with the same rule. Lower versions of .net core do round numeric values to 15 digits for double to string by default, so you can get the same result with what shown in ms excel. But it seems .net core 3.x changes this behavior which make the output different. 2ff7e9595c
Comments