https://bugs.documentfoundation.org/show_bug.cgi?id=116248
--- Comment #4 from Olivier Hallot <olivier.hallot@documentfoundation.org> ---
Actually there are two help pages on spreadsheet themes (to be updated):
(a) https://help.libreoffice.org/6.1/en-US/text/scalc/guide/design.html
(b) https://help.libreoffice.org/6.1/en-US/text/scalc/02/06080000.html
A help button should open (b) page.
1) The features is there for ages and has not been correctly exploited, AFAIK.
The "theme" is a set of cell styles that is added to the document. The parent
styles has name "Card" and has child styles that encloses a range of cells. In
addition, cell styles named "Background", "Column Header", "Input" are also
loaded.
2) However LO miss a piece of code to apply the theme styles to a cell range.
Applying the styles manually to spreadsheet tables is cumbersome.
3) I can imagine a use case in a complex spreadsheet with several tables
formatted with the Theme, and will allow change of style attributes quite
easily, making the document more homogeneous or uniform throughout several
sheets.
4) "Themes" are related to cell styles and "Autoformat" is related to direct
cell formatting.
5) for another ticket, once you highlight a theme in the dialog, the styles are
loaded to the document immediately and the Cancel button does not revert the
style loading.
6) Pivot tables also load a set of cell styles on creation and is the only way
I know to get fancy pivot tables, although every pivot table of a document will
get the same set of styles.
--
You are receiving this mail because:
You are on the CC list for the bug.
Context
- [Libreoffice-ux-advise] [Bug 116248] [UI] Missing Help button in dialog for Spreadsheet Themes · bugzilla-daemon
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.