1,327
edits
Changes
Jump to navigation
Jump to search
Line 149:
Line 149: − + Line 201:
Line 201: − + − File:LO_Calc_9_Adding_Page_Header_before_printing.png|Adding Page Header before printing + + − + − File:Margins in Print Preview.png|Click on Margin − File:Margin Movement.png|The Margin can be moved by dragging
→Printing a spreadsheet
{{Clear}}
{{Clear}}
<br>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. <br>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. 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. 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.
<br>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. <br>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. 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. 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.
{{clear}}
{{clear}}
{{Clear}}
{{Clear}}
==== Printing a spreadsheet ====
==== Adding Page Header or Footer ====
<gallery mode="packed" heights="320">
<gallery mode="packed" heights="320">
</gallery>
</gallery>
[[File:LO Calc Header Footer1.png|thumb|Header and Footer option in Print Preview]]
[[File:LO Calc Header Footer2.png|thumb|Adding Header/Footer]]
{{clear}}
{{clear}}
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 the user the broader idea of how the printed material look like.
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 the user the broader idea of how the printed material looks like.
<gallery mode="packed" heights="250">
<gallery mode="packed" heights="250">
</gallery>
</gallery>
* 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.