We have a template which contains some formula. It used to work fine with ExcelWriter, but after changing to Aspose, these formula were not working any more when merging with data. For example, one of the formula is:
=SUM(‘4) Employee Status’!J2:J65536)
After merging with data, it was changed to
=SUM(‘4) Employee Status’!J2:J4) instead of populating with the calculated result.
Attached is the template we used. Please let me know if it’s a limitation of Aspose, or I need to make some changes to some template.
Thanks for providing us the template file with details.
I think you are using Aspose.Cells for Java, is not it? After an initial test, we found the issue you have mentioned. When a marker is processed some new rows are inserted and then filled with data based on the marker's source data. We found there might be an issue (the formulas are not updated correctly somehow) when the new rows are inserted into a sheet.
We will look into it and figure it out soon.
Thank you for considering Aspose.
Please try the attached latest fix. We have fixed your mentioned issues.
Thank You & Best Regards,
The problem was resolved with the new library. I am very impressed with your promptness in providing the fix.