Bug 168809 - Ability to import and export the colors used for a chart's data series
Summary: Ability to import and export the colors used for a chart's data series
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Chart Color-Palettes
  Show dependency treegraph
 
Reported: 2025-10-11 08:26 UTC by Eyal Rozenberg
Modified: 2025-10-23 07:40 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Eyal Rozenberg 2025-10-11 08:26:22 UTC
A chart has an implicit color palette, in both a narrow and expanded senses.

In the narrow sense, it is the sequence of default chart data series colors.

In the wider sense, this also includes:

* The default colors of a chart's background area, axis lines, label text etc.
* The set of colors from within which a user is encouraged to choose series colors.

(i.e. a wider subset of what would be a chart's style.)

I would like, even before full chart styles are implemented, to be able to apply one chart's color palette to another, including across different document. This can be achieved with little UI work via an import and export mechanism.



See also bug 163535 about the default palette and bug 62925 about the request for full-fledged chart styles.
Comment 1 Heiko Tietze 2025-10-13 08:10:05 UTC
Chart palette was introduced for bug 106534. Find the option at Format Data Series... > Color Palette. And you can modify the standard chart colors per Tools > Options > Charts > Default Colors.

There are tickets requesting better palettes, and surely there are for an improved workflow. What exactly do you add to the topic?
Comment 2 Eyal Rozenberg 2025-10-13 11:28:18 UTC
(In reply to Heiko Tietze from comment #1)
> Chart palette was introduced for bug 106534. Find the option at Format Data
> Series... > Color Palette. And you can modify the standard chart colors per
> Tools > Options > Charts > Default Colors.
>
> There are tickets requesting better palettes, and surely there are for an
> improved workflow. What exactly do you add to the topic?

Well, first and foremost - the title of this bug: I want to be able to import and export, and that dialog tab doesn't let me do that (nor can I do that elsewhere).

I'll also add that its discoverability is lacking; and it doesn't show me the current, actual, color palette used (i.e. it's as though it shows the named style but not the DF). But those would be separate bugs about the dialog.


Anyway, is there a meta-bug for chart color palettes? I don't seem to see one. There is 104118 - but it's about color palettes in general.
Comment 3 Gerry 2025-10-22 19:29:49 UTC
FYI: Regarding (general) color palette import / export, I am not sure if you are aware of these:

Support for (import) multiple color palette formats: Gimp (.gpl), Adobe Swatch Exchange (.ase), LibreOffice/Apache OpenOffice (.soc) 
And see regarding gpl: https://bugs.documentfoundation.org/show_bug.cgi?id=92354


For export, there is an extension: https://extensions.libreoffice.org/en/extensions/show/custom-palette-eport
Comment 4 Heiko Tietze 2025-10-23 06:57:58 UTC
We discussed the topic in the design meeting.

The use case is clear and unequivocal. However, the development around colors has scattered and the customization of chart palettes is possible via tools > options > chart or with the newly introduced chart theme [1] or per color palette "Chart palette". In a wider scope we have document themes, document colors, application colors and themes, etc. This becomes not only difficult to understand for average users but also for sharing. If we import/export a chart palette (or theme) it is desirable to distribute it via extension - which ideally does not become a new category.

[1] https://gerrit.libreoffice.org/c/core/+/184265
Comment 5 Heiko Tietze 2025-10-23 07:21:55 UTC
(In reply to Gerry from comment #3)
> FYI: Regarding (general) color palette import / export...

Both deal with ordinary color palettes that wont apply at charts. At least it requires to change the color of each series manually.
Comment 6 Eyal Rozenberg 2025-10-23 07:40:53 UTC
(In reply to Heiko Tietze from comment #4)

Let me clarify that:

* This bug is not about officially sanctioned or blessed color palettes, that LibreOffice distributes. 

* I used the term "palette" to describe the actual series colors used, not some choice from the recently-added palettes tab of a dialog. For now, that tab does not show the current colors used by the chart; it only lets you apply one of several color palettes defined apriori.