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

          Priority: medium
            Bug ID: 58429
          Assignee: [email protected]
           Summary: "Contains" Conditional Formatting w/ Text Incorrect
                    Behavior
          Severity: normal
    Classification: Unclassified
                OS: All
          Reporter: [email protected]
          Hardware: All
            Status: UNCONFIRMED
           Version: 4.0.0.0.beta1
         Component: Spreadsheet
           Product: LibreOffice

Created attachment 71686
  --> https://bugs.freedesktop.org/attachment.cgi?id=71686&action=edit
Displays Behavior

LibO: Version 4.1.0.0.alpha0+ verified on 4.0 Beta1

The new "contains" feature for conditional formatting doesn't behave as
expected unless you add quotes. If you add a conditional format without the
quotes, no cells are triggers as "meeting criteria" which is incorrect, but if
you add quotes around the text the behavior is correct.

Another point is that if you go back in to edit your conditional format you can
see that the previously entered word without quotes now have single
apostorophe's ('WORD'), this should probably be "WORD" and the problem would be
resolved.

Example document, column A shows conditional formatting without quotes behaving
incorrectly, column B shows with quotes and working as expected.

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