Monday, April 29, 2024
 Popular · Latest · Hot · Upcoming
16
rated 0 times [  16] [ 0]  / answers: 1 / hits: 15756  / 1 Year ago, sun, april 23, 2023, 5:24:50

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.


More From » libreoffice

 Answers
5

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


[#36818] Sunday, April 23, 2023, 1 Year  [reply] [flag answer]
Only authorized users can answer the question. Please sign in first, or register a free account.
exceeeelh

Total Points: 21
Total Questions: 109
Total Answers: 120

Location: Marshall Islands
Member since Wed, Jan 5, 2022
2 Years ago
exceeeelh questions
Sun, Nov 20, 22, 17:08, 1 Year ago
Sat, Jan 1, 22, 08:04, 2 Years ago
Wed, May 12, 21, 05:11, 3 Years ago
;