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:
- In the
TrailingDots.xlsx* workbook, cells A5:A15 have the custom format:
@ *. - 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!