I have a col of numbers (say in B1 to B6), which is summed at the bottom - B7 is SUM(B1:B6). Cells in formula are relative. I insert two cols to left of B. I would expect the formula to change to SUM(D1:D6) - but it doesn’t. It becomes SUM(B1:D6)
If I make the cell refs absolute - SUM($B$1:$B$6) and insert the new cols, I get SUM($B$1:$D$6).
This is contrary to the guidance given in the Help file (absolute addresses in spreadsheets) - ‘After having inserted a new column A, the formula =SUM(A1:B2) will be automatically updated to =SUM(B1:C2).’
This behavior occurs in both column insert and cell insert.
Has anyone experienced this? Is there a solution, or should I file a Bug. Has only been a problem since 4.2.3.3.