we have just moved from OO to LO
I have a number of spreadsheets that utilise formulas in hidden columns.
when attempting the drag down multiple cells across numerous columns including hidden columns everything drags down apart from the formulas in the hidden columns.
can’t seem to find an answer - any ideas?
thks
Additional Info (04/dec/15)
I have tried to attach a sample doc to illustrate but i need points to do this apparently.
Here goes on extra explanation
i would normally highlight cells F1-L1 and then drag the columns/formulas down.
Col J is hidden containing a formula which is needed to provide a result in Col K
i) if i do this with Col J hidden then the formula in Col J doesn’t copy down
ii) if i do this with Col J shown the dragging down does copy the formula in Col J down.
The spreadsheet is used by a number of people who have a basic knowledge only so i need to keep it as simple as possible - highlighting and dragging down is ok, but i’d rather they did not start unhiding columns and potentially messing with formulas