Description: We can set the defaults for the Font Color, Background Color, Format as Currency, Border Color, etc. from the small triangle on the right allowing us to set a default and just click the cell then icon once to use it. The border icon says "Shift to overwrite" but pressing shift and selecting a border type doesn't do anything. We need to click a cell, then the icon, then individual type every time now wasting time. Steps to Reproduce: 1. Click the cell you want to edit. 2. Click the small arrow on the right side of the borders button. 3. Select the border type. There is no way to set a default type so you must just keep doing this for every cell selected or groups of cells selected over and over. 4. Click shift and select a type of border but nothing happens. The icon says (Shift to overwrite). Actual Results: We need to click three times. Once on the cell or cells we want. Then the icon twice every time. Once to get a drop down and then again for the border type each time. Expected Results: We set the default border type (like a color) and easily click the icon once to select it easily instead of clicking twice every time. As this action is repetitive a fix would be a good accessibility update reducing repetitive strain. Reproducible: Always User Profile Reset: Yes Additional Info: Shift to overwrite/set the default border
Created attachment 205181 [details] Mouseover popup
What I remember is that a specific border is applied like on the left side. And if you pick another, eg. the right side, the previous is overwritten - unless shift is pressed. Seems to be a regression. Version: 25.8.4.2 (X86_64) / LibreOffice Community Build ID: 580(Build:2) CPU threads: 32; OS: Linux 6.18; UI render: default; VCL: kf6 (cairo+xcb) Locale: de-DE (en_US.UTF-8); UI: en-US 25.8.4-3 Calc: threaded
(In reply to Heiko Tietze from comment #2) > What I remember is that a specific border is applied like on the left side. > And if you pick another, eg. the right side, the previous is overwritten - > unless shift is pressed. Seems to be a regression. No, the opposite. And, if there is a problem with the result, it might not be happening with every kind of border – I can set both left and right sides and overwrite them with upper and lower sides by means of the shift key (using the Tabbed UI).
BTW, I don't recall that the border icon ever worked in the same way as the background color icon (which is what the OP is actually requesting, nothing to do with the shift key), so I don't understand why this report is set as a regression. IOW, in which version of LO the border icon was split between "apply the same border as the last one selected" and the (right-side) down arrow that displays the other typical borders to select from?
I mainly want to select a border and the just be able to use the icon to apply it like colors. Just one quick click. This would save heaps of time. I wasn't sure what the English popup meant as when I clicked shift it didn't seem to do anything. Is "Shift to overwrite" meant to keep the outside edges? "Press shift to keep edges" I made 2 4x4 grids (Outer Border and All Inner Lines) then selected the middle four cells. I pressed shift and then no border. I couldn't see any difference. It would be nice if the shift key could let use keep of delete the outer border though. What is "Shift to overwrite" meant to do? I though it meant press shift and set the default border you want which would be useful. Do you think using the border icon and arrow like the color icon would be a good thing? I can only see it as a good thing as it would mean less clicks to do the same job.
Created attachment 205250 [details] showing the 4x4 grids with gap I pressed shift but didn't get a different result on the second grid.
I selected Outer Border and nothing happened when I tried to delete the center cross of the 4 cells. When 4 cells were selected and I pressed shift and tried again I was able to remove the center cross with Outer Border. Shift is doing something but we can't tell if it is active and the popup isn't clear. I tried the same thing with No Borders but wasn't able to delete the outside edges with shift pressed or not pressed. I also tried multiple times just to make sure.
Created attachment 205251 [details] Another weird thing After clearing the center I went to the left side and clicked Outer Border on the 2 cells on the left in the center. Nothing happened. Then after clearing it by selecting No Borders it kept the left side line. Something strange is happening.
(In reply to ady from comment #4) > BTW, I don't recall that the border icon ever worked in the same way as the > background color icon... Checked with 6.4 and you are right, no (obvious) effect with shift being pressed.
This has been discussed in bug 64626 leading to renaming from Border to "Borders, add lines; SHIFT to add and remove" and later what we have now. I don't see any shift in the function. So is the request to make this button overwrite the cell setting unless the user presses shift?
(In reply to Heiko Tietze from comment #10) > This has been discussed in bug 64626 leading to renaming from Border to > "Borders, add lines; SHIFT to add and remove" and later what we have now. I > don't see any shift in the function. > > So is the request to make this button overwrite the cell setting unless the > user presses shift? Steps for how you can see the effect of pressing Shift: 1. Select a 3x3 area of cells 2. From the Borders toolbar button, apply Outer border and all inner lines 3. Still retaining the selection, try to apply Outer border - observe that nothing happens 4. Press down Shift and apply Outer border - observe that the operation succeeded and you now have only the outer border
(In reply to Buovjaga from comment #11) > Steps for how you can see the effect of pressing Shift: Excellent! Now the question for the OP, what do you expect?
(In reply to Heiko Tietze from comment #12) > (In reply to Buovjaga from comment #11) > > Steps for how you can see the effect of pressing Shift: > Excellent! Now the question for the OP, what do you expect? First, the [shift] key does not have an effect on the icon, but on the cells. The "normal" no-shift action is to "add" borders to the currently selected cells. If you already have top_and_bottom borders on the selected cell and you press the left-side border icon, then you have these 3 sides of the cell with a border. But, under the same initial scenario, if you press [shift] and then you click on the left-side border icon, you should end up with _only_ the left-side border; i.e. the specific border replaces the prior one(s) (instead of adding). This is all normal, expected usage. The problem in comment 0 (and all the follow up comments about [shift]) is the mention of [SHIFT] itself, which has nothing to do with what the OP wants. The request is simple. Do you see how the background color icon works? It has a main icon and a down-arrow to its side. The down-arrow allows you to select a (new) background color for the selected cells, which also sets the next "default color" for the main icon (until you select a different color on the same palette next time you use it). Then the main icon allows you to apply the same background color to other cells without having to open the color palette each and every time. The OP's request: do the same/equivalent behavior for borders (instead of background colors) on the Borders icon (which is currently not a split icon as the background color is). The actual request is at least worth a discussion.