<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Border dropdown in Formatting Toolbar Doesn't Account for Adjacent Borders"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108234">108234</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Border dropdown in Formatting Toolbar Doesn't Account for Adjacent Borders
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.3.3.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86 (IA32)
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>timbacontent@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>