Bug 150799 - [UI] Poor space utilization in multi-line cell with filter on
Summary: [UI] Poor space utilization in multi-line cell with filter on
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: AutoFilter Calc-UX
  Show dependency treegraph
 
Reported: 2022-09-05 15:36 UTC by Piotr Osada
Modified: 2022-09-08 07:53 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Text do and does not fit in the cell, Wrap text, with and without Filter (71.45 KB, image/png)
2022-09-05 15:38 UTC, Piotr Osada
Details
Filter - Calc, Excel (5.44 KB, image/png)
2022-09-07 12:07 UTC, Piotr Osada
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Piotr Osada 2022-09-05 15:36:43 UTC
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:
.
Comment 1 Piotr Osada 2022-09-05 15:38:04 UTC
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.
Comment 2 Rafael Lima 2022-09-06 14:13:03 UTC
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.
Comment 3 Heiko Tietze 2022-09-07 09:21:34 UTC
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.
Comment 4 Piotr Osada 2022-09-07 12:07:30 UTC
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 ;-)
Comment 5 Heiko Tietze 2022-09-08 07:53:31 UTC
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.