Bug 36383 - EDITING auto row height or change row height removes AutoFilter result
Summary: EDITING auto row height or change row height removes AutoFilter result
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: low minor
Assignee: Not Assigned
URL: https://bz.apache.org/ooo/show_bug.cg...
: 74510 (view as bug list)
Depends on:
Blocks: AutoFilter
  Show dependency treegraph
Reported: 2011-04-19 01:42 UTC by Gualtiero Testa
Modified: 2019-03-13 00:26 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

ODS file to show the bug (8.44 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-04-19 01:43 UTC, Gualtiero Testa

Note You need to log in before you can comment on or make changes to this bug.
Description Gualtiero Testa 2011-04-19 01:42:32 UTC

when using filter, only the rows which match the filter are shown. Correct.

But if I use the auto height feature (optimal row height) by double clicking on the column which contains the rows number (on the left), some of the filter-out rows are shown again. This is not correct.

In the attached file there are four data rows and one header row.

If I add a filter on the first column (Type) to select the rows which contains the value "A", the filter hide the row 4 which contains the value "B".

The row with "B" is show again if I double click on the row dividers, even if the filter is in place !
Comment 1 Gualtiero Testa 2011-04-19 01:43:28 UTC
Created attachment 45800 [details]
ODS file to show the bug
Comment 2 Rainer Bielefeld Retired 2011-04-19 04:39:27 UTC
[Reproducible] with reporter's sample document and "LibreOffice 3.3.2  – WIN7  Home Premium  (64bit) German UI [OOO330m19 (Build:202 / tag]". Also reproducible with my own documents.

Steps to reproduce:
0. open sample document document
1. Click autofilter filter pulldown in 'B1'
2. Select filter for "AA"
   At least row 4 will disappear (additional rows depend on your search
   and filter settings)
3. Click common Row / Column Heading field to select all
   (or press <cntrl>+<a>
4. Right click on row heading "2" 
   context menu appears
5. Click 'Optimal row height'
   expected: nothing than row height will change
   actual: invisible rows will become visible.

The corresponding OOo issue is
"Changing row height shows filtered rows"

Your area?
Comment 3 Gualtiero Testa 2011-05-01 11:59:20 UTC

I've found that the Microsoft Excel 2007 shows the same behaviour as the one reported in this bug.

So may be Calc programmers have decided here to emulate Excel.

In any case, it looks to me a very strange behaviour.
Comment 4 Muthu 2011-07-01 03:17:39 UTC
Yes, seems like it is done on purpose (as described in the OOo bugzilla/issuezilla). Maybe wait for more suggestions?
Comment 5 Rainer Bielefeld Retired 2011-07-01 03:40:17 UTC
Old issue, also visible in OOo 3.1.1, 1.1.4

I really would be glad if  LibO would stop to emulate EXCEL bugs ;-)
Any Idea what for what the current should be useful? Why will row height be modified for rows hidden by filter, but modification of background, number format and others will not touch hidden rows? To me the current behavior seems to be without any logic.
I can't read in OOo issues that the observed behavior might be intended.
Comment 6 Muthu 2011-12-15 01:22:15 UTC
@Rainer: Really no idea :) Maybe somebody else might know a better reason? Kohei or Eike maybe?
Comment 7 Muthu 2012-01-11 03:33:04 UTC Comment hidden (no-value)
Comment 8 retired 2014-01-08 09:20:25 UTC Comment hidden (obsolete)
Comment 9 Joel Madero 2015-05-02 15:41:33 UTC Comment hidden (obsolete)
Comment 10 Gualtiero Testa 2015-05-04 06:22:05 UTC
I confirm the bug (tested again on LO on Windows 7)

No changes in the behaviour.
Comment 11 Buovjaga 2015-10-16 19:37:25 UTC
*** Bug 74510 has been marked as a duplicate of this bug. ***
Comment 12 QA Administrators 2016-11-08 11:17:01 UTC Comment hidden (obsolete)
Comment 13 Thomas Lendo 2017-10-18 19:37:15 UTC
Still repro.

Build ID: 5ea1b4c336d1cad92dc18e7cf7e4b381396f448b
CPU threads: 4; OS: Linux 4.10; UI render: default; VCL: gtk3; 
Locale: de-DE (de_DE.UTF-8); Calc: group
moggi's auto updater build, 2017-10-18
Comment 14 Roman Kuznetsov 2018-07-29 17:48:10 UTC
still repro in lo