Date: prev next · Thread: first prev next last
April 2018 Archives by date, by thread · List index


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


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.