https://bugs.documentfoundation.org/show_bug.cgi?id=157657
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #1 from Mike Kaganski <[email protected]> --- 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. 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. -- You are receiving this mail because: You are the assignee for the bug.
