Bug 117328 - RESET FILTER will not restore all lines of area containing empty cells
Summary: RESET FILTER will not restore all lines of area containing empty cells
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Data-Filter
  Show dependency treegraph
Reported: 2018-04-29 09:10 UTC by Rainer Bielefeld Retired
Modified: 2021-06-19 14:00 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:

test file (8.64 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-04-29 09:12 UTC, Rainer Bielefeld Retired

Note You need to log in before you can comment on or make changes to this bug.
Description Rainer Bielefeld Retired 2018-04-29 09:10:01 UTC
Steps how to reproduce with Version: (x64)
Build-ID: cb47f0d320994e001bc38dc2ee9b7d957b15e6ab
CPU-Threads: 4; BS: Windows 6.1; UI-Render: Standard; 
Gebietsschema: de-DE (de_DE); Calc: CL, special user profile for testing, Tango theme:

1. Open attached test file
2. Click Auotfilter-▼
3. Type search string "5" → [ok]
   » only 1 line containing "5" remains below heading "Heading"
4. Click on B2 containing "5"
5. Menu ˋData → More Filters → Reset Filterˊ
   Expected: all hidden lines restored
   Actual: Lines 13 ... 30 missing                                      😥

Additional information:
a) related to or DUP of "Bug 92626 - Resetting a filter in Calc results in 
   not every row being displayed "? I can't tell
Comment 1 Rainer Bielefeld Retired 2018-04-29 09:12:57 UTC
Created attachment 141755 [details]
test file

b) No other obvious DUPS found with http://shortlinks.de/p066
c) Already REPRODUCIBLE with Version: (x64)
   Build-ID: 8f48d515416608e3a835360314dac7e47fd0b821
   Windows 6.1; UI-Render: Standard; 
   localization: de-DE (de_DE);
Comment 2 Rainer Bielefeld Retired 2018-04-29 09:18:13 UTC
d)  already reproducible with Version: (x64)
    Build-ID: 066b007f5ebcc236395c7d282ba488bca6720265
    CPU-Threads: 4; BS-Version: Windows 6.1; UI-Render: Standard; 
    Gebietsschema: de-DE (de_DE)
Comment 3 Rainer Bielefeld Retired 2018-04-29 11:26:53 UTC
e) problem is related to empty cells
f) Already reproducible with Version:
   Build ID: f4a4fee523ff8a6d272eabda2ce9ca96bd3bbbb
   TinderBox: Win-x86@6, Branch:master, Time: 2013-06-14_23:53:13
   own user profile
g) Already reproducible with AOO420m1(Build:9800)  - Rev. 1692551
   Inherited from OOo?
   Already reproducible with OOo 1.1.5
   Nu issue found there
Comment 4 raal 2018-04-29 18:21:40 UTC
I can confirm with Version:
Build ID: 4dbce627d3643babaf90a93c70b365ff08abfca6
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk2;
Comment 5 Rainer Bielefeld Retired 2019-04-23 17:15:49 UTC
Still annoying with Version: 
Build ID: 2e3b0c5d42d60d46cd9f8b8eda9424b095c63418; Windows 6.1

For me 6.3 still is not ready for real work
Comment 6 b. 2020-09-04 18:35:14 UTC
still bug with: 

Version: (x64)
Build ID: <buildversion>
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default; VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc: CL
Comment 7 stragu 2021-06-19 14:00:10 UTC
Reproduced as described in Description (although "B2" should be "B3") with:

Version: / LibreOffice Community
Build ID: 94d552f94b427f884c004dba5d4619ecf729d605
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-06-18_13:30:27
Calc: threaded