How to move a range including formulas?

I just upgraded to LibreOffice 5.0.3.2 and noticed that it works slightly different than the old version when moving a range of cells. I noticed the same behaviour in both Linux and Windows versions.

Lets say that I enter 1 in B2, =B2+1 in B3, and copy the formula in B3 to B4:B9. In other words the range B2:B9 will contain the numbers one through eight. If I move the entire column or the range B2:B9 everything works as expected, but if move the range B6:B9 to e.g. C6:C9 the formulas will remain unchanged. The range C6:C9 will contain numbers 5, 1, 1, and 1 instead of 5, 6, 7, and 8 what I would have expected.

To get the expected behaviour I have to move first B6 to C6 whereafter I can move the range B7:B9 to C7:C9. The extra step increases the risk of errors and is annoying. How can I move the entire range in one step without messing up the formulas?

Hi

  • Select B6:B9
  • Right clickInsertShift cells rightOk

Of course this will also shift the cells that are to the right …

Regards