To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=88018
                 Issue #|88018
                 Summary|wrong cell reference after copying table
               Component|Spreadsheet
                 Version|OOo 2.3.1
                Platform|All
                     URL|
              OS/Version|Linux
                  Status|UNCONFIRMED
       Status whiteboard|
                Keywords|
              Resolution|
              Issue type|DEFECT
                Priority|P3
            Subcomponent|code
             Assigned to|spreadsheet
             Reported by|hillerd





------- Additional comments from [EMAIL PROTECTED] Mon Apr  7 16:24:59 +0000 
2008 -------
see attached ods file:

What I did:
- in "Tabelle1" type "content of B2 in Tabelle1" in cell B2
- in "Tabelle2" type "=Tabelle1.B2" in cell B1
- copy "Tabelle2", which is named "Tabelle2_2"
- found "=Tabelle2.B2" in cell B1, but expected "=Tabelle1.B2"

Further investigations indicate that the formula points to the relative table
position. Here in Tabelle2 the reference was to Tabelle1, which is positioned
directly before Tabelle2. The copy of Tabelle2 (so Tabelle2_2) is also
referenced to Tabelle2, which in this example is placed before it.

To confirm
- copied "Tabelle2" again as last table (so behind Tabelle2_2), named 
"Tabelle2_3"
- found "=Tabelle2_2.B2" in cell B1, so the name of the table before the
insertion point!

PS: I am using native OOo, so not the one provided by Ubuntu!

---------------------------------------------------------------------
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]

Reply via email to