https://bugs.documentfoundation.org/show_bug.cgi?id=153759
Bug ID: 153759
Summary: EDITING: Mark column -> Ctrl+C -> right-click ->
Insert Columns Before -> Ctrl+V -> wrong reference
despite $
Product: LibreOffice
Version: 7.4.5.1 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When done the steps stated in Summary, cell reference gets moved, even though
cell reference is protected by $
Steps to Reproduce:
1. Open new Calc file.
2. Enter the number '1' into cell E1. Cell E1 now has the value '1'.
3. Enter the formula '=E$1' into cell D1. Cell D1 now has the value '1' same as
cell E1.
4. Left-click on column D to mark column D. Enter key-combination Ctrl+C to
copy marked column D.
5. Left-click on column B and select "Insert Columns Before".
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 now reference Cell C1
instead of D1.
Actual Results:
Cell B1 is referencing C1.
Expected Results:
Cell B1 should reference D1.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.4.5.1 (x86) / LibreOffice Community
Build ID: 9c0871452b3918c1019dde9bfac75448afc4b57f
CPU threads: 12; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: en-US (en_GB); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
