Problem with formula after HTML convertion

Aspose.Cells Product Family
1

In our application we have an Excel file created by the Syncfusion component (external component library, that is capable of working with spreadsheets). When we use this file to generate HTML from this Excel file - the result in place where the formula should be calculated has 0.

Here you can see the problem:
screen.png (1.6 KB)

Here you can find a small application that is reproducing this problem.
TestApp (1).zip (7.5 KB)

If you think that the problem is not on your side but in the Excel file - please let me know what is wrong.

Thanks in advance!

2

@ManMasterDevelopment,
Please try the following code to test it. We can get the correct result.

HtmlSaveOptions options = new HtmlSaveOptions(SaveFormat.Html);
options.ExportHiddenWorksheet = false;
options.ExportSingleTab = true;
options.ExportFormula = false;

Workbook doc = new Workbook(filePath + "problem.xlsx");
//add this line for formula calculation
doc.CalculateFormula();
doc.Save(filePath + "out.html", options);

Can you try it again?

3

Your solution works good. Thanks!

4

@ManMasterDevelopment,
Thank you for your feedback. If you have any questions, please feel free to contact us.