Description: A "style" is understood by most users to be - as has been long established in Microsoft Word - a way to easily apply a user-defined set of character (or paragraph or cell) attributes to the user's selection. For example, a style might make the selected characters superscript and 6 pt size without affecting any other character attributes. Each such style would then be accessible via a user-defined keyboard shortcut, allowing the user to quickly go through a large spreadsheet and apply, or change, the visual appearance. If Calc 5.3.2.2 allows this it's insanely unintuitive and the help file is no help whatsoever. My attempts to create styles, when applied, seem to try to change every single parameter (and seem to do this in a very buggy way, although I'm not sure it's a bug because I can't understand how the UI is supposed to work). Steps to Reproduce: 1. try to use styles as described 2. try to use the help pages 3. _____________? Actual Results: Extreme frustration Expected Results: If it's called a "style" - obviously a tip of the hat to Microsoft Word - it should work as well or (preferably) better than Word, and someone who is comfortable with Word styles (e.g., about 1 billion people) should be able to intuit how Calc works. In lieu of that, the help file should explain, in detail and in friendly fashion, what is different and why, and how to use styles to save time. Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36
Please take a look to LibreOffice documentation for Calc, chapter 4. https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide
(In reply to m.a.riosv from comment #1) > Please take a look to LibreOffice documentation for Calc, chapter 4. > https://wiki.documentfoundation.org/Documentation/ > Publications#LibreOffice_Calc_Guide I read that, and while I still think this feature is riddled with bugs, I now see that even if they were fixed, "cell styles" appears to affect everything in the cell and can't be applied to a selection of characters within the cell. For a person trying to make a good looking spreadsheet, this makes the feature almost completely useless. Very disappointed. And since I entered that report I've stumbled on an intermittent problem where a Calc cell is formatted (with multiple sizes, underlining and superscript) as desired, and then when I come back to it, it's been corrupted - applying the underline to the same cell and superscripting the wrong characters (and this occurred during a period where I wasn't using styles at all). I couldn't find steps so I didn't report it, but the whole area of formatting is really a mess as of 5.3.2.2. The more I work with it (full time, seven days a week) the more discouraged I get.
I think bug 108220 and/or bug 58759 would address your frustrations. Let's close this one. *** This bug has been marked as a duplicate of bug 58759 ***