Hi Amjad,
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:
Hi Faiz,
Hi,
We have fixed this issue. This fix will be contained in our next release which will be published sometime in this week.
Thanks Shakeel,
Hi,
We have fixed this issue. Please download and use the latest version:
Aspose.Cells
for .NET v7.2.0.2
Hi Shakeel,
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.
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.
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.
Hi,
Hi,
Hi,NakulKapadia:Hi,Column is hiding but hidden rows are appearing in output.Please check this.Thanks and Regards,Nakul
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#
HtmlSaveOptions opts = new HtmlSaveOptions();
opts.HiddenColDisplayType = HtmlHiddenColDisplayType.Remove;
Workbook workbook = new Workbook(filePath);
workbook.Save(filePath + ".out.html", opts);
Screenshot:
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.
Hi Shakeel,
Hi,
Hi Amjad,
Hi,
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.