https://bugs.documentfoundation.org/show_bug.cgi?id=161061
--- Comment #5 from ady <[email protected]> --- (In reply to Cor Nouws from comment #4) > > Please also keep in mind that the Gridlines settings are supposed to apply > > per (selected) worksheet, not per entire workbook. > Where please do you get that knowledge from? > I don't see any hint in Tools>Options... dialog, don't read it in the > Help*... Years of experience(?). For the "View" menu, that's how it works in Excel (AFAICR). In Excel – again AFAICR – you can also pre-select multiple worksheets and then change the setting at once for those pre-selected worksheets; Calc behaves differently in this last matter (i.e. always one at a time). Menu "Tools > Options > Calc > View > Grid lines" is supposed to (also) set the initial default status of this setting when creating worksheets. For cells without BG color, if you want gridlines, then neither of these settings can be set to hide: (Note for the following tables: "S.o.c.c == Show on colored cells"): View | Options | Gridlines around cells withOUT BG color ON | Show | yes ON | S.o.c.c | yes ON | Hide | no OFF | Show | no OFF | S.o.c.c | no OFF | Hide | no For cells with background colors: View | Options | Gridlines around cells with BG color ON | Show | no ON | S.o.c.c | yes ON | Hide | no OFF | Show | no OFF | S.o.c.c | no OFF | Hide | no "Show on colored cells" actually means "Show on colored cells too". IIRC, Excel does the same. -- You are receiving this mail because: You are the assignee for the bug.
