Converting xlsx files with hidden elements throws exception when asking for the removal of hidden elements from html

Aspose.Cells Product Family
1

Hi!

We are trying to convert xlsx to html using Aspose.Cells for .net 20.7.0 and the following code:

AsposeLicenser.LoadLicense();

var options = new HtmlSaveOptions
{
    ExportImagesAsBase64 = true,
    ExportSingleTab = true,
    ExportHiddenWorksheet = false,
    ExportGridLines = true,
    HiddenRowDisplayType = HtmlHiddenRowDisplayType.Remove,
    HiddenColDisplayType = HtmlHiddenColDisplayType.Remove
};

using (var wb = new Workbook(file))
    wb.Save(file + "_output.html", options);

For the files in the archive below, we are getting exceptions (NullReference and ArgumentException). Note that with the last two settings removed (hidden rows and columns), there are no exceptions.

hidden-elements.zip (67.0 KB)

Thanks for any help!
Arnold

2

@arnoldbeilandevozon,

Please notice, we are able to reproduce the issue as you mentioned using your sample files. We found by converting your XLSX files with hidden elements to HTML, it throws exception(s) (NullReference and ArgumentException). We have logged a ticket with an id “CELLSNET-47490” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

3

@arnoldbeilandevozon,

This is to inform you that we have fixed your issue (logged earlier as “ CELLSNET-47490”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

4

@arnoldbeilandevozon,

Please try our latest version/fix: Aspose.Cells for .NET v20.7.1 (attached)

Your issue “CELLSNET-47490” should be fixed in it.

Let us know your feedback.
Aspose.Cells20.7.1 For .Net2_AuthenticodeSigned.Zip (5.4 MB)
Aspose.Cells20.7.1 For .Net4.0.Zip (5.4 MB)

5

Seems to work now. Please include the fixes in your next release on nuget.org as well.

Thanks,
Arnold

6

@arnoldbeilandevozon,
Sure, it will be done in the next release and thank you for the feedback.

7

The issues you have found earlier (filed as CELLSNET-47490,CELLSNET-47496) have been fixed in Aspose.Cells for .NET v20.8. This message was posted using Bugs notification tool by Amjad_Sahi