https://bugs.freedesktop.org/show_bug.cgi?id=44762
Bug #: 44762
Summary: FORMATTING, PIVOTTABLE: naming of styles and request
for more styles
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.4.4 release
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
The styles supplied with the Pivot Table / DataPilot are misleading and not
sufficient for a proper styling of the DataPilot.
The styles names are very different from the actual part name in the DataPilot,
hence it is not clear and even misleading to which part they apply (see table
below).
The supplied styles are to few for a proper styling:
- There is only one style for row, column and sub-totals. In general totals are
expressed stronger than subtotals - currently this is not possible.
- Row and column headings have the same style, so it is not possible for
example to center column headings and align right row headings.
Current situation:
Name in DataPilot Layout | Actual applied Style
----------------------------------------------------------------
Row Fields _______________________|_ Pivot Table Category
Coulmn Fields ____________________|_ Pivot Table Category
[Cells with drop down menu] ______|_ Pivot Table Fields
Data Fields ______________________|_ Pivot Table Value
Total Columns ____________________|_ Pivot Table Result
Total Rows _______________________|_ Pivot Table Result
[Subtotals] ______________________|_ Pivot Table Result
[Heading of totals] ______________|_ Pivot Table Title
[Description in upper left corner]|_ Pivot Table Corner
Because of these above mentioned shortcoming, I would like to propose a more
precise naming of the styles and a greater division of styles:
Name in DataPilot Layout | Actual applied Style
----------------------------------------------------------------
Row Fields _______________________|_ Pivot Table Row Category
Coulmn Fields ____________________|_ Pivot Table Column Category
[Cells with drop down menu] ______|_ Pivot Table Row Field, Pivot Table Column
Field
Data Fields ______________________|_ Pivot Table *Data*
Total Columns ____________________|_ Pivot Table Column Result
Total Rows _______________________|_ Pivot Table Row Result
[Subtotals of row/col fields] ____|_ Pivot Table Sub-Result
[Heading of totals] ______________|_ Pivot Table Row Result Title, Pivot Table
Column Result Title, Pivot Table Sub-Result Title
[Description in upper left corner]|_ Pivot Table Corner
Hierarchical overview of the new styles:
|-Pivot Table Category
-Pivot Table Row Category
-Pivot Table Column Category
|-Pivot Table Corner
|-Pivot Table Data
|-Pivot Table Field
-Pivot Table Row Field
-Pivot Table Column Field
|-Pivot Table Result
-Pivot Table Row Result
-Pivot Table Column Result
-Pivot Table Sub-Result
|-Pivot Table Result Title
-Pivot Table Row Result Title
-Pivot Table Column Result Title
-Pivot Table Sub-Result Title
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
