Adding a spreadsheet or any other LibreOffice file is easy using OLE Objects.
- Go to Insert→Object→OLE Object.
- You will be presented with this dialogue:
- As you can see at this point, you have two options, to create a new file, or to use an existing file.
Using a new file:
If you choose to create a new file, simply click okay, and you will be presented with a new, embedded file. (See below).
You can edit this as you normally would, without having to open an instance of Calc.
Using an existing file:
If you choose to use an existing file, click on the "Create from file" radio button. This will present you with some slightly different options:
- You can search for a file to use by using the "Search" button (it brings up a file dialogue where you can choose a file).
- You can use a local copy of the file by leaving the option "Link to file" unchecked.
- This provides more flexibility, but takes up more space in your file.
- If you choose to link to the file:
- It saves space
- If you move the file, the link will be broken, so keep this in mind.
- For best results, keep the files in the same directory.
Otherwise, everything else is the same as "Using a new file".
Example with an actual file: