Icon Sets Become Misaligned on Conversion to HTML

Aspose.Cells Product Family
21

@oraspose,

I used latest version/fix: Aspose.Cells for Java v25.11 with yoru template Excel file using the following sample code, it works OK.
e.g.,
Sample code:


        try (FileInputStream fstream = new FileInputStream("d:\\files\\ConditionalFormats.xlsx")) {
            // Instantiate a Workbook object that represents the existing Excel file
            Workbook workbook = new Workbook(fstream);

            // Get the named range
            Range range = workbook.getWorksheets().getRangeByName("IconSetLeftAlign");

            // Set the print area of the first worksheet to the address of the named range
            workbook.getWorksheets().get(0).getPageSetup().setPrintArea(range.getAddress());

            // Create HtmlSaveOptions and set desired properties
            HtmlSaveOptions saveOptions = new HtmlSaveOptions();
            saveOptions.setExportImagesAsBase64(true);
            saveOptions.setExportPrintAreaOnly(true);
            saveOptions.setExportHiddenWorksheet(false);
            saveOptions.setExportActiveWorksheetOnly(true);

            // Save the Excel file as HTML
            workbook.save("d:\\files\\out1.html", saveOptions);
        }

Please find attached the output HTML for your reference.
out1.zip (4.3 KB)

Could you please share your code snippet that you are using to produce error results (contents/shapes not aligned and repetition of objects). We will look into your issue soon.

22

Test code attached. It was used to check both HTML produced , as well as resulted word after inserting html into empty Word document.
Thank you.
JavaSample.zip (2.9 KB)

23

@oraspose,

Thanks for the sample code snippet.

I tested your scenario/case using your sample code snippet and template Excel file. I found Iconsets are misaligned and duplicated when ranges (from XLSX spreadsheet) are converted to HTML to DOCX. I spotted the issue especially with icons/shapes rendered with centered-aligned and right-aligned.

We require thorough evaluation of the issue. We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSJAVA-46557

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

24

Thanks for looking into it.
There seems to be similar / related issue with another multi-conditional icons set (named range “MultiCondIconSet”). It was previously noted on a separate thread : Icons get superimposed over numbers when Excel named range exported to HTML ).
Attached is comparison of HTML output with Excel input . Note that right-aligned icon are all disappearing, and center-aligned seemed to be cut off.
This can be reproduced with the same previously attached sample test.

Thank you.
MultiCondIconSet_issue.png (126.9 KB)

25

@oraspose,

Thank you for sharing the additional details and the screenshot.

I have already reviewed the issue you demonstrated and can confirm it. It appears that the HTMLs generated for right-aligned icons are completely disappearing, while those for center-aligned icons seem to be partially cut off. We have documented the details, along with the screenshots and observations, under the ticket “CELLSJAVA-46557” in our database. We will look into this matter at the earliest opportunity.