Custom Number Format with Trailing Dots is ignored when exporting to HTML

Hello,

When a workbook contains text-based cells with the custom number format “@ *.”, it shows the cell content with trailing dots. When this workbook is exported to HTML, the custom format seems to be ignored and the trailing dots do not appear in the resulting HTML file.

This behavior can be seen in the latest Aspose Cells for Java version 23.1, the attached TrailingDots.xlsx file and the following Java code:

final String xlFile = "TrailingDots.xlsx";
final String outFile = xlFile.replace(".xlsx", ".html");

final Workbook wb = new Workbook(xlFile);

Files.deleteIfExists(Paths.get(outFile));
wb.save(outFile);

Running the above code should produce the attached TrailingDots.html file. If you view the HTML file in a Browser, the trailing dots are not shown.

Key Observations:

  1. In the TrailingDots.xlsx* workbook, cells A5:A15 have the custom format:
    @ *.
  2. Exporting the same Workbook as PDF does show the trailing dots as expected.

Environment Details:

  • Aspose Cells for Java 23.1
  • Java version 1.8.0_211
  • Windows 10 OS (but also reproducible under Linux).

File description in the TrailingDots.zip (51.8 KB) attachment:

  • TrailingDots.xlsx: Excel saved workbook to be used by the code above.
  • TrailingDots.html: Aspose saved HTML file resulting from the sample code above.
  • TrailingDots.pdf: Aspose saved PDF file when the Workbook is saved as PDF.

Thank you!

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-45079

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.

@oraspose
We have fixed this issue and it will be inclued into the next release version 23.2
Please check dest.zip (2.7 KB)
which is generated by the hot fix 23.1.2

1 Like

The issues you have found earlier (filed as CELLSJAVA-45079) have been fixed in Aspose.Cells for Java 23.2.