Difference between revisions of "LibreOffice-Suite-Calc/C3/Images-and-Graphics/English-timed"
From Script | Spoken-Tutorial
| Line 290: | Line 290: | ||
|- | |- | ||
| − | || | + | ||05:38 |
||Now, go the folder where the image is stored and delete the image. | ||Now, go the folder where the image is stored and delete the image. | ||
Revision as of 15:32, 9 July 2014
Resources for recording
| Time | Narration |
| 00:00 | Welcome to 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 eg - 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,
|
| 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 sheets. |
| 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”. |
| 1: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 “Link”option 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 greyscale. |
| 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 greyscale. |
| 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 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 pressing 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 | Lets 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. |
| 8: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 summarise, we learned how to-
Insert an image file into a spreadsheet in many different ways |
| 08:46 | like
|
| 08:52 | Watch the video available at the following link |
| 08:55 | It summarises 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 |
