The new conditional formatting dialog is shaping up greatly. A particular improvement is that it is now possible to pick cell ranges in the condition and to enter formulas in the condition field.
With this regard, I have two enhancement requests with regards to usability of the cell range picker:
To enter a formula in all usual spreadsheet operations, you enter e.g. "=sum(" and then you pick the cell range, e.g. C13:C15.
The new conditional formatting dialog behaves differently. In the field for the condition (in the dialog you get from "Format"-"Conditional Formatting"-"Condition") you first need to pick the cell range, e.g. e.g. C13:C15 and then you need to write the formula around, e.g. "sum(C13:C15". In case you enter the formula first, e.g. "sum(", it will be overwritten by the cell range picker. It would be good if the behaviour would be the same like in all other spreadsheet operations.
When typing a formula in usual operations in Calc, e.g. "=s", then you get a tooltip telling you that the syntax for the formula is "=sum()". This tool tip is missing in the conditional formatting dialog. It would be good to have it there, too.
Thanks for the great work on conditional formattining!
System: Ubuntu 12.10, 64-Bit, LibreOffice Version 220.127.116.11 (Build ID: 527dba6f6e0cfbbc71bd6e7b88a52699bb48799)
@Markus: because this is a 'bug' about conditional formatting I add you too CC
marking as NEW (valid request).
Markus can decide if and which one we'll implement and if neither he can close as WONTFIX.
@Gerry - thanks for helping us make LibreOffice better, these enhancement requests and your bug reports help a ton
The part about the replacing of the string has been implemented as part of Bug 58635.
The other part requires a complete redesign of our formula suggestion handling so I doubt that it will be implemented any time soon.