I set icon set condition format and other condition format at the same range. After I using the workbook’s method ‘setDefaultStyle()’, the cell which with two conditional formats in effect at the same time, its style affected by the default style of the workbook, not by the style of the cell settings in html.
Here is the test code:
// java code
public class TestMain {
public static void main(String[] args) throws Exception{
Workbook workbook = new Workbook(“E:\AsposeTest\test.xlsx”);
Style style = workbook.getDefaultStyle();
style.setHorizontalAlignment(TextAlignmentType.LEFT);
workbook.save(“E:\AsposeTest\afterSetDefaultStyle.html”);
}
}
Please notice, I am able to reproduce the issue as you mentioned by using your template file and sample code. I found cell’s style is incorrect in HTML when using icon set and other conditional formatting at the same time. I have logged a ticket with an id “CELLSJAVA-44000” for your issue. We will look into it soon.
Once we have an update on it, we will let you know.