To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=85147
Issue #|85147
Summary|Sort results in #REF fields
Component|Spreadsheet
Version|OOo 2.3.1
Platform|PC
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P2
Subcomponent|editing
Assigned to|spreadsheet
Reported by|joris_dobbelsteen
------- Additional comments from [EMAIL PROTECTED] Thu Jan 10 21:33:25 +0000
2008 -------
A spreadsheet is created with links (using formula's like "=C33"). If these
entries are sorted, they will appear as #REF and the reference to the orignal
cell is lost. (Excel has the correct behaviour). Oddly enough Cut & Paste has
the desired behaviour.
An additional oddity is that not all formula's are invalid. If desired, an
example with the incorrect behaviour can be provided.
The sheet looks like the following, as described here.
For column A, make a sorted list from 1 to 38
For column B, provide the following numbers ("" is for blank cells)
*BEGIN* 10 11 12 "" 6 7 9 "" "" "" "" 8 1 2 3a 3b "" "" "" "" 15 4 5 22 23 21
15 27 26 25 24 14 13 17 20 19 18 17 *END*
For column C, the following references are in place (rownr:formula)
*BEGIN* 24:=C2 25:=C3 26:=C1 27:=C22 28:=C5 29:=C21 &"; " & C22 30:=C18
31:=C20 35:=C10 36:=C9 *END*
Sort values according to column B, ascending.
Rows 19,20,21 will contain =C#REF!
Row 26 contains a cascaded #REF! error.
---------------------------------------------------------------------
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]
