https://bugs.documentfoundation.org/show_bug.cgi?id=153759
Buovjaga <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |ilmari.lauhakangas@libreoff | |ice.org --- Comment #5 from Buovjaga <[email protected]> --- (In reply to milchreis from comment #2) > 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. I tried in office.com's Excel and nothing is pasted in the last step. I used "Insert columns to the left". -- You are receiving this mail because: You are the assignee for the bug.
