[Bug 161061] [UI] Grid lines are visible on all cells when option 'Show on colored cells' is chosen
https://bugs.documentfoundation.org/show_bug.cgi?id=161061 --- Comment #8 from ady --- Possible improvement for consideration... Change the wording from: "Show on colored cells" to: "Show on colored cells too" While it is not perfect for users that don't know the meaning of it (nor to what other cells the "too" is referring), the change would avoid the potential (recurrent) confusion with "Show on colored cells only", which is not the intention of this setting (IIUC). -- You are receiving this mail because: You are the assignee for the bug.
[Bug 161061] [UI] Grid lines are visible on all cells when option 'Show on colored cells' is chosen
https://bugs.documentfoundation.org/show_bug.cgi?id=161061 Cor Nouws changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=30 ||800, ||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=78 ||035, ||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=10 ||5326, ||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=10 ||5560, ||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=10 ||9289 --- Comment #7 from Cor Nouws --- (note, added ref to some former reports to check maybe in a spare hour..) -- You are receiving this mail because: You are the assignee for the bug.
[Bug 161061] [UI] Grid lines are visible on all cells when option 'Show on colored cells' is chosen
https://bugs.documentfoundation.org/show_bug.cgi?id=161061 --- Comment #6 from Cor Nouws --- (In reply to ady from comment #5) > (Note for the following tables: "S.o.c.c == Show on colored cells"): Thanks ! for these tables that I knew had to be made but didn't start on .. :) -- You are receiving this mail because: You are the assignee for the bug.
[Bug 161061] [UI] Grid lines are visible on all cells when option 'Show on colored cells' is chosen
https://bugs.documentfoundation.org/show_bug.cgi?id=161061 --- Comment #5 from ady --- (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.
[Bug 161061] [UI] Grid lines are visible on all cells when option 'Show on colored cells' is chosen
https://bugs.documentfoundation.org/show_bug.cgi?id=161061 --- Comment #4 from Cor Nouws --- Hi ady, (In reply to ady from comment #3) > There is also Options > Calc > Grid. I do know the grid and it's use quite well ;) > BTW, it is not "Grid Lines" nor "Grid lines", but rather "Gridlines", in But not used consistently.. > As for: > Menu Tools > Options > Calc > View > (Visual Aids) Grid lines > Show on > colored cells > > What other spreadsheet tools do? How _they_ behave? I think that's a different discussion? We had it ages ago when the three options were added (show, hide, show for cells with bgcolor) > And what is/was the (original) expected influence of the “menu View > View > Grid Lines” setting, when combining it with the related “Options > Calc > > View” settings? Is there a hierarchical precedence between these? Are these > independent (e.g. current temporal view vs setting saved to document)? Good questions. In any case, as it is now, the resulting behavior is very confusing. > Considering recent modifications to other items in the View menu and in the > Options menu, it is not so easy for me to know the original _expected_ > behavior of each of those View items, nor whether they apply (perhaps > temporarily on the live document, or per session) to the spreadsheet view > (only), or they should actually be saved to the document (too). Actually, I > have the same doubts about “menu Options > Calc > View” by now, because of > the same reason. Sharing that. > 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*... *) https://help.libreoffice.org/24.8/en-US/text/shared/optionen/01060100.html?System=UNIX=CALC=modules/scalc/ui/tpviewpage/TpViewPage#bm_id3157898 -- You are receiving this mail because: You are the assignee for the bug.
[Bug 161061] [UI] Grid lines are visible on all cells when option 'Show on colored cells' is chosen
https://bugs.documentfoundation.org/show_bug.cgi?id=161061 --- Comment #3 from ady --- There is also Options > Calc > Grid. This is because Grid is not the same as Gridlines. BTW, it is not "Grid Lines" nor "Grid lines", but rather "Gridlines", in order to identify/differentiate the lines that separate between cells (or show their limits without being a cell “border”) from the other places where the term “grid” is used. So, IDK the reason to have "View Grid Lines" instead of "View Gridlines", and the same for other places. Perhaps it is just to make translations easier? As for: Menu Tools > Options > Calc > View > (Visual Aids) Grid lines > Show on colored cells What other spreadsheet tools do? How _they_ behave? IOW, which of the following naming alternatives matches the expected behavior (which might not be the behavior you seem to expect)?: * Show on colored cells only? * Show on colored cells too? And what is/was the (original) expected influence of the “menu View > View Grid Lines” setting, when combining it with the related “Options > Calc > View” settings? Is there a hierarchical precedence between these? Are these independent (e.g. current temporal view vs setting saved to document)? Considering recent modifications to other items in the View menu and in the Options menu, it is not so easy for me to know the original _expected_ behavior of each of those View items, nor whether they apply (perhaps temporarily on the live document, or per session) to the spreadsheet view (only), or they should actually be saved to the document (too). Actually, I have the same doubts about “menu Options > Calc > View” by now, because of the same reason. So, may I suggest to look at other spreadsheet tools and their behavior regarding this Gridlines setting(s)? I cannot check this by myself ATM, but I believe Excel behaves as Calc too, but I might be misremembering so please do not just trust my words (i.e. if possible, re-create the spreadsheet anew in Excel and review the Gridlines options and behavior). Please also keep in mind that the Gridlines settings are supposed to apply per (selected) worksheet, not per entire workbook. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 161061] [UI] Grid lines are visible on all cells when option 'Show on colored cells' is chosen
https://bugs.documentfoundation.org/show_bug.cgi?id=161061 --- Comment #2 from Cor Nouws --- (In reply to ady from comment #1) > Please be mindful of menu View > View Grid Lines, and menu View > Grid and > Helplines, not confusing them with similarly-named settings in Options > > Calc > View dialog. Oh gosh... I've been living under a stone (or other wise too busy) that I missed this... > Some of these settings have an impact on the document, and others have an > impact on how the document is seen on the specific installation on the > specific device (not necessarily saved on the document). So each of these > are intended as different purposes. > > I mention this because we have seen recent changes in which the options in > the View menu are mixed/confused (unfortunately erasing their different > purposes) with similar settings within the Options > Calc > View dialog. Not > everything is supposed to be saved to the document, so these are not exactly > the same, despite their similar naming. Thanks for explaining Ady. It looks as is an improvement of this situation is desired..? -- You are receiving this mail because: You are the assignee for the bug.
[Bug 161061] [UI] Grid lines are visible on all cells when option 'Show on colored cells' is chosen
https://bugs.documentfoundation.org/show_bug.cgi?id=161061 --- Comment #1 from ady --- Please be mindful of menu View > View Grid Lines, and menu View > Grid and Helplines, not confusing them with similarly-named settings in Options > Calc > View dialog. Some of these settings have an impact on the document, and others have an impact on how the document is seen on the specific installation on the specific device (not necessarily saved on the document). So each of these are intended as different purposes. I mention this because we have seen recent changes in which the options in the View menu are mixed/confused (unfortunately erasing their different purposes) with similar settings within the Options > Calc > View dialog. Not everything is supposed to be saved to the document, so these are not exactly the same, despite their similar naming. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 161061] [UI] Grid lines are visible on all cells when option 'Show on colored cells' is chosen
https://bugs.documentfoundation.org/show_bug.cgi?id=161061 Cor Nouws changed: What|Removed |Added CC||c...@nouenoff.nl Keywords||regression -- You are receiving this mail because: You are the assignee for the bug.
