Bug 121314 - Show rows vs filter
Summary: Show rows vs filter
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
Keywords: needsDevAdvice
Depends on:
Blocks: AutoFilter
  Show dependency treegraph
Reported: 2018-11-09 16:03 UTC by kabilo
Modified: 2023-09-08 05:14 UTC (History)
6 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 kabilo 2018-11-09 16:03:18 UTC
menu Format - Rows - Show or context menu Show rows displays rows hidden by a filter - this is a property or an error. Rows remain hidden in MSO.

Actual Results:
rows are show

Expected Results:
rows should remain hidden

Reproducible: Always

User Profile Reset: No

Additional Info:
Comment 1 m_a_riosv 2018-11-11 01:59:53 UTC
I think not a bug it just does what is required, show the rows, if in MSO does nothing then what it's their function?
Comment 2 kabilo 2018-11-12 08:26:31 UTC
I think Hide rows and filter are two different options. Show rows should only show rows hidden by Hide rows.
Comment 3 Roman Kuznetsov 2018-11-17 15:03:39 UTC
MSExcel doesn't show rows hidden by filter when I select Show rows in this case.

Heiko, Eike, any opinions?
Comment 4 Heiko Tietze 2018-11-18 10:30:16 UTC
Hidden rows/columns are shown per "Show columns" (or rows), where the user needs to select the hidden cells (A..C if B is hidden, or 1..3 in case of 2, or 1 for B, or A for 2).

The autofilter function _hides_ rows ($A != 2 for example). If now A is being selected and Format > Rows > Show executed, the filtered row is shown but the filter setting remains in place. So this is definitely a bug (likely a dup).

The issue could be solved by making a difference between filter and visible, probably solving some other bugs. OTOH it opens the door for new confusion when these two options are combined by the user.

@QA:  Missing a META ticket on (auto) filter issues.
Comment 5 m_a_riosv 2018-11-19 01:01:19 UTC
For me it's a great utility of how it works now, the ability to show some of the filtered rows without the need to re-elaborate the filter, what some times would be very difficult. 

Looks to me it is an improvement not a bug.

The filter it's not destroyed, so can be reapplied without rebuild it.
Comment 6 QA Administrators 2019-11-20 03:50:32 UTC Comment hidden (obsolete)
Comment 7 Kevin Suo 2021-11-26 10:53:51 UTC
Still reproducible on current master.

In my opinion, this is apparently a bug. The rows filtered-out by autofilter should only be shown by resetting the autofilter. The rows should not show by changing the row height (as in bug 36383) or by clicking the "Format > Row > Show".

"Format > Row > Show" is used to show up the hidden rows (right-click on row header > Hide). Filtered rows are not normal hidden rows.
Comment 8 Kira Tubo 2023-09-08 01:05:35 UTC
Reproduced on daily master build. 

To clarify on steps to reproduce: 
1. Add data to any column
2. Data > Autofilter
3. Filter out any rows within the column
4. Select the whole column
5. Format > Rows > Show 

Version: (X86_64) / LibreOffice Community
Build ID: 9a37652b79001bf5208841b9221dee851b9b6d0f
CPU threads: 6; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded
Comment 9 Kira Tubo 2023-09-08 05:14:42 UTC
Reproduced on LO v. 3.3.0