| Summary: | FILTER: autofilter on "boolean" column with only 1 (0 state stays empty) | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | bcag2 |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | CC: | jbfaure |
| Priority: | medium | ||
| Version: | 4.2.1.1 release | ||
| Hardware: | Other | ||
| OS: | Windows (All) | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
Not a bug. The case Not Empty does exactly what you want. "Top Ten" too. Best regards. JBF |
Problem description: Steps to reproduce: 1. create a column with "boolean" type 0 or 1 2. type only 1 or nothing 3. create auto-filter 4. select only 1 Current behavior: it always displays all rows Expected behavior: I want it displays only 1 rows Workarounds : if I enter 0 (minimum 1 time) instead of nothing, it works. If I select "Not Empty" too. Same issue in 4.2.0.4 under Ubuntu Trusty beta1 Comment : in my real worksheet, I have about 100 rows and I only want to select few one (about 10), so I put 1 in some and filter. I know I can use "Not Empty" but I think it should be correct to can select only 1 (in Excel 2003, it works !) Regards Bertrand Operating System: Windows XP Version: 4.2.1.1 release