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