I have a sheet with a conditional formatting set to a pivot table, after the copy of the sheet, in the new sheet the conditional formatting are wrong, see the attached pdf.
I attach a simple program to replicate the issue.
Thanks for the sample project with template file and screenshots.
After an initial test, I am able to observe the issue as you mentioned (via screenshots pasted in the PDF file) by using your sample project with your template file. I found that conditional formatting in pivot table does not copied properly in the copied sheet.
I have logged a ticket with an id “CELLSNET-46477” for your issue. We will look into it soon.
Once we have an update on it, we will let you know.
This is to inform you that we have fixed your issue (logged earlier as “CELLSNET-46477”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.
Please try our latest version/fix: Aspose.Cells for .NET v19.1.3 (attached)
Your issue should be fixed in it.
Let us know your feedback.
Aspose.Cells19.1.3 For .Net2_AuthenticodeSigned.Zip (4.7 MB)
Aspose.Cells19.1.3 For .Net4.0.Zip (4.8 MB)