Welcome to the Spoken tutorial on Inserting images in LibreOffice Calc.
In this tutorial, we will learn the following:
Inserting an image file into a document.
For e.g. - jpeg, png or bmp.
Here, we are using:Ubuntu Linux version 10.04 and LibreOffice Suite version 3.3.4.
Images can be added into a spreadsheet by-Inserting an image file directly From a graphics program With the help of a clipboard orFrom the gallery.
We will discuss each one of them in detail.
Let us open our “Personal-Finance-Tracker.ods” spreadsheet.
First, let us select sheet 2.
We will insert images in this sheet.
It is a good practice to select a cell and then insert pictures.
If an image is already stored on your computer, you can insert it by first clicking on Insert
and then Picture and selecting From File.
Now, locate the image you want to insert.
I have already stored some images on the Desktop, in a folder named “Images”.
So, I will choose "Image1".
We will see the name of the image in the “Location” field .
Click on the Open button.
Observe that the image appears in the spreadsheet.
Let us insert another picture by linking it.
First, let us select a new cell.
Now, let’s click on Insert and Picture and select From File. Let us select another image.
Now, click on “Image 2”.
To link the image to your document, check the Linkoption and click Open.
In the dialog-box that appears, click on Keep Link button.
The picture is now linked to the file.
Linking:
When we link a file- First, it reduces the size of the spreadsheet when it is saved
since our spreadsheet does not contain the image.
Second, it enables the user to modify both the files separately.
Any changes made to the image file will be reflected in the linked image in the spreadsheet.
Let us change the color of "Image 2" which is linked to the file, to greyscale.
I am using the picture editor GIMP to edit this picture.
You can use any editor that is installed on your machine.
First, let’s save and close "Personal-Finance-Tracker.ods".
Next, go to the images folder.
Select "Image 2".
Now, right-click and select Open with GIMP.
"Image 2" opens in GIMP.
Now, let us change the picture from color to Grayscale.
Now, let’s save and close the image.
Let us open the "Personal-Finance-Tracker.ods".
"Image 2" is now displayed in grayscale.
However, one major disadvantage of linking the file is that- whenever you want to send this spreadsheet to a different computer or user,
you will have to send both- the spreadsheet as well as the image file.
Which means, you will always have to keep track of the location where you are storing both the files.
Let’s move this image to the right of the spreadsheet.
Another method of inserting images into a spreadsheet is by dragging it from its folder
where you have stored the image and dropping it on your spreadsheet.
Let us drag and drop an image.
Now, drag and drop the image file directly into your spreadsheet wherever you want to place it.
You will see that the image gets inserted into your document.
Let’s undo this change by pressing CTRL and Z.
Now, let us link the image using the drag and drop method.
This is easy too! Just press and hold the Control and Shift keys
while dragging the image into the spreadsheet.
The image file is now linked to the document.
Let’s save this Calc file by pressing Ctrl and S keys together.
Now, let’s close this file.
Now, let’s go to the folder where the image is located.
Let’s rename the image “Image 3.jpg”, that we inserted in the file, to “Image4.jpg”.
Now, open the “Personal Finance Tracker.ods” file again.
You see that the linked image is no longer visible!
The linked path shows an error!
Let us delete this link.
Pause this tutorial and do this assignment.
Insert an image as a link in a Calc sheet, save and close it.
Now, go to the folder where the image is stored and delete the image.
Open and check if the image is still visible in the Calc file.
Now, paste the image back into the image folder.
Check if the image is visible in the Calc file.
Notice, a new toolbar just below the “Standard” toolbar.
This is the “Picture” toolbar.
The Filter button at the top left of the “Picture” toolbar gives several options to change the look of the image.
Let’s undo this by typing Ctrl and Z.
The Graphics mode button has options to change the image into Grayscale, black-and-white or as a watermark.
There are other options on the Picture toolbar which we will cover later.
Next, we will learn how to insert image from a clipboard.
One can copy images stored on the clipboard, from one LibreOffice spreadsheet to another.
Let's create a new spreadsheet and name it as “abc.ods”.
This is our target document.
We already have an image in our “Personal-Finance-Tracker.ods” file.
This is our source document.
Now, select the image from the source file which is to be copied.
Press Ctrl and C keys together to copy the image.
The image is now saved on the clipboard.
Now switch to the target document which is “abc.ods”.
Select the location where you wish to place your saved image in “abc.ods”.
Now, press Ctrl and V keys together to insert the image into the document.
We see that the image is inserted into our target file.
Now we will learn how to insert images directly from the Calc Gallery.
Gallery has image as well as sounds which you can insert into your spreadsheet.
Let’s see how to do this.
Click on the Gallery icon in the standard toolbar.
Alternately, click on Tools option in the menu bar and then click on Gallery to open it.
Now, go through the images which the “Gallery” provides and click on the image you want to insert into your document.
Drag the image from the “Gallery” and drop it into the spreadsheet where you want to insert it.
You see that the image gets inserted into our “Personal-Finance-Tracker.ods” file.
This brings us to the end of this spoken tutorial on LibreOffice Calc.
To summarize, we learned how to:Insert an image file into a spreadsheet in many different ways,
like-from a file from the clipboard or from the gallery.
Watch the video available at the following link.
It summarizes the Spoken Tutorial project.
If you do not have good bandwidth, you can download and watch it.
The Spoken Tutorial project team: Conducts workshops using spoken tutorials.
Gives certificates for those who pass an online test.
For more details, please write to:contact at spoken hyphen tutorial dot org.
Spoken Tutorial project is a part of the Talk to a Teacher project.
It is supported by the National Mission on Education through ICT, MHRD, Government of India.
More information on this mission is available at:spoken hyphen tutorial dot org slash NMEICT hyphen Intro.
This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd.Thanks for joining.