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.

Reply via email to