Changes

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|1366x1366px|Insert data, row and column fields|right]]{{Clear}}

*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|800x800px|Insert data, row and column fields|left]]{{Clear}}

==== Printing a spreadsheet ====

==== Printing a spreadsheet ====

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

[[File:LO_Calc_9_Adding_Page_Header_before_printing.png|800x800px|left|Adding Page Header before printing]]  

Formatting a sheet for printing is not an easy task. To make it simpler, some tips are:

Formatting a sheet for printing is not an easy task. To make it simpler, some tips are:

# Use the ‘text wrap’ feature to wrap all the text input in a cell so that it won’t overflow to the next cell.

# Use the ‘text wrap’ feature to wrap all the text input in a cell so that it won’t overflow to the next cell.