https://bugs.freedesktop.org/show_bug.cgi?id=62664
--- Comment #11 from Dominique Boutry <[email protected]> --- Thanks for your scenario. Here is my analysis. Unlike EXCEL, LibO seems to manage 2 conditions for a line to be drawn between 2 cells : being set on behalf of the left/top cell or being set on behalf of the right/bottom cell (the line is a superposition of one line "belonging" to one cell and another line "belonging" to the adjacent cell). I can see that the right/bottom cell prevails in cas of discordant color settings, and that the larger line prevails in cas of discordant width settings (I suppose that this is an evidence of the cells order of processing : line by line beginning with the topmost line, and within a line cell by cell beginning with the leftmost cell). The usage of the left drawing in the dialog box Format > Cell > Border is blank to erase a line, grey to leave it unchanged and lined to set a line with the shown color/width. This drawing is pre-filled as follows : - when the selected area is a rectangle, it is initialised with the current state of borders (white if none, grey if mixed and black/solid if set with a unique width), - when the selected area is not a rectangle, it appears to be always left to blank (LibO doesn't try to pre-fill it). Unfortunatly, that means "erasing the border belonging to the cells". So in your exemple : - your selected area is not one rectangle (but two ...), so your format command results in erasing all line "belonging" to the selected cells except the topmost, not left unchanged (i.e., blank in the left drawing instead of greyed) - the "outer" lines of your two rectangles remain visible on behalf of the adjacent (not selected) cell, - the topmost lines of your two rectangles are set to red, due to the processing order of cells (should you have choosen a color for the bottom line, I guess that it would not have appeared). My analysis seems to also explain the inconsistency between horizontal lines ans vertical lines, in the case I show in comment 5. I think that a deep reflexion should be conducted on this way of processing borders, to confirm (or not) the interest of this great difference with EXCEL (much simpler to understand : the "last" setting of a line prevails over all previous ones, for the unique line between two adjacent cells ; which allows Excel to always pre-fill the left drawing in the dialog box). -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
