Bug 117715 - Unlike other settings, Number Format in a conditional formatting style doesn't apply if a cell has a number format applied by direct formatting
Summary: Unlike other settings, Number Format in a conditional formatting style doesn'...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.3.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Conditional-Formatting
  Show dependency treegraph
 
Reported: 2018-05-20 13:38 UTC by Roman Kuznetsov
Modified: 2018-05-24 20:17 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Screenshot with different results after conditional formatting (3.22 KB, image/png)
2018-05-20 13:40 UTC, Roman Kuznetsov
Details
File-example with different results after conditional formatting (8.39 KB, application/octet-stream)
2018-05-20 13:41 UTC, Roman Kuznetsov
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Roman Kuznetsov 2018-05-20 13:38:08 UTC
Description:
Unlike other settings, Number Format in a conditional formatting style doesn't apply if a cell has a number format applied by direct formatting

Version: 6.0.3.2
Build ID: 8f48d515416608e3a835360314dac7e47fd0b821
CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: gtk2; 
Locale: ru-RU (ru_RU.UTF-8); Calc: group

Steps to Reproduce:
1. Create a new Calc doc
2. In cell A1 enter number 200, in cell B1 enter number 200
3. Set for A1 Format as Number (Ctrl+Shift+1)
4. Create a new style "Good_Currency" from existing style "Good", with format number Currency
4. Create for A1 Condition (Format-Conditional Formatting-Condition) with Cell value is - greater than - 199 and in drop-down list Apply style select our Good_Currency
5. Create for B1 Condition (Format-Conditional Formatting-Condition) with Cell value is - greater than - 199 and in drop-down list Apply style select our Good_Currency
6. Look at A1 and B1. In B1 there is currency, in A1 there isn't!

Actual Results:  
Number Format in a conditional formatting style doesn't apply if a cell has a number format applied by direct formatting

Expected Results:
Number Format in a conditional formatting style always apply


Reproducible: Always


User Profile Reset: No



Additional Info:


User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:60.0) Gecko/20100101 Firefox/60.0
Comment 1 Roman Kuznetsov 2018-05-20 13:40:02 UTC
Created attachment 142215 [details]
Screenshot with different results after conditional formatting
Comment 2 Roman Kuznetsov 2018-05-20 13:41:00 UTC
Created attachment 142216 [details]
File-example with different results after conditional formatting
Comment 3 Xavier Van Wijmeersch 2018-05-20 16:34:24 UTC
no repro

Version: 6.0.5.0.0+
Build ID: efd59fd1d7fc9d955a2b924f247709201f2281c5
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group

Version: 6.1.0.0.alpha1+
Build ID: 8eb15f031003f6431d41853ff70e307b617d1a5a
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group

works for me, if not agree you can reopen as unconfirmed
Comment 4 Mike Kaganski 2018-05-21 18:17:37 UTC
Reproducible with Version: 6.1.0.0.alpha1+ (x64)
Build ID: db04be037b611e296ef9f2542322c52ed82d7a2b
CPU threads: 12; OS: Windows 10.0; UI render: GL; 
Locale: ru-RU (ru_RU); Calc: CL

STR:

1. Create a new empty spreadsheet
2. Put a number into A1 (e.g., 1)
3. Apply manual formatting to A1: e.g., Number format: 0 decimals; Font: Liberation Mono size 20; Font color: Indigo; Horizontal alignment: Left; Background: Orange.
4. Apply conditional formatting to A1: e.g., Condition: cell value greater than 0 => New style: Number formatting: Currency; Font: Liberation Serif size 8; Font color: Red; Horizontal alignment: Center; Background: Light Lime 4.

Actual result: every setting from Conditional formatting had overwritten the manual settings - *except for number formatting*, which is still Number 0 decimals, not Currency.
Comment 5 Eike Rathke 2018-05-22 10:04:13 UTC
If this is the case then the actual bug is that all other formatting is overridden by the conditional format. Hard cell format attributes should override conditional formatting.