Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

In MS Office Word, I can insert a worksheet directly from the Insert tab. Is it also possible in Libre Office 3 Writer, that is to insert a worksheet within the program, without the need to open a spreadsheet application?

The only method that I know is to launch LibreOffice Calc and select the range of cells, then copy and paste it in LibreOffice Writer.

share|improve this question

2 Answers 2

up vote 5 down vote accepted

Adding a spreadsheet or any other LibreOffice file is easy using OLE Objects.

Here's How:

  • Go to Insert→Object→OLE Object.
    Menu
  • You will be presented with this dialogue: 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).

Embedded file

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:

Dialogue Without File Selected

  • 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).

    Dialogue With File Selected

  • 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:

Editing: Editing an embedded file

Viewing: Viewing

share|improve this answer
1  
But If U choose Create from file option, how can I choose just one sheet ? –  skowron-line Jan 29 '13 at 10:04
    
@skowron-line I'm not sure. –  RolandiXor Jan 29 '13 at 16:31
    
@skowron-line: right click the object, choose Edit, navigate to the desired sheet. Helps if you close the sheet if it's open in Calc. –  Dan Dascalescu Jul 1 '13 at 2:26

Look at this topic: http://user.services.openoffice.org/en/forum/viewtopic.php?f=7&t=9981

The alternative is to do Insert/Ole Object.

share|improve this answer
    
Thank you for the quick response and for the link. Although the answers on that link works, I am looking for a way to insert a worksheet without the need to open LibreOffice Calc. –  Peachy Jul 16 '12 at 11:46
1  
The alternative is to do Insert/Ole Object... –  jasmines Jul 16 '12 at 11:57
    
It worked. Thank you! Can you please edit your answer to add this, so I can accept it. –  Peachy Jul 16 '12 at 12:05
    
You're welcome! –  jasmines Jul 16 '12 at 12:12
    
Do you mind adding some instructions to this answer? –  RolandiXor Aug 21 '12 at 1:13

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.