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


Hello

A great and beautiful work has been done, thank you for that. 
I hope my poor English will not betray my goal which is trying to improve 
this feature. I would like to continue to discuss it constructively...

My message will be a bit long because it is necessary to detail the steps, 
sorry for that...

In  (comment # 26) Michael says
"The relative reference is expressed consistently with reference to the top 
left hand corner of the range you're currently inside"

I agree with Michael on: "The idea of a special case for when a cell is
selected 
inside the range is (IMHO) not at all intuitive there."

I agree when we use Format> CF> Manage. 

I agree for cells "in the range".

But I do not agree when you use Format> CF> CF and when the current cell 
is the "last" of the range because it is a selection mode very common .

Steps to reproduce (tested with Version 3.6.4.0+ (Build ID: a010c4e)):

1. File> New> Spreadsheet
2. Type a, b, c, d respectively A1, A2, A3, A4
3. Select A4:A1

Note:
- After entering "d"  A5 is selected and a "common" way to select A1:A4 is
the 
mouse starting A4 to A1. Why I said in step 3 "select A4:A1"
- After step 3 A1:A4 is selected and the current cell is A4

4. Format> CF> CF> Add, condition: "formula is" B4 = 1, Apply style: Result

The reference is relative. So we want to test the cell one column to the
right, same row.

* This is the intuitive functionning in current versions*

5. Keep the selected range and redo Format> CF> CF
The formula is now displayed B7 = 1

I think it introduces a non-homogeneously managing of relatives references.
I do not see others dialogs doing this...

Further tests show other problem:

6. Delete (click on Remove)
7. Click Add, condition: "formula is" B4 = 1 Apply style: Result, Ok
8. Keep the selected range and redo Format> CF> CF
The formula was kept and correctly (in my opinion) spread:
Format> CF> Manage displays correctly for A1: A4 Form B1 = 1

This is my expected result, It would be great if we got directly :)

Thank you for reading this far ...
Regards
Pierre-Yves






--
View this message in context: 
http://nabble.documentfoundation.org/Libreoffice-ux-advise-LO-3-6-2-about-Manage-dialog-from-Conditional-Formatting-tp4009133p4013198.html
Sent from the UX-Advise mailing list archive at Nabble.com.

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.