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