https://bugs.documentfoundation.org/show_bug.cgi?id=96741
--- Comment #3 from [email protected] --- If you enter in a regular cell a formula you can type elements of the formula an add cell ranges with mouse selection (and typing again, and selecting again, and ...), all mixed up. Including a matrix formula. Which can be used also (with typing the ranges) in Validity: Cell range: IF(B1:B10="a";C1:C10;"") ... list with values in C where value in B="a" Instead of "a" you can also use a cell reference (D1) which can hold the selection of a (first) list. On which the contents of the second list then depends! or IF((A1:A10>4)*((B1:B10="a")+(B1:B10=D$1));C1:C10) or a special formula for a number range Maximum value: MAX(A1:A10;C1:C10;E1:E10) or an other (even much more complex) formula in a prospective new custom validity https://bugs.documentfoundation.org/show_bug.cgi?id=96698 -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
