Date: prev next · Thread: first prev next last
March 2012 Archives by date, by thread · List index


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.