Steps to reproduce: - Select all the cells - Select white in border color picker menu icon - Apply color to all the borders using "Outer border and all inner lines" option - Select another color (e.g. blue) from the border color picker menu icon - Select only a few colonms e.g. one or two or three columns - Apply color (e.g. previously selected blue) to the select colomns the borders using "Outer border and all inner lines" option Expected outcome: - all the borders are colored (e.g. all outer and inner borders are blue) Observed outcome: - the left outer border is not colored. gDrive link to screen record showing the issue described above : https://drive.google.com/file/d/1pK2JJ8mjANjLGyJlAC0YmZK3DXwyT2Z5/view?usp=sharing
I'm not sure this is a bug, or if this is the way the function is designed to work. The reason is, when you try to apply border to a range, the right edge is not affected when it already has a border. However, considering that the command is called "Outer border and all inner lines", I understand why users would expect that all edges (including the right outer borders) would be formatted. Let's hear from the UX team.
This looks like an Implementation error bug from 5.0 or earlier, when Border Color icon appeared. Only for toolbar icon Borders and Border colors (with some combinations). Not for Format-Cell.
(In reply to Rafael Lima from comment #1) > I'm not sure this is a bug, or if this is the way the function is designed > to work. The reason is, when you try to apply border to a range, the right > edge is not affected when it already has a border. The border between A1 and B1 can be defined via right of A1 and via left of B1. And left-of overrules right-of. We just have to pick one of the two conflicting options. See also bug 87787 and bug 143249 for discussions around borders. It's a hot topic.