Err:508 Copying from one file to another

Hi,

I use 1 file per year with 14 28 day sheets (over lap of months). I’m trying to copy the data from one file to the next.

This is what I’m doing with both files open:

  • click in R2 of 2017 and type “=SUM(” (if I use the closing “)” i get other problems see below.)
  • then click in R30 of 2016
  • go back to 2017 and press “Enter”

I get Err.508 in the cell. On the formula bar I see:

=SUM(‘file:///d:/data/reds/misc_2016.ods’#‘16-12-26’.r30)


If I use “=SUM()” with the cursor between the parentheses on the formula bar I get:

=SUM(‘file:///d:/data/reds/misc_2016.ods’#‘16-12-26’.r30))

which according to help.libreoffice.org would be:

508 | Error: Pair missing | Missing bracket, for example, closing brackets, but no opening brackets.

I’m using:
LibreOffice Version 5.2.3.3 (x64) on Windows 10 (1607 build 14393.447)

Bobby

Do you need the files to be linked? Are you going to change the data in 2016 later, and want those changes to be reflected in 2017?
If that isn’t important, I would suggest you copy the last sheet to your new file (Sheet>Move/copy) and link to those cells.

Otherwise, I think your error is that the formula is missing a $

=SUM('file:///d:/data/reds/misc_2016.ods'#$'16-12-26'.r30))

to indicate the sheet name.

I have discovered what the problem is. The name of the directory the files are in has an apostrophe in it “RED’s”.

=SUM(‘file:///d:/data/red’s/misc_2016.ods’#$‘16-12-26’.r30)

So, smilingfrog was right but it doesn’t fix my problem.