[Libreoffice-bugs] [Bug 95829] Conditional formatting insists on lowercase input for uppercase words

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95829

--- Comment #1 from Alexander van Loon  ---
Created attachment 120550
  --> https://bugs.documentfoundation.org/attachment.cgi?id=120550=edit
PDF document of the former ODS document to show the result I get

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

[Libreoffice-bugs] [Bug 95829] Conditional formatting insists on lowercase input for uppercase words

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95829

m.a.riosv  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 CC||miguelangelrv@libreoffice.o
   ||rg
 Resolution|--- |NOTABUG

--- Comment #2 from m.a.riosv  ---
Hi @Alesander,

columns C and E have text values no boolean values.

In the CF for column C you have 'No' with single quotes, they have no special
meaning for calc, quotes are part of the text. enter "No" an it works.

Conditional format is case insensitive. You can get a case sensitive use if
instead "Cell value..." select "Formula is.." E1="No" for condition of E1:E13,
if you set up Menu/Tools/Options/LibreOffice calc/Calculate - Case sensitive.

If don't want case sensitive without depends on the option, use with "Formula
is.." EXACT(E1;"No").

But I think there is not a bug, please if you are not agree reopen it.

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