Download it now!
Bug 94781 - Pivot Table design can be improved
Summary: Pivot Table design can be improved
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
Depends on:
Reported: 2015-10-05 10:20 UTC by marcostinez
Modified: 2017-08-08 12:35 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

One option of the out of the box designs in Excel (12.86 KB, image/png)
2015-10-05 10:20 UTC, marcostinez
Modified pivot styles (62.32 KB, image/png)
2017-01-02 16:22 UTC, Heiko Tietze

Note You need to log in before you can comment on or make changes to this bug.
Description marcostinez 2015-10-05 10:20:31 UTC
Created attachment 119302 [details]
One option of the out of the box designs in Excel

PT per se are extremely powerful but without proper design options their basic objective is very limited: Show/present data in a clear and easy way in order to quickly draw conclusions and make it visually appealing.
Excel has solved this in the Design Ribbon with a series of colour combinations with which the user can play around, changing the colours on the fly. In Calc I haven't seen anything like this.
I know I can format the colour of individual cells but the point here is to create a consistent colour/format combination .

I think there is a lot of potential to actually beat Excel in two ways:
1. Apart from the predefined designs in Excel you can theoretically create your own design template but for me it hasn't worked at all, so if Calc get's this right we would take the lead
2. Implementing a way that users can actually create a design/colour template, export and share it would improve Calc exponentially. When it comes to design and looks the power of the community is unbeatable
Comment 1 Buovjaga 2015-10-08 17:09:08 UTC
What says UX?
Comment 2 Cor Nouws 2015-12-02 15:38:20 UTC
I would say "yes" :)  Thanks for filing Marcos.
Could you help with working out specific (partial) design goals?

Cheers - Cor
Comment 3 Heiko Tietze 2015-12-02 15:48:18 UTC
Added this topic to our to-do list. However, I don't think we should follow Microsoft blindly, and color is not the primary method of UI design ;-).
Comment 4 Robinson Tryon (qubit) 2016-08-25 05:39:07 UTC Comment hidden (obsolete)
Comment 5 Heiko Tietze 2017-01-02 16:22:48 UTC
Created attachment 130096 [details]
Modified pivot styles

Checking back old UX tickets this one popped up. Actually we have pivot styles for category, corner, field, result, title, and value, and we could change the default styles and introduce background colors. Not the preferred approach, IMHO.
Another option is to have more than one style, meaning not only Default but also Rainbow, or the like, and means to quickly change all properties.
So this ticket is either a WFM or we should change its direction (probably there is also a duplicate).

Comment 6 Heiko Tietze 2017-08-08 12:35:39 UTC
(In reply to Heiko Tietze from comment #5)
> So this ticket is either a WFM...

It is.