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: Spreadsheet (show other bugs)
Version: 4.0.0.1 rc
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-01-13 10:15 UTC by Gerry
Modified: 2013-01-15 19:06 UTC (History)
3 users (show)

See Also:
i915 platform:
i915 features:


Attachments

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:

(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)
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


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.