Bug 93664 - filter a list with merged cells does not work
Summary: filter a list with merged cells does not work
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
4.2 all versions
Hardware: Other All
: medium normal
Assignee: Not Assigned
Keywords: bibisected, bisected, regression
Depends on:
Blocks: RTL-CTL Calc-Merge-Split Data-Filter
  Show dependency treegraph
Reported: 2015-08-25 17:42 UTC by Emersson Augusto Suarez Ortiz
Modified: 2020-04-17 07:39 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:

Misfiltering file (24.07 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-08-25 17:42 UTC, Emersson Augusto Suarez Ortiz
Sample modified (25.33 KB, application/vnd.oasis.opendocument.text)
2015-08-25 23:34 UTC, m.a.riosv
Filtering Cells but in rows (31.44 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-08-31 20:17 UTC, Emersson Augusto Suarez Ortiz
simple test case (9.46 KB, application/x-vnd.oasis.opendocument.spreadsheet)
2015-09-15 10:11 UTC, raal
example of filter on vertical merged cells (10.19 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-11-11 17:36 UTC, mt

Note You need to log in before you can comment on or make changes to this bug.
Description Emersson Augusto Suarez Ortiz 2015-08-25 17:42:58 UTC
Created attachment 118175 [details]
Misfiltering file

I have a file with a list in varios merged cells, and when a try to filter, it ask for the name to use, and is ok, but when you display the filter list, only show the "Empty" and the value of a cell out of the range with the merged cell.

It may be very more symple in the attached file.
Comment 1 m.a.riosv 2015-08-25 23:34:51 UTC
Created attachment 118180 [details]
Sample modified

Hi @Emerson, thanks for reporting.

Taking a look, the filter button is for the last column in the merged range.
You can see better selecting Standard filter where you can select the proper column for the filter.

I'm not sure really a bug, because all columns are part of the filter.

Perhaps it could be a request for enhancement, that in merged cells the filter of the left cell was showed. But then it also must be dependant of the language, LTR or RTL.

I have done a little modification in your file.
Adding a new row just below the header filter row.
Copying the titles and set up this new row as filter header.
Group the row with [F12] Menu/Data/Group and outline, so clicking on the minis it can be hide or when is hide clicking on the plus can be showed, if you can see it there is an option in View Calc options.

So it's possible to select as you can, avoiding to print the filter row.

And adding a blank row before subtotals row, we can avoid the filter including it.
Comment 2 Emersson Augusto Suarez Ortiz 2015-08-26 04:21:39 UTC
Helo, may be I can not show my point. In the file "Misfiltering file", I hope that when I click on each column it show me the list whit the elements in the column, but the filter only work whit the last one of the Columns. If you select "All items" in the last column, the other filter don't show all the elements in the respective column, then you only can filter the range by the last one. I hope the filter work in every column as it work when you don't have merged cells.
Comment 3 Emersson Augusto Suarez Ortiz 2015-08-26 04:25:10 UTC
Now I watch your modification and it is exactly what suppose not to do, why you have to use unmerged cells to filter a range whit merged cells? I really think it is a bug, and unfortunately (for me) I'm only a user and can not help the team to fix it.
Comment 4 m.a.riosv 2015-08-29 13:53:48 UTC
Change to unconfirmed, so other person can test it.
Comment 5 Emersson Augusto Suarez Ortiz 2015-08-31 20:17:20 UTC
Created attachment 118298 [details]
Filtering Cells but in rows

The past two files was with merged cells between 2 or more columns, but in this new file, the merged cells are in the same column. Indeed, if you merged cells in the same column and then apply the filter and you select to hide one group of merged cell, identifies with a number in the file, Column "A", it only hide the first row of the group.

Win 8.1 LO; Ubuntu 14.04 LO
Comment 6 m.a.riosv 2015-08-31 23:13:41 UTC
I think it has no relation, because in the sample merged cells are data cells no title cells.
Comment 7 Emersson Augusto Suarez Ortiz 2015-09-01 23:48:59 UTC
(In reply to m.a.riosv from comment #6)
> I think it has no relation, because in the sample merged cells are data
> cells no title cells.

Hello, please, can you explain just a little more your point, cause precisely, the problem is with the data cells when they are merged, does not matter if are titles or not.

1. The first files are whit cells merged between columns, titler or not, if you want to filter, all data are bad shown.

2. The second is whit cells merged in the same column (only rows), the data are well shown, but when you select a value to filter, only show or hide (it depends what you select) the very first row of the merged range, and the other rows that share the merged value are still shown by the filter.

Please apologies for my poor English, it is not my native language, It is the beautiful Spanish ;)
Comment 8 raal 2015-09-15 10:11:21 UTC
Created attachment 118736 [details]
simple test case

Reproducible with
ID build: 81898c9f5c0d43f3473ba111d7b351050be20261, win7

Works as reporter wants in Version (Build ID: 7545bee9c2a0782548772a21bc84a9dcc583b89), regression
Comment 9 raal 2015-09-23 12:54:06 UTC
not bibisectable with bibisect-win32-5.0. git checkout oldest: Version: Build ID: 57d6b92b69a31260dea0d84fcd1fc5866ada7adb contains the bug
Comment 10 raal 2015-11-17 16:06:26 UTC
reproducible with bibisect-44max$ git checkout oldest
Build ID: c15927f20d4727c3b8de68497b6949e72f9e6e9e
Comment 11 raal 2015-11-21 12:34:28 UTC
(In reply to raal from comment #8)
> Created attachment 118736 [details]
> simple test case



/bibisect-43all$ git bisect log
# bad: [423a84c4f7068853974887d98442bc2a2d0cc91b] source-hash-c15927f20d4727c3b8de68497b6949e72f9e6e9e
# good: [65fd30f5cb4cdd37995a33420ed8273c0a29bf00] source-hash-d6cde02dbce8c28c6af836e2dc1120f8a6ef9932
git bisect start 'latest' 'oldest'
# bad: [e02439a3d6297a1f5334fa558ddec5ef4212c574] source-hash-6b8393474974d2af7a2cb3c47b3d5c081b550bdb
git bisect bad e02439a3d6297a1f5334fa558ddec5ef4212c574
# good: [8f4aeaad2f65d656328a451154142bb82efa4327] source-hash-1885266f274575327cdeee9852945a3e91f32f15
git bisect good 8f4aeaad2f65d656328a451154142bb82efa4327
# bad: [9995fae0d8a24ce31bcb5e9cd0459b69cfbf7a02] source-hash-8600bc24bbc9029e92bea6102bff2921bc10b33e
git bisect bad 9995fae0d8a24ce31bcb5e9cd0459b69cfbf7a02
# good: [51b63dca7427db64929ae1885d7cf1cc7eb0ba28] source-hash-806d18ae7b8c241fe90e49d3d370306769c50a10
git bisect good 51b63dca7427db64929ae1885d7cf1cc7eb0ba28
# bad: [d65a58c31c8da044ef66ae4517fa2fe74cec0019] source-hash-2e053cf5ea4d93a2e1845e795a9c7fe1e08c84af
git bisect bad d65a58c31c8da044ef66ae4517fa2fe74cec0019
# bad: [79e02001f27d33b3b478324ab6fba5683413b4d9] source-hash-b6c016da23d309b4ac7d154bc33a22397974ed73
git bisect bad 79e02001f27d33b3b478324ab6fba5683413b4d9
# good: [183a576d94de9a9439d580c8b81f335ab57cdbdc] source-hash-a599f5b4b51848e3b397d471c9d12b373caadcef
git bisect good 183a576d94de9a9439d580c8b81f335ab57cdbdc
# bad: [a67b874d60de1f1a44bef57a53a7b8a84db0ba58] source-hash-19f4ebd8a54da0ae03b9cc8481613e5cd20ee1e7
git bisect bad a67b874d60de1f1a44bef57a53a7b8a84db0ba58
# good: [7fd8bdb3b18f50ea0adbc0a5e611f6a844b23189] source-hash-a1ac2538e9b287444500618ab4d2f0f06c25cf34
git bisect good 7fd8bdb3b18f50ea0adbc0a5e611f6a844b23189
# first bad commit: [a67b874d60de1f1a44bef57a53a7b8a84db0ba58] source-hash-19f4ebd8a54da0ae03b9cc8481613e5cd20ee1e7
Comment 12 Robinson Tryon (qubit) 2015-12-10 01:18:31 UTC Comment hidden (obsolete)
Comment 13 Xisco Faulí 2016-10-07 09:38:12 UTC
Regression introduced by

author	Jian Fang Zhang <zhangjf@apache.org>	2012-06-21 07:19:34 (GMT)
committer	Fridrich Štrba <fridrich.strba@bluewin.ch>	2013-03-12 04:36:59 (GMT)
commit	aaab3a79dfd762a64fa4c1d19dd29ae46c0b9dd0 (patch)
tree	188563cd703994526098978c754392dbfc95de51
parent	3545b0398ef3516278c8ac7d55283ffdb7cc28b6 (diff)

Resolves: #i120017, filter button is not shown in merged cell
Patch by: zhao shao zhi, aoo.zhaoshzh@gmail.com
Found by: Yan Ji,<yanji.yj@gmail.com>
Review by: zhangjf
(cherry picked from commit bcf01fd794ec169aaf2a3f8b86f986ec60e5beb8)

Signed-off-by: Fridrich Štrba <fridrich.strba@bluewin.ch>
Comment 14 QA Administrators 2018-10-14 02:57:15 UTC Comment hidden (obsolete)
Comment 15 mt 2018-11-11 17:36:17 UTC
Created attachment 146540 [details]
example of filter on vertical merged cells
Comment 16 mt 2018-11-11 17:44:54 UTC
Filters on orizzontally merged cells seems to work.

Filters on vertically merged cells does not work.
So the bug is still present.

This is because the hidden cell(s) continues to maintain the hidden value. And this could be correct and useful in some use cases.

IMO the best way to solve the problem is to add a forth option in the "Merge cells" window, letting the user to apply the content of the first cell to the hidden cell.

Build ID: 1:6.1.3~rc2-0ubuntu0.18.10.1
CPU threads: 4; OS: Linux 4.18; UI render: default; VCL: gtk3_kde5; 
Locale: en-GB (en_GB.UTF-8); Calc: group threaded
Comment 17 QA Administrators 2019-11-12 03:32:14 UTC Comment hidden (obsolete)
Comment 18 Emersson Augusto Suarez Ortiz 2020-04-17 07:39:47 UTC
Hi for the LO team.
This bugs is still present in version 6.4.