Bug 85998 - Usability improvements to "Choose Themes" (table styles in Calc): Add theme, delete theme, format cells according to theme
Summary: Usability improvements to "Choose Themes" (table styles in Calc): Add theme, ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: low enhancement
Assignee: Not Assigned
Depends on:
Blocks: Document-Themes Calc-Styles
  Show dependency treegraph
Reported: 2014-11-07 10:54 UTC by Gerry
Modified: 2022-04-13 10:03 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description Gerry 2014-11-07 10:54:15 UTC
Related to bug 77569.
LibreOffice Calc has with "Choose Themes" a very capable solution for Table Styles in Calc. It is in the toolbar "View" -> "Toolbars" -> "Tools". Choose Themes is based on the styles concept of LibreOffice.
However, usability needs to be improved to actually get a perfect solution:

Please add:
* possibility to add new themes on basis of the current cell selection. ("Add theme on basis of selection"). Following the logic in Choose Themes it shall add a theme on basis of the different cells in the selected table: bl=bottom left cell of tables, t=top, tr=top right, etc.)
* possibility to delete themes ("Delete theme")
* possibility to "Format selected cells according to theme", including the correct assignment of the different cell styles to the current selection of cells.

and in the long run:
* possibility to have alternating rows (color and so forth).

P.S: After these improvements, IMHO it is possible to remove the feature "AutoFormat" from Calc.
Comment 1 Adolfo Jayme Barrientos 2014-11-08 20:16:27 UTC
This seems an interesting proposal to add as a GSoC task ;)
Comment 2 Olivier Hallot 2014-11-11 17:38:21 UTC
About removing autoformat, it must be noted that if you must have 2 Calc tables with different formatting, changing styles of one table will change style of all tables with the same styles applied.
Comment 3 DanielOneil 2022-03-31 14:10:23 UTC Comment hidden (spam)
Comment 4 RachelKenzie 2022-04-04 08:37:53 UTC Comment hidden (obsolete, spam)
Comment 5 SherryHarris 2022-04-13 10:03:51 UTC Comment hidden (obsolete, spam)