||Welcome to the '''Spoken tutorial''' on '''Inserting images in LibreOffice Calc'''.  

|00:06

|In this tutorial, we will learn the following:

|00:09

|Inserting an '''image file''' into a document.

||For e.g. - '''jpeg''', '''png''' or '''bmp'''.  

|00:19

|Here, we are using:'''Ubuntu Linux''' version '''10.04''' and '''LibreOffice Suite''' version '''3.3.4'''.

|00:28

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

||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'''.  

||01:10

||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'''. <pause>  

||Let us insert another picture by linking it.  

|01:42

|First, let us select a new '''cell'''.

|01:45

|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 '''Link'''option and click '''Open'''.  

||In the dialog-box that appears, click on '''Keep Link''' button.  

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

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

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

||Let’s move this image to the right of the 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.  

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

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

||The linked path shows an '''error'''!  

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

||Now, paste the image back into the image folder.  

||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'''.  

||Let's create a new spreadsheet and name it as '''“abc.ods”'''.  

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

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

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

||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,

|08:46

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

|09:08

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