[Solved] Word Doc docx file with embedded spreadsheet

Writing a book, Automating Document Production - Discuss your special needs here
Post Reply
huskerkevin
Posts: 3
Joined: Sun Apr 11, 2021 11:39 pm

[Solved] Word Doc docx file with embedded spreadsheet

Post by huskerkevin »

I have many Word docs (docx) files with embedded spreadsheets (Office 2021 and 2016 created on the lates version of Windows). Spreadsheets are embedded and not linked. File contains several dozen pages. Each page begins with a date, typed at the top, several blank lines, followed by an embedded spread. When I open the docx file in Writer, I can see the date, the curser can moved down several lines, then stops, like writer is "seeing" something. But there are no embedded spreadsheets. What am I doing wrong?
Last edited by MrProgrammer on Fri Jul 23, 2021 4:39 am, edited 1 time in total.
Reason: Tagged ✓ [Solved]
Open Office 4.1.9 on MacOS, Apple OS 11.2.3
User avatar
RusselB
Moderator
Posts: 6599
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Word Doc docx file with embedded spreadsheet

Post by RusselB »

Welcome to the Forums.
it's very possible, even likely, that you are doing nothing wrong. OpenOffice just might not recognize the embedded spreadsheets.
You could try using LibreOffice which has a higher compatibility level with Microsoft's formats than what OpenOffice does. In fact, this would be my first suggestion.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
huskerkevin
Posts: 3
Joined: Sun Apr 11, 2021 11:39 pm

Re: Word Doc docx file with embedded spreadsheet

Post by huskerkevin »

Thanks, RusselB! I'll give it a try.
Open Office 4.1.9 on MacOS, Apple OS 11.2.3
User avatar
Villeroy
Volunteer
Posts: 30799
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Word Doc docx file with embedded spreadsheet

Post by Villeroy »

OLE (object linking and embedding) is a Microsoft technology. The embedded object is opened by whatever application uses the right magic spells in the Windows registry. OpenOffice does not register itself as host for embedded Microsoft douments.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
huskerkevin
Posts: 3
Joined: Sun Apr 11, 2021 11:39 pm

Re: Word Doc docx file with embedded spreadsheet

Post by huskerkevin »

Sadly typical. LbreOffice won't open the embedded spreadsheet either. Looks like I’ll have to send more money to Microsoft.

Thanks to all who commented.
Open Office 4.1.9 on MacOS, Apple OS 11.2.3
User avatar
RusselB
Moderator
Posts: 6599
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Word Doc docx file with embedded spreadsheet

Post by RusselB »

Before sending more money, you might try http://www.zamzar.com to convert the file to an OpenDocument format
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
Lupp
Volunteer
Posts: 3249
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: Word Doc docx file with embedded spreadsheet

Post by Lupp »

huskerkevin wrote:Looks like I’ll have to send more money to Microsoft.
You might better try to get a fix for LibreOffice. There are already related bug (or feature request) reports, but they may be too specialized, badly worded, and/or put aside for unknown reasons.
"Create a way to re-associate an embedded OLE object with an appropriate application available on the opening system." might be a rather clear wording for what's needed.
RusselB wrote:...you might try http://www.zamzar.com to convert the file...
Am I the only one who is suspecting "benevolent" "free" services needing a powerful (costly) background to be baits? If somehing is swaying before my eyes and smells well, I'm looking for the line.

I neither have a "Word" nor an "Excel", and can't create an example for myself.
Could somebody supply such an example for the studies I would like to start.
On Windows 10: LibreOffice 7.2 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
Mountaineer
Posts: 175
Joined: Sun Sep 06, 2020 8:27 am

Re: Word Doc docx file with embedded spreadsheet

Post by Mountaineer »

I try to create an example tomorrow at work.

Usually we only associate file-types to AOO/LO.
Here we have to find out, wich reference is used.
Windows will have it's own system to store this as COM/OLE are quite old techniques. (Wikipedia states some info on related objects is stored in the registry)

And even after a possible edit the result have to be givven back to the calling program, instead of a regular save.

J.
OpenOffice 3.1 on Windows Vista
User avatar
Lupp
Volunteer
Posts: 3249
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: Word Doc docx file with embedded spreadsheet

Post by Lupp »

If it comes to conversion, exporting embedded objects, converting them, and re-inserting them into the converted parent document might be an option. Without being able to study an example, I can't tell if this is as complictated as it sounds. Sometimes the LibO API supports complex tasks well.
On Windows 10: LibreOffice 7.2 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
Mountaineer
Posts: 175
Joined: Sun Sep 06, 2020 8:27 am

