Free Support Forum - aspose.com

Hidden columns reappear after saving

Hello!

I have written a piece of code using Aspose in order to generate XLSX files for a customer.

He told me that everything is going well if he opens that file manually but not if he tries to process it by a mean for which I don't have any detail. It looks like in that case, most of the columns are hidden.

He also told (and shown) me that this issue dissapears if he simply opens the file and save it (without any modification). By performing this step, the Excel file size is also growing (a lot for big files). I also noticed by reading the two files with a binary editor that the content is really different.

I attach the two documents (before and after that saving step).

Does this issue ring a bell?

Sorry for not having more details about this.

Thank you for your help.

Hi,

Thanks for using Aspose.Cells for .NET.

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

and see if it resolves your problem.

I have tested your issue and was not able to notice any issue. Below is my sample code. I have also attached the output file for your reference.

C#


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


Workbook workbook = new Workbook(filePath);

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