Bug 137164 - CALC: upgrades destroy graph color schemes
Summary: CALC: upgrades destroy graph color schemes
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.1.2 release
Hardware: All Windows (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-09-30 15:31 UTC by Stephen
Modified: 2020-11-15 19:10 UTC (History)
1 user (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 Stephen 2020-09-30 15:31:19 UTC
Description:
I have a spreadsheet with data for many categories and sub-categories. In the graphs derived from the spreadsheets I have a color scheme the uses different shades of the same color for the sub-categories of each category.

For instance in the graph sub-categories for Category 1 are all shades of red, sub-categories for Category 2 are all shades of blue, etc.

With each upgrade all the subcategories are assigned new colors seemingly at random, and I have to go through every sub-category of every graph and re-assign the original colors. This takes hours. Can upgrades be improved to retain graph color schemes?


Steps to Reproduce:
1.assign specific colors to series in a graph
2.Run an upgrade
3. Note colors change

Actual Results:
All colors seem to be reassigned at random

Expected Results:
left the color scheme alone


Reproducible: Always


User Profile Reset: No



Additional Info:
happened with the last two upgrades I performed
Comment 1 Martin Srdoš 2020-11-13 16:10:41 UTC
Hello Stephen,

Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)

Also write, what do you mean by run upgrade. Is it installing a new version of LO?
Comment 2 Martin Srdoš 2020-11-15 19:10:52 UTC
Info from reporter:
"Well I guess you can close as it didn't change the graph colors on my main sheet either. Thank for you time and effort".

No longer reproducible by bug reporter.