https://bugs.documentfoundation.org/show_bug.cgi?id=117715
Bug ID: 117715
Summary: Unlike other settings, Number Format in a conditional
formatting style doesn't apply if a cell has a number
format applied by direct formatting
Product: LibreOffice
Version: 6.0.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: 79045_79...@mail.ru
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
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs