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)
Version:
(earliest affected)
4.1.6.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Conditional-Formatting
  Show dependency tree / graph
 
Reported: 2015-03-24 21:49 UTC by Jérôme
Modified: 2023-12-17 16:13 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
see 'Mar' tab, cells G27 and H27 (285.52 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-03-24 21:49 UTC, Jérôme 		Details
View All Add an attachment (proposed patch, testcase, etc.)

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.

Reproducible.
Win7x64,
LibreOffice 4.4.2.1 and 4.4.0.0.beta2+ (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: 6.5.0.0.alpha0+ (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
Comment 6 QA Administrators 2021-12-06 04:06:28 UTC Comment hidden (obsolete)
Comment 7 Jérôme 2021-12-12 14:59:54 UTC 
I confirm the conditional format is not copied from G26:H26 to G27.
Version: 7.2.3.2 / LibreOffice Community
Build ID: a49ed84f3d037188bbbcb324f9afc3796d887539
CPU threads: 4; OS: Linux 4.9; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.utf8); UI: fr-FR
Calc: threaded
Comment 8 QA Administrators 2023-12-13 03:14:05 UTC Comment hidden (obsolete)
Comment 9 Jérôme 2023-12-16 21:04:07 UTC 
I confirm the conditional format is not copied from G26:H26 to G27.
Version: 7.3.7.2.M5 (x64) / LibreOffice Community
Build ID: cf0a4747cef76399d7acd30c4dcda7a78e7973c2
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: fr-FR (fr_FR); UI: fr-FR
Calc: threaded

I don't have the time at the moment to install the latest version.
Comment 10 Jérôme 2023-12-17 16:13:14 UTC 
I just tested with a snap version on GNU/Linux.

I confirm the conditional format is not copied from G26:H26 to G27.

Version: 7.6.3.2 (X86_64) / LibreOffice Community
Build ID: 4fe86607b5ac922e55f140471fda9b60bdaa980d
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded