https://bugs.documentfoundation.org/show_bug.cgi?id=153759
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- Status|CLOSED |REOPENED Ever confirmed|0 |1 Resolution|NOTABUG |--- --- Comment #2 from [email protected] --- Not solved. My description has mistakes. Look again into the following, please: Steps to Reproduce claimed bug: 1. Open new Calc file. 2. Enter the number '1' into cell G1. Cell G1 now has the value '1'. 3. Enter the formula '=$G1' into cell D1. Cell D1 now has the value '1' same as cell G1. 4. Mark column D and enter key-combination Ctrl+C to copy marked column D. 5. Left-click on column B and select "Insert Columns Before". 7. Note how value '1' has shifted from cell D1 to cell E1 as it should. However, column D is still the copied cell as indicated with vertically moving interrupted lines around the column D. 8. Note that column B is still marked. 6. Enter key-combination Ctrl+V to insert copied column D into column B. Cell B1 now has the value '0' instead of '1', because it is still referencing Cell G1 instead of H1. Same steps bring correct reference and value '1' in Microsoft Excel. My explanation: When a column is added on the left side of marked/copied column D, the marked/copied column D's content shifts to the right and its reference shifts also +1 column, which is ok of course. However, the "marking of copy" doesn't shift to the right. It stays on column D, which I find wrong already. But let's say that is ok, we can at least agree that at this moment, column D has no value anymore since it was shifted +1 column. So at this state, if I press Ctrl+V, then it should at least paste no value because column D has no value. Instead, it pastes column D's old reference value, which is definitely wrong. My fix proposal: I believe the problem is fixed if the "marking of copy" also shifts when everything else shifts. Or, take off the "marking of copy" when everthing shifts, so I am forced to recopy the correct column again. Comparison to Microsoft Excel: Microsoft Excel gives two options to add a new column while another has "marking of copy". 1. Add new column with a copy of marked column. Then, it takes off the "marking of copy", so that the user has to mark and copy it again if he needs it. 2. Add new column without a copy of marked column. Then also, it takes off the "marking of copy". Conclusion: Simplest solution in my eyes is to take away the "marking of copy" evertime new cells are added, so that the user is forced to start a new copy procedure. This is what Microsoft Excel does. Sorry for the long text, I hope this makes sense. -- You are receiving this mail because: You are the assignee for the bug.
