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.

The key is that the column containing the data must be included in the selection - that is, to insert two cols to left of col B, I am selecting A and B then going Insert Left. If I just select A and insert a single col, the data moves to col C and the formula correctly transforms to SUM(C1:C6). I've tried this with data in col G and cols inserted left (including G), with the same error.

 I have replicated the issue on another machine running Win7 64, and with a completely clean install of 4.2.3.3 on a system running XP that has never had LO loaded. I also replicated the problem on a reversion to 4.2.0.4.

Similar to Bug 71014.