Not sure if this should be considered a bug or an enhancement, bug setting cell borders in writer and calc are a major pain because cells that share the same border visually can have different border settings and these border dont play nicely together. For writer, if you insert a table of 3x3, and in cell B2 you set the borders to none, the left and bottom borders show as transparent but not the top and right. I'm assuming the way the cells are being draw to make up the table maybe causing it to look like this, as unfortunately there isnt a means for me to open up the cell properties and see exactly what is going on. In order to achieve what is intended, a user will likely have to jump through many hoops to get the way it should be. For calc, select a number of cells (e.g. C7:F16), and set their inner and outer borders, then select one of the cells (e.g. E12) in the changed cells and set its borders to none. You wont visually see a difference because the cells around it all have their borders on. So in order to achieve what is intended, a user will have to go to each of the 4 cells around it, open up the formatting cell dialog and disable the related sides. So the simple solution is that when a cell border is set or unset in any manner (border width, style, color, etc), that its neighboring cells must also be set or unset in the same way.
(In reply to Jay Philips from comment #0) > Not sure if this should be considered a bug or an enhancement, bug setting > cell borders in writer and calc are a major pain because cells that share > the same border visually can have different border settings and these border > dont play nicely together. > > For writer, if you insert a table of 3x3, and in cell B2 you set the borders > to none, the left and bottom borders show as transparent but not the top and > right. I'm assuming the way the cells are being draw to make up the table > maybe causing it to look like this, as unfortunately there isnt a means for > me to open up the cell properties and see exactly what is going on. In order > to achieve what is intended, a user will likely have to jump through many > hoops to get the way it should be. Strange and interesting. I did not recognized it before in WRITER. But for me this is inconsistent and a buggy behaviour, because I see no reason for it. > For calc, select a number of cells (e.g. C7:F16), and set their inner and > outer borders, then select one of the cells (e.g. E12) in the changed cells > and set its borders to none. You wont visually see a difference because the > cells around it all have their borders on. So in order to achieve what is > intended, a user will have to go to each of the 4 cells around it, open up > the formatting cell dialog and disable the related sides. This is for me also inconsistent and a buggy behaviour, because I can't see any reason yet. Maybe anybody else has a good explanation? For me as a normal user this is buggy and annoying. It is inconsistent for me, because inside a table I have borders to distinct between cells. If I want to change it, why do I have to change it from "both" sides? And in CALC I have also similar effect as in WRITER. If I set in a number of cells inner and outer borders and then select only one cell within them and change the colour of the total outer border it gets only changed at the top and on the left. > So the simple solution is that when a cell border is set or unset in any > manner (border width, style, color, etc), that its neighboring cells must > also be set or unset in the same way. I would agree. At least I don't have any idea yet, why it should not. Maybe anybody else has also any further thoughts about these issues? @Markus: Can you maybe also help with this issue? Do you have an explanation? What are thoughts about it?
I won't touch any border code anymore. This is an enhancement but one that will at least on the calc side never be implemented.
(In reply to Markus Mohrhard from comment #2) > I won't touch any border code anymore. > > This is an enhancement but one that will at least on the calc side never be > implemented. Thanks for your very fast reply. But I hope you are wrong with the second part in your last sentence ;-)
(In reply to Jay Philips from comment #0) > So the simple solution is that when a cell border is set or unset in any > manner (border width, style, color, etc), that its neighboring cells must > also be set or unset in the same way. I agree that it's inconvenient, but one can also think of use cases where it's handy that setting all borders of one cell does not affect those of the adjacent ones. This maybe eases the pain some may feel by Markus respons. (I've seen from a distance the pain various developers had to get borders work as well as possible and improve interoperability too...)
Isn't this a duplicate of 34449?
Should be bug 34449. I think the fixing of that bug closes this one as well.
Bug 34449 fixes this issue in dialog, while this bug report is about being able to do it in the borders group button in the toolbar, the place where most people will be making the change.
There have been a couple of requests recently. My opinion on bug 100549, comment 3.
Hi Yousuf, while I don't necessarely agree about the toolbar option being the most used I understand your sentiment. As the improvement in 5.2 solves the core of this issue, shouldn't the toolbar and dialog functionality be merged then? ps: this applies for other dialogs as well, for example "background (color)".
*** Bug 107674 has been marked as a duplicate of this bug. ***
The core issue is still present in the most recent 5.3 release 1. add a bottom border to Cell 1A 2. right click Cell 2A and choose Format Cells ... bug: the border applied in step 1 cannot be edited in spite of the fact that there is no functional distinction between a bottom border of 1A and a top border of 2A. 3. ask a friend to look at your spreadsheet and edit the border - he/she will only pick the correct cell 50% of the time bug: This is just wrong. This kind of thing is precisely why Excel is so bad and why there's so much demand for a smarter program like Calc. Also note that to test these steps I had to wait about 15 seconds for the Format Cells dialog to be drawn.
*** Bug 107616 has been marked as a duplicate of this bug. ***
still active in 5.3.4 - I can't believe you guys didn't fix a single one of the two dozen horrible bugs I've been complaining about for several months. I haven't been this disappointed in a group of people since the November election.
*** Bug 108255 has been marked as a duplicate of this bug. ***
Please also check the discussion on bug 108255.
*** Bug 108234 has been marked as a duplicate of this bug. ***
Please add keyword 'needsUXEval' and CC 'libreoffice-ux-advise@lists.freedesktop.org' if input from UX is needed.
*** Bug 139455 has been marked as a duplicate of this bug. ***
I've changed component to LibreOffice, because the description says "setting cell borders in writer and calc are a major pain" and comments talk about both.