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

But it does in Linux, may be a Mac bug.

On 30/10/17 09:20, Steve Edmonds wrote:
> But the second sheet doesn't recalculate if the source is changed, 
> even with recalculate.
>
> 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