Aspose Cell Save as HTML shows hidden column in output

Aspose.Cells Product Family
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
21

Hi,


We already set your request for your issue as Priority Request into our database. Anyways, I have just talked to the relevant developer and hopefully we will fix your issue within a couple of days or so.

By the way, for "This issue has been posted in priority forum also"
Could you give me the Priority Forum’s Thread URL?

Thanks for your understanding!
22

Hi,

Please download and try this fix: Aspose.Cells for .NET v7.3.0.2

We have added a property name “HtmlHiddenRowDisplayType” for your needs.

23

Hi Shakeel,


I will test it and soon I will let you know.
Thanks,
Nakul



24

Hi Shakeel,


It is working fine.

Thanks ,
Nakul
25

Hi,

Thanks for your testing and feedback.

It’s good to know that this issue is now resolved with the latest fix.

If you face any other problem, please feel free to let us know, we will be glad to help you asap.

26

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

This message was posted using Notification2Forum from Downloads module by aspose.notifier.
(1)