Apache OpenOffice (AOO) Bugzilla – Issue 110256
Formula in Calc OLE breaks that object
Last modified: 2010-04-19 13:44:43 UTC
Hello, 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? Thanks
Please attach a sample document
Created attachment 68466 [details] Sample Document
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?
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 tomorrow. I that helps a little bit. Thanks
Hello again, today I did the promised test by installing OOo320 on a machine which had never seen OpenOffice.org 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.
Created attachment 68513 [details] corrupted sample document
No, sorry. Cannot get information from this under which conditions this problem may occur.
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 ***
Closing duplicate.