At 12:02 24/06/2015 +1000, John Sparrow wrote:
I am linking data in one Master worksheet to another Slave worksheet
in the same workbook.
Are you sure you are using LibreOffice? Calc calls these "sheets" and
"spreadsheets"; you are using the language of Another Product!
The Master worksheet has blanks in its data. These blanks will be
filled in at some future time - hence I need to be able to link
those blank cells to the Slave worksheet. Libre Office Help says
Copy the data, open the Paste Special dialog, tick the "paste all"
box, and the "Link" box, and click OK. Doesn't work for me. What am
I doing wrong?
Nothing, it seems: apparently empty cells are not linked. (You must
mean that your cells are empty, not that they "have blanks".)
There is an easy workaround. Just fill your empty cells in the source
with some placeholder and then paste the link to the new range with
noi empty cells. You could leave the placeholders until the source
cells needed their real values or you could remove the values after
you have created the links.
You say that your source range "has blanks in its data", by which I
believe you must mean empty cells. If your cells contain blanks - a
string of one or more blanks - you will not see the problem. A blank
string, then, is a perfectly suitable placeholder.
Note that if you empty the source cells after creating the links, you
may find that the target cells will show as zero, not empty. If
necessary, you can work around this is various ways, including
perhaps setting the cell format to #.
I trust this helps.
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy