Changes

* When the cursor is on this cell, the formula will be seen in the ‘formula’ bar on top of the sheet, below the menu.<br>All arithmetic operations, statistical operations are possible with spreadsheet.  

* When the cursor is on this cell, the formula will be seen in the ‘formula’ bar on top of the sheet, below the menu.<br>All arithmetic operations, statistical operations are possible with spreadsheet.  

* You can ‘copy paste’ a formula from one cell to other cells in the same column, here ‘copy paste’ by default will copy paste the formula and not the content. This 'copy' and 'paste' of formula is not useful, when we want to 'fix' one value in our formula.  

* You can ‘copy paste’ a formula from one cell to other cells in the same column, here ‘copy paste’ by default will copy paste the formula and not the content. This 'copy' and 'paste' of formula is not useful, when you want to 'fix' one value in our formula.

* For instance, if we are computing 'Percentage of total' in the example of Average annual rainfall (cms) then, You can input in column ''C2 "=B2*100/B16"''. If you copy this cell C2 to C3, Calc will change the formula to "''=B3*100/B17''", since it will increment both numerator and denominator cells.  

* For instance, if you are computing 'Percentage of total' in the example of Average annual rainfall (cms) then, You can input in column ''C2 "=B2*100/B16"''. If you copy this cell C2 to C3, Calc will change the formula to "''=B3*100/B17''", since it will increment both numerator and denominator cells.

* However consider you want to fix the denominator to '''B16''<nowiki/>'. To 'fix' the reference, you should insert '$' before the cell reference. So you should give formula ''C2 "=B2*100/B$16''" since you want to fix the value in the 16th row. When you copy paste the formula to C3, it will copy as "''=B3*100/B$16''", which is what you want.

* However consider you want to fix the denominator to '''B16''<nowiki/>'. To 'fix' the reference, you should insert '$' before the cell reference. So you should give formula ''C2 "=B2*100/B$16''" since you want to fix the value in the 16th row. When you copy paste the formula to C3, it will copy as "''=B3*100/B$16''", which is what you want.

==== Print Preview ====

==== Print Preview ====

Before printing any document we must make sure about the overall preview of the page. So get that we 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 ]]

* Click on margin icon for the flexible movement of margins in the spreadsheet.

* Click on margin icon for the flexible movement of margins in the spreadsheet.

==== 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. We can name this file “''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").

# Main difference between "Save" and "Save As" is that Save Saves the document whereas Save As saves the document with another name.

# Main difference between "Save" and "Save As" is that Save Saves the document whereas Save As saves the document with another name.