Free Support Forum - aspose.com

Text with Vertical Text Alignment Disappears in HTML - Regressive

Hello,

Text formatted with Vertical Text Alignment disappears when exported to HTML. This is regressive to Aspose Cells version 19.12 - which shows the vertical text correctly when the workbook is exported to HTML.

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

final String xlFile = [PATH] + "VerticalText.xlsx";

Workbook wb = new Workbook(xlFile);

String html = xlFile.replace(".xlsx", "-v" + CellsHelper.getVersion() + ".html");
Files.deleteIfExists(Paths.get(html));
wb.save(html);
System.out.println("Successfully created HTML file:  " + html);

Key Observations:

  1. Cells B4:B13 in the attached Workbook are merged and formatted with Vertical Alignment (as shown in the attached VerticalText.png screenshot).
  2. Running the above code under Cells 21.3, should produce a file similar to the attached VerticalText-v21.3.0.html file.
  3. Rendering the HTML output file in a Browser, the Vertical Text from cells B4:B13 disappears. Note the text is technically within the HTML, but it is not rendered because the Top and Left Margin settings are offset beyond the boundaries of the table cell.
  4. Running the same code under Aspose Cells for Java version 19.12, should produce a file similar to the attached VerticalText-v19.12.0html file.
  5. Rendering the HTML output file from Cells 19.12 in a Browser, displays the vertical text correctly.

Environment Details:

  • Aspose Cells for Java 21.3 (for first run)
  • Aspose Cells for Java 19.12 (for second run)
  • Java version 1.8.0_211
  • Windows 10 OS (but also reproducible under Linux).

File description in the VerticalText.zip (20.3 KB) attachment contains:

  • VerticalText.xlsx: Excel workbook to be used by the code above.
  • VerticalText.png: Screen shot of the Vertical Text Format applied to the range B4:B13.
  • VerticalText-v21.3.0.html: HTML output file produced from the code above under Aspose Cells 21.3.
  • VerticalText-v19.12.0.html: HTML output file produced from the code above under Aspose Cells 20.8.

Thank you!

@oraspose,
This issue is reproduced and logged in our database for further investigation. We will notify you here once any update is ready for sharing in this regard.

This issue is logged as:
CELLSJAVA-43429 - Text with Vertical Text Alignment Disappears in HTML

@oraspose,
Please try our latest version/fix: Aspose.Cells for Java v21.3.8 (attached)
aspose-cells-21.3.8-java.zip (7.3 MB)

Your issue should be fixed now.

The version fix looks very good.
Thank you for fixing this so quickly!

@oraspose,
You are welcome.

The issues you have found earlier (filed as CELLSJAVA-43429) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi