Hello
Thank you for this great job
I comment only some details (no comment = agree)
In the following (x) refers to the same number in your mockup.
*(0) Menu Format> Insert Format Tools>
Conditionnal Formatting... / Manage Cond ...
Unless it is planned to integrate other tools in this menu
I would prefer Format> Conditionnal Formatting > Define ... / Manage ...
like Insert> Names> Define ... / Manage ...
*(1)(2) later conditions defeat earlier conditions
My English is quite limited and I am afraid to be a misunderstanding but I
prefer to check.
I understand that message as: the latter condition verified prevails.
It's actually the opposite: The first condition checked prevails.
This message (The first condition checked prevails) seems more explicit
(considering my poor english).
*(2) Summary
It seems possible to display a summary of the following condition
if exists (condition 3 in the mockup, n+1 actually)
*(2) Condition 1 Summary
Display the range seems unnecessary (already present in the title).
The condition is most important here.
*(2) Expander Labelled Area: Range / Scope
Can we change with the keyboard and mouse (selection in the sheet)?
Can we enter a range name (Insert> Names and Data> Define Range)?
*(Detail of 1)
If the user enter a value Does not enter a value...
For the record, remember:
1. The two areas with BETWEEN and NOT BETWEEN
2. Conditions of type "Formula"
*(4) Conditionnal Formatting Manager
Instead of using a DataGrid control (which displays the first condition
in a column) I would consider it better to use a TreeView control that
would display the tree Sheets> Ranges> Conditions.
It would be useful to enrich the Navigator with an entry
"Formatting Conditionnal" which would list the ranges:
1. double click: selection
2. right click context menu: Edit / Remove
Now some answers to your remarks:
* It's still not possible to add conditions in an arbitrary place in
the list. I consider that a design decision.
If (2) is the state of dialog when define Condition n, click the Add button
should add after the condition n. I do not understand how the proposed design
requires adding at the end of the list.
* One important difference to Excel is that this design does not allow
sort conditions that apply to different ranges.
I do not have Excel for years. Do you mean that our dialog should allow
to define conditions for different ranges at the same time?
I would personally hostile to this possibility for confusion it would create
when several conditions are defined (with "cascade") for the same range.
Sample problem: If you change the range how to reflect the change to all the conditions
already set?
From Monday I will be "offline" for two weeks and I could not answer any questions.
Sorry ...
Regards
Pierre-Yves
Une messagerie gratuite, garantie à vie et des services en plus, ça vous tente ?
Je crée ma boîte mail www.laposte.net
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.