To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=69078
User rainerbielefeld changed the following:
What |Old value |New value
================================================================================
Keywords| |needhelp, oooqa
--------------------------------------------------------------------------------
Summary|sorting data with formula |relative references are ad
|refering to other data |apted when sorting data ro
| |ws
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Wed Aug 30 01:49:24 -0700
2006 -------
That's really unexpected.
Facts for first:
----------------
I checked with "2.0.2 German version WIN XP: [680m5(Build9011)]" and
"1.1.4 (German) WIN XP: [645m52 (Build 8824)]"
Before you sort, you have
row 30:
A 800 9600 7680000
or original cell formula contents:
A =B2*$D$2 =C2*$D$2 =B30*C30
After sort, you have Row with "A" in row 50:
A 20800 -10400 -216320000
or original cell formula contents
A =B27*$D$2 =C27*$D$2 =B55*C55
That means the value of the cells in the cells of column B ... remains, because
the relative reference will be adapted just so, that in the new line "A" in row
50, to where the contents moves during sort, the relative reference will be the
same as it was for the contents of old line "Z", that during sort moved to row
30.
What's to do
-------------
Of course, that's dangerous. If someone only wants to see the contents of the
rows in an other order, he will destroy the logical connection of the cells in
one row. The word "sort" means, that the contents (=results of calculation with
formulas) of each row will not be changed, only sort order of complete rows
But
----
- It's easy to avoid that by adding a '$' to the formulas so that
'=B2*$D$2' changes to '=B$2*$D$2'
(can also be done easily in 'sample.ods' using regular expressions
- The behaviour that relative row internal references will be
adapted if you move contents is wanted generally. I doubt that
it would be useful to have different behaviour for
- The behaviour that relative references to rows will be adapted if you move
contents
is knwon from "copy / paste" and "fill", so that some users might want
to have the same behaviour for move (but I don't think so)
- Users might be used to the existing behaviour from other software. I checked
with MS WORKS4.5a and saw that the handling is the same as with OOo
My result
---------
I can not decide.
No bug, but may be ENHANCEMENT issue?
I would like to leave behaviour as it is
---------------------------------------------------------------------
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]
