Issue with Range Intersect

Hi,

I have been facing issue with Aspose.cells when working with Range Intersect. I am processing .xlsm file having inbuilt macro and formula dealing with range names. I am using range intersect in formula for some of the cells. Example of one such formula is =SUM(rowReqSubtotalDc (colBudget1:colBudget10)). after processing the file using Aspose.cells I save the file locally but when I open the locally saved file it breaks all the formula having range intersect. It basically removes the space required in range intersect. Is this the bug in Aspose.cells? Looking for some help on how to resolve this issue.

Hi,


Thanks for sharing some details.

Please try our latest version/fix: Aspose.Cells for Java v8.4.2 (if you are not already using it). If you still find the issue with v8.4.2, kindly provide the sample JAVA program (runnable) with template files to show the issue on our end, we will check it soon.

Thank you.