Endless saving workbook to HTML format (2892)

Aspose.Cells Product Family
1

Hi,

I am writing to you about a problem we encountered in working with MSO Excel documents (xlsx format) using the Aspose Cells v21.9 library.

Specifically, when we open the document (workbook) and then immediately try to save it in HTML format, the save operation never ends.

I am enclosing a source document and test code for reproducing reported behavior.

In the hope that together we will quickly overcome the problem!
Best regards!

Nenad

test code and XLSX file.zip (2.7 MB)

2

We have logged a ticket with an id "CELLSJAVA-44792” for your mentioned issue. We will check it soon.

3

@zpredojevic
Formulas are input in range D257:D 1048504, the max column index 32, So there is about 30,000,000 TDs to export.
Please check whether those formulas are excepted.

4

@zpredojevic
In the next version, we will recalculate the max range if removing the hidden columns.As the following codes:

Workbook w = new Workbook(dir +“file.xlsx”);//not working - exception
HtmlSaveOptions options = new HtmlSaveOptions();
options.setHiddenColDisplayType(HtmlHiddenColDisplayType.REMOVE);
w.save(dir +“dest.html”,options);
5

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