Issue 102558 - Formula with cells arguments do not update when copying and paste insert
Summary: Formula with cells arguments do not update when copying and paste insert
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO310m11
Hardware: Unknown All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2009-06-06 10:36 UTC by walidz
Modified: 2013-01-29 21:44 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Calc file (8.64 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-06-06 10:41 UTC, walidz
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description walidz 2009-06-06 10:36:54 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 !
Comment 1 walidz 2009-06-06 10:41:16 UTC
Created attachment 62817 [details]
Calc file
Comment 2 Regina Henschel 2009-06-06 12:40:09 UTC
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.