https://bugs.documentfoundation.org/show_bug.cgi?id=156229
--- Comment #5 from Lupe <[email protected]> --- I was able to follow the steps provided and successfully apply each theme. I would say the challenge presents itself for beginner user personas. When the theme does not apply, there is no indication that there is a previous step that needs to occur to display all themes. There is a falsehood that since some of the themes are able to apply and other themes do not then some users may think it is a bug in the system. Another challenge is that following steps in the help page may be confusing to some readers. https://help.libreoffice.org/latest/en-US/text/scalc/guide/design.html The step by step instructions do not follow the direct explanation for the use of the instructions and feels disjointed. It may be useful to rearrange some information to reading flow more efficient. Also, in my system, I was unable to find a 'change theme' icon in my toolbar. I may have missed it but, I provided instructions below in the event that others may miss it. Possible Solutions: 1) a. I'm not too sure how feasible this is but perhaps including an icon next to unapplied themes to trigger a box when hovered over providing a brief text box explaining the prior step. or b. if no custom cell style is applied then themes cannot be opened/ used. 2) rewording the help page to something like this- Step-by-Step Guide to Apply a Theme to a Spreadsheet: Before you format a sheet with a theme, you need to apply at least one custom cell style to the cells on the sheet. Here's how you can do it: a. Open the Styles tab. b. In the lower list box, select the "Manage Styles" view. c. A list of existing custom defined cell styles will be displayed. d. Double click a name from the Styles window to apply this style to the selected cells (i.e. 'Card') Now that you have a custom cell style applied, you can proceed to apply a theme to your spreadsheet: a. Open the Format tab. b. Towards the fifth section, select the "Spreadsheet Theme" b. The Theme Selection dialog will appear, listing the available themes for the whole spreadsheet. c. The Styles window will show the custom styles for specific cells. In the Theme Selection dialog, choose the theme that you want to apply to the spreadsheet by clicking onto the name. Click "OK" to apply the selected theme. Once you select a new theme in the Theme Selection dialog, the properties of the custom style will be applied to the current spreadsheet, and you'll immediately see the modifications in your spreadsheet. I have provided mockup in attachment for first solution. -- You are receiving this mail because: You are the assignee for the bug.
