To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=106916
User regina changed the following:
What |Old value |New value
================================================================================
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |WORKSFORME
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Sat Nov 14 22:45:55
+0000 2009 -------
The data in row B are relative references and they are treated as such. It
becomes easier to understand, if you write the references in the R1C1 form. Then
the pairs are:
Ref Data
R(2)C(2) 7
R(4)C(2) 5
R(1)C(2) 1
R(1)C(2) 3
R(-3)C(2) 4
R(2)C(2) 2
R(-6)C(2) 8
R(-1)C(2) 6
After sorting you get:
R(1)C(2) 1
R(2)C(2) 2
R(1)C(2) 3
R(-3)C(2) 4
R(4)C(2) 5
R(-1)C(2) 6
R(2)C(2) 7
R(-6)C(2) 8
This gives the values as you see them.
I guess, that you try to make a database table in Calc with a foreign key to
itself. If so, you should consider to use Base instead of Calc.
If you will use the sheet as a data base table, you must mimic the behavior of a
data base engine in Calc. And that means here, that you never sort or move the
data records itself, but only view the data in a sorted way. Use a different
sheet which shows the data via =$Sheet1.B2 etc. and this sheet you can sort.
---------------------------------------------------------------------
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]
