Download it now!
Bug 121839 - FORMATTING -- ConditionalFormat.ColorScale Does Not Survive File-Rreload
Summary: FORMATTING -- ConditionalFormat.ColorScale Does Not Survive File-Rreload
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
: 121774 (view as bug list)
Depends on:
Blocks: Conditional-Formatting
  Show dependency treegraph
Reported: 2018-12-01 12:08 UTC by axettejoj-5397
Modified: 2019-09-19 03:34 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

Reportedly, the problem is caused by R1C1 syntax (GIF produced by OP) (3.00 MB, image/gif)
2018-12-01 23:01 UTC, Mike Kaganski
Please attach a sample document, as this makes it easier for us to verify the bug.. (67.48 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-12-18 16:40 UTC, axettejoj-5397

Note You need to log in before you can comment on or make changes to this bug.
Description axettejoj-5397 2018-12-01 12:08:52 UTC
After File/App Close-Reopen
Conditional Color Scale Formatting
is no longer displayed. The entries are
present in Manage but Editing has no effect.
Have to be removed & recreated from scratch again( 

Steps to Reproduce:
1. Format - Conditional - Color.Scale - (2 Entries)
2. File - Close - Open

Actual Results:

Expected Results:

Reproducible: Always

User Profile Reset: Yes

Additional Info:
Build ID: 6.1.1-3
CPU threads: 2; OS: Linux 4.18; UI render: default; VCL: gtk2; 
Locale: en-US (en_US.UTF-8); Calc: threaded
Comment 1 raal 2018-12-01 15:29:23 UTC
I can not confirm with Version:
Build ID: a63cd8bbe7cf881daa8dc7a7f32f3e5ac384e902
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3;
Comment 2 Mike Kaganski 2018-12-01 23:01:13 UTC
Created attachment 147208 [details]
Reportedly, the problem is caused by R1C1 syntax (GIF produced by OP)

However, in testing on Windows, I also used R1C1, and didn't repro (
Comment 3 Xisco Faulí 2018-12-05 11:03:32 UTC Comment hidden (obsolete)
Comment 4 raal 2018-12-16 16:27:13 UTC
*** Bug 121774 has been marked as a duplicate of this bug. ***
Comment 5 axettejoj-5397 2018-12-18 16:37:46 UTC
The temp workaround is
to to switch to the Calc A1
formula syntax style, create that 
formatting, save it, reload the doc
& then finally switch back to R1C1.
That way it seems to persists..
Comment 6 axettejoj-5397 2018-12-18 16:40:15 UTC
Created attachment 147652 [details]
Please attach a sample document, as this makes it easier for us to verify the bug..
Comment 7 axettejoj-5397 2018-12-18 16:42:40 UTC
> Thank you for reporting the bug..

Related bug in the attachment. 
R47R48. Merged cells never show
conditional color scale properly.
Comment 8 Oliver Grimm 2019-06-20 11:53:05 UTC
CANNOT confirm here
neither with A1 nor R1C1 syntax

Build-ID: 1:6.1.5-3
CPU-Threads: 2; BS: Linux 4.19; UI-Render: Standard; VCL: gtk3; 
Gebietsschema: de-DE (de_DE.utf8); Calc: group threaded
Comment 9 Joel Hilsenrath 2019-06-26 06:03:29 UTC
Some of the Conditional Formatting settings will only save correctly in the .ods file format.
Comment 10 Xisco Faulí 2019-08-09 11:52:31 UTC
Could you please try to reproduce it with the latest version of LibreOffice
from ?
I have set the bug's status to 'NEEDINFO'. Please change it back to
'UNCONFIRMED' if the bug is still present in the latest version.