Bug 134351 - Wrong Auto Filter Result if the record contains only one single row
Summary: Wrong Auto Filter Result if the record contains only one single row
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: lowest trivial
Assignee: Not Assigned
Keywords: bibisected, bisected, regression
Depends on:
Reported: 2020-06-28 04:09 UTC by Kevin Suo
Modified: 2020-07-14 10:39 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Kevin Suo 2020-06-28 04:09:54 UTC
This is a minor bug.

Steps to Reproduce:

1. Type in the following in A1 and A2:

2. Set auto filter.

3. Click on the dropdown list in A1 and type in "1" in the input box, then click OK.

Current Result:
The filtered result is NONE.

Expected Result:
The filtered result should either be 1, or Calc just refuses to show the filter, as there is only one row.
Comment 1 Kevin Suo 2020-06-28 04:11:12 UTC
Regression caused by:
author	scito <info@scito.ch>	2020-04-03 16:13:42 +0200
committer	Serge Krot (CIB) <Serge.Krot@cib.de>	2020-04-29 17:21:25 +0200
commit	e9c04fdc6d91a152c9197bda3b07316bed1dc4f3
tdf#130770 apply autofilter to data regardless of autofilter changes

(Before that commit, when type in 1 in the filter input box and click ok, then the filtered is not set. After that commit, the filter is set but NONE is shown which is wrong).

Adding Serge Krot to cc list - would you please take a look? thanks.
Comment 2 Xisco Faulí 2020-07-14 10:39:03 UTC
Reproduced in

Build ID: fa844c15233f108a0e9b0b2e8c9757c1aa088a4b
CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

I also confirm the bisection in comment 1 is correct

Adding Cc: to Serge Krot