Inconsistent HTML output

Aspose.Cells Product Family
1

Hi,

Using Aspose Cells for Java, version 24.8.

Sample code:

Workbook workbook = new Workbook("input.xlsx");
WorksheetCollection worksheets = workbook.getWorksheets();
Worksheet worksheet = worksheets.get("S1-9.1_401091");
worksheets.setActiveSheetIndex(worksheet.getIndex());
HtmlSaveOptions saveOptions = new HtmlSaveOptions(SaveFormat.HTML);
saveOptions.setExportActiveWorksheetOnly(true);
workbook.save("output.html", saveOptions);

In the HMTL file for the exported sheet, take a look at cells D7 and E7, and compare them to the original sheet in the source Excel workbook. The inconsistency of the generated HTML output should be apparent.

Kind regards,
Taras

repro.zip (58.1 KB)

2

@TarasTielkes
By testing with sample files and code on the latest version v24.8, we can reproduce the issue. When saving the file to HTML, the data in the HTML result file is inconsistent with that in the Excel file.

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSJAVA-46107

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

3

Hi @John.He ,

Do you have an idea, where the changed value comes from?
It seems very strange, that Aspose Cells would be changing content, when exporting a sheet to HTML.

Kind regards,
Taras

4

@TarasTielkes,

We have’n t evaluated your issue yet. We kindly request a little time to thoroughly assess the problem first, after which we will provide you with specific details. We will revert to you once we have completed the analysis.

Thanks for your patience and stay tuned.

5

@TarasTielkes ,

We are pleased to inform you that your issue has been resolved. The fix will be included in an upcoming release (Aspose.Cells v24.10) that we plan to release in the first half of October 2024. You will be notified when the next version is released.

Attached is the fixed result for your reference:
fixed.zip (2.6 KB)

6

The issues you have found earlier (filed as CELLSJAVA-46107) have been fixed in Aspose.Cells for Java 24.10.