# Odd behaviour with cell references when inserting new columns [closed]

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.