https://bugs.freedesktop.org/show_bug.cgi?id=73344
Priority: medium
Bug ID: 73344
Assignee: [email protected]
Summary: INDIRECT fails with defined names of range union /
multiple areas
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: NEW
Version: unspecified
Component: Chart
Product: LibreOffice
If a defined name contains multiple ranges, unioned, INDIRECT doesnt produce a
ref. This behaviour also occurs on MS Excel 2007, so perhaps it is desirable
to maintain compatibility.
To reproduce
A1: 2
A2: 2
A3: 2
A4: =A1~A3
A5: =AREAS(A1~A3)
A6: =SUM(A1~A3)
A7: =COUNT(A1~A3)
define blah to be "$A$1~$A$3"
B4: =blah
B5: =AREAS(blah)
B6: =SUM(blah)
B7: =COUNT(blah)
C4: =INDIRECT("blah")
C5: =AREAS(INDIRECT("blah"))
C6: =SUM(INDIRECT("blah"))
C7: =COUNT(INDIRECT("blah"))
Expected results:
A4=#VALUE
A5=2
A6=4
A7=2
B4=#VALUE
B5=2
B6=4
B7=2
C4=#VALUE
C5=2
C6=4
C7=2
Actual results (Calc and MS Office 2007):
A4=#VALUE
A5=2
A6=4
A7=2
B4=#VALUE
B5=2
B6=4
B7=2
C4=#REF
C5=#REF
C6=#REF
C7=0
Redefine blah to be "$A$1:$A$2" and the results are as expect.
--
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
