https://bugs.documentfoundation.org/show_bug.cgi?id=159167
--- Comment #17 from Alexander Nolting <[email protected]> --- (In reply to Heiko Tietze from comment #16) > (In reply to Rafael Lima from comment #5) > > AFAIK it is not possible to define a conditional formatting rule where the > > condition is a range. > I wouldn't expect a range for simple comparisons like "is equal to" but when > it comes to "is in top N elements" the situation is less clear. > https://help.libreoffice.org/24.2/en-US/text/scalc/01/05120100.html see below > > > 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. > > 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. I would like to see that this is possible by two reasons: you have found a other cases; here where a range has to be evaluated by a formula. An algorithm running over a range need to be programmed anyway. This would allow more flexibility for users than the example (Excel). It would also more intuitive as at other places "creating and copying" cell formular or selecting and dragging/filling a number of cells in a row or a column is normal for users. > > I'll change the summary accordingly. If you disagree, Alexander, feel free > to revert. I'm fine changing the summary. Getting a timely fix for this is not important. I would rather see more flexibility, because I perform such cell comparisons frequently and selecting several cells to compare and then inserting the formula for them would save me a lot of work. -- You are receiving this mail because: You are the assignee for the bug.
