Changes

{{clear}}

{{clear}}

=== Navigating a spreadsheet ===

==== Navigating a spreadsheet ====

<gallery mode="packed" heights="350">

<gallery mode="packed" heights="350">

File:Cal step 2.png|Navigation from various sheets

File:Cal step 2.png|Navigation from various sheets

* Columns and rows can be inserted or deleted or hidden in a spreadsheet. You can right click anywhere on the spreadsheet and insert/ delete rows and columns. You can also go to Sheet menu and insert rows/ columns.  <br>

* Columns and rows can be inserted or deleted or hidden in a spreadsheet. You can right click anywhere on the spreadsheet and insert/ delete rows and columns. You can also go to Sheet menu and insert rows/ columns.  <br>

=== Inserting a new sheet ===

==== Inserting a new sheet ====

<gallery mode="packed" heights="200">

<gallery mode="packed" heights="200">

File:Insert a sheet.png|Inserting a new sheet

File:Insert a sheet.png|Inserting a new sheet

{{clear}}

{{clear}}

=== Formatting a spreadsheet ===

==== Formatting a spreadsheet ====

<gallery mode="packed" heights="350">

<gallery mode="packed" heights="350">

File:LO Calc 6 Formatting numbers.png| Formatting in Calc

File:LO Calc 6 Formatting numbers.png| Formatting in Calc

To Split a merged cell, right click on the merged cell and click "split cell".

To Split a merged cell, right click on the merged cell and click "split cell".

=== Freeze or Unfreeze rows and columns ===

==== Freeze or Unfreeze rows and columns ====

 

If you enter data for a large number of rows or columns, you will not be able to read the row/column headings. To be able to see the column (and row) headings, you should move your cursor to the cell above which (and to the left of which) you want to be able to see your headings and click on "View --> Freeze Cells --> Freeze Rows and Columns".<gallery mode="packed" heights="320">

If you enter data for a large number of rows or columns, you will not be able to read the row/column headings. To be able to see the column (and row) headings, you should move your cursor to the cell above which (and to the left of which) you want to be able to see your headings and click on "View --> Freeze Cells --> Freeze Rows and Columns".<gallery mode="packed" heights="320">

{{clear}}

{{clear}}

=== Sorting the data ===

==== Sorting the data ====

<gallery mode="packed" heights="320">

<gallery mode="packed" heights="320">

File:LO_Calc_4_Sorting_data.png|Sorting the Data

File:LO_Calc_4_Sorting_data.png|Sorting the Data

{{clear}}

{{clear}}

=== Preparing charts and graphs===

==== Preparing charts and graphs====

<gallery mode="packed" heights="200px">  

<gallery mode="packed" heights="200px">  

#In the Last window Give the title if you want it to be appeared on the top of the chart. Click "Finish".

#In the Last window Give the title if you want it to be appeared on the top of the chart. Click "Finish".

=== Working with Pivot tables ===

==== Working with Pivot tables ====

The pivot table (formerly known as Data Pilot) allows you to combine, compare, and analyze large amounts of data. You can view different summaries of the source data, you can display the details of areas of interest, and you can create reports. A table that has been created as a pivot table is an interactive table. Data can be arranged, rearranged or summarized according to different points of view.

The pivot table (formerly known as Data Pilot) allows you to combine, compare, and analyze large amounts of data. You can view different summaries of the source data, you can display the details of areas of interest, and you can create reports. A table that has been created as a pivot table is an interactive table. Data can be arranged, rearranged or summarized according to different points of view.

<gallery mode="packed" heights="250">

<gallery mode="packed" heights="250">

{{Clear}}

{{Clear}}

=== Print Preview ===

==== Print Preview ====

Before printing any document you must make sure about the overall preview of the page. So get that you can click on "File--> Print Preview". This gives user the broader idea of how the printed material looks like.

Before printing any document you must make sure about the overall preview of the page. So get that you can click on "File--> Print Preview". This gives user the broader idea of how the printed material looks like.

