https://bugs.documentfoundation.org/show_bug.cgi?id=159167
--- Comment #18 from Eike Rathke <[email protected]> --- (In reply to Heiko Tietze from comment #16) > (In reply to Rafael Lima from comment #5) > > It has to be either a single cell or the result of a formula. > Using MIN(A$1:A$2) as suggested in comment 3 works well. The issue was that > "$Tabelle1.$A$2:$E$2" is not a formula; less than a range does not compute. Nitpick: $Tabelle1.$A$2:$E$2 _is_ a formula consisting of just one range reference that if not used in array context produces the implicit intersection of the range and the current formula position, resulting in either one cell or its value, or an error value if a unique intersection is not possible. I.e. if entered on any other row than row 2 between columns A and E (even on a different sheet) results in a value, entered anywhere else (on row 2 or behind column E) it results in error. > Nevertheless I agree with room for improvement. If a function does not > return a simple value like A1:A2 or MIN() without parameter, it should > trigger a warning and not become accepted. This would boil down to not accepting an expression that yields an error value, except #N/A error maybe that is a valid result of lookup functions. -- You are receiving this mail because: You are the assignee for the bug.
