Created attachment 63594 [details] Original ODT file LibO 3.5.3.2, Ubuntu Linux amd64 The attached .odt file contains 2 embedded spreadsheets. 1) Saving the file, as .docx, Windows Office 2010 fails to display the objects (they are simply gone) 2) Saving the .odt as .doc it opens just fine in Office 2010, showing the tables as "Excel 97" objects. 3) Opening the .odt directly in WinWord simply displays a struck out box (big fat red cross) where the table object would be. Not sure, if we fail to produce valid .docx, or if WinWord fails here....
Created attachment 63595 [details] Saved by LibO 3.5.3.2, objects are lost in WinWord
Created attachment 63596 [details] Saved by LibO 3.5.3.2, objects are fine in WinWord 2010
(In reply to comment #1) > Created attachment 63595 [details] > Saved by LibO 3.5.3.2, objects are lost in WinWord Notice how the saved .docx shrinks in size (41k vs 6k vs 34k), compared to both the original .odt and the saved .doc file. So it seems, the objects are really not included in the save-as-docx file.
I can confirm that saving the original .odt as .docx under LibO 3.5.4.2 also leads to the embedded objects missing in the saved file.
Another update, the embedded tables are missing in the .docx file even, when saving them with current Master (Version 3.7.0.0.alpha0+ (Build ID: 616ad0b))
This bug is about failure to save embedded spreadsheets/charts in the .docx file (object physically missing from the file). Related(?) to this, might be a failure to load them if saved by Excel/WinWord filed in bug 46546.
setting back version to 3.5.3 (see rules about version field) and confirming (on 3.5.5~rc2 linux)
[Reproducible] with reporter's and own sample and "LibreOffice 3.5.5.3. German UI/Locale [Build-ID: 7122e39-92ed229-498d286-15e43b4-d70da21] on German WIN7 Home Premium (64bit) All OLE objects except Math Object will be lost after having saved a native .odt as .docx We have several such "loss when save from/as .docx" reports with may be overlapping roots. Still the same with parallel installation of Master "LOdev " 3.7.0.0.alpha0+ - WIN7 Home Premium (64bit) ENGLISH UI [Build ID: 3985521]" (tinderbox: W2008R2@16-minimal_build, pull time 2012-06-24) I did not check where problem started. @Michael: Please set Status to ASSIGNED and add yourself to "Assigned To" if you accept this Bug
Adding Cedric to CC as suggested by mmeeks.
Please raise from Medium and Normal to something higher, this is data loss. Please add an explanation for Importance fields at https://bugs.freedesktop.org/page.cgi?id=fields.html#importance.
OK, I had a look at this, seems for DOCX we never wrote replacement images for OLE object in the past, so this is an issue for master as well. This is something that works in RTF, though. I have a local patch to get this working, I'll try to clean it up soon and get it into master.
Miklos Vajna committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=bd6ae389008e110be62a335dfcd82c655d512e63 fdo#51550 fix DOCX export dataloss on non-math/chart OLE export The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Resolved in master, -3-6 review: https://gerrit.libreoffice.org/1017
Miklos Vajna committed a patch related to this issue. It has been pushed to "libreoffice-3-6": http://cgit.freedesktop.org/libreoffice/core/commit/?id=fc3f771c1f5fed267298c851e94bef9557278b5b&g=libreoffice-3-6 fdo#51550 fix DOCX export dataloss on non-math/chart OLE export It will be available in LibreOffice 3.6.4. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Already [Reproducible] with Server Installation of "LibreOffice 3.3.3 German UI/Locale [OOO330m19 (Build:301) tag libreoffice-3.3.3.1] on German WIN7 Home Premium (64bit)
Still reproducible in master (4.3), AFAIK it was never completely fixed for embedded spreadsheets as originally reported, we only wrote an image preview instead of the sheet. I've been working on the docx exporter to support the roundtrip of embedded sheets in docx documents. In theory, I should have been able to fix this bug with some little modifications, but I got stuck and now I don't have much time for this. Part of the relevant code is at DocxExport::WriteOLEObject, where we fail at getting an input stream to the embedded sheet if the original document is an .odt; fixing that would save the embedded sheet into the exported document. You will need one more thing for Word to detect the object as an embedded sheet: at DocxAttributeOutput::WriteOLE you should check if sProgID is empty, and if it is, you should manually detect the type of the document in the object and set the proper value to that variable. In the case of an embedded .ods, the value would be "Excel.OpenDocumentSpreadsheet.12".
moving to a more modern MAB then =) thanks Jacobo !
Created attachment 98263 [details] Saved by LibO 4.2.3.3, second object lost in LibO retested test case under Win7x64 using 3.5.0 and 4.2.3 final releases in 3.5.0 all the 2 objects were lost after saving as .docx and reloading in LibO now first object persists in 4.2.3 while second is still lost so situation improved but bug not still 100% fixed
4.1.x reached end of life. moving this still reproducible bug to mab4.2 list.
Bug reporter here. I can confirm that the second embedded table is still being completly lost (without replacement image or anything) when saving to .docx. I object to call the first embedded spreadsheet being "fixed" though, it is replaced by a graphic showing the spreadsheet, which is something very different from the embedded spreadsheet.
Created attachment 107154 [details] Saved by LibO 4.3.1.2, both OLE objects saved as images @Sebastian I retested with LibO 4.3.1.2 and recent 4.4.0.0 master now the second table is not lost but, as you correctly pointed out regarding the first one, both OLE objects are converted into images when saved in .docx rather the being embedded in the file like in the source .odt so, another improvement from previous releases, but still not a definitive fix.
I suggest creating two new bug reports to describe the two separate behaviors. As described the original bug was looked at, and something was done. If you're unhappy with what is done, please create a new bug report to point that out. You can put this bug in the SEE area of the new bug reports. Also because there are two different behaviors, it's better to separate the bugs into two reports. Moving back to FIXED. Please don't reopened it.