Références perdues lors d'un formatage conditionnel

To comment on the following update, log in, then open the
issue:
http://www.openoffice.org/issues/show_bug.cgi?id=82133

                 Issue #|82133
                 Summary|Références perdues lors d'un
formatage conditionnel
               Component|Spreadsheet
                 VersionOo 2.3
                Platform|All
                     URL|
              OS/Version|All
                  Status|UNCONFIRMED
       Status whiteboard|
                Keywords|
              Resolution|
              Issue type|DEFECT
                Priority|P3
            Subcomponent|formatting
             Assigned to|spreadsheet
             Reported by|thierryguilbert





------- Additional comments from thierryguilbertopenoffice.org Mon Oct  1 09:46:59 +0000 2007
-------
Bonjour,

Voici les manipulations à faire pour générer une erreur
comportementale :
- Sélectionnez un bloc de cellules de HAUT en BAS par
exemple : b3:e13
- appliquez un format condionnel, par exemple : choisir
"Formule est", et saisir
dans le champ formule : "$f3>=$f$13" /style
"fondVert". Validez.

Le formatage ne marche pas ! 

Pourquoi ?
Parce que si vous regardez par exemple la formule
conditionnelle dans la cellule
b3, vous verrez que Calc à générer une référence de
type $F#REF !>=$F$13

Merci

------------------------------------------------------------
---------
Please do not reply to this automatically generated
notification from
Issue Tracker. Please log onto the website and enter your
comments.
http://qa.openoffice.org/issue_handling/
project_issues.html#notification

------------------------------------------------------------
---------
To unsubscribe, e-mail: issues-unsubscribesc.openoffice.org
For additional commands, e-mail: issues-helpsc.openoffice.org

To comment on the following update, log in, then open the
issue:
http://www.openoffice.org/issues/show_bug.cgi?id=82133






------- Additional comments from fstopenoffice.org Mon Oct  1
10:08:29 +0000 2007 -------
Hi,

as this bugtracking system is used worldwide, the decission
was made to
communicate in English.

Please translate your Issue to English.

Frank

------------------------------------------------------------
---------
Please do not reply to this automatically generated
notification from
Issue Tracker. Please log onto the website and enter your
comments.
http://qa.openoffice.org/issue_handling/
project_issues.html#notification

------------------------------------------------------------
---------
To unsubscribe, e-mail: issues-unsubscribesc.openoffice.org
For additional commands, e-mail: issues-helpsc.openoffice.org

To comment on the following update, log in, then open the
issue:
http://www.openoffice.org/issues/show_bug.cgi?id=82133



User thierryguilbert changed the following:

                What    ld value 
               |New value
============================================================
====================
                 Summary|Références perdues lors
|conditional formating : un
                        |d'un formatage conditionne|known
references
                        |l                         |
------------------------------------------------------------
--------------------




------- Additional comments from thierryguilbertopenoffice.org Mon Oct  1 15:39:20 +0000 2007
-------
Sorry for my bad english !

My objective was to apply a green background into cells with
a conditional 
format.

Here are the steps to reproduce unknown references from Calc
:
- Select a bloc of cells from up to down : for example
b3:e11
- Make a conditional format, for example : choose
"Formula is", and in the 
formula field "$f3>=$f$13" /style
"vert". Validate.

Formatting doesn't work !

Why ?
Because if you look at the conditional format of the cell b3
(for example), 
Calc has translated by a reference of type $F#REF
!>=$F$13

Thanks

------------------------------------------------------------
---------
Please do not reply to this automatically generated
notification from
Issue Tracker. Please log onto the website and enter your
comments.
http://qa.openoffice.org/issue_handling/
project_issues.html#notification

------------------------------------------------------------
---------
To unsubscribe, e-mail: issues-unsubscribesc.openoffice.org
For additional commands, e-mail: issues-helpsc.openoffice.org

To comment on the following update, log in, then open the
issue:
http://www.openoffice.org/issues/show_bug.cgi?id=82133



User regina changed the following:

                What    ld value 
               |New value
============================================================
====================
                      CC|''                       
|'regina'
------------------------------------------------------------
--------------------
                  Status|UNCONFIRMED              
|RESOLVED
------------------------------------------------------------
--------------------
                Keywords|                          |oooqa
------------------------------------------------------------
--------------------
              Resolution|                         
|WORKSFORME
------------------------------------------------------------
--------------------




------- Additional comments from reginaopenoffice.org Mon Oct  1 16:52:19 +0000 2007
-------
You know, that the references in a formula are relative to
the address, where
you use the formula, unless you set a $ to make it absolute.
What happens now?
If you move your mouse down to select b3:b13 the active cell
will be b13. If you
now use the formula $f3>=$f$13 it is relative to b13.
When OOo enters the
formula to the cell b12, that part in the formula, which is
still relative will
be changed. Cell b12 gets the formula $f2>=$f$13 and so
on. Cell b11 gets
formula $f1>=$f$13 and b10 gets formula $f0>=$f$13.
But a row 0 doesn't exist
and you get the #REF! error.

When you enter the formula you must write it in that way,
that it fits to the
active cell.

------------------------------------------------------------
---------
Please do not reply to this automatically generated
notification from
Issue Tracker. Please log onto the website and enter your
comments.
http://qa.openoffice.org/issue_handling/
project_issues.html#notification

------------------------------------------------------------
---------
To unsubscribe, e-mail: issues-unsubscribesc.openoffice.org
For additional commands, e-mail: issues-helpsc.openoffice.org