Description: 1) When a cell with the filter enabled is filled with many lines of text then a lot of space above the filter button is wasted. I would advocate that in such a situation the hatched red box could also contain text. 2) In addition, the last letters can be truncated in the place let's call it "margin" next to the filter button. Steps to Reproduce: . Actual Results: . Expected Results: . Reproducible: Always User Profile Reset: No Additional Info: .
Created attachment 182228 [details] Text do and does not fit in the cell, Wrap text, with and without Filter This is how it's look like.
This seems like a valid request. When a cell has wrapped text, the bounding box should not include the width of the down arrow for its entire height, which causes excess space waste. I just don't know if it would be feasible to have a non-rectangular bounding box for the text in a cell.
I don't think non-rectangular drawing areas is a feasible way to go. But it would be possible to just draw the autofilter expand button over the text - with the obvious drawbacks. And ultimately I wonder if this is needed at all. The autofilter applies to the very first cell only, and there shouldn't be too much text in those headings usually. If these rare cases, some excessive white space is acceptable IMO.
Created attachment 182282 [details] Filter - Calc, Excel I agree that these can be rare cases. They are definitely specific. In printed documents, these buttons do not make sense and are not visible. The cases that I mean (and this is also my case) include using a spreadsheet as a to-do list, a store's inventory list, or a list of research or interview data. Then many columns are usually named for 1-3 words (e.g. material code name, test start date, end date, test number, arrangement (Horizontal, Vertical)) and these parameters are often a short number or one letter H, V, etc. When I want to fit many of these categories on the width of the monitor, I narrow down the columns so that the values are visible in full. Then there is no problem for me that a single word will even divide into 4-5 lines. I just want to see the full category name and its value. Finally, how not to give the ultimate argument here: Excel can do that ;-)
Well, let's see if developers pick it up. From the UX/design POV it's admittedly ugly and multiple words in title are not so rare.