https://bugs.documentfoundation.org/show_bug.cgi?id=157657
--- Comment #3 from Eike Rathke <[email protected]> --- The functions and operators affected by case-sensitivity are defined in the ODF OpenFormula standard (ODFF), v1.3 has 3.4 Host-Defined Behaviors, https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html#__RefHeading__1017868_715980110 1.HOST-CASE-SENSITIVE: if true, text comparisons are case-sensitive. This influences the operators =, <>, <, <=, >, and >=, as well as database query functions that use them. Note that the EXACT function is always case-sensitive, regardless of this calculation setting. The database query functions are the D*() functions (DAVERAGE(), DCOUNT(), ...). Note that UI behaviour like Data Validity during input is not defined in the standard (and shouldn't). If it makes sense we can let it follow the option or implement even something different. If case-sensitivity is enabled it makes sense to allow only strictly matching input, but if Excel restricts validity also for case-insensitivity we may need something else. (In reply to qcxhome from comment #2) > 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. Use Validity Criteria, Allow: Either Custom, and in Formula enter a formula that evaluates to either TRUE (<>0, good input) or FALSE (=0, bad input). Or Cell range, and in Source enter a formula that returns an area or array. References used in such formulas are adjusted the same as in other formula expressions and named ranges and expressions. See also https://help.libreoffice.org/7.6/en-GB/text/scalc/01/12120100.html?&DbPAR=CALC&System=UNIX For further questions about details and possible solutions please use https://ask.libreoffice.org/ and not this bug tracker; you may link back the question here so others can follow, thanks. -- You are receiving this mail because: You are the assignee for the bug.
