Difference between revisions of "LibreOffice-Suite-Calc/C3/Images-and-Graphics/English-timed"

From Script | Spoken-Tutorial
Jump to: navigation, search
 
(10 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
=Resources for recording=
 
=Resources for recording=
 
[[Media:Images and graphics in Calc.zip |Images and graphics in Calc]]
 
[[Media:Images and graphics in Calc.zip |Images and graphics in Calc]]
−
 
  
  
Line 10: Line 9:
 
|-
 
|-
 
||00:00
 
||00:00
−
||Welcome to Spoken tutorial on Inserting images in LibreOffice Calc.  
+
||Welcome to the '''Spoken tutorial''' on '''Inserting images in LibreOffice Calc'''.  
  
 
|-
 
|-
−
||00:06
+
|00:06
−
||In this tutorial we will learn the following:
+
|In this tutorial, we will learn the following:
  
 
|-
 
|-
−
||00:09
+
|00:09
−
||Inserting an image file into a document.
+
|Inserting an '''image file''' into a document.
  
 
|-
 
|-
 
||00:13
 
||00:13
−
||For eg - jpeg, png or bmp.  
+
||For e.g. - '''jpeg''', '''png''' or '''bmp'''.  
  
 
|-
 
|-
−
||00:19
+
|00:19
−
||Here we are using, Ubuntu Linux version 10.04 and LibreOffice Suite version 3.3.4  
+
|Here, we are using:'''Ubuntu Linux''' version '''10.04''' and '''LibreOffice Suite''' version '''3.3.4'''.
  
 
|-
 
|-
−
||00:28
+
|00:28
−
||Images can be added into a spreadsheet by, 
+
|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.  
−
 
+
−
* Inserting an image file directly
+
−
+
−
* From a graphics program,
+
−
+
−
* With the help of a clipboard or
+
−
 
+
−
* From the gallery.  
+
  
 
|-
 
|-
Line 50: Line 41:
 
|-
 
|-
 
||00:48
 
||00:48
−
||First, let us select sheet 2.
+
||First, let us select '''sheet 2'''.
  
 
|-
 
|-
 
||00:51
 
||00:51
−
||We will insert images in this sheets.  
+
||We will insert images in this sheet.  
  
 
|-
 
|-
 
||00:54
 
||00:54
−
||It is a good practice to select a cell and then insert pictures.  
+
||It is a good practice to select a '''cell''' and then insert pictures.  
  
 
|-
 
|-
 
||00:59
 
||00:59
−
||If an image is already stored on your computer, you can insert it by first clicking on “Insert”
+
||If an '''image''' is already stored on your computer, you can insert it by first clicking on '''Insert'''
  
 
|-
 
|-
−
||1:06
+
||01:06
−
||and then “Picture” and selecting “From File”.  
+
||and then '''Picture''' and selecting '''From File'''.  
  
 
|-
 
|-
−
||1:10
+
||01:10
−
||Now locate the image you want to insert.
+
||Now, locate the '''image''' you want to insert.
  
 
|-
 
|-
−
||1:14
+
||01:14
−
||I have already stored some images on the Desktop in a folder named “Images”.
+
||I have already stored some images on the Desktop, in a folder named “Images”.
  
 
|-
 
|-
−
||1:20
+
||01:20
−
||So, I will choose “Image1”.  
+
||So, I will choose '''"Image1"'''.  
  
 
|-
 
|-
−
||1:24
+
||01:24
−
||We will see the name of the image in the “Location” field .
+
||We will see the name of the image in the '''“Location”''' field .
  
 
|-
 
|-
−
||1:28
+
||01:28
−
||Click on the “Open” button  
+
||Click on the '''Open''' button.
  
 
|-
 
|-
−
||1:31
+
||01:31
−
||Observe that the image appears in the spreadsheet. <pause>  
+
||Observe that the image appears in the '''spreadsheet'''. <pause>  
  
 
|-
 
|-
−
||1:38
+
||01:38
−
||Let us insert another picture by Linking it.  
+
||Let us insert another picture by linking it.  
  
 
|-
 
|-
−
||1:42
+
|01:42
−
||First let us select a new cell.
+
|First, let us select a new '''cell'''.
  
 
|-
 
|-
−
||1:45
+
|01:45
−
||Now, let’s click on “Insert” and “Picture” and select “From File”. Let us select another image.  
+
|Now, let’s click on '''Insert''' and '''Picture''' and select '''From File'''. Let us select another image.  
  
 
|-
 
|-
−
||1:55
+
||01:55
−
||Now click on “Image 2”.  
+
||Now, click on '''“Image 2”'''.  
  
 
|-
 
|-
−
||1:58
+
||01:58
−
||To link the image to your document, check the “Link”option and click “Open”.  
+
||To '''link''' the image to your document, check the '''Link'''option and click '''Open'''.  
  
 
|-
 
|-
−
||2:05
+
||02:05
−
||In the dialog box that appears, click on “Keep Link” button.  
+
||In the dialog-box that appears, click on '''Keep Link''' button.  
  
 
|-
 
|-
−
||2:11
+
||02:11
 
||The picture is now linked to the file.  
 
||The picture is now linked to the file.  
  
 
|-
 
|-
−
||2:15
+
||02:15
−
||Linking
+
||Linking:
  
 
|-
 
|-
−
||2:17
+
||02:17
−
||When we link a file:
+
||When we link a file- First, it reduces the size of the spreadsheet when it is saved
−
First, it reduces the size of the spreadsheet when it is saved
+
 
    
 
    
 
|-
 
|-
−
||2:23
+
||02:23
−
||Since our spreadsheet does not contain the image.
+
||since our spreadsheet does not contain the image.
  
 
|-
 
|-
−
||2:27
+
||02:27
 
||Second, it enables the user to modify both the files separately.  
 
||Second, it enables the user to modify both the files separately.  
  
 
|-
 
|-
−
||2:32
+
||02:32
−
||Any changes made to the image file,
+
||Any changes made to the image file will be reflected in the linked image in the spreadsheet.  
−
Will be reflected in the linked image
+
−
In the spreadsheet.  
+
  
 
|-
 
|-
−
||2:39
+
||02:39
−
||Let us change the color of Image 2, which is linked to the file to greyscale.  
+
||Let us change the color of "Image 2" which is linked to the file, to '''greyscale'''.  
  
 
|-
 
|-
−
||2:46
+
||02:46
−
||I am using the picture editor GIMP to edit this picture.
+
||I am using the '''picture editor GIMP''' to edit this picture.
  
 
|-
 
|-
−
||2:50
+
||02:50
 
||You can use any editor that is installed on your machine.  
 
||You can use any editor that is installed on your machine.  
  
 
|-
 
|-
−
||2:54
+
||02:54
−
||First let’s save and close "Personal-Finance-Tracker.ods"  
+
||First, let’s '''save''' and close "Personal-Finance-Tracker.ods".
  
 
|-
 
|-
−
||3:01
+
||03:01
−
||Next, go to the images folder.
+
||Next, go to the '''images''' folder.
 
      
 
      
 
|-
 
|-
−
||3:04
+
||03:04
−
||Select "Image 2".
+
||Select '''"Image 2"'''.
 
   
 
   
 
|-
 
|-
−
||3:06
+
||03:06
−
||Now, right-click and select Open with GIMP.  
+
||Now, right-click and select '''Open with GIMP'''.  
  
 
|-
 
|-
−
||3:10
+
||03:10
−
||Image 2 opens in GIMP.  
+
||"'''Image 2'''" opens in GIMP.  
  
 
|-
 
|-
−
||3:13
+
||03:13
−
||Now let us change the picture from color to greyscale.  
+
||Now, let us change the picture from color to '''Grayscale'''.  
  
 
|-
 
|-
−
||3:18
+
||03:18
−
||Now, let’s save and close the image.  
+
||Now, let’s '''save''' and close the image.  
  
 
|-
 
|-
−
||3:22
+
||03:22
−
||Let us open the Personal-Finance-Tracker.ods.  
+
||Let us open the '''"Personal-Finance-Tracker.ods"'''.  
  
 
|-
 
|-
−
||3:26
+
||03:26
−
||Image 2 is now displayed in greyscale.  
+
||"Image 2" is now displayed in '''grayscale'''.  
  
 
|-
 
|-
−
||3:30
+
||03:30
−
||However, one major Disadvantage of linking the file is that,
+
||However, one major disadvantage of linking the file is that- whenever you want to send this spreadsheet to a different computer or user,
−
Whenever you want to send this spreadsheet to a different computer or user,
+
  
 
|-
 
|-
−
||3:40
+
||03:40
−
||You will have to send both, the spreadsheet as well as the image file.
+
||you will have to send both- the spreadsheet as well as the image file.
 
      
 
      
 
|-
 
|-
−
||3:44
+
||03:44
 
||Which means, you will always have to keep track of the location where you are storing both the files.  
 
||Which means, you will always have to keep track of the location where you are storing both the files.  
  
 
|-
 
|-
−
||3:52
+
||03:52
−
||Let’s move this image to the right of the spreadsheet  
+
||Let’s move this image to the right of the spreadsheet.
  
 
|-
 
|-
−
||3:58
+
||03:58
 
||Another method of inserting images into a spreadsheet is by dragging it from its folder
 
||Another method of inserting images into a spreadsheet is by dragging it from its folder
  
 
|-
 
|-
−
||4:05
+
||04:05
 
||where you have stored the image and dropping it on your spreadsheet.  
 
||where you have stored the image and dropping it on your spreadsheet.  
  
 
|-
 
|-
−
||4:09
+
||04:09
−
||Let us drag and drop an image.  
+
||Let us '''drag and drop''' an image.  
  
 
|-
 
|-
−
||4:12
+
||04:12
−
||Now drag and drop the image file directly into your spreadsheet wherever you want to place it.  
+
||Now, drag and drop the image file directly into your spreadsheet wherever you want to place it.  
  
 
|-
 
|-
−
||4:19
+
||04:19
 
||You will see that the image gets inserted into your document.
 
||You will see that the image gets inserted into your document.
  
 
|-
 
|-
−
||4:23
+
||04:23
−
||Let’s undo this change by pressing CTRL and Z.  
+
||Let’s '''undo''' this change by pressing '''CTRL''' and '''Z'''.  
  
 
|-
 
|-
−
||4:29
+
||04:29
−
||Now let us link the image using the drag and drop method.  
+
||Now, let us link the image using the '''drag and drop''' method.  
  
 
|-
 
|-
−
||4:34
+
||04:34
−
||This is easy too!  
+
||This is easy too! Just press and hold the '''Control''' and '''Shift''' keys  
−
Just press and hold the “Control” and “Shift” keys  
+
  
 
|-
 
|-
−
||4:40
+
||04:40
 
||while dragging the image into the spreadsheet.  
 
||while dragging the image into the spreadsheet.  
  
 
|-
 
|-
−
||4:44
+
||04:44
 
||The image file is now linked to the document.  
 
||The image file is now linked to the document.  
  
 
|-
 
|-
−
||4:48
+
||04:48
−
||Let’s save this Calc file by pressing CTRL and S keys together.  
+
||Let’s '''save''' this '''Calc''' file by pressing '''Ctrl''' and '''S''' keys together.  
  
 
|-
 
|-
−
||4:54
+
||04:54
−
||Now let’s close this file.  
+
||Now, let’s '''close''' this file.  
  
 
|-
 
|-
−
||4:58
+
||04:58
−
||Now let’s go to the folder where the image is located.  
+
||Now, let’s go to the folder where the image is located.  
  
 
|-
 
|-
−
||5:02
+
||05:02
−
||Let’s rename the image “Image 3.jpg”, that we inserted in the file to “Image4.jpg”.  
+
||Let’s '''rename''' the image '''“Image 3.jpg”''', that we inserted in the file, to “'''Image4.jpg'''”.  
  
 
|-
 
|-
−
||5:12
+
||05:12
−
||Now open the “Personal Finance Tracker.ods” file again.  
+
||Now, open the “Personal Finance Tracker.ods” file again.  
  
 
|-
 
|-
−
||5:18
+
||05:18
 
||You see that the linked image is no longer visible!  
 
||You see that the linked image is no longer visible!  
  
 
|-
 
|-
−
||5:22
+
||05:22
−
||The linked path shows an error!  
+
||The linked path shows an '''error'''!  
  
 
|-
 
|-
−
||5:25
+
||05:25
 
||Let us delete this link.  
 
||Let us delete this link.  
  
 
|-
 
|-
−
||5:28
+
||05:28
 
||Pause this tutorial and do this assignment.  
 
||Pause this tutorial and do this assignment.  
  
 
|-
 
|-
−
||5:32
+
||05:32
−
||Insert an image as a link in a Calc sheet, save and close it.  
+
||Insert an image as a '''link''' in a '''Calc sheet''', '''save''' and '''close''' it.  
  
 
|-
 
|-
−
||5:38
+
||05:38
−
||Now, go the folder where the image is stored and delete the image.
+
||Now, go to the folder where the image is stored and delete the image.
  
 
|-
 
|-
−
||5:43
+
||05:43
 
||Open and check if the image is still visible in the Calc file.
 
||Open and check if the image is still visible in the Calc file.
  
 
|-
 
|-
−
||5:49
+
||05:49
−
||Now paste the image back into the image folder.  
+
||Now, paste the image back into the image folder.  
  
 
|-
 
|-
−
||5:53
+
||05:53
 
||Check if the image is visible in the Calc file.  
 
||Check if the image is visible in the Calc file.  
  
 
|-
 
|-
−
||5:57
+
||05:57
−
||Notice a new toolbar just below the “Standard” toolbar.  
+
||Notice, a new toolbar just below the “Standard” toolbar.  
  
 
|-
 
|-
−
||6:02
+
||06:02
−
||This is the “Picture” toolbar.  
+
||This is the '''“Picture” toolbar'''.  
  
 
|-
 
|-
−
||6:04
+
||06:04
−
||The “Filter” button at the top left of the “Picture” toolbar gives several options to change the look of the image.  
+
||The '''Filter''' button at the top left of the '''“Picture”''' toolbar gives several options to change the look of the image.  
  
 
|-
 
|-
−
||6:13
+
||06:13
−
||Let’s undo this by pressing CTRL and Z.  
+
||Let’s '''undo''' this by typing '''Ctrl''' and '''Z'''.  
  
 
|-
 
|-
−
||6:18
+
||06:18
−
||The “Graphics mode” button has options to change the image into grayscale, black-and-white or as a watermark.  
+
||The '''Graphics mode''' button has options to change the image into '''Grayscale''', black-and-white or as a '''watermark'''.  
  
 
|-
 
|-
−
||6:26
+
||06:26
−
||There are other options on the “Picture” toolbar which we will cover later.  
+
||There are other options on the '''Picture''' toolbar which we will cover later.  
  
 
|-
 
|-
−
||6:32
+
||06:32
−
||Next we will learn how to insert image from a clipboard.  
+
||Next, we will learn how to insert image from a '''clipboard'''.  
  
 
|-
 
|-
−
||6:37
+
||06:37
 
||One can copy images stored on the clipboard, from one LibreOffice spreadsheet to another.  
 
||One can copy images stored on the clipboard, from one LibreOffice spreadsheet to another.  
  
 
|-
 
|-
−
||6:44
+
||06:44
−
||Lets create a new spreadsheet and name it as “abc.ods”.  
+
||Let's create a new spreadsheet and name it as '''“abc.ods”'''.  
  
 
|-
 
|-
−
||6:50
+
||06:50
 
||This is our target document.  
 
||This is our target document.  
  
 
|-
 
|-
−
||6:53
+
||06:53
 
||We already have an image in our “Personal-Finance-Tracker.ods” file.  
 
||We already have an image in our “Personal-Finance-Tracker.ods” file.  
  
 
|-
 
|-
−
||6:59
+
||06:59
−
||This is our source document.  
+
||This is our '''source''' document.  
  
 
|-
 
|-
−
||7:02
+
||07:02
−
||Now select the image from the source file which is to be copied.  
+
||Now, select the image from the source file which is to be copied.  
  
 
|-
 
|-
−
||7:06
+
||07:06
−
||Press “CTRL” and “C” keys together to copy the image.  
+
||Press '''Ctrl''' and '''C''' keys together to '''copy''' the image.  
  
 
|-
 
|-
−
||7:11
+
||07:11
 
||The image is now saved on the clipboard.  
 
||The image is now saved on the clipboard.  
  
 
|-
 
|-
−
||7:15
+
||07:15
−
||Now switch to the target document, which is “abc.ods”.  
+
||Now switch to the target document which is “'''abc.ods'''”.  
  
 
|-
 
|-
−
||7:21
+
||07:21
−
||Select the location where you wish to place your saved image in “abc.ods”.  
+
||Select the location where you wish to place your saved image in “'''abc.ods'''”.  
  
 
|-
 
|-
−
||7:28
+
||07:28
−
||Now press “CTRL” and “V” keys together to insert the image into the document.  
+
||Now, press '''Ctrl''' and '''V''' keys together to insert the image into the document.  
  
 
|-
 
|-
−
||7:35
+
||07:35
 
||We see that the image is inserted into our target file.  
 
||We see that the image is inserted into our target file.  
  
 
|-
 
|-
−
||7:42
+
||07:42
−
||Now we will learn how to insert images directly from the Calc Gallery.  
+
||Now we will learn how to insert images directly from the '''Calc Gallery'''.  
  
 
|-
 
|-
−
||7:48
+
||07:48
−
||“Gallery” has image as well as sounds which you can insert into your spreadsheet.  
+
||'''Gallery''' has image as well as sounds which you can insert into your spreadsheet.  
  
 
|-
 
|-
−
||7:54
+
||07:54
 
||Let’s see how to do this.  
 
||Let’s see how to do this.  
  
 
|-
 
|-
−
||7:57
+
||07:57
−
||Click on the “Gallery” icon in the standard toolbar.  
+
||Click on the '''Gallery''' icon in the '''standard toolbar'''.  
  
 
|-
 
|-
−
||8:01
+
||08:01
−
||Alternately, click on “Tools” option in the menu bar and then click on “Gallery” to open it.  
+
||Alternately, click on '''Tools''' option in the menu bar and then click on '''Gallery''' to open it.  
  
 
|-
 
|-
−
||8:09
+
||08:09
−
||Now go through the images which the “Gallery” provides and click on the image you want to insert into your document.  
+
||Now, go through the images which the “Gallery” provides and click on the image you want to insert into your document.  
  
 
|-
 
|-
−
||8:18
+
||08:18
−
||Drag the image from the “Gallery”  
+
||Drag the image from the “Gallery” and drop it into the spreadsheet where you want to insert it.  
−
and drop it into the spreadsheet where you want to insert it.  
+
  
 
|-
 
|-
−
||8:26
+
||08:26
−
||You see that the image gets inserted into our “Personal-Finance-Tracker.ods” file.  
+
||You see that the image gets inserted into our “'''Personal-Finance-Tracker.ods'''” file.  
  
 
|-
 
|-
−
||8:34
+
||08:34
−
||This brings us to the end of this spoken tutorial on 'LibreOffice Calc'.  
+
||This brings us to the end of this spoken tutorial on '''LibreOffice Calc'''.  
  
 
|-
 
|-
−
||8:39
+
||08:39
−
||To summarise, we learned how to-
+
||To summarize, we learned how to:Insert an image file into a spreadsheet in many different ways,
−
Insert an image file into a spreadsheet in many different ways  
+
  
 
|-
 
|-
−
||8:46
+
|08:46
−
||like  
+
|like-from a file from the clipboard or from the gallery.
−
* From a file  
+
−
 
+
−
* From the clipboard or  
+
−
 
+
−
*  From the gallery  
+
  
 
|-
 
|-
−
||8:52
+
||08:52
−
||Watch the video available at the following link  
+
||Watch the video available at the following link.
  
 
|-
 
|-
−
||8:55
+
||08:55
−
||It summarises the Spoken Tutorial project  
+
||It summarizes the '''Spoken Tutorial''' project.
  
 
|-
 
|-
−
||8:58
+
||08:58
−
||If you do not have good bandwidth, you can download and watch it  
+
||If you do not have good bandwidth, you can download and watch it.
  
 
|-
 
|-
−
||9:03
+
||09:03
−
||The Spoken Tutorial Project Team
+
||The Spoken Tutorial project team: Conducts workshops using spoken tutorials.  
−
Conducts workshops using spoken tutorials.  
+
  
 
|-
 
|-
−
||9:08
+
|09:08
−
||Gives certificates for those who pass an online test  
+
|Gives certificates for those who pass an online test.
  
 
|-
 
|-
−
||9:12
+
||09:12
−
||For more details, please write to contact at spoken hyphen tutorial dot org  
+
||For more details, please write to:'''contact at spoken hyphen tutorial dot org'''.
  
 
|-
 
|-
−
||9:19
+
||09:19
−
||Spoken Tutorial Project is a part of the Talk to a Teacher project  
+
||'''Spoken Tutorial''' project is a part of the '''Talk to a Teacher''' project.
  
 
|-
 
|-
−
||9:23
+
||09:23
−
||It is supported by the National Mission on Education through ICT, MHRD, Government of India  
+
||It is supported by the National Mission on Education through ICT, MHRD, Government of India.
  
 
|-
 
|-
−
||9:31
+
||09:31
−
||More information on this Mission is available at  
+
||More information on this mission is available at:'''spoken hyphen tutorial dot org slash NMEICT hyphen Intro'''.
−
spoken hyphen tutorial dot org slash NMEICT hyphen Intro  
+
  
 
|-
 
|-
−
||9:41
+
||09:41
−
||This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd  
+
||This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd.Thanks for joining.
−
Thanks for joining
+

Latest revision as of 15:00, 26 October 2016

Resources for recording

Images and graphics in Calc


Time Narration
00:00 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.
00:13 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.
00:39 We will discuss each one of them in detail.
00:43 Let us open our “Personal-Finance-Tracker.ods” spreadsheet.
00:48 First, let us select sheet 2.
00:51 We will insert images in this sheet.
00:54 It is a good practice to select a cell and then insert pictures.
00:59 If an image is already stored on your computer, you can insert it by first clicking on Insert
01:06 and then Picture and selecting From File.
01:10 Now, locate the image you want to insert.
01:14 I have already stored some images on the Desktop, in a folder named “Images”.
01:20 So, I will choose "Image1".
01:24 We will see the name of the image in the “Location” field .
01:28 Click on the Open button.
01:31 Observe that the image appears in the spreadsheet. <pause>
01:38 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.
01:55 Now, click on “Image 2”.
01:58 To link the image to your document, check the Linkoption and click Open.
02:05 In the dialog-box that appears, click on Keep Link button.
02:11 The picture is now linked to the file.
02:15 Linking:
02:17 When we link a file- First, it reduces the size of the spreadsheet when it is saved
02:23 since our spreadsheet does not contain the image.
02:27 Second, it enables the user to modify both the files separately.
02:32 Any changes made to the image file will be reflected in the linked image in the spreadsheet.
02:39 Let us change the color of "Image 2" which is linked to the file, to greyscale.
02:46 I am using the picture editor GIMP to edit this picture.
02:50 You can use any editor that is installed on your machine.
02:54 First, let’s save and close "Personal-Finance-Tracker.ods".
03:01 Next, go to the images folder.
03:04 Select "Image 2".
03:06 Now, right-click and select Open with GIMP.
03:10 "Image 2" opens in GIMP.
03:13 Now, let us change the picture from color to Grayscale.
03:18 Now, let’s save and close the image.
03:22 Let us open the "Personal-Finance-Tracker.ods".
03:26 "Image 2" is now displayed in grayscale.
03:30 However, one major disadvantage of linking the file is that- whenever you want to send this spreadsheet to a different computer or user,
03:40 you will have to send both- the spreadsheet as well as the image file.
03:44 Which means, you will always have to keep track of the location where you are storing both the files.
03:52 Let’s move this image to the right of the spreadsheet.
03:58 Another method of inserting images into a spreadsheet is by dragging it from its folder
04:05 where you have stored the image and dropping it on your spreadsheet.
04:09 Let us drag and drop an image.
04:12 Now, drag and drop the image file directly into your spreadsheet wherever you want to place it.
04:19 You will see that the image gets inserted into your document.
04:23 Let’s undo this change by pressing CTRL and Z.
04:29 Now, let us link the image using the drag and drop method.
04:34 This is easy too! Just press and hold the Control and Shift keys
04:40 while dragging the image into the spreadsheet.
04:44 The image file is now linked to the document.
04:48 Let’s save this Calc file by pressing Ctrl and S keys together.
04:54 Now, let’s close this file.
04:58 Now, let’s go to the folder where the image is located.
05:02 Let’s rename the image “Image 3.jpg”, that we inserted in the file, to “Image4.jpg”.
05:12 Now, open the “Personal Finance Tracker.ods” file again.
05:18 You see that the linked image is no longer visible!
05:22 The linked path shows an error!
05:25 Let us delete this link.
05:28 Pause this tutorial and do this assignment.
05:32 Insert an image as a link in a Calc sheet, save and close it.
05:38 Now, go to the folder where the image is stored and delete the image.
05:43 Open and check if the image is still visible in the Calc file.
05:49 Now, paste the image back into the image folder.
05:53 Check if the image is visible in the Calc file.
05:57 Notice, a new toolbar just below the “Standard” toolbar.
06:02 This is the “Picture” toolbar.
06:04 The Filter button at the top left of the “Picture” toolbar gives several options to change the look of the image.
06:13 Let’s undo this by typing Ctrl and Z.
06:18 The Graphics mode button has options to change the image into Grayscale, black-and-white or as a watermark.
06:26 There are other options on the Picture toolbar which we will cover later.
06:32 Next, we will learn how to insert image from a clipboard.
06:37 One can copy images stored on the clipboard, from one LibreOffice spreadsheet to another.
06:44 Let's create a new spreadsheet and name it as “abc.ods”.
06:50 This is our target document.
06:53 We already have an image in our “Personal-Finance-Tracker.ods” file.
06:59 This is our source document.
07:02 Now, select the image from the source file which is to be copied.
07:06 Press Ctrl and C keys together to copy the image.
07:11 The image is now saved on the clipboard.
07:15 Now switch to the target document which is “abc.ods”.
07:21 Select the location where you wish to place your saved image in “abc.ods”.
07:28 Now, press Ctrl and V keys together to insert the image into the document.
07:35 We see that the image is inserted into our target file.
07:42 Now we will learn how to insert images directly from the Calc Gallery.
07:48 Gallery has image as well as sounds which you can insert into your spreadsheet.
07:54 Let’s see how to do this.
07:57 Click on the Gallery icon in the standard toolbar.
08:01 Alternately, click on Tools option in the menu bar and then click on Gallery to open it.
08:09 Now, go through the images which the “Gallery” provides and click on the image you want to insert into your document.
08:18 Drag the image from the “Gallery” and drop it into the spreadsheet where you want to insert it.
08:26 You see that the image gets inserted into our “Personal-Finance-Tracker.ods” file.
08:34 This brings us to the end of this spoken tutorial on LibreOffice Calc.
08:39 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.
08:52 Watch the video available at the following link.
08:55 It summarizes the Spoken Tutorial project.
08:58 If you do not have good bandwidth, you can download and watch it.
09:03 The Spoken Tutorial project team: Conducts workshops using spoken tutorials.
09:08 Gives certificates for those who pass an online test.
09:12 For more details, please write to:contact at spoken hyphen tutorial dot org.
09:19 Spoken Tutorial project is a part of the Talk to a Teacher project.
09:23 It is supported by the National Mission on Education through ICT, MHRD, Government of India.
09:31 More information on this mission is available at:spoken hyphen tutorial dot org slash NMEICT hyphen Intro.
09:41 This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd.Thanks for joining.

Contributors and Content Editors

Minal, PoojaMoolya, Pratik kamble, Sandhya.np14

Retrieved from "https://script.spoken-tutorial.org/index.php?title=LibreOffice-Suite-Calc/C3/Images-and-Graphics/English-timed&oldid=29523"