Cells.copyRows with conditional formatting in cells causes resulting file size grow in Aspose Cells 8

Hello,

in Excel document we have to copy cells with conditional formatting. Method Cells.copyRows degrades performance and multiplies resulting file size in Aspose 8. With Aspose 7 it worked fine. Also, it happens only when we copy same row multiple times, but if we will copy, say, row 1 to row 2, than row 2 to row 3 performance and size are ok. Attached is sample to reproduce the issue.

test.xltx is source file with conditional formatting in cells A1-J1
test-aspose-cells-7.7.2.xlsx is file generated with Aspose 7.7.2
test-aspose-cells-8.4.2.xlsx - generated with Aspose 8.4.2
main.java is sample code

Thanks

Hi,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue. Running your sample code on the latest version shows the performance and file size grow issue. I have attached the output excel files generated with the older and newer versions for a reference.

We have logged this issue in our database for investigation. 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

  • CELLSJAVA-41422 - Cells.copyRows with conditional formatting in cells causes file size grow and performance issue

Hi,

Thanks for using Aspose.Cells.

We have fixed this issue.

Please download and try the latest fix: Aspose.Cells
for Java v8.5.1.2
and let us know your feedback.

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


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