Aspose Cell Save as HTML shows hidden column in output

Aspose.Cells Product Family
1

Hi Team,



workbook.Save(stream, Aspose.Cells.SaveFormat.Html);

Generated HTML has hidden column visible,

Is there any way to suppress hidden column.

Please help it is urgent.

Thanks and Regards,
Nakul
2
Hi,

Please download and try the latest version: Aspose.Cells for .NET v7.1.2.7

If you still find any issue, give us your template Excel file here, we will check it soon.

Thank you.
3

Hi Amjad,


I am getting this issue in new version also.

I am just using below line of code and Excel consisting of Hidden columns.

Workbook workbook = new Workbook(excelDocumentStream);
workbook.Save(@“C:\Test\Test.html”, Aspose.Cells.SaveFormat.Html);

I will share you sample shortly. Till that you can try above line of code

Thanks and Regards,
Nakul


4

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

You do not need to post your files.

I was able to replicate the problem using the latest version.

Please see the code below. I have attached the source and output files. Please see the screenshot below for a reference.

Please note, the issue occurs in FireFox and not IE.

We have logged this issue in our database. Development team will look into this issue. Once the issue is fixed or have some update relating to it, we will let you know asap.

This issue has been logged as CELLSNET-40581.

C#


string filePath = @“F:\Shak-Data-RW\Downloads\source.xlsx”;


Workbook workbook = new Workbook(filePath);


workbook.Save(filePath + “.out.html”);


Screenshot:
5

Hi Faiz,


I would expect the column should be suppress in output.

There should be option to remove hidden column in generated HTML.

It will be logged in priority forum

Thanks and Regards,
Nakul


6

Hi,

We have fixed this issue. This fix will be contained in our next release which will be published sometime in this week.

7

Thanks Shakeel,


Let me know once it is published.

We are priority user and this post is already there in priority forum.

Regards,
Nakul
8

Hi,

We have fixed this issue. Please download and use the latest version:
Aspose.Cells
for .NET v7.2.0.2

9

Hi Shakeel,


Thanks for solution, i checked this solution.

The hidden columns are part of HTML out put as display:none, Is there any way to suppress hidden columns completely from output html as we don’t want to send it over browser.

-Nakul


10

Hi,

Thanks for your feedback.

I can understand your requirement, therefore I have logged your comment in our database against the issue id: CELLSNET-40581

Developers will look into your requirement and once it is resolved or we have some other update for you, we will let you know asap.

11

Hi,

We have fixed this issue. It will be contained in a next fix.

There’s a new property named “HtmlHiddenColDisplayType” in HtmlSaveOptions and it got two options (“Hidden”/“Remove”) inside it.

12

Hi,

We have released the fix with this new feature.

Please download and try:
Aspose.Cells
for .NET v7.2.0.8 and let us know your feedback.

13

Hi,


Column is hiding but hidden rows are appearing in output.

Please check this.

Thanks and Regards,
Nakul
14

Hi,


Thank you for using Aspose.Cells

I was not able to reproduce the issue of Hidden rows using the latest version: Aspose.Cells for .NET 7.3.0 . I have used the attached source.xlsx file which contains 4th row as hidden.

Please download and use this version and let us know your feedback.

15
NakulKapadia:
Hi,

Column is hiding but hidden rows are appearing in output.

Please check this.

Thanks and Regards,
Nakul
Hi,

Thanks for your feedback.

I was able to observe this issue using the latest version: Aspose.Cells for .NET 7.3.0 as mentioned by you.

Actually the hidden row is still present inside the html. I have attached a screenshot for your reference.

Just like HtmlSaveOptions.HiddenColDisplayType, we also need HtmlSaveOptions.HiddenRowDisplayType property.

We will look into it and fix this issue soon. Below is my test code, I have attached the source xlsx file and the output html files for a reference.

C#
string filePath = @"F:\Shak-Data-RW\Downloads\source.xlsx";

HtmlSaveOptions opts = new HtmlSaveOptions();
opts.HiddenColDisplayType = HtmlHiddenColDisplayType.Remove;

Workbook workbook = new Workbook(filePath);

workbook.Save(filePath + ".out.html", opts);

Screenshot:

16
I was about to send my analysis with 7.3.0, but you catch the issue.

Thanks for looking again.

This is a priority issue, and already posted in priority forum.

Thanks and Regard,
Nakul
17

Hi,

Thanks for your comments.

We have logged this issue as a priority user.

Once, it is fixed, we will update you soon.

If you encounter any other issue, please feel free to post, we will help you asap.

18

Hi Shakeel,


When shall I expect the fix.

Thanks and Regards,
Nakul
19

Hi,


Well, I am afraid, your issue is still “Open/In Process”. However, I have asked the relevant developer to update on your issue or share an ETA for the issue/feature. Once we have any update, we will let you know here immediately.

Sorry for any inconvenience caused!
20

Hi Amjad,


This issue has been posted in priority forum also, please have a look into this as soon as possible, we are waiting for fix as we need to apply it in production.

Thanks and Regards,
Nakul