[Libreoffice-bugs] [Bug 108234] New: Border dropdown in Formatting Toolbar Doesn' t Account for Adjacent Borders

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 108234
           Summary: Border dropdown in Formatting Toolbar Doesn't Account
                    for Adjacent Borders
           Product: LibreOffice
           Version: 5.3.3.2 release
          Hardware: x86 (IA32)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: timbacontent at gmail.com

Description:
Calc's border logic is badly broken and inferior to Excel.

Steps to Reproduce:
1. open attached spreadsheet
2. select B3 with the intent of removing the white border between B2 and B3
3. in the formmatting toolbar, select the icon for no border

Actual Results:  
nothing happens

Expected Results:
border should be removed


Reproducible: Always

User Profile Reset: No

Additional Info:
The core problem is that while the border the user sees between B2 and B3 uses
the same pixels whether it's attached to B2 or B3, there is no way for user to
know which cell it's attached to. Invisibly attaching the border to one of the
adjacent cells is the design flaw. If not for this, the "Remove Border"
checkbox in the Format Cells dialog would be unnecessary, saving literally
thousands of unnecessary clicks for the serious user. But this problem is
further compounded by the failure to add the functionality of "remove border"
to the the Formatting toolbar icon.

My user experience (and I'm approaching 1000 hours of using this program -
strictly for formatting - no math), is that Calc is a passive aggressive entity
that seeks to tempt with with time-saving features, only to do everything in
its power to keep those features from working. Another problem is the "recent
colors" display - I haven't figured out the exact bug yet, but it has a way of
not showing the correct color. And of course this stems from your ill-advised
choice to use different color defaults than Excel. You must realize that almost
everyone who uses your program learned on Excel and left Excel because it was
so annoying. Why don't you welcome us by making this transition easy and
enjoyable instead of being so passive aggressive?

To add insult to injury, you changed the name (and presumably some aspect of)
the Remove Borders checkbox when you did the 5.3 version. Why on earth didn't
you just fix it then?


User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/58.0.3029.110 Safari/537.36

-- 
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/20170530/11093caa/attachment.html>