https://bugs.freedesktop.org/show_bug.cgi?id=58338

          Priority: medium
            Bug ID: 58338
          Assignee: [email protected]
           Summary: FORMATTING: Conditional formatting causes a "clear
                    direct formatting".
          Severity: normal
    Classification: Unclassified
                OS: All
          Reporter: [email protected]
          Hardware: Other
        Whiteboard: BSA
            Status: UNCONFIRMED
           Version: 4.0.0.0.beta1
         Component: Spreadsheet
           Product: LibreOffice

Created attachment 71552
  --> https://bugs.freedesktop.org/attachment.cgi?id=71552&action=edit
Spreadsheet with cell style Date already defined

Hello

Steps to reproduce:

1. Open the attached spreadsheet (CF_Date.ods)
2. Type the current date in A1, next day in B1 (so, if current date is
15/12/12, type 15/12/12 in A1, 16/12/12 in B1)
3. Select  A1:B1, Format> Conditional formatting> Condition> Date is> Today,
Style : Date

Expected result: the content of A1 is the same and  applies cell style Date, B1
no change, no conditional format

Actual result: A1's content transformed in number (formula bar) and applies
cell style Date, B1 loses its format and is displayed as a number

So conditional formatting causes the equivalent of a
"clear direct formatting". 

Note: the exemple is given with "Date is" but same problem with others, for
example:

1. type "AA" in A3
2. align right (ctrl+r)
3. Format> FC> Condition> Cell value is> equal to> "bb", style : Heading

A3 loses the right alignment

Reproduced (fr-discuss)

Regards
Pierre-Yves
Operating System: All

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to