https://bugs.documentfoundation.org/show_bug.cgi?id=166669
Bug ID: 166669
Summary: In LibreOffice Calg Conditional Formatting for
Duplicates should be case insensitive
Product: LibreOffice
Version: 24.8.6.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When using conditional formatting in calc one can chose "Cell Value" is
"Duplicate" which is a very useful tool to find duplicate emails etc in a
column. The problem is that it is case sensitive so e.g. duplicate emails are
not found if one is upper and one is lower case. I can't think of a case where
it would make sense to look for duplicates in a case-sensitive way. It should
by default be case-insensitive or at least both options to choose from.
Steps to Reproduce:
1.column with emails, some duplicate but in upper and lower case
2.Format→Conditional→New Rule→Cell Value is duplicate
3.Conditional formatting will not apply to duplicate emails because case is not
the same
Actual Results:
conditional formatting for duplicates will not apply if e.g. emails are
duplicates and not exactly the same case
Expected Results:
conditional formatting for email duplicates should apply if emails are
duplicates and not exactly the same case. Best would be either conditional
formatting for duplicates should by default be case-insensitive or it should
have one option "is duplicate (case insensitive)" and another option "is
duplicate (case sensitive)"
Reproducible: Always
User Profile Reset: No
Additional Info:
LibreOffice 24.8.6.2, on Ubuntu
--
You are receiving this mail because:
You are the assignee for the bug.
