1,089
edits
Changes
Jump to navigation
Jump to search
Line 119:
Line 119: − + Line 179:
Line 179: − + Line 193:
Line 193: − +
→Formatting a spreadsheet
{{clear}}
{{clear}}
Formatting a spreadsheet involves two important formats.
Formatting a spreadsheet involves two important formats.
* Text formatting : Most of the formatting options available in LibreOffice Writer are available in Calc also. Making the text bold, italicized, increasing/reducing font size, font color etc are all available. Data can also be formatted based on what it represents - date, time, currency, etc. The numeric information display format in terms of "000" separators or number of decimal places can be configured.
* Text formatting : Text formatting involves making the text bold, italicized, increasing/reducing font size, font color etc. Data can also be formatted based on what it represents - date, time, currency, etc. The numeric information display format in terms of "000" separators or number of decimal places can be configured.
* Alignment of Text inside the cell : Since Calc gives much importance for cells, the text alignment inside the cell also needs to be taken care of. Such alignments can be Top, center and bottom. Wrap text option allows the text which gone out of the cell to be aligned within the cell boundary.
* Alignment of Text inside the cell : Since Calc gives much importance for cells, the text alignment inside the cell also needs to be taken care of. Such alignments can be Top, center and bottom. Wrap text option allows the text which gone out of the cell to be aligned within the cell boundary.
</gallery>
</gallery>
# Position the cursor within a range of cells containing values, row and column headings.
# Position the cursor within a range of cells containing values, row and column headings.
# Choose "Insert --> Pivot Table --> Create". The Select Source dialog appears. Choose Current selection and confirm with OK. The table headings are shown as
# Choose "Insert --> Pivot Table --> Create". The Select Source dialog appears. Choose Current selection and confirm with OK.
# 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>Drag the desired buttons into one of the four areas.<br><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>Drag the desired buttons into one of the four areas.<br><br>
<gallery mode="packed" heights="250">
<gallery mode="packed" heights="250">
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 '''"'''DataField" dialog.
* By double-clicking on one of the fields in the "Data Fields" area you can call up the '''"'''DataField" 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.
* 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}}
{{Clear}}