To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=108147
User rainerbielefeld changed the following:
What |Old value |New value
================================================================================
CC|'' |'rainerbielefeld'
--------------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Keywords| |oooqa
--------------------------------------------------------------------------------
Resolution| |INVALID
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Fri Jan 8
06:28:56 +0000 2010 -------
Reported effect is reproducible with "Ooo 3.2.0 RC1 WIN XP DE-multilingual
version German UI activated [OOo320m8 (Build 9472)]", but I can't see a bug.
Proceeded as reported and step 8 created a new document containing only 1 sheet.
Formula in 'A1' references to not existing "Sheet2", and so it's absolutely
correct that the error message #REF! appears.
Expectation that reference should in new document should reference to source
spreadsheet is not comprehensible and incorrect: If a forumula in
"original.ods#Sheet1.B1" would reference to 'B2' in the same sheet, what can be
expected after the sheet has been copied due to report to a new document?
a) Reference to 'B2' in the same sheet or
b) to 'B2' in souce ocument / source sheet?
Of course I will expect case "a"
I also tried to copy/paste the source sheet into n empte document containig an
(empty) Sheet2. In this case the formula remained and pointed to 'Sheet2.A1' in
the destination document.
So INVALID.
@kwanbis:
Please feel free to reopen this issue if you can contribute really conclusive
arguments for your point of view, but I strongly recommend to discuss that in an
user forum afore.
Please always specify OS and Platform you used for your tests!
---------------------------------------------------------------------
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]
