https://bugs.freedesktop.org/show_bug.cgi?id=76125

          Priority: medium
            Bug ID: 76125
          Assignee: [email protected]
           Summary: FILTER: autofilter on "boolean" column with only 1 (0
                    state stays empty)
          Severity: normal
    Classification: Unclassified
                OS: Windows (All)
          Reporter: [email protected]
          Hardware: Other
        Whiteboard: BSA
            Status: UNCONFIRMED
           Version: 4.2.1.1 release
         Component: Spreadsheet
           Product: LibreOffice

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

-- 
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

Reply via email to