Ask Your Question

err:508 Copying from one file to another [closed]

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

redwdc gravatar image

updated 2020-08-23 17:31:13 +0100

Alex Kemp gravatar image


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:


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


which according to would be:

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

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


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-11 14:21:23.044698

2 Answers

Sort by » oldest newest most voted

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

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 $


to indicate the sheet name.

edit flag offensive delete link more

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

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".


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

edit flag offensive delete link more

Question Tools

1 follower


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

Seen: 89 times

Last updated: Dec 14 '16