Corrupted Excel file after anonymization


#1

Hello,

I am trying to anonymize a excel document and after, when I open it, excel crashes because the file is broken.
Specifically in my case is the sheet p.46 the, first chart that crashes excel.
I saw with Open XML SDK 2.5 Productivity Tool that it contains a lot of errors. I tried to fix some but there are others that I cannot.

The file before and after are attached in a zip filefiles.zip (98.1 KB)
.
I am using Aspose.Cells 17.10.0.0.

Thanks.


#2

@translationcenter,

Thank you for your query.

By anonymization if you mean managing the document properties, then you may please visit this link and if you want to encrypt the file, please visit here.

If this information is not helpful to you, please share the sample code which you have used to convert BEFORE.XLSX file to AFTER.XLSX. Also please note that both the files open fine here in Excel 2016.

You may please try this scenario with the latest version Aspose.Cells for .NET 18.7 and share the feedback.


#3

Thank you for your reply.

I also tried with the latest version and I still have the same issue.
And it is a very simple procedure.

Here it is the code:

Workbook workBook = new Workbook(filePath);
this.Anonymize(workBook, replaceString);

Thanks.


#4

@translationcenter,

We are sorry that the we could not find the definition of this.Anonymize() function. Please share your sample file and code snippet with us for our testing. This sample can be a console application based project which compiles and executes without any exception. We will reproduce the problem and provide our feedback after analysis.