We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

When exporting html, using conditional formatting to hide the border does not take effect

When exporting html, using conditional formatting to hide the border does not take effect(aspose-cells-21.1), but it’s ok on aspose-cells-8.8.2

code show as below:

Workbook wb = new Workbook("test.xlsx");
HtmlSaveOptions options = new HtmlSaveOptions();
options.setExportActiveWorksheetOnly(true);
wb.save("test.html", options);

test.zip (8.8 KB)

The screenshot from html:
test.png (1.1 KB)

I also found another problem:
The conditional formatting border is red. When exporting html, the display is different in html and Excel.
border-red.zip (8.8 KB)
excel.png (944 Bytes)
html.png (1.0 KB)

@xhaixia,

Please notice, I am able to reproduce both your mentioned issues. I found issue(s) with conditional formatting to hide borders which is not working in Excel to HTML rendering. I have logged a ticket with an id “CELLSJAVA-43752” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

@xhaixia

The issue is fixed in v21.8.7.
aspose-cells-21.8.7-java.zip (7.4 MB)

If you saving to html manually in Excel, the display of Excel generated html is same as Aspose.Cells genreated, which is different with the one in Excel.

The issues you have found earlier (filed as CELLSJAVA-43752) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi