Bug 85998

Summary:	Usability improvements to "Choose Themes" (table styles in Calc): Add theme, delete theme, format cells according to theme
Product:	LibreOffice	Reporter:	Gerry <gerry.treppel>
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---	QA Contact:
Severity:	enhancement
Priority:	low
Version:	4.3.2.2 release
Hardware:	Other
OS:	All
See Also:	https://bugs.freedesktop.org/show_bug.cgi?id=77569
Whiteboard:
i915 platform:		i915 features:

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 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.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.