Embedding AOO spreadsheet into Writer doc?
Embedding AOO spreadsheet into Writer doc?
I'm trying to make an OO text document that could be more valuable to me if I could embed an OO spreadsheet into it. Is that at all possible, or is there a workaround for this? Thanks for any help.
Open Office 4.1.6 on Windows 10
Re: Embedding OO spreadsheet into OO word doc?
Do you need the sheet dynamic, or static?
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: Embedding AOO spreadsheet into Writer doc?
Thanks for responding, Rory. I'd like them dynamic; I know how to put a static picture of them in (or at least I did w/ MS Word, and I expect I could with OO Write). Is that possible?
Open Office 4.1.6 on Windows 10
Re: Embedding AOO spreadsheet into Writer doc?
Probably best to use OLE embedding - I don't do this, so can only point you to the existence of the method and suggest you consult the Help files.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: Embedding AOO spreadsheet into Writer doc?
You will find much useful information in the Writer FAQ, the Writer Tutorials, the up to date Writer guide and the Writer Manual. May I suggest you bookmark the pages.
Search Help with OLE for embedding a spreadsheet.
Press F1 to access the Help screen and search for your problem
The chapter headings in the manual are:
1 - Introducing Writer
2 - Setting up Writer
3 - Working with Text
4 - Formatting Pages
5 - Printing, Exporting, Faxing and E-Mailing
6 - Introduction to Styles
7 - Working with Styles
8 - Working with Graphics
9 - Working with Tables
10 - Working with Templates
11 - Using Mail Merge
12 - Tables of Contents, Indexes and Bibliographies
13 - Working with Master Documents
14 - Working with Fields
15 - Using Forms in Writer
16 - Customizing Writer – Keyboard shortcuts.
When a pop-up window opens, click the Help button for extensive help on that function - it is often more comprehensive than the manual.
Showing that a problem has been solved helps others searching so, if your problem is now solved, please view your first post in this thread and click the Edit button (top right in the post) and add [Solved] in front of the subject.
Search Help with OLE for embedding a spreadsheet.
Press F1 to access the Help screen and search for your problem
The chapter headings in the manual are:
1 - Introducing Writer
2 - Setting up Writer
3 - Working with Text
4 - Formatting Pages
5 - Printing, Exporting, Faxing and E-Mailing
6 - Introduction to Styles
7 - Working with Styles
8 - Working with Graphics
9 - Working with Tables
10 - Working with Templates
11 - Using Mail Merge
12 - Tables of Contents, Indexes and Bibliographies
13 - Working with Master Documents
14 - Working with Fields
15 - Using Forms in Writer
16 - Customizing Writer – Keyboard shortcuts.
When a pop-up window opens, click the Help button for extensive help on that function - it is often more comprehensive than the manual.
Showing that a problem has been solved helps others searching so, if your problem is now solved, please view your first post in this thread and click the Edit button (top right in the post) and add [Solved] in front of the subject.
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.
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.
Re: Embedding AOO spreadsheet into Writer doc?
One more point - see [Tutorial] Differences between Writer and MS Word files for why you should always work in and save files as .odt.
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.
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.
Re: Embedding AOO spreadsheet into Writer doc?
Like Rory I do not use them but at its simplest copy the area of the spreadsheet that is to go into the Writer table, do Paste Special > DDE link and see what happens. A change in the spreadsheet should be reflected in the Writer file.Padeen wrote:Thanks for responding, Rory. I'd like them dynamic; I know how to put a static picture of them in (or at least I did w/ MS Word, and I expect I could with OO Write). Is that possible?
That's the limit of my knowledge.
LibreOffice 7.3.7. 2; Ubuntu 22.04
Re: Embedding AOO spreadsheet into Writer doc?
Thanks, Rory; very valuable information!
Open Office 4.1.6 on Windows 10