https://bugs.freedesktop.org/show_bug.cgi?id=55712
Priority: medium
Bug ID: 55712
Assignee: [email protected]
Summary: FILTER: Autofilter incorrect if filtered cells are
referenced in formulas
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 3.6.2.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 68187
--> https://bugs.freedesktop.org/attachment.cgi?id=68187&action=edit
NotUsedInFormula.ods
Hello
Steps to Reproduce
1. Open the attached spreadsheet NotUsedInFormula.ods
2. Click in A1 to open the AutoFilter list box
Expected and actual results: 8 values displayed
3. Open the attached spreadsheet UsedInFormula.ods
Same spreadsheet with cells in column C refers to cells of the filtered area by
formulas such as: =IF(A2=1, 1)
4. Click in A1 to open the AutoFilter list box
Expected Result: 8 values displayed
Actual result: 15 values displayed
5. Delete Column C
6. Click in A1 to open the AutoFilter list box
Expected and actual results: 8 values displayed
Reproduced with Version 3.6.3.0+ (Build ID: 1e73405)
Reproduced (fr-discuss)
This bug seems to be related (or have a different effect) of bug 54552
Regards
Pierre-Yves
--
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
