Computing

Version 6.0.5.2 (Calc)

To specify a data range
1. Select the data range. Do one of the following:
Enter the data range in the text box.
In Calc, an example data range would be "$Sheet1.$B$3:$B$14". Note that a data range may consist of more than one region in a spreadsheet, e.g. "$Sheet1.A1:A5;$Sheet1.D1:D5" is also a valid data range. In Writer, an example data range would be "Table1.A1:E4".
In Calc, click Select data range to minimise the dialogue box, then dragover a cell area to select the data range.
If you want a data range of multiple cell areas that are not next to each other, enter the first range, then manually add a semicolon at the end of the text box, then enter the other ranges. Use a semicolon as delimiter between ranges.

The highlighted text above dose not work with the semicolon but did work with a comma