Re: Word Doc docx file with embedded spreadsheet

Post by Mountaineer »

I prepared 2 .doc files with Word 2003 running on old Win7
one contains a .xls from Excel 2003 one a .ods of LO 6.0.7.3 - 32 bit

Original Filenames for the Spreadsheets were Mappe1.xls and Map1.ods
I just dragged the closed Spreadsheets via Drag-n-drop from the Explorer in the text.

I can open both file with LO 6.0.7.3 / Writer and the spreadsheet is visible, can be edited with LO Calc for both files,
while Word will call Excel in one case and opens Calc with Navigator in the second case.

J.

PS: I will try the same on Win10 later...
Attachments
TestOLEWord2003.doc
Word2003-File (.doc) contains a Excel Spreadsheet (.xls)
(31.5 KiB) Downloaded 283 times
TestOLEWord2003andCalc.doc
Word2003-File (.doc) contains a Calc Spreadsheet (.ods)
(28.5 KiB) Downloaded 239 times
OpenOffice 3.1 on Windows Vista
User avatar
Villeroy
Volunteer
Posts: 30799
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Word Doc docx file with embedded spreadsheet

Post by Villeroy »

LO 6.0 and 7.1 on Linux open both embedded objects in place when double-clicked.
AOO on Linux opens them in separate Calc windows.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
MrProgrammer
Moderator
Posts: 4413
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Word Doc docx file with embedded spreadsheet

Post by MrProgrammer »

Mountaineer wrote:I prepared 2 .doc files with Word 2003 running on old Win7
The topic concerns DOCX format, not DOC.
Mr. Programmer
AOO 4.1.7 Build 9800 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
Villeroy
Volunteer
Posts: 30799
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Word Doc docx file with embedded spreadsheet

Post by Villeroy »

MrProgrammer wrote:
Mountaineer wrote:I prepared 2 .doc files with Word 2003 running on old Win7
The topic concerns DOCX format, not DOC.
and huskerkevin runs OpenOffice which opens all docx documents read-only anyway. I think that the problem can be solved by installing LibreOffice.

https://www.libreoffice.org/discover/li ... penoffice/
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Mountaineer
Posts: 175
Joined: Sun Sep 06, 2020 8:27 am

Re: Word Doc docx file with embedded spreadsheet

Post by Mountaineer »

MrProgrammer wrote:
Mountaineer wrote:I prepared 2 .doc files with Word 2003 running on old Win7
The topic concerns DOCX format, not DOC.
a bit patience please, when I wasting my time using MS.stuff I barely remember.... :roll:
(I have a archived system on my machine, but I don't have something current.
There I needed to use the machine of one of our last MS-Office-Users....)

Here are 2 docx Files made with MS Office professional 2019 Win 10 - both open without problems in LO Version 6.0.7.3 /32 bit and differ only a bit in how the table was embedded.
Attachments
OLEWordExcelV2.docx
(24.47 KiB) Downloaded 275 times
OLEWordExcel.docx
(24.54 KiB) Downloaded 275 times
OpenOffice 3.1 on Windows Vista
Mountaineer
Posts: 175
Joined: Sun Sep 06, 2020 8:27 am

Re: Word Doc docx file with embedded spreadsheet

Post by Mountaineer »

As huskerkevin works on a Mac there may also be a problem with the OS.
Maybe it is no longer allowed to switch between applications via OLE or it
has to be allowed....

J.
OpenOffice 3.1 on Windows Vista
User avatar
MrProgrammer
Moderator
Posts: 4413
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Word Doc docx file with embedded spreadsheet

Post by MrProgrammer »

huskerkevin wrote:But there are no embedded spreadsheets. What am I doing wrong?
Mac FAQ Q55: Why can't I open the "new" Microsoft formats, DOCX/XLSX/PPTX?
Mountaineer wrote:Here are 2 docx Files made with MS Office professional 2019 Win 10 - both open without problems in LO Version 6.0.7.3 /32 bit and differ only a bit in how the table was embedded.
Thank you for the DOCX attachments, Mountaineer.

I opened OLEWordExcel.docx and OLEWordExcelV2.docx with AOO 4.1.7 on MacOS 10.14.6. Both show the text but not the embedded spreadsheet.

