https://bugs.documentfoundation.org/show_bug.cgi?id=171282
Bug ID: 171282
Summary: FILEOPEN Intersection with a union as operand is not
detected
Product: LibreOffice
Version: 5.1.6.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 206129
--> https://bugs.documentfoundation.org/attachment.cgi?id=206129&action=edit
intersection on union
Open attached spreadsheet.
It has functions SUM and AREAS. The parameter is an intersection of the range
B2:E3 with the union of ranges C3:C5 and E3:E5. Thus the resulting parameter is
a reference list of cells C3 and E3. The operators for intersection and union
depend on the language of your Excel. The brackets for the union are necessary
to distinguish a union from a list.
Error is, that the range operators are not detected. The intersection should be
character ! and the union should be character ~.
If you correct the formulas to
=SUM(B2:E3!(C3:C5~E3:E5))
and
=AREAS(B2:E3!(C3:C5~E3:E5)),
then the results are correct. Thus LibreOffice is able to calculate such
formulas, but the import from Excel is wrong.
The problem exists at least since Version: 5.1.6.2 (x64)
Build ID: 07ac168c60a517dba0f0d7bc7540f5afa45f0909
CPU Threads: 32; OS Version: Windows 6.19; UI Render: GL;
Locale: de-DE (de_DE); Calc: group
--
You are receiving this mail because:
You are the assignee for the bug.
