https://bugs.documentfoundation.org/show_bug.cgi?id=156585
Bug ID: 156585
Summary: Calc - paste special with link does not copy empty
cells
Product: LibreOffice
Version: 7.4.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When I copy-special (link option) empty cells from one sheet to another, I do
not get a link to the original cells, but completely empty cells, with no
links. If a cell in the original sheet is emptied, then the cell linked to it
shows the value '0'.
Steps to Reproduce:
1.create sheet A containing some filled and some empty cells
2.create sheet B
3.copy the content of sheet A
4. paste it into sheet B with 'paste special' selecting 'link' option and
'paste all' selected
5. in sheet B the cells that contained something in sheet A will be correctly
linked to their origin; cells that were empty in sheet A contain nothing in
sheet B (while I'd expect them to contain a link to the corresponding cell in
sheet A). This is annoying because you want ALL changes in sheet A (including
filling empty cells) to be reflected in sheet B.
6. Delete the content of a non-empty cell in sheet A, that was correctly linked
in sheet B. Now the corresponding cell in sheet B still contains the link to
the original cell in sheet A, but it contains a value of 0. This is quite
worrisome because empty is not the same as 0; i.e., after the change the cell
will be empty in sheet A and contain '0' in sheet B.
Actual Results:
see steps to reproduce
Expected Results:
see steps to reproduce
Reproducible: Always
User Profile Reset: No
Additional Info:
The bug was first noticed in 2010 in the OO forum (very clear explanation),
with a message in 2018 confirming it in Libreoffice as well.
https://bz.apache.org/ooo/show_bug.cgi?id=109556
--
You are receiving this mail because:
You are the assignee for the bug.
