We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Hidden Cell wrong

Workbook wb = new Workbook(new FileInputStream("C:/Test.xlsx"));
HtmlSaveOptions options = new HtmlSaveOptions();
options.setExportActiveWorksheetOnly(true);

options.setHiddenColDisplayType(HtmlHiddenColDisplayType.HIDDEN);
options.setHiddenRowDisplayType(HtmlHiddenRowDisplayType.HIDDEN);
wb.save("C:/Test.html", options);


B3 is hidden in ms excel , but visible in html.

Hi,


Thanks for providing us template file and sample code.

After an initial test, I observed the issue as you mentioned by using your sample code with your template file. I found some hidden cell (e.g B3) is wrongly displayed in the output HTML even though we specify setHiddenColDisplayType and setHidden
RowDisplayType options accordingly in the code segment:
e.g
Sample code:

Workbook wb = new Workbook(new FileInputStream(“C:/Test.xlsx”));
HtmlSaveOptions options = new HtmlSaveOptions();
options.setExportActiveWorksheetOnly(true);

options.setHiddenColDisplayType(HtmlHiddenColDisplayType.HIDDEN);
options.setHiddenRowDisplayType(HtmlHiddenRowDisplayType.HIDDEN);
wb.save(“C:/Test.html”, options);

I have logged a ticket with an id “CELLSJAVA-41562” for your issue. We will look into it soon.

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

Thank you.

Hi,

Thanks for using Aspose.Cells.

It is to inform you that we have fixed your issue CELLSJAVA-41562 now. We will soon provide the fix after performing QA and including other enhancements and fixes.

Hi,

Thanks for using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for Java (Latest Version) and let us know your feedback.

The issues you have found earlier (filed as CELLSJAVA-41562) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by Aspose Notifier.