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

Aspose.Cells Product Family
, , ,
1

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)

2

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)

3

@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.

4

@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.

5

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