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?
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’.
Please try this fix.