Bug 59316 - Conditional formatting: Usability improvements for the cell range picker in new conditional formatting dialog
Summary: Conditional formatting: Usability improvements for the cell range picker in n...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) rc
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Conditional-Formatting-Editing
  Show dependency treegraph
Reported: 2013-01-13 10:15 UTC by Gerry
Modified: 2023-10-05 12:00 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Gerry 2013-01-13 10:15:41 UTC
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 (Build ID: 527dba6f6e0cfbbc71bd6e7b88a52699bb48799)
Comment 1 Jorendc 2013-01-13 14:04:33 UTC
@Markus: because this is a 'bug' about conditional formatting I add you too CC
Comment 2 Joel Madero 2013-01-15 19:06:41 UTC
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
Comment 3 Markus Mohrhard 2017-04-08 23:25:08 UTC
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.