Re: [libreoffice-users] Link Paste Special in Calc

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

John




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.
https://www.avast.com/antivirus


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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