https://bugs.freedesktop.org/show_bug.cgi?id=60385
Priority: medium
Bug ID: 60385
Assignee: [email protected]
Summary: Formula returns Err:509 Missing Operator
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: 3.6.2.2 release
Component: Spreadsheet
Product: LibreOffice
I'm running LibreOffice Spreadsheet 3.6.2.2 in Ubuntu 12.10. The minus operator
used with references to cells in other sheets which have spaces in their names
more than once in a formula usually generates a 509 error.
For example:
=-'1 2 3'!r[-7]c-'1 2 3'!R[-7]C
=-'1 2'!r[-8]c-'1 2'!R[-8]C
=-'s 1'!r[-9]c-'S 1'!R[-9]C
=-'sheet 2'!r[-10]c-'Sheet 2'!R[-10]C
=-'sheet 2'!r1c1-'Sheet 2'!R1C1
all generate Err:509 rather than the expected result.
whereas:
=-Sheet8!R[-12]C-Sheet8!R[-12]C
generates the expected result.
A single minus operator and reference to the other sheet works as expected, and
I notice that if I add the second minus operator and reference, the name of the
first sheet reference changes to lower-case.
If I put a space in the name of a sheet used in a working formula with the
minus operator, it continues to work, whether or not I re-enter it. If I enter
the same formula in a new cell, it returns an error.
I'm using R1C1 references, and both absolute and remote references are
affected.
It is possible to work round the problem by placing the cell references in
brackets and applying the minus sign outside the brackets, for example:
=-('sheet 2'!r1c1+'Sheet 2'!R1C1)
generates the expected result.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
