To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=97254
User rainerbielefeld changed the following:
What |Old value |New value
================================================================================
CC|'' |'rainerbielefeld'
--------------------------------------------------------------------------------
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
Keywords| |oooqa
--------------------------------------------------------------------------------
Summary|in conditional format the |Absolute $ references for
|cell value with '$' does n|conditional formatting not
|ot increase after insert | modified if referenced ce
|new row/column |ll moves
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Mon Dec 15
10:17:10 +0000 2008 -------
I checked with "Ooo 3.0.0 (DE) Multilingual version German UI WIN XP: [OOO300m9
(Build9358)]" and can confirm the reported effect. Bug or feature? I can't
decide.
I believe that behaviour for "$-references" (Example: "$F$5")should be:
If a cell with $-reference-formula moves to an other place, the reverence should
stay ("$F$5")
If a referenced cell moves (here: 'F5' moves to 'G6' because a line and a row
have been inserted), all references "$F$5" should be modified to "$G$6".
In 1.1.4 I saw that expected behaviour, but no longer in 2.4
At least we have some inconsistence, as you see in my attached "sample.ods":
Open "sample.ods" and insert a new line before old line 1, all $-references in
column 'E' will be modified from "Line 1" to "Line 1", but formatting reference
in A1 will not be modified.
Conclusion in last sentence of report is wrong.
Dup of Issue 4155?
---------------------------------------------------------------------
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: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
