Chandrika: Created page with '=Resources for recording= Images and graphics in Calc {| border=1 || '''VISUAL CUE''' || '''NARRATION''' |- || Show Slide Number 1 …'

2012-11-29T05:19:31Z

Created page with '=Resources for recording= Images and graphics in Calc {| border=1 || '''VISUAL CUE''' || '''NARRATION''' |- || Show Slide Number 1 …'

New page

=Resources for recording=
[[Media:Images and graphics in Calc.zip |Images and graphics in Calc]]

{| border=1
|| '''VISUAL CUE'''
|| '''NARRATION'''

|-
|| Show Slide Number 1
Title Slide
Spoken Tutorial on Inserting Images in LibreOffice Calc.
|| Welcome to the
Spoken tutorial on Inserting images in
'''LibreOffice Calc'''.

|-
|| Show Slide Number 2

'''Learning Objectives'''
* Inserting an image file into a document.
* For eg - jpeg, png, bmp.
||
In this tutorial we will learn the following:

* Inserting an image file into a document.
* For eg - jpeg, png, bmp.

|-
|| Show Slide Number 3
OS and versions
Here we are using
* Ubuntu Linux version 10.04
* LibreOffice Suite version 3.3.4
|| Here we are using

'''* Ubuntu Linux '''version 10.04 and
'''* LibreOffice Suite''' version 3.3.4

|-
|| Show Slide Number 4
'''Images'''
Images can be added into a spreadsheet by

* Inserting an image file directly
* From a graphics program
* With the help of a clipboard
* From the gallery
||

Images can be added into a spreadsheet by

* Inserting an image file directly
* From a graphics program,
* With the help of a clipboard or
* From the gallery.

|-
||
|| We will discuss each one of them in detail.

|-
|| Open “Personal-Finance-Tracker.ods”
|| Let us open our “'''Personal-Finance-Tracker.ods'''” spreadsheet.

|-
|| Select sheet 2.
|| 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.

|-
|| Click on “Insert” >> select “Picture” >> click on “From File”.

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

|-
|| Go To Desktop
Click on the “Images” folder >> Point to the images.

Next click on “Image1”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'''”.

|-
|| Point to the “Location” field and the filename.

Click on Open button
|| We will see the name of the image in the “'''Location'''” field .

Click on the “'''Open'''” button

|-
|| Point to the image inserted in the file.
|| Observe that the image appears in the spreadsheet. <pause>

|-
||
|| Let us insert another picture by Linking it.

|-
|| Select a new cell. Ensure that the cell you select is not next to image 1 or it will overlap.
Click on “Insert” >> select “Picture” >> click on “From File”.
<<Select another image not the roses image>>
|| First let us select a new cell.
Now, let’s click on “'''Insert'''” and “'''Picture'''” and select “'''From File'''”.
Let us select another image.

|-
|| Click on “Image 2”
|| Now click on “Image 2”.

|-
|| Put a check on “Link” option

click “Open”
|| 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.

<Pause for 2 secs>
|| In the dialog box that appears, click on “'''Keep Link'''” button.

|-
|| Point to the linked file.
|| The picture is now linked to the file.

|-
|| Show Slide Number 5
'''
Linking'''
* Reduces the size of the spreadsheet when it is saved
* Since our spreadsheet does not contain the image
* 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

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

|-
|| Show Slide
Modify a Linked Image
|| Let us change the color of '''Image 2''', which is linked to the file to greyscale.

