OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Linking from Writer to Multiple Sheets in Calc

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Writer
View previous topic :: View next topic  
Author Message
jarthurmiller
General User
General User


Joined: 27 Aug 2003
Posts: 25
Location: Missouri

PostPosted: Fri Feb 24, 2006 3:23 pm    Post subject: Linking from Writer to Multiple Sheets in Calc Reply with quote

I've searched the archives but was unable to find any discussion on this issue.

I have a Calc workbook that has 4 sheets. I've named each of the sheets. I would like to insert 4 OLE links in my Writer document, one link to each of the Calc sheets.

In Writer, I went to the Insert...Object...OLE Object menu and inserted the path to the Calc spreadsheet. I did this 4 times, but the same sheet appeared in each object. I double clicked on each of the objects, selected the next "sheet tab," and exited the object. I was able to save the document and "keep" each Calc sheet in its respective Writer object. However, when I closed the Writer document and re-opened it, the 4 objects showed the same sheet. No longer did each object contain a "view" of the sheet I selected.

Does anyone have any ideas on how to do what I need to do?

Thanks,

John Miller
Back to top
View user's profile Send private message
mi_so
Newbie
Newbie


Joined: 31 Mar 2006
Posts: 1

PostPosted: Fri Mar 31, 2006 5:35 am    Post subject: Re: Linking from Writer to Multiple Sheets in Calc Reply with quote

jarthurmiller wrote:
I've searched the archives but was unable to find any discussion on this issue.

I have a Calc workbook that has 4 sheets. I've named each of the sheets. I would like to insert 4 OLE links in my Writer document, one link to each of the Calc sheets.

John Miller


I've exactly the same problem. Solution of this problem is very required.
I thing that this could be a bug.

Another way to do this is using DDE links, but without formats.

Mirek Sobczak
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Writer All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group