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

Free Support Forum - aspose.com

Setsharedformula and Copy throws out of memory

Our requirement is we need to copy the formula from the first row to the below consecutive rows. We tried with 10000 rows. It throws out of memory exception. is there any optimized way to copy formulas from first row to the below consecutive rows?


Thanks for providing us some details.

Could you provide us sample JAVA program (runnable) with template file (if any) to reproduce the issue on our end, we will check it soon.

Also try our latest version/fix: Aspose.Cells for Java v8.5.2 (if you are not already using it).

Thank you.