[Libreoffice-bugs] [Bug 141349] New: Copying a column with Absolute referencing does not work

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=141349

            Bug ID: 141349
           Summary: Copying a column with Absolute referencing does not
                    work
           Product: LibreOffice
           Version: 7.1.0.3 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: marty.bugzilla at spam86.com

Description:
If I copy an entire column that contains cells using absolute references ($),
the copied cells do not reference the correct location. The absolute reference
is ignored. I have to go each cell in the original column and copy them one by
one for the proper absolute reference to work. 

Steps to Reproduce:
1.Create a cell with an absolute reference to a cell to the right. 
2. Copy the entire column
3. Paste insert the column (paste all, shift cells right)
4. the cell will reference the wrong location

Actual Results:
the wrong cell is used by the formula

Expected Results:
I expect the data in the cell in the absolute reference to be used in the cell
formulas in the pasted column.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210330/8fc0f660/attachment.htm>