https://bugs.documentfoundation.org/show_bug.cgi?id=158314

            Bug ID: 158314
           Summary: Autofilter always shows "Empty" entry as active
           Product: LibreOffice
           Version: 7.6.3.2 rc
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Created attachment 190961
  --> https://bugs.documentfoundation.org/attachment.cgi?id=190961&action=edit
simple test spreadsheet

Steps to Reproduce:

1. Assume we have the following in a spreadsheet:
a       b
1       5
2       <blank>
3       7
4       8

(Note that the place marked as <blank> should be left empty)

2. Set autofilter, select "1" in the drop-down of column a, OK, then click the
drop-down of column b.

Current Behaviour:
The drop-down of column b shows both "(empty)" and "5" as active.

Expected:
The drop-down of column b shows only "5" as active, because in this case the
only remaining record is "5".

Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 0660a763466bfa0012d16f60f82b0ffb2f341b64
CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: zh-CN (zh_CN.UTF-8); UI: zh-CN
Calc: threaded

also in
Version: 7.6.4.0.0+ (X86_64) / LibreOffice Community
Build ID: bab433911bdecb344f7ea94dbd00690241a08c54
CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: he-IL (zh_CN.UTF-8); UI: zh-CN
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to