| Summary: | Conditional formatting: Usability improvements for the cell range picker in new conditional formatting dialog | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Gerry <gerry.treppel> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | NEW --- | ||
| Severity: | enhancement | CC: | jmadero.dev, jorendc, markus.mohrhard, mgb1508 |
| Priority: | medium | ||
| Version: | 4.0.0.1 rc | ||
| Hardware: | Other | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 116222 | ||
@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 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: (a) 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. (b) 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 4.0.0.1 (Build ID: 527dba6f6e0cfbbc71bd6e7b88a52699bb48799)