How to move/copy sheets to new workbook ...

r_vinoya

In excel, when I move/copy a sheet to a new workbook, the links that I have created in that sheet would automatically be referenced to the source workbook.

In open office, the links that I made would become #REF!

ex. workbook1 has 3 sheets named sheet1, sheet2, and sheet3. In sheet1 of workbook1 there is a link to sheet3 (Cells A1 of sheet1 has this formula: =sheet3.A1)
sheet3 A1 has a value of 23, so sheet1 A1 would return 23.
But when I copy sheet1 to new workbook, workbook2, the sheet1 A1 would return #REF!

Is there any solution to this problem?
_________________
# : - )

SergeM · Posted: Wed Dec 03, 2003 11:52 pm Post subject:

try with =$sheet3.$A$1 instead of =sheet3.A1
_________________
Linux & Windows OOo3.0
UNO & C++ : WIKI
http://wiki.services.openoffice.org/wiki/Using_Cpp_with_the_OOo_SDK
In French
http://wiki.services.openoffice.org/wiki/Documentation/FR/Cpp_Guide

r_vinoya · Posted: Fri Dec 05, 2003 12:08 am Post subject:

I tried your solution :

dfrench · Posted: Fri Dec 05, 2003 8:26 pm Post subject:

This looks like a bug to me. I have seen a few references to this type of behaviour in the issuezilla (goto www.openoffice.org to see this)
Even if you make the reference absolute like this " ='file:///C:/My Documents/temp10.sxc'#$Sheet3.B1" in the source document, moving the sheet to a new workbook does not work correctly.

r_vinoya · Posted: Fri Dec 05, 2003 10:38 pm Post subject:

I see...So there is now way to use that function. Thanks
_________________
# : - )