Page styles are important: - each sheet can have a different page style; - each page style allows setting orientation, header/footer, scaling.. etc; - that interacts with print ranges; - and result in beautiful PDF exports or prints. It's - as far as I know - mostly unclear that double clicking a page style in the Stylist (eh.. pane Manage Styles :D ) applies that to the active sheet. What if we add a selection widget to the sheets tab, that allows picking one of the available page styles? (checked in Version: 24.2.1.2 (X86_64) / LibreOffice Community Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded and in Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 05a1217921b7be283c6750a35b90e4feda6e993e CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded)
(In reply to Cor Nouws from comment #0) > What if we add a selection widget to the sheets tab, that allows picking one The Stylist offers in Calc the page styles Default and Report. It's the same workflow as known from Writer. What are you missing?
Available per Sheet via main 'Sheet' menu seems fine, but to me would be more convenient if a "Page Style..." entry were added onto the context menu of the sheet's Tab bar entry--it applies to that specific sheet. That would be in line with what is available for Writer. But how useful would that really be? Only the Stylist "Page style" content panel provides a selector, while opening the edit panel for the current style would kind of encourage direct formatting of the Sheet style otherwise. I.e. Edit a style rather than apply another existing style. Not the work flow suggested. And given that the locale generated shellnew provides only 'Default' and 'Report' page layouts all additional are Custom Styles that are per-document only, or as delivered via .OTS template -> New work flows. What improvement to styling would placing the control directly on the sheet provide that isn't already provided via the Stylist? So applying a 'Page' style to a sheet is not a "Benjamin" level workflow--and the existing 'Stylist' based manipulation should suffice for "Eve" users [1]. -1 =-ref-= [1] CG24 pgs 216-218, https://nextcloud.documentfoundation.org/s/8KWEqHH7pTzFp9s
(In reply to V Stuart Foote from comment #2) Otherwise, seems Calc needs Status bar context menu access to apply page style to each Sheet as for bug 87750, to match UI for Writer.
(In reply to V Stuart Foote from comment #3) > (In reply to V Stuart Foote from comment #2) > > Otherwise, seems Calc needs Status bar context menu access to apply page > style to each Sheet as for bug 87750, to match UI for Writer. That is a logic approach. However: - in Writer picking a page style means it is applied from the top/place with hard break defining a page style above to the bottom/place with a hard break defining a page style. - in Calc picking a page style means it is applied to the selected sheet(s). Hence one could argue that adding the choice to the sheet tab is the more natural place?
(In reply to Cor Nouws from comment #4) > (In reply to V Stuart Foote from comment #3) > > (In reply to V Stuart Foote from comment #2) > > > > Otherwise, seems Calc needs Status bar context menu access to apply page > > style to each Sheet as for bug 87750, to match UI for Writer. > That is a logic approach. > However: > - in Writer picking a page style means it is applied from the top/place with > hard break defining a page style above to the bottom/place with a hard break > defining a page style. > - in Calc picking a page style means it is applied to the selected sheet(s). > > Hence one could argue that adding the choice to the sheet tab is the more > natural place? Don't think so. Currently in Calc the page "Style" entry on the status bar reflects the *active* sheet with cursor focus, even with multiple sheets selected. And currently the Sytlist allows applying a sheet style to a selection of sheets. Assume in implementing it that a selector on the status bar would do the same, work against a selection of sheets. So while having selector in context menu entry at the Sheet tab would be good for styling a single sheet (though not simply the "Page Style..." dialog) adding the page style selector to the status bar as for bug 87750 would offer a more efficient UI to style a full spreadsheet document. Also more discoverable/better feed back when applied--annotated onto the Status bar for each sheet.
Hi Stuart, I think I do not fully understand your comments about applying styles from the Manage Styles pane in the Sidebar in comparison with other options. Choosing a page style from the Sidebar applies that to the selected sheet(s), as you write. But you seem to see differences, or possible differences with a situation where a page style is picked from a list with available page styles at another position (either sheet tab or status bar)? Either I do not understand the difference, or not understand your comments :) Can you pls clarify?
(In reply to Cor Nouws from comment #6) > Hi Stuart, > I think I do not fully understand your comments about applying styles from > the Manage Styles pane in the Sidebar in comparison with other options. > Choosing a page style from the Sidebar applies that to the selected > sheet(s), as you write. Correct. > But you seem to see differences, or possible differences with a situation > where a page style is picked from a list with available page styles at > another position (either sheet tab or status bar)? They would be the same. Just that a page style applied via the context menu of a Sheet's "Tab"--would apply against just that sheet. While a page style applied via the Status Bar (bug 87750) would apply to all selected active Sheets. Also that for both, the action should be applying the page style to the sheet. And *not* simply opening the "Page Style..." dialog which is a style editor with no means to select/apply a different page style--likely custom by template or previously created in current spreadsheet. That is the way the Status bar selector functions for Writer pages (though as you note the page styles for Writer affect ODF text documents differently than page styles for Calc ODF spreadsheets). > Either I do not understand the difference, or not understand your comments :) > Can you pls clarify? Just want to be clear that what is needed for both the Sheet tab (bug 160920) and the Status bar <r-mouse> context menu action (bug 87750) is the style selector and not the style editor for the sheet.
thanks! (In reply to V Stuart Foote from comment #7) > They would be the same. Just that a page style applied via the context menu > of a Sheet's "Tab"--would apply against just that sheet. While a page style > applied via the Status Bar (bug 87750) would apply to all selected active > Sheets. To me that looks a matter of choice (in any case if right click on multiple selected sheets respects the selection)? > Also that for both, the action should be applying the page style to the > sheet. And *not* simply opening the "Page Style..." dialog which is a style > .. Fully agree to that.
(In reply to Cor Nouws from comment #8) > To me that looks a matter of choice (in any case if right click on multiple > selected sheets respects the selection)? > > > Also that for both, the action should be applying the page style to the > > sheet. And *not* simply opening the "Page Style..." dialog which is a style > > .. > Fully agree to that. If I may... The positive in the status bar: the UI space is already used for Page Style info. This is a negative for the worksheet Tab, where a new non-essential (but potentially useful) context menu item would be added. The negative in the status bar: the current info is relevant for the current worksheet only. When selecting multiple worksheets, perhaps with different Page Styles each, there is no indication of the Page Styles in use by the other selected worksheets. In such situation, allowing to select a different Page Style for the multiple-selection of worksheets would impact all the selected worksheets, and it would be easy for users to not notice the multiple change. Perhaps the display of the Page Style should change when selecting multiple worksheets? For instance, use bold?, italics?, underline? add symbol? Currently this distinction is not needed, even when selecting multiple worksheets. If the Page Style is simultaneously changed for more than the current/active/displayed worksheet, perhaps a confirmation dialog should pop up?
(In reply to ady from comment #9) > If I may... If you insist .. ;) - but sure! > The positive in the status bar: the UI space is already used for Page Style > info. This is a negative for the worksheet Tab, where a new non-essential I would love to see a broadly accepted and clear definition of 'non-essential' in the UI/software? Me expects to get dozens - IOW: it's rather subjective. > (but potentially useful) context menu item would be added. > > The negative in the status bar: the current info is relevant for the current > worksheet only. When selecting multiple worksheets, perhaps with different > Page Styles each, there is no indication of the Page Styles in use by the > other selected worksheets. In such situation, allowing to select a different > Page Style for the multiple-selection of worksheets would impact all the > selected worksheets, and it would be easy for users to not notice the > multiple change. That is not different to what happens when applying a style in the Manage Styles pane. But honestly I think that users that work with multiple sheets selected, can be considered experienced enough to.. > Perhaps the display of the Page Style should change when selecting multiple > worksheets? For instance, use bold?, italics?, underline? add symbol? > Currently this distinction is not needed, even when selecting multiple > worksheets. Yes, maybe a bit opaque .. still people would need to learn/see the meaning. > If the Page Style is simultaneously changed for more than the > current/active/displayed worksheet, perhaps a confirmation dialog should pop > up? See before: it is standing practice - and a different subject, so pls open a separate bug report to discuss.
(In reply to Cor Nouws from comment #10) > > The positive in the status bar: the UI space is already used for Page Style > > info. This is a negative for the worksheet Tab, where a new non-essential > I would love to see a broadly accepted and clear definition of > 'non-essential' in the UI/software? By non-essential I mean that there are other ways to achieve the same goal. Having the possibility of selecting a different Page Style, either from the status bar of from the worksheet Tab could be convenient, but there are other ways to achieve it. For instance, in the worksheet Tab, the context menu includes "Move or Copy sheet", which I think it is more relevant in this menu than the suggested Page Style. After some time, we can read the opposite reasoning: "your request for this new UI artifact sounds useful, but that area of the UI already has many items". At some point, adding items is not as much welcome. Carefully considering which precise items are really a plus in a certain context menu eventually reduces the potential unwanted clutter. > > (but potentially useful) context menu item would be added. > > > > The negative in the status bar: the current info is relevant for the current > > worksheet only. When selecting multiple worksheets, perhaps with different > > Page Styles each, there is no indication of the Page Styles in use by the > > other selected worksheets. In such situation, allowing to select a different > > Page Style for the multiple-selection of worksheets would impact all the > > selected worksheets, and it would be easy for users to not notice the > > multiple change. > That is not different to what happens when applying a style in the Manage > Styles pane. > But honestly I think that users that work with multiple sheets selected, can > be considered experienced enough to.. Experienced users make mistakes too. By the time users realize the mistake, it might be too late to undo it. With the current situation, users can modify the Page Style itself from the status bar, but ATM it is not possible (from the status bar) to make the mistake of selecting a different Page Style to "unwanted" worksheets. Since the status bar can show the Page Style that corresponds to the current worksheet _only_ (while having multiple worksheets selected), the chance for this potential mistake increases. That is not to say that the suggested change is not worth it. I was just mentioning some UX details that might be relevant in order to choose whether the suggested context menu (or whichever other UI method) should rather be located on the status bar or on the worksheet Tab, and perhaps to have additional details in mind.
(In reply to ady from comment #11) > ... > Experienced users make mistakes too. By the time users realize the mistake, > it might be too late to undo it. thnx Ady. I'm glad we sort of agree that using multiple sheets selected is for experienced user. In the case of picking a 'wrong' page style for a sheet, that will only affect the print (preview) and produced PDF - something one would expect to be checked - but nothing in the document is affected in any way.
(In reply to Cor Nouws from comment #0) > It's - as far as I know - mostly unclear that double clicking a page style > in the Stylist (eh.. pane Manage Styles :D ) applies that to the active > sheet. So, don't you want to make that the bug?
Created attachment 194162 [details] Screenshot Writer We discussed the topic in the design meeting. Likewise in Writer the statusbar in Calc should provide access the page styles and allow quickly pick one for the current sheet.