I opened OLEWordExcel.docx and OLEWordExcelV2.docx with Pages, which is a word processor included with MacOS. I'm sure the OP's system has Pages. Both show the text and the embedded spreadsheet. The OP should direct any questions about Pages to an Apple forum.

I opened OLEWordExcel.docx and OLEWordExcelV2.docx with TextEdit, which is a "rich text" processor included with MacOS. I am sure the OP's system has TextEdit. Both show the text but not the embedded spreadsheet. The OP should direct any questions about TextEdit to an Apple forum.

I opened OLEWordExcel.docx and OLEWordExcelV2.docx with Preview, which is a image processor included with MacOS. I am sure the OP's system has Preview. Both show the text and the embedded spreadsheet. The OP should direct any questions about Preview to an Apple forum.

I opened OLEWordExcel.docx and OLEWordExcelV2.docx with QuickLook, which is a file viewer included with MacOS. I am sure the OP's system has QuickLook. Both show the text and the embedded spreadsheet. The OP should direct any questions about QuickLook to an Apple forum.

Both DOCX files contain the embedded spreadsheet in the ZIP archive.
$ zipinfo OLEWordExcel.docx 
Archive:  OLEWordExcel.docx
Zip file size: 25124 bytes, number of entries: 16
-rw----     4.5 fat     1603 b- defS 80-Jan-01 00:00 [Content_Types].xml
-rw----     4.5 fat      590 b- defS 80-Jan-01 00:00 _rels/.rels
-rw----     4.5 fat     1250 b- defS 80-Jan-01 00:00 word/_rels/document.xml.rels
-rw----     4.5 fat    18184 b- defS 80-Jan-01 00:00 word/document.xml
-rw----     4.5 fat     9576 b- stor 80-Jan-01 00:00 word/embeddings/Microsoft_Excel_Worksheet.xlsx
-rw----     4.5 fat     8387 b- defS 80-Jan-01 00:00 word/theme/theme1.xml
-rw----     4.5 fat     4000 b- defS 80-Jan-01 00:00 word/media/image1.emf
-rw----     4.5 fat     2844 b- defS 80-Jan-01 00:00 word/settings.xml
-rw----     4.5 fat     1419 b- defS 80-Jan-01 00:00 word/fontTable.xml
-rw----     4.5 fat      296 b- defS 80-Jan-01 00:00 customXml/_rels/item1.xml.rels
-rw----     4.5 fat      341 b- defS 80-Jan-01 00:00 customXml/itemProps1.xml
-rw----     4.5 fat    29155 b- defS 80-Jan-01 00:00 word/styles.xml
-rw----     4.5 fat      988 b- defS 80-Jan-01 00:00 docProps/app.xml
-rw----     4.5 fat      733 b- defS 80-Jan-01 00:00 docProps/core.xml
-rw----     4.5 fat      655 b- defS 80-Jan-01 00:00 word/webSettings.xml
-rw----     4.5 fat      241 b- defS 80-Jan-01 00:00 customXml/item1.xml
16 files, 80262 bytes uncompressed, 21032 bytes compressed:  73.8%
$ zipinfo OLEWordExcelV2.docx 
Archive:  OLEWordExcelV2.docx
Zip file size: 25061 bytes, number of entries: 16
-rw----     4.5 fat     1603 b- defS 80-Jan-01 00:00 [Content_Types].xml
-rw----     4.5 fat      590 b- defS 80-Jan-01 00:00 _rels/.rels
-rw----     4.5 fat     1250 b- defS 80-Jan-01 00:00 word/_rels/document.xml.rels
-rw----     4.5 fat    18186 b- defS 80-Jan-01 00:00 word/document.xml
-rw----     4.5 fat     9308 b- stor 80-Jan-01 00:00 word/embeddings/Microsoft_Excel_Worksheet.xlsx
-rw----     4.5 fat     8387 b- defS 80-Jan-01 00:00 word/theme/theme1.xml
-rw----     4.5 fat     5444 b- defS 80-Jan-01 00:00 word/media/image1.emf
-rw----     4.5 fat     2865 b- defS 80-Jan-01 00:00 word/settings.xml
-rw----     4.5 fat     1419 b- defS 80-Jan-01 00:00 word/fontTable.xml
-rw----     4.5 fat      296 b- defS 80-Jan-01 00:00 customXml/_rels/item1.xml.rels
-rw----     4.5 fat      341 b- defS 80-Jan-01 00:00 customXml/itemProps1.xml
-rw----     4.5 fat    29155 b- defS 80-Jan-01 00:00 word/styles.xml
-rw----     4.5 fat      988 b- defS 80-Jan-01 00:00 docProps/app.xml
-rw----     4.5 fat      733 b- defS 80-Jan-01 00:00 docProps/core.xml
-rw----     4.5 fat      655 b- defS 80-Jan-01 00:00 word/webSettings.xml
-rw----     4.5 fat      306 b- defS 80-Jan-01 00:00 customXml/item1.xml
16 files, 81526 bytes uncompressed, 20969 bytes compressed:  74.3%
I can extract the spreadsheet with UNZIP. I realize not all OpenOffice users will have the technical skills to do that.
$ unzip -j OLEWordExcel.docx \*.xlsx
Archive:  OLEWordExcel.docx
 extracting: Microsoft_Excel_Worksheet.xlsx  