[[File:LO Calc Margin.png|thumb|Setting the margin ]]

[[File:LO Calc Margin.png|thumb|Setting the margin ]]

# Use "Format --> Page" option to insert header / footer information, such as file name, page number etc. <br>Use "Print preview" feature to keep checking if the formatting is satisfactory <br>

# Use "Format --> Page" option to insert header / footer information, such as file name, page number etc. <br>Use "Print preview" feature to keep checking if the formatting is satisfactory <br>

=== Adding Page Header or Footer ===

==== Adding Page Header or Footer ====

<gallery mode="packed" heights="300">

<gallery mode="packed" heights="300">

File:LO Calc Header Footer.png|Header/Footer option in Print Preview

File:LO Calc Header Footer.png|Header/Footer option in Print Preview

{{clear}}

{{clear}}

=== Saving the files and formats ===

==== Saving the files and formats ====

# Like in most applications, a file can be saved using the File –-> Save command, or by the shortcut key Ctrl+S. Always give a meaningful file name, reading which you should get an idea of the file contents. This file has been named “''Rainfall information for cities in South India, October 2016.ods''”. Often adding the month-year information when the file was created can be useful later.

# Like in most applications, a file can be saved using the File –-> Save command, or by the shortcut key Ctrl+S. Always give a meaningful file name, reading which you should get an idea of the file contents. This file has been named “''Rainfall information for cities in South India, October 2016.ods''”. Often adding the month-year information when the file was created can be useful later.

# The files will be saved as ".ods". You can save a spreadsheet as a Microsoft Excel format also ("File --> Save As").

# The files will be saved as ".ods". You can save a spreadsheet as a Microsoft Excel format also ("File --> Save As").

To do this, "File --> Export as PDF". A window appears which lets you to change the default settings. You can do the required changes and click "Export". In the next window it asks you to give the path where to export the file.

To do this, "File --> Export as PDF". A window appears which lets you to change the default settings. You can do the required changes and click "Export". In the next window it asks you to give the path where to export the file.

== Advanced features ==

==== Advanced features ====

* Calc is a very sophisticated software application and can even be used as a database, by cross referring data across sheets and books.  

* Calc is a very sophisticated software application and can even be used as a database, by cross referring data across sheets and books.  

* You can also generate multi-variate tables using the 'Pivot' feature.  

* You can also generate multi-variate tables using the 'Pivot' feature.  

* Vlookup is an interesting feature with which you can query for a particular information using a simple syntax.  

* Vlookup is an interesting feature with which you can query for a particular information using a simple syntax.  

==Ideas for resource creation==

===Ideas for resource creation===

# Calc can be used for analyzing data sets generated by your students as part of projects. Large secondary data sets can also be analyzed.  Some of these project ideas include information about family members, houses in the area, crops / vegetation in the area, goods sold and prices in local shop and programs of the local government and budgets etc. The collected information can be analyzed and published in tabular cum graph formats.  

# Calc can be used for analyzing data sets generated by your students as part of projects. Large secondary data sets can also be analyzed.  Some of these project ideas include information about family members, houses in the area, crops / vegetation in the area, goods sold and prices in local shop and programs of the local government and budgets etc. The collected information can be analyzed and published in tabular cum graph formats.  

# Spreadsheets are also useful for helping solving numeric puzzles by setting up formulas and extrapolating.  

# Spreadsheets are also useful for helping solving numeric puzzles by setting up formulas and extrapolating.  

==References==

===References===

#[https://en.wikipedia.org/wiki/LibreOffice_Calc Wikipedia]

#[https://en.wikipedia.org/wiki/LibreOffice_Calc Wikipedia]

#[https://help.libreoffice.org/scalc/.uno:HelpIndex?Language=en-US&System=UNIX&Version=5.2 User manual for LO Calc]  

#[https://help.libreoffice.org/scalc/.uno:HelpIndex?Language=en-US&System=UNIX&Version=5.2 User manual for LO Calc]