Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index

Thanks, Brian.
My delay in responding has been that I've been trying this work around.
I've also found another which may be more satisfactory.
My array is continuous, so if I link the top left cell from one to the other, remove the "$" mark from the cell details (A1 instead of $A$1), and then copy that cell to the equivalent of all of the cells in the second sheet. This links the empty cells.

That system is not perfect for me because after some manipulation, I need to create a CSV of the sheet as a standalone to import into a Genealogy Software program. In that process, the empty cells get converted to 0's. At least it's a step in the right direction.

Many thanks


On 24/06/2015 10:49 PM, Brian Barker wrote:
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.

Brian Barker

This email has been checked for viruses by Avast antivirus software.

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.