Re: [libreoffice-users] Calc 5.x Mac - syntax to link cells in two spreadsheets?

Hello,

This is not a MAC reference (it is a Linux reference), but this syntax
(LO 5.4.2.2 Linux/Fedora 64-bit) works well for me:

='file:///mnt/public/Documents/Global/List of CDs.ods'#$Sheet1.C11

The link was inserted as per the instructions in the help (https://help
..libreoffice.org/Calc/Referencing_a_Cell_in_Another_Document)

I hope it helps.

Rémy Gauthier.

Le dimanche 29 octobre 2017 à 14:42 -0400, bunk3m a écrit :
> Hello all,
>
> I've been struggling with this one for a week now.  Google hasn't been 
> my friend so far so thought I'd ask the user group.
>
> LO 5.4.2.2 Mac 64 Bit.
>
> I have a spreadsheet (originally in xls but now ods) where data is 
> provided to a summary spreadsheet.
>
> I am unable to get the syntax to link the cells in the two spreadsheets 
> on my Mac.
>
> I've tried, single and double quotes for file location, "." or "!" for 
> identifying the source cell but nothing seems to work.  I get 
> ERR:507/ERR:508/ERR:501/ERR:510 and occasionally #NAME?#
>
> The file names have spaces as do the tab in the spreadsheet.
>
> I've tried the =HYPERLINK(file:///... and ='file:///...' commands but 
> that doesn't work.
>
> I've also tried the Insert Hyperlink but that won't let me select the 
> cell in target spreadsheet.
>
> I'm loath to go back to Excel for this one spreadsheet but I've been 
> linking spreadsheets in Excel for so long and it works.
>
> I'd appreciate any Mac specific guidance.
>
> Bunk3m.
> PS on Digest mode.  Please cc me directly in addition to answering to 
> the list.
-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted