Issue 110692 - Sheet lost in incorporated Calc OLE
Summary: Sheet lost in incorporated Calc OLE
Alias: None
Product: Writer
Classification: Application
Component: save-export (show other issues)
Version: OOo 3.2
Hardware: PC Windows, all
: P2 Trivial (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@sw
Keywords: oooqa
: 110256 112481 (view as issue list)
Depends on:
Blocks: 109046
  Show dependency tree
Reported: 2010-04-08 10:32 UTC by vitriol
Modified: 2017-05-20 11:41 UTC (History)
3 users (show)

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

Test bugdoc (13.66 KB, text/plain)
2010-04-08 10:33 UTC, vitriol
no flags Details
mangled file (14.39 KB, application/vnd.oasis.opendocument.text)
2010-07-19 19:52 UTC, delgarot
no flags Details
unaffected file (84.68 KB, application/vnd.oasis.opendocument.text)
2010-07-19 19:53 UTC, delgarot
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description vitriol 2010-04-08 10:32:42 UTC
Severe bug found in OOo 3.2. Data loss.
Steps to reproduce:
- Open the attached OLEbug.odt in Writer.
- Double click on OLE object to modify.
- Write something into a cell. For example d in A4 on Sheet1. The object has 2
- Click over the OLE object to leave the edit mode, and quickly save the document.
- Reopen the document, and double click on the OLE.
- BUG: Sheet2 is lost.

It's non 100% reproducible, but verified by many users. Maybe it depends on the
speed of execution.

Thank you for your attention.
Comment 1 vitriol 2010-04-08 10:33:26 UTC
Created attachment 68818 [details]
Test bugdoc
Comment 2 vitriol 2010-04-08 11:01:57 UTC
The step 4 is "Click outside the OLE object" not "over"...
Comment 3 Rainer Bielefeld 2010-04-08 12:43:03 UTC
100% Reproducible with "OLEbug.odt" and "Ooo-Dev 3.2.1 multilingual version
English UI WIN XP: [OOO300m14 (Build 9489)]"! It does not matter how I save and
close the document, second sheet always was lost when I reopened closed document.

NOT reproducible with "OLEbug.odt" and "Ooo 3.1.1 WIN XP DE[OOO310m19 (Build

I failed to create my own sample document. Only reproducible with clones of

Can you please contribute a step by step instruction how to create an won sample
Comment 4 vitriol 2010-04-08 12:55:51 UTC

- Create a document in Calc with two sheets, and save as ODS.
- Insert the Calc document into Writer with Insert > Object > Ole object... >
Create from file. The option "Link to file" must be unchecked.
- Save Writer document as ODT.
- Delete the original Calc ODS document.
Comment 5 Rainer Bielefeld 2010-04-08 13:14:16 UTC
Before I saved a writer document, I increased size of OLE spreadsheet after
doubleclick, changed from to sheet 2 to sheet 1, iserted A-c into 'A1' ... 'A3',
clicked into writer document area, closed saved with name, reopened (without
deleting CALC document) and second sheet was lost.

I used WIN dialogs, I did not test whether problem also appears with OOo dialogs.
Comment 6 jbf.faure 2010-04-09 05:00:50 UTC
Add me to cc.
Comment 7 uwe.luebbers 2010-04-09 11:25:32 UTC
Adjusted target
Comment 8 uwe.luebbers 2010-04-09 11:29:20 UTC
Assigned issue
Comment 9 niklas.nebel 2010-04-09 13:54:33 UTC
Fixed in CWS "calc321stopper2".
Comment 10 niklas.nebel 2010-04-09 16:06:02 UTC
Reassigning to QA for verification
Comment 11 kla 2010-04-13 12:21:33 UTC
Seen ok in CWS calc321stopper2 -> verified
Comment 12 michael.ruess 2010-04-19 13:44:22 UTC
*** Issue 110256 has been marked as a duplicate of this issue. ***
Comment 13 michael.ruess 2010-06-18 07:23:42 UTC
*** Issue 112481 has been marked as a duplicate of this issue. ***
Comment 14 Oliver Brinzing 2010-06-18 11:53:49 UTC
Comment 15 delgarot 2010-07-19 19:50:28 UTC
OOo v 3.2.1 on Windows 7 Home Premium

It looks like this bug may have eaten several hours of my homework.
I will attach both the eaten assignment, and the previous assignment that was not 
affected.  I notice that when opening the odt files as zip, the undamaged file has 
object folders, while the damaged file is missing those folders.
What can I do to not reproduce this bug on my subsequent homework assignments?
Comment 16 delgarot 2010-07-19 19:52:12 UTC
Created attachment 70691 [details]
mangled file
Comment 17 delgarot 2010-07-19 19:53:07 UTC
Created attachment 70692 [details]
unaffected file