Bug 59284 (Cell-Border) - [META] Calc cell border related issues
Summary: [META] Calc cell border related issues
Status: NEW
Alias: Cell-Border
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium enhancement
Assignee: Not Assigned
: 75124 (view as bug list)
Depends on: 34837 38304 42339 47078 56894 57564 60173 81165 84129 86903 87787 91005 91007 91997 92736 100548 104036 104129 107901 Toolbar-Border-Controls 120166 120902 121071 121268 121614 122841 125259 130675 132915 135510 141588 141774 143839 144141 145726 145948 146466 146760 149208 151373 152558 153388 153660 153782 48622 51901 52112 53011 55266 57345 61054 73896 76166 76461 77369 79787 88827 98176 98317 99027 99190 100518 100549 100644 103924 112671 113751 116031 116237 119496 123033 124496 124744 126407 127770 127986 130919 132859 133434 135957 137790 139139 140032 140185 147388 149213 150005 150100 151755 157447 159846 160282
Blocks: Calc-Cells Borders
  Show dependency treegraph
Reported: 2013-01-12 15:49 UTC by Emir Sarı
Modified: 2024-07-11 03:52 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:

Dialog with no option to see an old pt-value of a border (21.42 KB, image/png)
2014-11-22 13:13 UTC, riesslibo

Note You need to log in before you can comment on or make changes to this bug.
Description Emir Sarı 2013-01-12 15:49:50 UTC

IMHO, the current cell formatting/borders dialog makes applying borders to cells very hard in general. It looks confusing, outdated, and lacks ease of use (also functionality). Let me explain:

- There are no visible-at-first-glance border definitions, user has to chase through a drop-down menu. 

- The definitions in this menu are confusing, they all look the same, user has to define thickness via setting it manually. 

- When selected multiple cells with different borders, it is very complicated to set a batch border setting, and this does not respond quite well, for instance in Excel this responds quite well to user behaviour. 

- Dotted borders look blurry and outdated. So as thick borders. 

Possible improvements:

- Set predefined borders, so user would choose thicknesses at first glance. This includes fixing border widths, so it would not disappear when selecting a cell. I recall there was a bug report about this, I'll add it here. 
- Hide thickness width selection under a button, so user would not get confused. 
- Improve border rendering, so it would look stylish (especially dotted ones). 
- Border preview box could be a little bit bigger, so it would be easier to apply borders by mouse clicks. 

Feel free to add any suggestions under this thread.
Comment 1 tommy27 2013-11-24 08:22:54 UTC
I change status of this useful meta-bug to NEW to remove it from the list of UNCONFIRMED bugs.
Comment 2 Owen Genat (retired) 2014-01-21 13:43:39 UTC
Summary edited to indicate the meta-nature of this enhancement / bug. Do we have meta-enhancements? 

All the open bugs in the See Also list should instead be in the Depends on field. It would be good if someone from QA could confirm it is OK to make this bulk-change, as it will cause quite a few emails to go out. Some clarity on the policy with regard to meta-enhancements would also be good.

I notice that several of the bugs in the See Also list, have their own small See Also list (excluding the back link to this bug), so there is evidently a bit of a tangle here.

Comment 3 sophie 2014-03-12 10:06:08 UTC
*** Bug 75124 has been marked as a duplicate of this bug. ***
Comment 4 riesslibo 2014-06-06 07:19:32 UTC
Can confirm this "bug" for LibO Calc on Win7/64 and even Calc 4.3 beta1, in special case of the tast from #75124 : 
Task: to know what width each border of a cell has. Can't find it out using Format Cell -- Borders dialog. Don't see any workaround.
Comment 5 riesslibo 2014-11-22 13:13:27 UTC
Created attachment 109846 [details]
Dialog with no option to see an old pt-value of a border

Same Problem still in V4.4.0.0 beta 1 (and in Writer in the dialog for borders around the paragraph)

See the attached screenshot:

You see three thick borders and one thin, there is no way so see the pt-value of the thin one, if you click on the left thin border, it is changed to the value displayed in the right, here to the thick  one. 

Perhaps this action "changing" the thickness of a border should be a 2 step action, first click display actual values, then you could change the values on the right, click again the new values will be done to the border, you click on.