Xls to xlsm convertion problem (pivot table display)

Aspose.Cells Product Family
1

Hi,

When we convert an xls file to xlsm the display of the pivot table change.

Please see attachments.

Code:

 m_workbook = new Workbook("....xls");

m_workbook.Save("....xlsm");

 
Thanks for your help
Best regards
2

Hi,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue using the following code with your given source file as you have shown it in your screenshot. We have tested it with the latest version: Aspose.Cells for .NET 7.7.1 but the problem still persists.

We have logged this issue in our database. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-42300.

C#


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


Workbook workbook = new Workbook(filePath);

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

3

Hi,

Please download and try our latest version/fix: Aspose.Cells for .NET v7.7.1.2

We have fixed your issue. See the sample codes as follows:
e.g.
Sample code:

Workbook wb = new Workbook(@"D:\convert_example.xls");

wb.Worksheets[0].PivotTables[0].CalculateData();

wb.Worksheets[0].PivotTables[0].RefreshDataOnOpeningFile = true;

wb.Save(@"D:\convert_example_out.xlsm");

Let us know your feedback.

Thank you.

4

Hi,

I will try it, is it this 7.7.1 version in the current release of aspose total ?

Thanks

5
Hi,

Well, you may use this fix (v7.7.1.2) without any problem, it will behave like an official release and you may use it on production server, it includes all the functionality (full fledged) and fixes of official release i.e. v7.7.1 till that fix. Generally, we publish official releases of the product once in a month. Our next official release of the product (e.g v7.7.2) that is scheduled to be released in the mid of next month, it will include all the previous fixes and enhancements including this one (v7.7.1.2) too. And, Aspose.Total only includes official releases of the products

Thank you.
6

Hi,

Works Fine, just need a refresh but it's OK for us.

Thanks

7

Hi,

Thanks for your feedback and using Aspose.Cells.

It is good to know that your issue is fixed now. Let us know if you encounter any other issue. We will be glad to look into it and help you further.

8

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

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.