The cell is set to wrap automatically, but it still displays after being converted to HTML###

Aspose.Cells Product Family
1

Formula cells have been set with automatic line wrapping in Excel. After being converted to HTML through the interface, although the line breaks, the corresponding data is still displayed as # # # instead of # #. Lower versions of aspose can display numerical values normally
image.png (63.4 KB)
image.png (61.5 KB)
image.png (60.4 KB)

this is my file：
EPPR_70851.zip (37.4 KB)

this is my code：


Workbook workbook = new Workbook("D://Program_Data//Aspose//EPPR_70851//EPPR_70851.xlsx");
workbook.save("D://Program_Data//Aspose//EPPR_70851//EPPR_70851/EPPR_70851.html", SaveFormat.HTML);
2

@xhaixia
By using sample files and code for testing, we can reproduce the issue. Discovered that after setting the cell to wrap automatically, the cell content is displayed as # symbol in HTML.

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

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

@xhaixia,

You may please try the following code:

Workbook workbook = new Workbook("D://Program_Data//Aspose//EPPR_70851//EPPR_70851.xlsx");
HtmlSaveOptions saveOptions = new HtmlSaveOptions();
saveOptions.setFormatDataIgnoreColumnWidth(true);
workbook.save("dest.html", saveOptions);