Issue 64202 - Spreadsheet inserted as OLE object resets viewed sheet when doing Update All
Summary: Spreadsheet inserted as OLE object resets viewed sheet when doing Update All
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 2.0.2
Hardware: PC Windows XP
: P3 Trivial with 6 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
: 72153 103057 104848 107129 107783 117462 (view as issue list)
Depends on:
Blocks:
 
Reported: 2006-04-10 12:17 UTC by jfvelezserrano
Modified: 2017-05-20 11:11 UTC (History)
7 users (show)

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

Attachments
ODT document and linked spreadsheet (open with out update links) (10.71 KB, application/vnd.oasis.opendocument.text)
2006-04-10 12:28 UTC, jfvelezserrano 		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 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".