https://bz.apache.org/ooo/show_bug.cgi?id=127825
Issue ID: 127825
Issue Type: DEFECT
Summary: Standard filter with option "No duplication" is losing
results.
Product: Calc
Version: 4.1.5
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: Normal
Priority: P5 (lowest)
Component: code
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
The standard filter offers the option to suppress repetitions.
Applied to long data columns it returns less distinct items than actually
contained.
>From a few tests it seems that a maximum of 16384 distinct items can be
handled. Yes. That's a Strange number. We might expect a maximum of 2^15=32768
if an array with non-negative indices of type Integer (16 bit) was used. But
2^14?
The bug was found by a friend of mine. I reproduced it with an independent
example under AOO V4.1.5 (from PortableApps package). In both cases the error
occured as well when filtering in situ as when delivering the results to a
different range (option 'Copy results to...').
Occurring only with data sets of more than 16384 items, it's a poisonous bug,
because few users will look thoroughly enough on the results to notice it.
The attached demo needs a large file due to the nature of the bug. To open it
will take some time.
--
You are receiving this mail because:
You are the assignee for the issue.