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

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

||When we link a file- First, it reduces the size of the spreadsheet when it is saved

||Any changes made to the image file will be reflected in the linked image in the spreadsheet.  

||"'''Image 2'''" opens in GIMP.  

||Now, let us change the picture from color to '''Grayscale'''.  

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

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

||Let’s '''rename''' the image '''“Image 3.jpg”''', that we inserted in the file, to “'''Image4.jpg'''”.  

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

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

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

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

||'''Gallery''' has image as well as sounds which you can insert into your spreadsheet.  

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

||It summarizes the '''Spoken Tutorial''' project.

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

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