|-
|| Switch to Calc
|| 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'''
||
* First let’s save and close '''Personal-Finance-Tracker.ods'''

|-
||
* First, go to the images folder.
* Select Image 2.
* Now, right-click and select Open with GIMP.
||
* Next, go to the images folder.
* Select Image 2.
* Now, right-click and select Open with '''GIMP'''.

|-
|| Point to the picture.
|| '''Image 2 '''opens in '''GIMP'''.

|-
|| Using GIMP change the color to Grayscale.
|| Now let us change the picture from color to greyscale.

|-
|| Save and close the image.
|| Now, let’s save and close the image.

|-
|| Open '''Personal-Finance-Tracker.ods'''.
|| Let us open the '''Personal-Finance-Tracker.ods'''.

|-
|| Point that the image is displayed in grey scale.
|| '''Image 2''' is now displayed in greyscale.

|-
|| Show Slide Number 7
'''Disadvantage of linking'''

* 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
* Have to keep track of the stored location
||
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.

|-
|| Move this image to the right of the spreadsheet
|| Let’s move this image to the right of the spreadsheet

|-
|| Switch to the Ubuntu Desktop >> Double-click on the “Images” folder >> click on “Image 3” file.

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

|-
|| Drag and drop “Image 3” into the spreadsheet on the left side.

|| Now drag and drop the image file directly into your spreadsheet wherever you want to place it.

|-
|| Point to the image in the spreadsheet.

Press CTRL and Z.
|| You will see that the image gets inserted into your document.

Let’s undo this change by pressing '''CTRL '''and '''Z'''.

|-
|| Click on the image in the folder again.
Press and hold “Control +Shift” while dragging the image to the spreadsheet.
|| 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.

|-
|| Point to the “Image 3”.
|| The image file is now linked to the document.

|-
|| Press CTRL and S keys together.
Click Close button to close the Calc file.
|| Let’s save this '''Calc '''file by pressing '''CTRL''' and '''S''' keys together.
Now let’s close this file.

|-
|| Open the folder “Images” on the Desktop.
|| Now let’s go to the folder where the image is located.

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

|-
|| Open “Personal Finance Tracker.ods”
|| Now open the “Personal Finance Tracker.ods” file again.

|-
|| Point to the blank area where the image is disappeared.
|| You can see that the linked image is no longer visible!
The linked path shows an error!

|-
|| Delete the link from the document.
|| Let us delete this link.

|-
|| Show Slide
Assignment
Insert an image as a link in a Calc sheet, save and close it.
Now, go the folder where the image is stored and delete the image.
Open 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.

|| Pause this tutorial and do this assignment.
Insert an image as a link in a '''Calc '''sheet, save and close it.
Now, go the folder where the image is stored and delete the image.
Open 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.

|-
|| Point to the “Picture” toolbar below the “Standard” toolbar.
|| Notice a new toolbar just below the “'''Standard'''” toolbar. This is the “'''Picture'''” toolbar.

|-
||
Click on the “Filter” button >> Point to the different options >> Click on “Invert” option.
|| The “'''Filter'''” button at the top left of the “'''Picture'''” toolbar gives several options

to change the look of the image.
<pause>
Let’s undo this by pressing '''CTRL '''and '''Z'''.

|-
|| Click on the “Graphics mode” button and point to all the options listed.
|| The “'''Graphics mode'''” button has options to change the image into grayscale, black-and-white or as a watermark.

|-
|| Point to the other options.
|| 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.

|-
|| Create a new spreadsheet and name it “abc.ods”.
|| Lets create a new spreadsheet and name it as “'''abc.ods'''”.

This is our target document.

|-
|| Switch to “Personal-Finance-Tracker.ods” file
|| We already have an image in our “'''Personal-Finance-Tracker.ods'''” file.

This is our source document.

|-
|| Select image “Image1” from “Personal-Finance-Tracker.ods”
|| Now select the image from the source file which is to be copied.

|-
|| Press “Control” and “C” keys together
|| Press “'''CTRL'''” and “'''C'''” keys together to copy the image.

The image is now saved on the clipboard.

|-
|| Switch to “abc.ods”.

|| Now switch to the target document, which is “'''abc.ods'''”.

|-
|| Select any suitable cell location.
|| Select the location where you wish to place your saved image in “'''abc.ods'''”.

|-
|| Press “Control +V” keys together
|| Now press “'''CTRL'''” and “'''V'''” keys together to insert the image into the document.

|-
|| Point to the inserted image.
|| We see that the image is inserted into our target file.
<pause>

|-
||

|| Now we will learn how to insert images directly from the '''Calc Gallery'''.

|-
|| Point to the Gallery icon
|| “'''Gallery'''” has image as well as sounds which you can insert into your spreadsheet.

|-
|| Switch to “Personal-Finance-Tracker.ods”
|| Let’s see how to do this.

|-
|| Click on the “Gallery” icon in the standard toolbar.
Click on “Tools”>> Point to the “Gallery”
|| 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.

|-
||

Click on the second background tile.
|| Now go through the images which the “'''Gallery'''” provides and click on the image you want to insert into your document.

|-
|| Drag and drop image on a suitable cell.
|| Drag the image from the “'''Gallery” '''

and drop it into the spreadsheet where you want to insert it.

|-
|| Point to the image inserted.
|| You see that the image gets inserted into our “'''Personal-Finance-Tracker.ods'''” file.

|-
|| Show Slide number 8

'''SUMMARY'''

* Insert an image file into a spreadsheet in many different ways like
** From a file
** From the clipboard
** From the gallery

|| This brings us to the end of this spoken tutorial on ''''''LibreOffice Calc''''''.

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

|-
|| Acknowledgements.
||

|-
|| Show About Slide

About the Spoken Tutorial Project

* Watch the video available at http://spoken-tutorial.org/What_is_a_Spoken_Tutorial

* It summarises the Spoken Tutorial project

* If you do not have good bandwidth, you can download and watch it
||

* Watch the video available at the following link

* It summarises the Spoken Tutorial project

*If you do not have good bandwidth, you can download and watch it
|-
|| Show About Slide

Spoken Tutorial Workshops

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@spoken-tutorial.org
||

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
|-
|| Show Acknowledgement Slide

Acknowledgements

* 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

* http://spoken-tutorial.org/NMEICT-Intro
||

*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
|-
|| Show About the contributor Slide

About the Contributor

* This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd

* www.desicrew.in

* Thanks for joining
||

*This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd

* Thanks for joining
|-
|}

LibreOffice-Suite-Calc/C3/Images-and-Graphics/English - Revision history

Chandrika: Created page with '=Resources for recording= Images and graphics in Calc {| border=1 || '''VISUAL CUE''' || '''NARRATION''' |- || Show Slide Number 1 …'