https://bugs.freedesktop.org/show_bug.cgi?id=80260
Priority: medium
Bug ID: 80260
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: Conditional formatting in spreadsheets doesn't work
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: lachlan...@gmail.com
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.3.0.0.beta2
Component: Spreadsheet
Product: LibreOffice
Created attachment 101391
--> https://bugs.freedesktop.org/attachment.cgi?id=101391&action=edit
Document that doesn't work
Check out this document.
I am trying to highlight y/Y green then mark everything else red. the
conditional formatting doesn't work in any way, values are formatted
incorrectly no matter what i try
I have tried equals/not, contains/not, begins with Y/begins with N.
in the current document i'm using equals/not. I have half formatted general and
half formatted text
- all the blank cells going green.
- no matter what value I enter it's always red.
- in some versions a 0 will go green like it's expecting a true/false formula
- I have also had the correct value have no colour but i'm not sure how that
happened
I'm not trying to recreate the wheel here it should be green or red. why is
this happening?
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
