Issue 109556 - paste special with link of an empty cell doesn't link anything
Summary: paste special with link of an empty cell doesn't link anything
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 1.0.0
Hardware: All All
: P2 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks: 97765
  Show dependency tree
 
Reported: 2010-02-24 00:23 UTC by pposc
Modified: 2018-04-26 14:10 UTC (History)
5 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description pposc 2010-02-24 00:23:37 UTC
When copying a non empty cell (e.g. A1) using the option "link" of "paste
special", the result is a link to the source cell:
=$Sheet1.$A$1

When doing the same with an empty cell, we should expect the same formula as a
result. However, Calc doesn't copy anything (the result is an empty cell, of
course, but with no link at all with the source cell).

This behaviour is annoying when we like to copy/paste+link a set of cells, some
of them empty. Only the non empty cells are linked to the destination cells. If
the empty source cells are later populated, the destination cells will remain
empty (because they are not linked).
Comment 1 pposc 2010-02-24 00:28:18 UTC
We have tested OOo 2.0 - 2.4.3 - 3.1.1 on Windows XP and Linux (Fedora) : same
behaviour
Comment 2 Edwin Sharp 2013-08-20 12:56:22 UTC
As given in description.

Rev. 1514603 Win 7.
Comment 3 Boudewijn OVERGAAUW 2015-05-23 20:27:13 UTC
This is still not solved in OpenOffice 4.1.1 on Windows
Comment 4 Agata 2018-04-26 10:48:40 UTC
Still not solved in LibreOffice 6.0.3.2

It's a very annoying bug, as it requires a lot of work to make a workaround (when linking many cells, one has to fill and then delete the contents of all the empty ones or link them manually, both solutions are time consuming).
Comment 5 Keith N. McKenna 2018-04-26 14:10:54 UTC
(In reply to Agata from comment #4)
> Still not solved in LibreOffice 6.0.3.2
> 
> It's a very annoying bug, as it requires a lot of work to make a workaround
> (when linking many cells, one has to fill and then delete the contents of
> all the empty ones or link them manually, both solutions are time consuming).

This is the bug tracker for Apache OpenOffice. The LibreOffice bug tracker is at https://bugs.documentfoundation.org/