Problems with saving in xls format with ClearData option equal "true"

Aspose.Cells Product Family
1

Hi, Aspose Team!

As requsted, I’m creating a new thread for issue with clearData. Problem happens, when you try to open and save xls file with cleardata option set to true. There happens numerous corruptions with figures on the screen. Some rows become resized. Etc, etc, etc.

Here is the sample code:
var workbook = new Workbook(stream, loadOptions);
var format = new XlsSaveOptions(SaveFormat.Excel97To2003);
format.ClearData = true;
workbook.Save(“out.xls”, format);

Could you, please take a look?
I used latest 7.1.2.6 version. Pictures and sample app are attached.

Thank You in advance,
Denis

2

Hi,

Thanks for your cooperation and posting.

I was able to replicate the problem using the latest version:
Aspose.Cells
for .NET v7.1.2.6

Below is my test code for a reference.

I have attached both the source and output files.

We have logged this issue in our database. Once the issue is fixed or we have some update relating to it, we will let you know asap.

This issue has been logged as CELLSNET-40559.

C#


string filePath = @“F:\Shak-Data-RW\Downloads\Vproj\CheckAspose\Models\test_template.xls”;


Workbook workbook = new Workbook(filePath);


var format = new XlsSaveOptions(SaveFormat.Excel97To2003);

format.ClearData = true;


workbook.Save(filePath + “.out.xls”, format);


3

Hi,


We have fixed this issue. Please download and try the latest version: Aspose.Cells for .NET v7.1.2.7

4

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

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