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
Have two duplicate options to select from, each for one of the cases. +1
There are for sure situations where case-sensitivity is relevant as well as the opposite. Changing the default breaks the workflow for other users. I suggest to Format > Text > lowercase first. => WF
The topic was on the agenda of the design meeting. And in fact Excel behaves as expected so we should do the same for being consistent. Example: Alpha alpha aLpha beta Hossein, easy hack?
Taking this one, recently I fixed a similar issue with the UNIQUE formula
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/a7354ccdba7a608f66b98b4e0025a11504d15f11 tdf#166669: make conditional formatting for duplicates case insensitive It will be available in 26.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Xisco Fauli committed a patch related to this issue. It has been pushed to "libreoffice-25-8": https://git.libreoffice.org/core/commit/40c5a2731abc5f17093624b162c2d5280a66c774 tdf#166669: make conditional formatting for duplicates case insensitive It will be available in 25.8.0.0.beta2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.