Bug 121314 - Show rows vs filter
Summary: Show rows vs filter
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.3.1 rc
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: needsDevAdvice
Depends on:
Blocks: AutoFilter
  Show dependency treegraph
 
Reported: 2018-11-09 16:03 UTC by kabilo
Modified: 2021-11-26 10:53 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments

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
Description:
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.