How to copy formula maintaining relative addressing
It feels like this question must surely have been asked and solved a 100 times, but I have searched all over and come up with nothing.
I want to copy formulae in the same way that Excel copies them - where cell references are copied relative - eg if cell A2 has formula =A1 then when I copy it to cell B2 it should read =B1. I understand that formulae are stored in the xls file in absolute string form, eg A1 rather than the relative form R1C1.
Has this been implemented within POI? If not, can it be performed with a simple string substitution - in which case does anyone have the necessary regular expression to handle all circumstances?