$ zipinfo Microsoft_Excel_Worksheet.xlsx 
Archive:  Microsoft_Excel_Worksheet.xlsx
Zip file size: 9576 bytes, number of entries: 12
-rw----     4.5 fat     1284 b- defS 80-Jan-01 00:00 [Content_Types].xml
-rw----     4.5 fat      588 b- defS 80-Jan-01 00:00 _rels/.rels
-rw----     4.5 fat      698 b- defS 80-Jan-01 00:00 xl/_rels/workbook.xml.rels
-rw----     4.5 fat     1518 b- defS 80-Jan-01 00:00 xl/workbook.xml
-rw----     4.5 fat      222 b- defS 80-Jan-01 00:00 xl/sharedStrings.xml
-rw----     4.5 fat      322 b- defS 80-Jan-01 00:00 xl/worksheets/_rels/sheet1.xml.rels
-rw----     4.5 fat     8384 b- defS 80-Jan-01 00:00 xl/theme/theme1.xml
-rw----     4.5 fat     1620 b- defS 80-Jan-01 00:00 xl/styles.xml
-rw----     4.5 fat     1361 b- defS 80-Jan-01 00:00 xl/worksheets/sheet1.xml
-rw----     4.5 fat      599 b- defS 80-Jan-01 00:00 docProps/core.xml
-rw----     4.5 fat     1364 b- defS 80-Jan-01 00:00 xl/printerSettings/printerSettings1.bin
-rw----     4.5 fat      816 b- defS 80-Jan-01 00:00 docProps/app.xml
12 files, 18776 bytes uncompressed, 6302 bytes compressed:  66.4%
I can open the extracted XLSX file with either Calc or Numbers, which is a spreadsheet included with MacOS. I'm sure the OP's system has Numbers. The OP should direct any questions about Numbers to an Apple forum.
Mr. Programmer
AOO 4.1.7 Build 9800 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
Villeroy
Volunteer
Posts: 30799
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Word Doc docx file with embedded spreadsheet

Post by Villeroy »

OO Linux does not show any object embedded in the docx.
LO 6 and 7 display the objects and make them editable.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
keme
Volunteer
Posts: 3574
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: Word Doc docx file with embedded spreadsheet

Post by keme »

Lupp wrote:
RusselB wrote:...you might try http://www.zamzar.com to convert the file...
Am I the only one who is suspecting "benevolent" "free" services needing a powerful (costly) background to be baits? If somehing is swaying before my eyes and smells well, I'm looking for the line.
That is the sensible thing to do. There is always a cashflow. Everyone needs to be aware of that. Thanks for reminding us!

True, that free service is bait, but they seem quite honest about that. The "line" is there in plain sight. Nothing covert about this as far as I can tell.

Free service limits input file size to 50MB and throughput to 2 files per day.

Paid service on different levels increases allowed file size, lifts the file count limit and adds shareable (to some extent) cloud storage.

This "credible business model" is why Zamzar is also my go-to recommendation for file conversion. Other services may offer more or charge less. Some are legit, and some have covert elements. If I cannot see where cashflow is generated, I leave it alone.
John_Ha
Volunteer
Posts: 9096
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Word Doc docx file with embedded spreadsheet

Post by John_Ha »

MrProgrammer wrote:Both DOCX files contain the embedded spreadsheet in the ZIP archive.
...
I can extract the spreadsheet with UNZIP. I realize not all OpenOffice users will have the technical skills to do that.
On Windows

1. rename fred.odt to fred.zip
2. Double click fred.zip - it opens just like a normal folder and the file can be used.
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
Post Reply