https://bugs.documentfoundation.org/show_bug.cgi?id=157657
--- Comment #2 from [email protected] --- (In reply to Mike Kaganski from comment #1) > IMO, the data validity must follow the general > Options->Calc->Calculate->Case sensitive. That it doesn't is a bug IMO, but > otherwise, no additional controls are needed. The help message of "Options->Calc->Calculate->Case sensitive" confuses me. It says "Disable case sensitivity for interoperability with Microsoft Excel". It is clear that it is for interoperability with MS Excel, but it's not clear for me which LO features this option applies to. If the data validity follows that option, a further case might be a user don't want the case sensitive for the interoperability with MS Excel, then uncheck that option, then the data validity behavior is changed which may not be expected by the user. Should that help message be updated to be more specific? Or, an additional case sensitive option is required for LO features that is not related to the interoperability with MS Excel. BTW, I'm not familiar with the background, implementation and any consideration about interoperability with MS Excel. So, my thought about the case sensitive may be wrong. Please point out to me if my understanding is not correct. And any workaround is also acceptable for me. :) > FTR: If the validity rule is e.g. List, with the sole entry aBc, then Excel > disallows abc or ABC, but allows aBc; while Calc allows all of these > (irrespective of the case sensitivity global setting). > > If needed that a specific validity rule case sensitivity was different from > the global setting, the validity may use formulas, which may be made case > sensitive e.g. using REGEX with its (?i) flag. One of my cases is using a named cell range to set the data source. How do I use formulas alternatively? The named cell range can increase and reduce dynamically by adding or removing rows from a specific sheet. -- You are receiving this mail because: You are the assignee for the bug.
