[Libreoffice-bugs] [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

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=117715

kompilainenn <79045_79...@mail.ru> changed:

   What|Removed |Added

 Blocks||87351


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=87351
[Bug 87351] [META] Conditional formatting bugs and enhancements
-- 
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

[Libreoffice-bugs] [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

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=117715

--- Comment #5 from Eike Rathke  ---
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.

-- 
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

[Libreoffice-bugs] [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

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=117715

Mike Kaganski  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1

--- Comment #4 from Mike Kaganski  ---
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.

-- 
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

[Libreoffice-bugs] [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

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=117715

kompilainenn <79045_79...@mail.ru> changed:

   What|Removed |Added

 Status|RESOLVED|UNCONFIRMED
 Resolution|WORKSFORME  |---

-- 
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

[Libreoffice-bugs] [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

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=117715

Xavier Van Wijmeersch  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 Resolution|--- |WORKSFORME

--- Comment #3 from Xavier Van Wijmeersch  ---
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

-- 
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

[Libreoffice-bugs] [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

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=117715

--- Comment #2 from kompilainenn <79045_79...@mail.ru> ---
Created attachment 142216
  --> https://bugs.documentfoundation.org/attachment.cgi?id=142216=edit
File-example with different results after conditional formatting

-- 
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

[Libreoffice-bugs] [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

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=117715

--- Comment #1 from kompilainenn <79045_79...@mail.ru> ---
Created attachment 142215
  --> https://bugs.documentfoundation.org/attachment.cgi?id=142215=edit
Screenshot with different results after conditional formatting

-- 
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