Difference between revisions of "LibreOffice-Calc-on-BOSS-Linux/C2/Introduction-to-LibreOffice-Calc/English-timed"

||* Introduction to LibreOffice Calc.

||* Various toolbars in LibreOffice Calc.

||* How to open a new document in Calc.

||* How to open an existing document

||* How to save and Close a document in Calc.

||It is a free and open source software. So it can be copied, reused and distributed free of cost.

||For more information on Synaptic Package Manager, please refer to the GNU/Linux Tutorials on this website and download LibreOffice Suite by following the instructions on this website.

||Remember, when installing use the “Complete” installation for '''Calc'''.

||The '''document''' in '''Calc''' is called a '''workbook'''. A workbook contains many sheets called as spreadsheets.

||Each spreadsheet consists of '''cells''' arranged in rows and columns. Each row is identified by a number and each column by an alphabet.

||'''Cells''' can hold information like text, numbers, formulas, and many more '''data elements''' for display and manipulation.

||Each '''spreadsheet''' can have many '''sheet'''s and each sheet can have little more than one million rows and one thousand columns which gives us more than one '''billion''' or hundred crore cells in a single sheet.

||The '''Calc window''' has various toolbars like the '''title bar''', the '''menu bar''', the '''standard toolbar''', the '''formatting bar''', the '''formula bar''' and the '''status bar'''.

||Now you can see three sheet tabs at the bottom left corner of the spreadsheet namely, “Sheet1”, “Sheet 2” and “Sheet 3”.

||These tabs enable access to each individual sheet with the visible sheet having a white tab.

||The main section of the spreadsheet where the data is entered contains various cells in the form of a grid.  Each cell is at the intersection of a column and a row.

||The columns start at “A” and go on to the right and the rows start at “1” and go down.

||These column and row headers form the cell references that appear in the '''Name Box''' field.

||You can open a new document by clicking on the '''New''' icon in the standard toolbar or by clicking on the '''File''' option in the menu bar and then clicking on the '''New''' option and then finally clicking on the '''Spreadsheet''' option.

||You see that a new Calc window opens up in both the cases.

||Now we will learn how to build a “Personal Finance Tracker” in the spreadsheet.

||Let us see how to enter a data in a few of the cells in a spreadsheet.

||So click on the cell referenced as A1 in the first sheet of the spreadsheet.

||Let us type the heading as “SN” which denotes the serial number of the items which we will represent in the spreadsheet.

||Now click on the cell referenced as B1 and type another heading as “Items”.

||Similarly, click on the cells C1, D1, E1, F1 and G1 one after the other and write the headings as “Cost”, “Spent”, “Received”, “Date” and “Account” respectively.

||Once done writing your spreadsheet you should save it for future use.

||To save this file, click on “File” in the menu bar and then click on the “Save As” option.

||A dialog box appears on the screen where you are required to enter the name of your file under the “Name” field.

||So enter the name of the file as “Personal Finance Tracker”.   

||Below the “Name” field you have the “Save in folder” field where you are required to enter the folder name which will contain your saved file.

||So click on the down arrow in the “Save in folder” field.

||A list of folder options appears. Here we can choose the folder where we want our file to be saved.

||We click on the “Desktop” option.

||So the file will be saved on the desktop.

||Now click on the “File type” option in the dialog box.

||It shows you a list of file type options or file extensions under which you can save your file.

||The default file type in LibreOffice Calc is the “ODF Spreadsheet” which provides the extension “dot ods”.

||ODF stands for Open Document Format which is an open standard.

||Besides saving in dot ods format which can be opened in LibreOffice Calc, you can also save your file in dot xml, dot xlsx and in dot xls format which can be opened in the MS Office Excel program.

||Another popular file extension which opens in most programs is dot csv.  

||This is often used to store spreadsheet data in a text file format, which reduces the file size hugely and is easily portable.

||We will click on the “ODF Spreadsheet” option.

||You see that the file type, “ODF Spreadsheet and within brackets, dot ods” gets displayed next to the “File type” option.

||Click on the “Save” button.

||In addition to the above formats discussed, the spreadsheet can also be saved in “dot html” format which is a web page format.

||This is done in the same way as explained before. .

||So click on the “File” option in the menu bar and then click on the “Save As” option.

||Now click on the ”File Type” option, and then click on the “HTML Document and within braces OpenOffice dot org Calc” option.

||This option gives the “dot html” extension to the document.

||Click on the “Save” button.

||Now put a check on the “Ask when not saving in ODF format” option in the dialog box.

||Finally click on the “Keep Current Format” option.

||You see that the document gets saved with dot html extension.

||This format is used when we want to show our spreadsheet as a web page that can be opened by a web browser program.

||The document can also be exported to PDF format by simply clicking on the “Export Directly as PDF” option in the standard tool bar.  

||As before,  choose the location where you wish to save.

||Alternately you can do so by clicking on the “File” option in the menu bar and then clicking on the “Export as pdf” option.

||In the dialog box which appears, click on the “Export” option and then click on the “Save” button.

||A pdf file will be created.

||Lets close this document by clicking on File and then Close.  

||Next we will learn how to open an existing document in LibreOffice Calc.

||To open an existing document, click on the “File” menu in the menu bar at the top and then click on the “Open” option.

||A dialog box appears on the screen.

||Here find the folder where you saved your document.

||So click on the small pencil button at the top left corner of the dialog box. It has the name, “Type a file name”.

||This opens a “Location Bar” field.

||So we type the name of the file as “Personal Finance Tracker”.

||Now in the list of file names that appears, choose “Personal Finance Tracker dot ods”.

||Now click on the “Open” button.

||You see that the file Personal Finance Tracker.ods opens.

||Alternately you can open an existing file by clicking on the “Open” icon in the toolbar at the top and doing the further process in the same manner.

||You can also open files with “dot xls” and “dot xlsx” extensions which are used by Microsoft Excel in Calc.

||Next you will see how to modify a file and save it under the same file name.

||So let us modify the file by making the headings bold and increasing their font size.

||So first click on the cell referenced as A1. Select the headings “SN”, “Cost”, “Spent”, “Received”,  “Date” and “Account” by clicking on the left mouse button and then dragging it along all the headings.

||This will select the text and highlight it. Now release the left mouse button. The text should still be highlighted. Now click on the “Bold” icon in the standard toolbar.

||The headings thus become bold.

||Now let us increase the font size of the headings.

||So lets select the headings and then click on the “Font Size” field in the toolbar.

||In the drop down menu, let us choose “14”.

||So you see that the font size of the headings increases.

||Now let us change the font style we are using.

||So click on the down arrow in the “Font Name” field and then select “Bitstream Charter” as the font name.

||After making the required modifications, click on the “Save” icon.

||Once you have saved your document and you wish to close it, just click on the “File” menu in the menu bar and click on the “Close” option.

||How to open an existing document.

||How to save and Close a document in Calc.  

||COMPREHENSIVE ASSIGNMENT Open a new document in Calc.

|| Save it under the name “Spreadsheet Practice.ods”  

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

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

||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 Desi Crew Pvt.Ltd.

  Thanks for joining