Issue 72153 - Calc sheet mixed in OLE linked files
Summary: Calc sheet mixed in OLE linked files
Status: CLOSED DUPLICATE of issue 64202
Alias: None
Product: Writer
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0.4
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: michael.ruess
QA Contact: issues@sw
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-11-30 17:41 UTC by tial
Modified: 2006-12-01 16:43 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Exemple calc sheets (5.55 KB, application/vnd.oasis.opendocument.spreadsheet)
2006-11-30 17:42 UTC, tial 		no flags Details
The text document with OLE to data1 sheets (8.54 KB, application/vnd.oasis.opendocument.text)
2006-11-30 17:43 UTC, tial 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description tial 2006-11-30 17:41:35 UTC 
In writer, trying to link an calc file.

Steps :

1/ Create a calc document with 2 sheets, fill some datas
2/ Create a new writer document
3/ Insert / OLE / From file -> select your file and check Linked
4/ In the new box created, double click to open the OLE Calc, chose one of the sheet
5/ repeat 3 & 4, but select the other sheet
6/ save file

At opening, you will ALWAYS see same sheet in the 2 boxes, and this is the last
sheet you selected when editing your writer document.
Comment 1 tial 2006-11-30 17:42:46 UTC 
Created attachment 41021 [details]
Exemple calc sheets
Comment 2 tial 2006-11-30 17:43:34 UTC 
Created attachment 41022 [details]
The text document with OLE to data1 sheets
Comment 3 michael.ruess 2006-12-01 10:35:55 UTC 
Problem is, that it is a link to the Calc file. The last viewed (active) sheet
is saved in the source file.
Only when NOT updating the links on re-opening the Writer document, the old view
of the linked OLE objects will be restored.
Comment 4 michael.ruess 2006-12-01 10:38:26 UTC 
Closed.
Comment 5 tial 2006-12-01 14:59:57 UTC 
I aggre that if you didnt update your links, sheets stay the same.

I cannot understand how is that OLE is working  ;

If I want to add a linked OLE object, this is because I need to have an updated
witer document while someone updates the numbers in the calc sheet.

In short, if I put linked OLE sheets, I's because I need to have an updated
datas from that OLE source :)

While rearching in the issue tracker to retrive my own bug, I've missed the next
one when I added my issue :

Issue 64202 
http://qa.openoffice.org/issues/show_bug.cgi?id=64202

As I can read, mine is a DUP :(
Comment 6 michael.ruess 2006-12-01 16:41:26 UTC 
That's righ, this on is a dup to issue 64202.
Nevertheless, I am sure, that this won't be fixable. As you already mentioned, a
link is for having updated number. But also the last view of the linked document
is stored in the file. So everytime, someone changes the viewed sheet source
document (and this is also the case when you double click the linked objet) it
is stored in the file and will be part of the object's update process.
The container document does not know about the type of the object (if its
spreadsheet or drawing or formula etc...), thus the last view cannot be
controlled by it.

*** This issue has been marked as a duplicate of 64202 ***
Comment 7 michael.ruess 2006-12-01 16:43:25 UTC 
Closed.