Created attachment 115253 [details]
When text overlaps a cells border, the border can interfere with the font text, as can be seen in the attached screenshot. Its not so bad when the transparent gray appears behind text, but its quite bad when the border is black, like in cell J14.
Created attachment 115260 [details]
ux-advise, setting to NEW
(Optional) ellipsis would be a possible solution (e.g. "Income de...") for text. Complete content is usually shown in tooltips. Microsoft Excel hides grid lines (and borders if possible) for text and "diamonds out" large numbers (e.g. "#####" for "1234.56789"). But I prefer the small triangular identifier in red that LO uses for long numbers, perhaps as well with ellipsis.
We're replacing our use of the 'ux-advise' component with a keyword:
Component -> LibreOffice
Add Keyword: needsUXEval
No further input needed from UX. The request is about an option per workplace with the modification of this default per document to make the overflow behavior more flexible (if the surrounding cells are empty), with
(o) Do not change the grid (current behavior)
( ) Hide grid lines (the actual request here)
( ) Cut the text (as happening when the neighboring cell has content)
Devs, what is possible here?
(In reply to Heiko Tietze from comment #4)
> ... The request is about an option per
> workplace with the modification of this default per document to make the
> overflow behavior more flexible (if the surrounding cells are empty), with
No this is incorrect, its about the default behaviour, which likely isnt modifiable by the user.
Cor, Stuart: Got an opinion about this?
(In reply to Yousuf Philips (jay) from comment #5)
> No this is incorrect, its about the default behaviour, which likely isnt
> modifiable by the user.
Enhanced your request a bit but it's still about the default behavior. There might be users who want to keep the old behavior or want to cut the text, and therefore my advise is to introduce the enhancement as a choice. Also, the default is one thing but there might be documents that need a different layout. Therefore I vote for having the choice of the default plus an option to override it per document.
I would never activate that setting. It makes less visible what the settings of cells are. So I wouldn't do it.
Spans and merged cells would be the "normal" way to do this manually, with the other handling being autowrap of text meeting the bound, or autosize of column width/height.
Adding logic to hide specific border (right or left) of otherwise rendered cell grid seems rather a waste of time.
This falls into that category of trying to make a spreadsheet do layout feats it is not intended to do.
(In reply to Heiko Tietze from comment #6)
> Enhanced your request a bit but it's still about the default behavior. There
> might be users who want to keep the old behavior or want to cut the text,
> and therefore my advise is to introduce the enhancement as a choice. Also,
> the default is one thing but there might be documents that need a different
> layout. Therefore I vote for having the choice of the default plus an option
> to override it per document.
In my view, there would be no users who would want the cell border to cut through the text (aka the current behaviour). If a user doesnt like the current behaviour, they have the ability to manually set how they want the text to appear (e.g. merge, wrap), but doubt we want to set a document level option for what it should do in this circumstance. I'll let Eike give his opinion on this document level option?
(In reply to V Stuart Foote from comment #8)
> Adding logic to hide specific border (right or left) of otherwise rendered
> cell grid seems rather a waste of time.
We currently hide the border when you are typing in a blank cell or in edit mode (F2), so logic is already present for this behaviour.
> This falls into that category of trying to make a spreadsheet do layout
> feats it is not intended to do.
This happens in Excel, Calligra Sheets, Gnumeric, Google Sheets, and Quattro Pro, so i would assume its not out of bounds of what a spreadsheet should do, especially when it improves UX.
 If there is no assigned border, it will remove the grid border, but if there is a border, it will trim the text and show the border
Please don't include me in any UX bugs. I will surely not fix them.
*** Bug 127986 has been marked as a duplicate of this bug. ***