HI, we’ve encountered a slight difference in the results produced by an Excel files using aspose.
Hi,
Thanks for your posting and using Aspose.Cells.
We have tested this issue with the following sample code using the latest version and found the issue. Aspose.Cells calculation is different than MS-Excel calculation.
**Latest Version Download Link: **Aspose.Cells for .NET (Latest Version)
We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.
This issue has been logged as
- CELLSNET-45116 - Aspose.Cells calculation is different than MS-Excel calculation
I have also attached the output pdf file generated by the following code that is showing the Aspose.Cells calculation for a reference.
C#
//Load your source excel file
Workbook workbook = new Workbook(“Rep+IR+Stress+GI_Q416_Anonim.xlsm”);
//Perform workbook formula calculation by Aspose.Cells.
workbook.CalculateFormula();
//Hide all the worksheets except Results sheet
for(int i=0; i<workbook.Worksheets.Count; i++)
{
if (workbook.Worksheets[i].Name == “RESULTS”)
continue;
workbook.Worksheets[i].IsVisible = false;
}
//Render entire worksheet into single pdf page
PdfSaveOptions opts = new PdfSaveOptions();
opts.OnePagePerSheet = true;
//Save the workbook in pdf format
workbook.Save(“output.pdf”, opts);
Hi,
Hi, there are any news about this issue?
Hi,
Hi, there is any news?
Thanks for considering Aspose APIs.
We are afraid, there is no further progress on this issue. Once, we will have some update or any news for you, we will share it with you asap.
We have tried many solutions but could not get the expected result for such kind of issue. Currently we cannot find the proper solution for it so we are unable to solve it.
The issue is at the moment open and in case, we have some other news for you, we will share it with you asap.