Working with a formula in Calc: Data => Validity is a very powerful option. (Especially a matrix-formula for a custom cell-range. Very good!) But entering could be a pain. A formula could be used in each condition (Whole number, Decimal, ...), but the used cell ranges must be typed! Mouse-selection as in a regular formula (or in Excel: Validity => all conditions) does only work in condition "Cell range". And in "Cell range" it does not work with a mix of typing and mouse-selection. Using mouse-selection overwrites everything typed before. (In Excel you can mix it as you like.) With only one cell range in the formula the problem could be resolved by mouse-selection first and building the formula around the taken cell range. But with 2 or more needed cell ranges in the formula ... Using names and "Insert => Names => Insert" does not help, because LibreOffice does not allow this function while "Data => Validity" dialog is open. (In Excel it is possible.) So please: 1.) Make available cell ranges by Mouse-selection in ALL conditions of Validity 2.) The mouse-selection(s) should work in a custom mix with typing (as in a regular formula) 3.) Make available "Insert => Names => Insert" in Validity
Ok, I'm changing this to be about 1). You should create separate reports for 2) and 3) and then comment here the numbers and I will confirm them. Adding needsDevEval keyword, so devs can evaluate this for an easy hack.
2.) The mouse-selection(s) should work in a custom mix with typing (as in a regular formula) new in: https://bugs.documentfoundation.org/show_bug.cgi?id=96741 3.) Make available "Insert => Names => Insert" in Validity new in: https://bugs.documentfoundation.org/show_bug.cgi?id=96743
Bug is still present. No changes in bug behavior. Testsystem: LO 5.2.3.3 on Windows Vista