We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Conditional Formatting on pivot table getting scrambled


I am currently using Aspose.Cells version for .Net with the attached file. The pivot table in the file contains some conditional formatting which you can see in the manage rules option.

My code moves the file to a new location before opening it via the aspose.cells.Save() function, but in doing so this appears to be making a mess of the conditional formatting on the pivot table in that the "applies to " in the rules looks completely incorrect.

My code is very simple:

string templatePath = @"C:\TEMP\4.5Test.xlsx";

string fileName = @"C:\TEMP2\CopiedVersion.xlsx";

Aspose.Cells.Workbook myWorkbook = new Workbook();

myWorkbook = new Aspose.Cells.Workbook(templatePath);

myWorkbook.Save(fileName, Aspose.Cells.SaveFormat.Xlsx);

Many Thanks


After an initial test, I can find the issue as you have mentioned. I have logged a ticket with an id: CELLSNET-40145. We will look into it soon.

Thank you.


Is there any news on this issue yet?



I am afraid, your issue is not resolved yet.

Will you please also try the latest version:
Aspose.Cells for .NET v7.0.3.4 and see if it works for you?


I have tested this with version of the dll as well and this has made no difference to the formatting in the pivot table.



We have fixed this issue. Please download: Aspose.Cells for .NET v7.0.3.6

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

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