Unable to detect Cells that are to small to show number correctly (+ HTML conversion)

Aspose.Cells Product Family
1

Hello,

I am converting excel files into html using Aspose.Cells for Java.
In some of the cells in excel I can see that monetary values (Currency category in excel) are too big to show up in the table, as below:
image.png (5.2 KB)

When increasing the width of the column in excel, the number shows up, of course. Althought I don’t want to modify input excel.

In output html I would like to have the size of the cell aligned so these long numerical, monetary values are completely visible.
The problem is that it seems that this issue cannot be detected in Cell or Style classes’ properties. Any kind of value checks of the Cell shows the full value.

I don’t want to just set all columns’ widths to the width of the widest cell, because in other columns I have text values which I want to have wrapped in a narrow cell. That’s why I need to detect the exact columns where I have values that would not render correctly.

Please let me know if anyone can see a solution to this issue.

Kind regards,
Maria

2

@nananam608,
I have tried this scenario using MS Excel where my sample workbook with large number but narrow column width is converted to HTML. The output file does not show proper number value and shows “##########”. I could not find any option in Excel which can display the proper number in HTML without expanding the column width. As Aspose.Cells mimics the behavior of Excel, therefore no such option is available in Aspose.Cells to create your required output file.

However, if you can perform this task using Excel only, then share the steps with us for our reference. We will review these steps and try to provide assistance to achieve the same using Aspose.Cells.