Save to HTML: incorrect cell background color

Aspose.Cells Product Family
1

Hi,

Using Aspose Cells for Java, version 24.11.

Sample code:

Workbook workbook = new Workbook("input.xlsx");
HtmlSaveOptions saveOptions = new HtmlSaveOptions(SaveFormat.HTML);
WorksheetCollection worksheets = workbook.getWorksheets();
Worksheet worksheet = worksheets.get("N.10-N.20");
worksheets.setActiveSheetIndex(worksheet.getIndex());

saveOptions.setExportActiveWorksheetOnly(true);
saveOptions.setExportImagesAsBase64(true);

workbook.save("output.html", saveOptions);

Input workbook and generated HTML:
color.zip (99.0 KB)

As you can see, a large majority of the cells in the saved worksheet are rendered with a black background (which is not present when viewing the sheet with Microsoft Excel), making the appearance of the sheet quite unreadable.

Kind regards,
Taras

2

Somewhat reminiscent of this previously reported issue: Invalid text color when saving to HTML

3

@TarasTielkes,

Thanks for the template Excel file.

After initial testing, I am able to reproduce the issue as you mentioned by using your template Excel file and sample code snippet. I found incorrect cell background color when saving Excel spreadsheet to HTML.

We require thorough evaluation of the issue. 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-46180

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.

4

@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.12) that we plan to release in the first half of December 2024. You will be notified when the next version is released.
Attached is the result after fix for your reference:
output.zip (11.9 KB)

5

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