Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Formula with cells arguments do not update when copying and paste insert | ||||||
---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | walidz <openoffice> | ||||
Component: | editing | Assignee: | AOO issues mailing list <issues> | ||||
Status: | CONFIRMED --- | QA Contact: | |||||
Severity: | Trivial | ||||||
Priority: | P3 | CC: | issues, rb.henschel | ||||
Version: | OOO310m11 | ||||||
Target Milestone: | --- | ||||||
Hardware: | Unknown | ||||||
OS: | All | ||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
Description
walidz
2009-06-06 10:36:54 UTC
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. |