[Libreoffice-bugs] [Bug 108255] "Remove Border" checkbox adds confusion, but no functionality

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Fri Jun 2 22:54:58 UTC 2017


https://bugs.documentfoundation.org/show_bug.cgi?id=108255

--- Comment #10 from Kevin <timbacontent at gmail.com> ---
I have a new understanding of this bug. The problem is that when you are in one
cell, Calc is blind to the attributes of the adjacent cell. This explains the
two major symptoms:

1. Calc fails to activate the Remove Border checkbox when there is indeed a
border available to be removed, forcing the user to enter the other cell. Calc
can't put up the Remove Borders checkbox unless there is ALSO a pre-existing
border in the selected cell. Adding a border while in the dialog box does not
accomplish this.

2. Calc fails to grey out the Remove Border checkbox when there is no border
available to be removed, causing extra clicks and extreme frustration.

SOLUTION 1 (best): Make it work like Excel - each border is a discrete object,
not parented by any cell, but accessible from any cell on which it borders.

SOLUTION 2 (if you insist that there is some value to giving each cell its own
discrete set of borders): Give Calc the intelligence to examine the adjacent
cells and activate the Remove Border checkbox only if there's a border to be
removed.

A whole college course in UI Design could be dedicated to the Format Cells
design of Calc, and another course could be dedicated to the different, but
even more appallingly embarrassing design failures of Excel. Surely there is
someone at the Document Foundation with the vision and perseverance to fix this
mess once and for all.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170602/91bfcf7d/attachment-0001.html>


More information about the Libreoffice-bugs mailing list