Aspose Cell Save as HTML shows hidden column in output

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

Hello, it appears the issue is back again. I am using the latest 7.6 version.


string myData;

HtmlSaveOptions opts = new HtmlSaveOptions();

opts.HiddenColDisplayType = HtmlHiddenColDisplayType.Remove;
opts.HiddenRowDisplayType = HtmlHiddenRowDisplayType.Remove;
opts.ExportActiveWorksheetOnly = true;
opts.HtmlCrossStringType = HtmlCrossType.Cross;

using (var memStream = new MemoryStream())
{
wb.Save(memStream, opts);
memStream.Position = 0;
var sr = new StreamReader(memStream);
myData = sr.ReadToEnd();
}

Resulting HTML still contains hidden columns.

Please advise.


28

Hi Joel,

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

We were not able to replicate this issue using the latest version: Aspose.Cells
for .NET v7.6.0.2. If your issue still occurs with the latest version, then please provide us your sample source file and the screenshot highlighting the issue with red circles. We will look into it and help you asap.