Hi.
My Mac has LO 5.1..., My Linux 5.3...
When I add the connection on my Mac as in my earlier test I get a
formula like
='file:///mnt/public/Documents/Global/List of CDs.ods'#$Sheet1.C11
I don't get any error, it calculates fine on creation of the formula,
but cannot get it to update if the
Thank you for testing this, Steve.
I tried what you suggested near the beginning of my testing and tried it
again just now. When I follow your instructions, I get an ERR:507.
I've tried following the instructions that Remy provided [The link was
inserted as per the instructions in the help
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
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
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
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
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
