Ask Your Question
0

err:508 Copying from one file to another

asked 2016-12-12 14:46:47 +0200

redwdc gravatar image

updated 2016-12-12 14:51:23 +0200

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

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2016-12-12 22:57:05 +0200

smilingfrog gravatar image

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.

edit flag offensive delete link more
0

answered 2016-12-14 22:37:39 +0200

redwdc gravatar image

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-12-12 14:46:47 +0200

Seen: 57 times

Last updated: Dec 14 '16