The attached workbook IconSets.xlsx, contains a simple table with conditional formats that use Icon Sets.
Under the latest version of Aspose Cells for Java version 18.10 - when the workbook is saved as HTML, the resulting HTML shows the icons at an unexpected locations.
This can be reproduced with the following code:
final String xlFile = [PATH] + "IconSets.xlsx"; final String sheetName = "Sheet1"; Workbook wb = new Workbook(xlFile); Worksheet sheet = wb.getWorksheets().get(sheetName); wb.getWorksheets().setActiveSheetIndex(sheet.getIndex()); String htmlFile = xlFile.replace(".xlsx", "-" + sheetName + ".html"); wb.save(htmlFile); System.out.println("Successfully created HTML file:\n " + htmlFile);
When you view the produced HTML file in any browser, you should see the misaligned icons (as compared to the worksheet as rendered in Excel).