Description: Utilizing the Spreadsheet Theme option the following categories apply no changes to the sheet: Nature, Millennium, Night, Pumpkin, Black & White, Blackberry Bush, Fifties Diner, & Green Grapes. This bug occurs regardless of light or dark mode. Other users have experienced similar error. Example:https://www.youtube.com/watch?v=DVcC1uyDkn8 discussion of issue is at:1:10 Steps to Reproduce: 1.Open Calc 2.Format---> Spreadsheet Theme 3.Select the following theme option: Nature, Millennium, Night, Pumpkin, Black & White, Blackberry Bush, Fifties Diner, Green Grapes. Actual Results: No changes to the formatting of the spreadsheet document. Expected Results: Selecting from the options menu should show a preview of the theme color scheme & typography. Apply the option should result in applied theme color scheme & typography. Reproducible: Always User Profile Reset: Yes Additional Info: The following was provided automatically from About LibreOffice: Version: 7.5.4.2 (X86_64) / LibreOffice Community Build ID: 36ccfdc35048b057fd9854c757a8b67ec53977b6 CPU threads: 4; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
Created attachment 188307 [details] Example of bug
Hello, Thank you for submitting this! I was able to recreate the issue using the version pasted below. I have no idea what some of the categories like Millennium, Nature, etc. are supposed to look like - but they are not applying any theme beyond standard so I would conclude it is a bug. Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 77fca616e0bd79e0b405fd0b3543cf8e94e15df3 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
Suggestion: 1. Open a new Calc spreadsheet. 2. Menu Styles > Manage Styles (the Style side bar opens) 3. A1: Double click on some style in the side bar, e.g Card > Card B 4. Menu Format > Spreadsheet Theme 5. Click once on each theme; for each theme, A1 changes its background color (for the "Card B" cell style, for example). The content of the official Help might need some clarification, or better wording, or examples. https://help.libreoffice.org/latest/en-US/text/scalc/guide/design.html If all this works for you, then maybe a new report to request / suggest improvements to the help content would be better than having this report bug 156229. Please test and confirm. Setting to NEEDINFO.
Created attachment 188569 [details] Mockup for notification of missed theme step possible solution to alert user when a custom cell style has not been selected prior to theme application.
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.
IOW, the problem seems to be UX + adequate Help.
(In reply to Lupe from comment #5) > a. an icon next to unapplied themes to trigger a box when hovered over > providing a brief text box explaining the prior step. Would be much better than a textual description. > Step-by-Step Guide to Apply a Theme to a Spreadsheet: Surely needs to be added. Another alternative is to have these themes at the Stylist (next to Cell Styles and Page Styles), or as an extra tab in the sidebar similar to the Document Style (aka Design) in Writer. Besides, cleaning up the list and making it extendable is desirable. But on the other hand, I wonder if users need such feature -- and understand the difference to page/cell styles/autoformat style. Digging the bugtracker does not return many results (except a duplicate of this report; keeping this one for the comments) meaning users are not so much interested in this theming.
*** Bug 117998 has been marked as a duplicate of this bug. ***
No further input, let's make this a topic for documentation. (The "Card" cell style is inserted after a theme has been picked.) The dialog is a wizard, check wizards/source/template/DialogStyles.xdl for details, with styles defined under extras/source/templates/wizard/styles/. I vote for removal of the whole feature. Tomaz (or Miklos) is working on the (Document) Themes alternative.