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

Just tried on my mac.
Open the sheet I want to perform the calculation in.
Open the source sheet from which I want to fetch the data

Enter the formula in a cell in the first sheet, i.e =2*
then click in the source cell in the second sheet,
then click enter and it seems to work.
steve

On 30/10/17 07:42, bunk3m wrote:
> 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