Cell references in formulas not always updating during copy process

Aspose.Cells Product Family
1
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
2

Hi Dan,

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

3

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

4

Hi Dan,

Please try this fix.