[Libreoffice-bugs] [Bug 114659] New: Pasting cells between sheets uses absolute values ( not cross-sheet references)

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 114659
           Summary: Pasting cells between sheets uses absolute values (not
                    cross-sheet references)
           Product: LibreOffice
           Version: 5.4.4.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mail at samtuke.com

Description:
When copying and pasting cells which contain formulas between two sheets of the
same document, the values are inserted literally, instead of pasting the
formulas with references to the original sheet, as expected. By default,
references should be used instead of literal values.

Steps to Reproduce:
1. Create some calculations using formulas and cell references within sheet #1
2. Create sheet #2 in the same document and copy the cells from sheet #1
3. Double click the pasted cells and observe the values are literal numbers --
the formulas are gone

Actual Results:  
Formulas are lost and literal values are inserted

Expected Results:
Formulas are inserted, with automatically updated cell references pointing to
sheet #1 in the same document.


Reproducible: Always


User Profile Reset: No



Additional Info:


User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:59.0) Gecko/20100101
Firefox/59.0

-- 
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/20171222/2a56c0c9/attachment.html>