Changes

==== Inserting formulae for computations====

==== Inserting formulae for computations====

[[File:LO Calc 3 Processing the data Summing up rainfall information.png|500px|left]]  

[[File:LO Calc 3 Processing the data Summing up rainfall information.png|800x800px|left]]  

You can do almost any kind of computation or processing with a spreadsheet. Here we will calculate the total rainfall for the cities. You can go to the cell below last row with data in Column B, which has the rainfall information and simply type in “=Sum(B2:B15)” assuming the data is in rows 2 through 15 of column B. Any computation or formula must begin with the “=” sign. Or you can simply use the shorthand icon on the menu bar “∑” and hit enter and the application will insert the same formula.<br>

You can do almost any kind of computation or processing with a spreadsheet. Here we will calculate the total rainfall for the cities. You can go to the cell below last row with data in Column B, which has the rainfall information and simply type in “=Sum(B2:B15)” assuming the data is in rows 2 through 15 of column B. Any computation or formula must begin with the “=” sign. Or you can simply use the shorthand icon on the menu bar “∑” and hit enter and the application will insert the same formula.

 

 

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

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>

All arithmetic operations, statistical operations are possible with spreadsheet. <br>

{{clear}}

{{clear}}

==== Sorting the data ====

==== Sorting the data ====

[[File:LO_Calc_4_Sorting_data.png|500px|left]]  

[[File:LO_Calc_4_Sorting_data.png|800x800px|left]]  

You can sort the data in anyway you want. You could sort it on the descending order of the rainfall (Column B) to see the data by the cities with the heaviest rainfall at the top. You can sort the data by cities (Column B).

You can sort the data in anyway you want. You could sort it on the descending order of the rainfall (Column B) to see the data by the cities with the heaviest rainfall at the top. You can sort the data by cities (Column B).

remember that you should select the entire sheet (Edit – Select All, or simply CTRL-A) or keep the cursor on a single cell, else you may sort only the data selected which will be incorrect.

remember that you should select the entire sheet (Edit – Select All, or simply CTRL-A) or keep the cursor on a single cell, else you may sort only the data selected which will be incorrect.

File:2. LO Calc Pivot 2. Inserting pivot.png|Inserting Pivot

File:2. LO Calc Pivot 2. Inserting pivot.png|Inserting Pivot

</gallery>

</gallery>

1. Position the cursor within a range of cells containing values, row and column headings. <br>  

1. Position the cursor within a range of cells containing values, row and column headings. <br>2. Choose Insert - Pivot Table - Create. The Select Source dialog appears. Choose Current selection and confirm with OK. The table headings are shown as <br><gallery mode="packed" heights="280px" "caption="Adding the fields">  File:3. LO Calc Data Pivot 3. Current Selection.png|Selection wizard File:4. LO Calc Data Pivot 4. Pivot form.png|Pivot Table wizard </gallery>

2. Choose Insert - Pivot Table - Create. The Select Source dialog appears. Choose Current selection and confirm with OK. The table headings are shown as <br> <gallery mode="packed" heights="280px" "caption="Adding the fields">  File:3. LO Calc Data Pivot 3. Current Selection.png|Selection wizard File:4. LO Calc Data Pivot 4. Pivot form.png|Pivot Table wizard </gallery>

The table headings are shown as buttons in the Pivot Table dialog. Drag these buttons as required and drop them into the layout areas "Page Fields", "Column Fields", "Row Fields" and "Data Fields". <br>3. Drag the desired buttons into one of the four areas. <br>

The table headings are shown as buttons in the Pivot Table dialog. Drag these buttons as required and drop them into the layout areas "Page Fields", "Column Fields", "Row Fields" and "Data Fields". <br>

3. Drag the desired buttons into one of the four areas. <br>

Drag a button to the '''Page Fields''' area to create a button and a listbox on top of the generated pivot table. The listbox can be used to filter the pivot table by the contents of the selected item. You can use drag-and-drop within the generated pivot table to use another page field as a filter. <br>

Drag a button to the '''Page Fields''' area to create a button and a listbox on top of the generated pivot table. The listbox can be used to filter the pivot table by the contents of the selected item. You can use drag-and-drop within the generated pivot table to use another page field as a filter. <br>

If the button is dropped in the '''Data Fields''' area it will be given a caption that also shows the formula that will be used to calculate the data. <br>

If the button is dropped in the '''Data Fields''' area it will be given a caption that also shows the formula that will be used to calculate the data. <br>

* By double-clicking on one of the fields in the '''Data Fields''' area you can call up the [[Vnd.sun.star.help://scalc/text/scalc/01/12090105.xhp?Language=en-US&System=UNIX&UseDB=no&DbPAR=scalc|'''Data Field''']] dialog.

* By double-clicking on one of the fields in the '''Data Fields''' area you can call up the [[Vnd.sun.star.help://scalc/text/scalc/01/12090105.xhp?Language=en-US&System=UNIX&UseDB=no&DbPAR=scalc|'''Data Field''']] dialog.

* Use the '''Data Field''' dialog to select the calculations to be used for the data. To make a multiple selection, press the Ctrl key while clicking the desired calculation.

*[[File:Insert data, row and column fields.png|left|800x800px|Insert data, row and column fields]]Use the '''Data Field''' dialog to select the calculations to be used for the data. To make a multiple selection, press the Ctrl key while clicking the desired calculation.{{Clear}}

 

==== Printing a spreadsheet ====

==== Printing a spreadsheet ====