Description: If I add a border to cell B2 and then go to A2 and try to remove it's border I'd expect it to remove B2's left border, instead nothing happens. Steps to Reproduce: 1. Add a left, double, or full border to B2 2. go to A2 and attempt to remove the right border by clearing borders Actual Results: Nothing changes Expected Results: B2's left border to go away Reproducible: Always User Profile Reset: No Additional Info: Version: 7.0.3.1 (x64) Build ID: d7547858d014d4cf69878db179d326fc3483e082 CPU threads: 12; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL
Each cell has their own borders, so cleaning in one doesn't clean on the neighbor, and I think it's the expected and intended behavior. Not a bug. Maybe for you should be fine what you expect, but it is not so on other cases. E.g. clearing the direct format on a column next to a column being the border of a table with borderline enable.
(In reply to m.a.riosv from comment #1) > Each cell has their own borders, so cleaning in one doesn't clean on the > neighbor, and I think it's the expected and intended behavior. > > Not a bug. > > Maybe for you should be fine what you expect, but it is not so on other > cases. > > E.g. clearing the direct format on a column next to a column being the > border of a table with borderline enable. Google sheets and excel act as if they have shared borders. Why is this the intended behavior?
cALC (In reply to Epper from comment #2) > (In reply to m.a.riosv from comment #1) > > Each cell has their own borders, so cleaning in one doesn't clean on the > > neighbor, and I think it's the expected and intended behavior. > > > > Not a bug. > > > > Maybe for you should be fine what you expect, but it is not so on other > > cases. > > > > E.g. clearing the direct format on a column next to a column being the > > border of a table with borderline enable. > > Google sheets and excel act as if they have shared borders. Why is this the > intended behavior? They should not act as such! The intended behavior in Calc is to respect the border you use for each cell or column; while excel does not check whether the deleted side is used by another cell or column! That is why in excel you should re-do the borders again if you delete the border of a neighboring cell or column! Don't you like the burden you have avoided?
No, because its a burden either way. There is no way to know which cell the border belongs to. The other spreadsheet software have a shared methodology, so having a different methodology makes it a burden of having to learn a new way of doing things. If it acted like the other software it would be a similar problem that users know how to deal with, instead of a new challenge for users to figure out how to overcome.
(In reply to Riyadh from comment #3) > cALC (In reply to Epper from comment #2) > > (In reply to m.a.riosv from comment #1) > > > Each cell has their own borders, so cleaning in one doesn't clean on the > > > neighbor, and I think it's the expected and intended behavior. > > > > > > Not a bug. > > > > > > Maybe for you should be fine what you expect, but it is not so on other > > > cases. > > > > > > E.g. clearing the direct format on a column next to a column being the > > > border of a table with borderline enable. > > > > Google sheets and excel act as if they have shared borders. Why is this the > > intended behavior? > > They should not act as such! > > The intended behavior in Calc is to respect the border you use for each cell > or column; while excel does not check whether the deleted side is used by > another cell or column! > > That is why in excel you should re-do the borders again if you delete the > border of a neighboring cell or column! > > Don't you like the burden you have avoided? No, because its a burden either way. There is no way to know which cell the border belongs to. The other spreadsheet software have a shared methodology, so having a different methodology makes it a burden of having to learn a new way of doing things. If it acted like the other software it would be a similar problem that users know how to deal with, instead of a new challenge for users to figure out how to overcome.
In 5.2, a new option was introduced. When you select "No borders" in the Calc dialog, you can tick "Remove border" and it will remove it from the adjacent cells as well: https://wiki.documentfoundation.org/ReleaseNotes/5.2#Calc In other respects, this is a dupe of bug 87787 *** This bug has been marked as a duplicate of bug 87787 ***