Bug 90209 - FORMATTING FILESAVE conditional formatting fails to be saved
Summary: FORMATTING FILESAVE conditional formatting fails to be saved
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Conditional-Formatting
  Show dependency treegraph
Reported: 2015-03-24 21:49 UTC by Jérôme
Modified: 2019-12-06 01:22 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

see 'Mar' tab, cells G27 and H27 (285.52 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-03-24 21:49 UTC, Jérôme

Note You need to log in before you can comment on or make changes to this bug.
Description Jérôme 2015-03-24 21:49:19 UTC
Created attachment 114313 [details]
see 'Mar' tab, cells G27 and H27

The automatic formatting isn't saved in some condition.

If I copy the range G26:H26 to G27 (and thus H27), then the automatic formatting is properly pasted with the content into the 2 cells.

I can change to the following values :
- G27 : '7e'
- H27 : 'RM CEE'

The automatic formatting works and makes the G27 background change to yellow.

Next I just save the file, close it and open it again.

The automatic formatting disappears.

Looking at the automatic formatting management (in French menu : "Format", "formatage conditionnel", "gérer..."), the automatic formatting exist for a list of contiguous cell references but G27 (ie : ..., G25, G26, G28, G29, ...) and H27 (ie : ..., H25, H26, H28, H29, ...).

Note that the G27 and H27 references appears before I save.

I reproduced this bug the 3 times that I performed the above test.

LO build ID : 40ff705089295be5be0aae9b15123f687c05b0a
Comment 1 m.a.riosv 2015-03-24 22:27:11 UTC
Hi @Jérôme, thanks for reporting.

LibreOffice and (x64)
Comment 2 tommy27 2016-04-16 07:22:51 UTC Comment hidden (obsolete)
Comment 3 QA Administrators 2017-05-22 13:22:19 UTC Comment hidden (obsolete)
Comment 4 QA Administrators 2019-12-03 14:34:45 UTC Comment hidden (obsolete)
Comment 5 m.a.riosv 2019-12-06 01:22:49 UTC
Now the conditional format is not copied from G26:H26 to G27.
Version: (x64)
Build ID: 60e8941fd581bb06cbf6be62edb8c387e7c07812
CPU threads: 4; OS: Windows 10.0 Build 19035; UI render: default; VCL: win; 
Locale: es-ES (es_ES); UI-Language: en-US
Calc: CL