Apache OpenOffice (AOO) Bugzilla – Issue 102558
Formula with cells arguments do not update when copying and paste insert
Last modified: 2013-01-29 21:44:07 UTC
This is a very critical bug that may make calc unreliable. When “copying†and “paste insert†ranges that are related to a range beneath them , the formulas of these new inserted cells do not update themselves to the newly shifted cells Microsoft Excel does not have this problem at all !!! 1- Open the attached file I uploaded with this issue, 2- select Entire Row 8 , then Copy 3- Select Row 6 4- Go to Paste Special , 5- from the “Shift Cells†Select “Down†and press OK 6- now examine the vlookup formula arguments , they are not updated to the new shifted rows down. (other rows are updated correctly) I tested it on Ms excel ,the result is perfectly correct !
Created attachment 62817 [details] Calc file
The clipboard content is not adapted, when a range is shifted, that is used in the clipboard content. You can see this behavior too, when you copy the row, then insert a row and paste the content into the new row. I do not know, whether this "works a designed" and the design should be changed or whether this is a bug (but sure not a P1 one). So a developer should decide. The question how clipboard content is treated, when doing something else before pasting it, should be clarified before working on issue 21280. walidz, you can avoid such problems, if you define a name for the lookup range and use that name in your VLOOKUP formula.