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 origin excel file:test.7z (7.7 KB)
here is the html before I set default style: before.png (96.4 KB)
here is the html after I set default style(setHorizontalAlignment(TextAlignmentType.LEFT);): after.png (108.5 KB)
here is the excel file after I set default style:afterSetDefaultStyle.7z (9.9 KB)