Summary: | Removing cell border from neighbor fails | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Epper <epper.marshall> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED DUPLICATE | ||
Severity: | normal | CC: | epper.marshall, ilmari.lauhakangas, riyadhtalal |
Priority: | medium | ||
Version: | 7.0.3.1 release | ||
Hardware: | All | ||
OS: | Windows (All) | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: |
Description
Epper
2021-01-06 21:31:32 UTC
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 *** |