https://bugs.documentfoundation.org/show_bug.cgi?id=103793
Bug ID: 103793
Summary: FORMATTING: Conditional formatting doesn't respect
category of number-format.
Product: LibreOffice
Version: 5.1.6.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 128591
--> https://bugs.documentfoundation.org/attachment.cgi?id=128591&action=edit
Demo file, created following the descripted steps.
Steps to reproduce:
1. Create a new spreadsheet.
2. Create a new style (e.g. named "asCurrency"). On tab "numbers" choose
"currency" as category. Further choose a background-color.
3. Create a new style (e.g. named "asDate"). On tab "numbers" choose "date" as
category.
4. Open the dialog for conditional formatting for cell A1.
5. Create a condition with the formula $A$2="D" and link it to the style
"asDate".
6. Create a condition with the formula $A$2<>"D" and link it to the style
"asCurrency".
7. Write a date to cell A1 (e.g. 4.3.).
8. Write "D" to cell A2.
Result:
Switching between to the two examined conditions effects the background-color,
but not the numbers->category. It seems impossible to get a currency format
through changing A1 and A2 values in this state. The value is always either
viewed as date or as plain number.
Expected:
The condition NOT "D" in cell A2 should influence A1s format, including its
numbers->category. In this case A1s value should appear as currency (e.g.
42.433,00 € instead of 04.03.2016).
Variant:
Sometimes it's just the other way around so that the date-format won't appear.
Best regards,
Jan
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
