Columns missing from html output

Aspose.Cells Product Family
1

Hi,


I am using Aspose.Cells-8.6.3.6
While generating the HTML output of a range, some of the columns are missing.

In the attached Excel where columns F,G & H are hidden. The html output of the range A1:K3, only first 5 columns information appears. Columns I, J and K are missing in the output.

Here is the source code to copy range to new worksheet & save as html.

Range sourceRange = selectedWorksheet.getCells().createRange(“A1:K3”);

Workbook targetWorkbook = new Workbook(FileFormatType.XLSX);
WorksheetCollection targetWsc = targetWorkbook.getWorksheets();
com.aspose.cells.Worksheet targetWs = (com.aspose.cells.Worksheet)targetWsc.get(0);
Range targetRange = targetWs.getCells().createRange(0, 0, sourceRange.getRowCount(), sourceRange.getColumnCount());

PasteOptions options = new PasteOptions();
options.setPasteType(PasteType.ALL);

targetRange.copy(sourceRange, options);

File htmlFile = new File(“C:/temp/AposeGenerated.htm”);
HtmlSaveOptions htmlSaveOptions = new HtmlSaveOptions(SaveFormat.HTML);
htmlSaveOptions.setHiddenColDisplayType(HtmlHiddenColDisplayType.REMOVE);
htmlSaveOptions.setHiddenRowDisplayType(HtmlHiddenRowDisplayType.REMOVE.REMOVE);

targetWorkbook.save(htmlFile.getAbsolutePath(), htmlSaveOptions);

Attached herewith the excel file and the html output generated for your reference.

Thanks,
Neeraj

2

Hi Neeraj,

Thanks for your posting and using Aspose.Cells.

We were able to replicate this issue with the following sample code using the latest version:

Aspose.Cells
for Java v8.6.3.6 with your sample excel file. Columns get missing from HTML output.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged

  • CELLSJAVA-41708 - Columns get missing from HTML output

I have attached the output html generated with this code for a reference.

Java
String filePath = “D:\Downloads\Hidden+Cols+Small+Sample+2.xlsx”;

Workbook wb = new Workbook(filePath);

HtmlSaveOptions htmlSaveOptions = new HtmlSaveOptions(SaveFormat.HTML);
htmlSaveOptions.setHiddenColDisplayType(HtmlHiddenColDisplayType.REMOVE);
htmlSaveOptions.setHiddenRowDisplayType(HtmlHiddenRowDisplayType.REMOVE);

wb.save(filePath + “.output.htm”, htmlSaveOptions);

3

Hi,


Thanks for logging the issue for the same.

Just to inform you - this issue is reported by one of our customers in their production environment as major “Data Loss” with high severity level.
This is something which was working fine in previous versions and is broken in some recent release of Aspose Cells.

Since it has high severity, can you please provide a fix for this ASAP?

Thanks,
Neeraj


4

Hi,

Thanks for your posting and using Aspose.Cells.

We have logged your comment in our database for product team consideration. Please let us know which past version was working fine so that we change the issue type as regression. Regression issues are likely to be fixed sooner. Once there is some fix or other update for you, we will let you know asap.

5

Hi,


It was working fine in with Aspose Cells version 8.5.x.

So being a regression issue, looking forward to immediate fix.

Thanks,
Neeraj


6

Hi,

Thanks for your posting and using Aspose.Cells.

You are right. It works fine in older version like 8.5.0.2 so it is a regression. We have logged this finding in our database for product team consideration and a fix. Hopefully, your issue will be fixed soon.

7

Hi,


Any update on this? As told earlier too, this has very high severity level so please let me now when should be expect a fix for this?

Thanks,
Neeraj
8
Hi Neeraj,

I am afraid, product team hasn't shared any ETA for the mentioned issue however, we have increased the priority of the ticket and requested the concerned member of the product team to share the ETA. As soon as we get any news, we will share it here for your kind reference.

We are sorry for the inconvenience caused to you.
9

Hi,

Thanks for using Aspose.Cells.


This issue should be fixed in about February 5, 2016. Once the fix is available for you, we will let you know by posting in this thread.

10

Hi,

Thanks for using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for Java v8.7.0.2 and let us know your feedback.

11

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

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