Issue 110256 - Formula in Calc OLE breaks that object
Summary: Formula in Calc OLE breaks that object
Status: CLOSED DUPLICATE of issue 110692
Alias: None
Product: Writer
Classification: Application
Component: save-export (show other issues)
Version: OOO320m12
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: writerneedsconfirm
QA Contact: issues@sw
Keywords: needmoreinfo, oooqa
Depends on:
Reported: 2010-03-19 12:30 UTC by m4f
Modified: 2010-04-19 13:44 UTC (History)
1 user (show)

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

Sample Document (20.01 KB, application/vnd.oasis.opendocument.text)
2010-03-22 10:40 UTC, m4f
no flags Details
corrupted sample document (19.64 KB, application/vnd.oasis.opendocument.text)
2010-03-24 11:27 UTC, m4f
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description m4f 2010-03-19 12:30:56 UTC
we have a problem when saving some of our Writer documents with OO 3.2, which 
were originally created with OO 3.1.
An embedded Calc document gets damaged.
Steps to reproduce: (please excuse if not all Commands are described correct, 
because we use the German Version of OO)

* create a new Writer document with OO 3.1
* click Insert->Object->Ole Object
* select "Table" and "Create new" and click OK
* add a 2nd sheet and type something in as well
* switch to the 1st sheet and add in any cell a formula which references a cell 
of the 2nd sheet
* exit the embedded table
* save and close the document

* now open the document with OO 3.2
* double click the table and modify something (eg enter additional text in an 
empty cell)
* exit the embedded table
* save and close the document

* now re-open the document with OO 3.1 or 3.2 (doesn't matter)
* double click the table: The 2nd sheet is not in there anymore!

How can I avoid this issue?
Comment 1 eric.savary 2010-03-20 18:59:35 UTC
Please attach a sample document
Comment 2 m4f 2010-03-22 10:40:11 UTC
Created attachment 68466 [details]
Sample Document
Comment 3 michael.ruess 2010-03-22 16:14:47 UTC
I cannot reproduce the problem. I tried with the attached and a new document I
created from the scratch. Perhaps a special step is missing in the description?
Comment 4 m4f 2010-03-23 16:59:39 UTC
I use two different PCs where the one with OO320 was upgraded from 311. So on
this computer OO311 components are not available anymore. On the other one I
work with OO311.

I tried modifying the sample document using OO320portable on the PC where OO311
is installed on the harddisk and it works as expected: I can open and modify the
document correctly with both versions without any issue.

Next try was to open and modify the the sample document with OO320portable on a
computer where no OOo was installed before. In this case the OLE gets corrupted.

Next step will be to install OO320 on a fresh WinXP. I will post the result

I that helps a little bit. Thanks
Comment 5 m4f 2010-03-24 11:21:56 UTC
Hello again,

today I did the promised test by installing OOo320 on a machine which had never
seen before in any version.

The result is as I described in my first post: the file gets corrupted when
editing and saving with OOo32!

I will attach a corrupted version of the sample document. Perhaps this can give
you any hints.
Comment 6 m4f 2010-03-24 11:27:09 UTC
Created attachment 68513 [details]
corrupted sample document
Comment 7 michael.ruess 2010-03-24 14:51:00 UTC
No, sorry. Cannot get information from this under which conditions this problem
may occur.
Comment 8 michael.ruess 2010-04-19 13:44:23 UTC
We were now be able to reproduce, it will be handled and fixed for OOo 3.2.1.
See issue 110692.

*** This issue has been marked as a duplicate of 110692 ***
Comment 9 michael.ruess 2010-04-19 13:44:43 UTC
Closing duplicate.