Created attachment 146489 [details]
Table Design in Properties section of Sidebar in Impress
When inserting a new table in Impress, in both the Sidebar Properties section and the Tabbed bar there is an option for Table Design.
This option shows several Table Styles and allows an user to configure how those Styles can be configured (stronger color in header row and/or first column and/or final row)
I would like to request if this feature can be made available in Calc and replace the Table Styles section in Writer.
Since Calc is the obvious application to manipulate tables this feature should be available to it. Furthermore, offering table styles independently of cell styles is a feature in other spreadsheet applications such as Excel or WPS Spreadsheets.
Therefore, this is a feature that is necessary in Calc to try to achieve feature parity with other spreadsheet applications.
This also solves the issue of creating more Table Styles without assuming that the final row is a total row since the user will have the flexibility to define that as already happens in Impress.
I would like to request that this Table Design feature becomes available both in Calc and Writer and that the command to access it is grouped near to the other Styles buttons in all LO modules.
Created attachment 146490 [details]
Current Table Styles in Writer
Created attachment 146491 [details]
No table styles in Calc
Created attachment 146492 [details]
Table styles in Excel 2016
Created attachment 146493 [details]
Add Table Design to Calc, rename to Table Styles and move location close to other styles.
Also by making this Table Design option in Calc and Writer we could remove Autoformat Table Styles from both.
Just to mention that for Calc there is a GSoC idea since a while, but so far nobody dared to pick it up, https://wiki.documentfoundation.org/Development/GSoC/Ideas#Implement_table_styles
Note that it's way more than non-trivial to implement.
In theory, I like the idea of a more visual styling like tables in Impress. But there are technical differences:
- Impress table styling (I don't call it Styles) are completely different to table styles in Writer and to AutoFormat table styling.
- Now it's not possible (as far as I know) to use commands to modify style attributes. If you want to modify a style in the sidebar like it's done in Impress now, Bug 107865 - 'UNO commands to modify style-level character and paragraph properties' must be implemented for table styles.
PS: Please use keywords, etc. carefully and read what they do. I'll remove needsDevEval as we don't ask for an EasyHack.
When adding needsUXEval, please also add libreOffice-Ux-advise@... to CC and maybe Cor's and Stuart's and my e-mail.
just for info:
"Format as Table" in Excel (2010 and more new) allows not only select a visual style for range but also:
1. Every that "table" on sheet has its own name you can use in formulas with, for example, SUMIF or VLOOKUP
2. "Table" automatic changes its size if you add row or column
3. In this "table" will be active autofilter by default
4. When you add rows in end of "table" then they automatic get all formulas from previous row
5. When you add columns in "table" and enter a formula in to one cell then all cells in this column will be have this formula automatically
6. If you scroll your "table" down, then headers (from first row of "table") will be show in row with column number (will don't need freeze first row)
7. When you enable Total row for this "table" you can select in Total row some different function (sum, average, count, etc.)
Let's keep this together with the previously reported issue. Although it's the underlying code aka style description that differs between Writer, Calc and Impress/Draw as well as access via sidebar.
*** This bug has been marked as a duplicate of bug 101802 ***