Landray RDM EKP-5444 Convert Effect

Aspose.Cells Product Family
1

cells source code：
src.zip (1.6 KB)

origin cells:
差旅协议酒店信息（2024-01）.xlsx.zip (448.6 KB)

before converted：
image.jpg (221.4 KB)

after converted：
image.png (358.9 KB)

Please have a check.

2

@hucq_landray_com_cn
By using sample code and file for testing on the latest version v24.3, we can reproduce the issue. Found text cross column failure when converting file to HTML. Please check the attachment. result.zip (881.2 KB)

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

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.

3

@hucq_landray_com_cn ,

  1. If “newStyle.setTextWrapped(true);” is called, only one character is visible in MS Excel because the row height is customize. If the text of the cell is wrapped, it should not overflow other empty cells.

  2. With the latest version 24.3, you will get the same result as Landray RDM EKP-5444 Convert Effect. Though we set the row height, browser automatically expands row to fit the data.

  3. We plan to add property to hide some text if the cell is wrapped, then row won’t automatically increase in size in browser. But you only can see a part of cell’s value.

4

@hucq_landray_com_cn ,

We are pleased to inform you that your issue has been resolved. The fix will be included in an upcoming release (Aspose.Cells v24.4) that we plan to release in the first half of April 2024. You will be notified when the next version is released.
Attached is the result after fix for your reference: canapplystle.zip (437.7 KB)

Please call HtmlSaveOptions.setHideOverflowWrappedText() as following code when the next version is released:

saveOptions.setHideOverflowWrappedText(true);
6

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