Free Support Forum - aspose.com

Cell references in formulas not always updating during copy process

Aspose Nanjing Team,

In my little example Java program I am adding columns/rows and then copying the formulas in the reference line to the newly inserted lines.

The cell references increment correctly for U9 copying into U10:U19 but when W9, and others, are copied into W10:W19, and others, the cell references never increment?

Regards,
Dan

Hi Dan,

We found the issue and will figure it out, thank you.

Aspose Nanjing team,

The Excel template file may have been a little sloppy in the way the ‘#N/A’ was being used in the 'IF" function.

I replaced ‘#N/A’ with the function ‘NA()’ and the Java code ran with no problems.

FYI: Excel was OK with the usage of ‘#N/A’.

Regards,
Dan

Hi Dan,

Please try this fix.