Apache OpenOffice (AOO) Bugzilla – Issue 66077
Diagonals unexpectedly affected by "Change outer borders without changing inner lines"
Last modified: 2013-08-07 15:12:27 UTC
When using borders around cells in Calc, users often want to modify the style of borders (colors and width of the line) around a table that already has borders without modifying the borders of the cells inside the table. The borders dialog (format > cells > borders) has a button to do exactly that which is the fifth button in the UI (see the screenshot). The only problem is if cells inside the table have crosses/diagonals, only the horizontal and vertical borders are kept, and the cross(es) or diagonals are deleted. I suppose the expected behaviour would be to keep everything unchanged even the cross(es). To reproduce the behaviour : - Select cells (ex: C7:D8). - apply borders with diagonals (format > cells > borders, and then click on the "pre-view" to add them) - select cells including c7:D8 (ex: A1:E9) - Click on the fifth button above the pre-view in format > cells > borders => the crosses are lost...
Created attachment 36894 [details] A screenshot of the buttons
Yes, I agree, that is unexpected. I tested with testfile.ods: 1. Mark B4:E16 using mouse 2. Menu "Format - Cells" 3. click right standard button (tooltip: Set Outer Border Without Changing Inner Lines) expected: in preview pane all "inner lines" should be greyed out to show that they will not be affected by changes actual: only inner borders between cells are greyed out, diagonals disappear, what seems to show that they will really disappear after <OK> 4. Change line colour to "light blue" 5. Press button OK. Result: more or less as expected - Outer border colour changes to "light blue" - inner borders between cells remain as they were - diagonals disappear as shown in preview pane. Workaround: to leave diagonals as they are you have to click on a diagonals crossing (pls. see screenshot) as a "step 3.2" 2 times, so that you get diagonals greyed out. If you continue with step 4, you get results as expected with unchanged diagonals. Suggestions: A) We can change Help texts and Tooltip" Replace "inner lines" by "inner borders" B) We can change function so that diagonals will additionally appear greyed out in preview pane, and so they will not be affected by changes. I do not know what behaviour is defined in design guidelines.
Created attachment 37052 [details] testkit with testfile and screenshots
Hi, this is a missunderstanding of the given features. The buttons you're using are predefined border sets. This is indicated by the tooltip 'Select a predefined borderstyle to apply'. So this Issue is invalid and closed as such. Frank
closed invalid
Well, I would then say that the behaiour should be the one described. When would you like to add borders and remove the diagonals ? I do not see at the moment, but maybe you have examples. I would not find much use to add borders but remove diagonals if they are ! Maybe adding a new button would be another solution, but I think that changing the one already defined would be better. That's why I reopen the issue.
So let the requirements team decide.