Download it now!
Bug 91005 - Cell border should be hidden when text crosses over cell border
Summary: Cell border should be hidden when text crosses over cell border
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: needsDevEval
: 127986 (view as bug list)
Depends on:
Blocks: Cell-Border
  Show dependency treegraph
 
Reported: 2015-05-02 01:09 UTC by Yousuf Philips (jay) (retired)
Modified: 2020-04-03 06:05 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:


Attachments
screenshot (222.26 KB, image/png)
2015-05-02 01:09 UTC, Yousuf Philips (jay) (retired)
Details
excel printscreen (3.02 KB, image/png)
2015-05-02 06:58 UTC, raal
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Yousuf Philips (jay) (retired) 2015-05-02 01:09:54 UTC
Created attachment 115253 [details]
screenshot

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.
Comment 1 raal 2015-05-02 06:58:30 UTC
Created attachment 115260 [details]
excel printscreen

ux-advise, setting to NEW
Comment 2 Heiko Tietze 2015-05-04 13:27:21 UTC
(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.
Comment 3 Robinson Tryon (qubit) 2016-08-25 05:26:50 UTC Comment hidden (obsolete)
Comment 4 Heiko Tietze 2017-07-19 11:16:51 UTC
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?
Comment 5 Yousuf Philips (jay) (retired) 2017-07-20 04:56:32 UTC
(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?
Comment 6 Heiko Tietze 2017-07-20 07:40:18 UTC
(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.
Comment 7 Cor Nouws 2017-07-20 10:59:40 UTC
I would never activate that setting. It makes less visible what the settings of cells are. So I wouldn't do it.
Comment 8 V Stuart Foote 2017-07-20 12:21:05 UTC
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.

To me--WONTFIX
Comment 9 Yousuf Philips (jay) (retired) 2017-07-21 00:29:11 UTC
(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[1], so i would assume its not out of bounds of what a spreadsheet should do, especially when it improves UX.

[1] 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
Comment 10 Markus Mohrhard 2017-07-21 02:18:01 UTC
Please don't include me in any UX bugs. I will surely not fix them.
Comment 11 Timur 2020-04-03 06:05:39 UTC
*** Bug 127986 has been marked as a duplicate of this bug. ***