https://bugs.documentfoundation.org/show_bug.cgi?id=151851
Bug ID: 151851
Summary: Sorting array formula works differently in Calc
compared to Excel
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Created attachment 183357
--> https://bugs.documentfoundation.org/attachment.cgi?id=183357&action=edit
Sorting array formula example
In the attachment, the data range "range1" (A1:A15) is sorted in C1:C15 using
array formulas like
> {=INDEX(range1;MATCH(LARGE(COUNTIF(range1;">"&range1);ROW(C1:C1));COUNTIF(range1;">"&range1);0))}
The results in Excel start with sorted cells containing data, then zeroes; in
Calc, zeroes are first.
It seems to me that Calc is correct in this case (because indeed, empty cells
are those that have most other cells greater than them); but this is an interop
problem; and anyway, maybe I miss some detail (I always am confused by array
evaluation).
--
You are receiving this mail because:
You are the assignee for the bug.
