Issue 64202

Summary: Spreadsheet inserted as OLE object resets viewed sheet when doing Update All
Product: Calc Reporter: jfvelezserrano <jvelez>
Component: uiAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: alex, gibi, issues, lars_o_hansen, manens, rainerbielefeld_ooo_qa, sztejkat
Version: OOo 2.0.2Keywords: oooqa
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
ODT document and linked spreadsheet (open with out update links) none

Description jfvelezserrano 2006-04-10 12:17:54 UTC 
- First you must build a non empty Spreadsheet with 2 pages and save it to disk.
- Then you must create a text document in the wordprocessor.
- Now, you must insert 2 views of the spreadsheet as OLE object from file
(insert/Object/Ole Object from file option).
- You must personalize each view. For example, doing double click in one of the
views in order to select distinct pages in each view.
- After that you must exit formthe ole view clicking on the text document.
- Finally, if you update the links (tools/update/links) the personalization is
gone. The views are identical.
Comment 1 jfvelezserrano 2006-04-10 12:28:00 UTC 
Created attachment 35605 [details]
ODT document and linked spreadsheet (open with out update links)
Comment 2 jfvelezserrano 2006-04-10 12:41:17 UTC 
It is important to insert the the OLE object with the option "linked to file"
active.

In general, any modification to a view to a OLE Object is lost after the update
link action.
Comment 3 lars 2006-04-10 13:12:26 UTC 
I didn't get this to work with Update->Links but with Update->Update All; so 
confirmed with 680_m162 on WinXP Pro SP2
Comment 4 jfvelezserrano 2006-04-10 17:18:45 UTC 
Ok. "Update->Update All" fails.

Update->Links seems to work, but if you single click in a view of a sheet it
resets. 

Also, if you save the document and load it latter, and if you choose "yes" to
the answer "Update links?" they get reset again.
Comment 5 michael.ruess 2006-04-26 10:13:42 UTC 
MRU->OC: when linking to a calc document, I think it is not possible to show two
different views, right? The information about which table will be shown on
opening is stored in the file, right?
Comment 6 jfvelezserrano 2006-05-04 13:54:52 UTC 
It is true. In "others" wordprocessors it is not possible to show two
different views. In this case I think that OpenOffice.org works better than
"others" wordprocessors.

I begin using OLE objects because DDE links don't maintain de format of the text.

Then I must conclude that you can't link several parts of a spreedshet
maintaining the original format. "Other" wordprocessors allow you to do that
with "cut/copy with link".
Comment 7 frank 2006-05-09 14:47:46 UTC 
Hi Niklas,

please have a look at this one and re-assign if needed.

Frank
Comment 8 niklas.nebel 2006-07-14 18:12:44 UTC 
changing target
Comment 9 michael.ruess 2006-12-01 16:41:25 UTC 
*** Issue 72153 has been marked as a duplicate of this issue. ***
Comment 10 bernd_gloss 2007-08-11 10:11:58 UTC 
Found the same problem in OO 2.2.0 (Fedora 7)
Comment 11 bernd_gloss 2007-08-11 10:29:19 UTC 
This seems to me being an Writer bug rather than a Spreadsheet bug, isn't it?
Comment 12 niklas.nebel 2007-12-04 18:07:16 UTC 
retarget 2.x -> 3.x
Comment 13 michael.ruess 2009-06-24 13:46:30 UTC 
*** Issue 103057 has been marked as a duplicate of this issue. ***
Comment 14 michael.ruess 2009-11-23 13:36:49 UTC 
*** Issue 107129 has been marked as a duplicate of this issue. ***
Comment 15 Rainer Bielefeld 2009-12-30 07:54:38 UTC 
*** Issue 107783 has been marked as a duplicate of this issue. ***
Comment 16 gibi 2010-04-19 16:10:50 UTC 
*** Issue 104848 has been marked as a duplicate of this issue. ***
Comment 17 gibi 2010-04-19 16:26:47 UTC 
Confirmed with 3.2.0 Windows XP
But also on Linux X64 with 3.2.0 and OOO320m15 (build:9492) 
So should we change its OS to "All" ?
Comment 18 eric.savary 2011-03-18 18:37:50 UTC 
*** Issue 117462 has been marked as a duplicate of this issue. ***
Comment 19 Marcus 2017-05-20 11:11:33 UTC 
Reset assigne to the default "issues@openoffice.apache.org".