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