https://bugs.documentfoundation.org/show_bug.cgi?id=89479
Bug ID: 89479
Summary: FILTER: Special filter selects wrong rows of the input
data area confusing the indices
Product: LibreOffice
Version: 4.2.8.2 release
Hardware: Other
OS: Windows (All)
Status: UNCONFIRMED
Severity: critical
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 113519
--> https://bugs.documentfoundation.org/attachment.cgi?id=113519&action=edit
test case
s. attached file with bug.
Handling of data area filtering is strange. There are several bugs and an
overall strange behaviour with slightly unpredictable results.
In the attached file I did the following:
1. Populate a 10-column-table with rows of values in sheet NormData
2. Populate a 10-column-table with 1 row of filter-criteria values in sheet Jan
(identical table headers)
3. Define 3 areas for data (in), filter criteria (crit) and output area (out)
(this one in table Jan as well underneath the crit-area) respectively
4. Mark the data area in NormData and choose menu Data.Filter.Special filter
4a. 1. error: Dropdownlist in dialog window for filter crit. is empty but
should be filled with 3 defined areas
4b. fill field with crit-area and click OK: Nothing happens!?
4c: if you alternatively choose the output area in the dialog Options.copy
results to: instead, table row indices of in- and output seem to be confused
because you see rows starting from the beginning of the ouput table with
content from the same row in the input table (instead of the content starting
from first row on filtered data)
Sometimes when the output table is updated there are old rows at the end from a
previous output.
I believe that input and output indices are confused. Would you please check
this. It's an easy to fix problem with strong achievements for professional
users.
Regards,
fury
--
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
