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@lists.freedesktop.org
Reporter: m...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs