diff --git a/source/text/scalc/01/02140000.xhp b/source/text/scalc/01/02140000.xhp index 2c93bcc03c..8b4a5f2284 100644 --- a/source/text/scalc/01/02140000.xhp +++ b/source/text/scalc/01/02140000.xhp @@ -40,13 +40,12 @@

Sheet

Series

- - Filling cells using context menus: - +

+ +

Filling cells using context menus

+ You can reuse the values in the current column to fill the cell. Call the context menu when positioned in a cell and choose Selection List. diff --git a/source/text/scalc/01/02140100.xhp b/source/text/scalc/01/02140100.xhp index 87d7aabfb5..044f608b6e 100644 --- a/source/text/scalc/01/02140100.xhp +++ b/source/text/scalc/01/02140100.xhp @@ -1,6 +1,4 @@ - - - -Down +Fill Down /text/scalc/01/02140100.xhp @@ -30,16 +27,15 @@ - - + +

- -

Down

- Fills a selected range of at least two rows with the contents of the top cell of the range. +

Fill Down

+ Fills a selected range of at least two rows with the contents of the top cell of the range.

- If a selected range has only one column, the contents of the top cell are copied to all others. If several columns are selected, the contents of the corresponding top cell will be copied down. + If a selected range has only one column, the contents of the top cell are copied to all others. If several columns are selected, the contents of the corresponding top cell will be copied down. diff --git a/source/text/scalc/01/02140200.xhp b/source/text/scalc/01/02140200.xhp index 032a93d93c..22ef3e1821 100644 --- a/source/text/scalc/01/02140200.xhp +++ b/source/text/scalc/01/02140200.xhp @@ -1,6 +1,4 @@ - - - -Right +Right /text/scalc/01/02140200.xhp @@ -30,16 +27,14 @@ - - +

- -

Right

- Fills a selected range of at least two columns with the contents of the left most cell. +

Fill Right

+ Fills a selected range of at least two columns with the contents of the left most cell.

- If a range of only one row is selected, the contents of the far left cell are copied to all the other selected cells. If you have selected several rows, each of the far left cells is copied into those cells to the right. + If a range of only one row is selected, the contents of the far left cell are copied to all the other selected cells. If you have selected several rows, each of the far left cells is copied into those cells to the right. diff --git a/source/text/scalc/01/02140300.xhp b/source/text/scalc/01/02140300.xhp index e9757cc929..deba5fca6b 100644 --- a/source/text/scalc/01/02140300.xhp +++ b/source/text/scalc/01/02140300.xhp @@ -1,6 +1,4 @@ - - + + + + Up + /text/scalc/01/02140300.xhp + + + Sun Microsystems, Inc. + + + - - - -Up -/text/scalc/01/02140300.xhp - - -Sun Microsystems, Inc. - - - - - -

- -

Up

- Fills a selected range of at least two rows with the contents of the bottom most cell. -

- If a selected range has only one column, the content of the bottom most cell is copied into the selected cells. If several columns are selected, the contents of the bottom most cells are copied into those selected above. + +

Fill Up

+ Fills a selected range of at least two rows with the contents of the bottom most cell. +

+ If a selected range has only one column, the content of the bottom most cell is copied into the selected cells. If several columns are selected, the contents of the bottom most cells are copied into those selected above. diff --git a/source/text/scalc/01/02140400.xhp b/source/text/scalc/01/02140400.xhp index 36a8c51445..dd4cf14ac8 100644 --- a/source/text/scalc/01/02140400.xhp +++ b/source/text/scalc/01/02140400.xhp @@ -1,6 +1,4 @@ - - - - - - -Left -/text/scalc/01/02140400.xhp - - -Sun Microsystems, Inc. - - - - - -

- -

Left

- Fills a selected range of at least two columns with the contents of the far right cell. -

- If a selected range has only one row, the content of the far right cell is copied into all other cells of the range. If several rows are selected, the far right cells are copied into the cells to the left. + + + + Left + /text/scalc/01/02140400.xhp + + + Sun Microsystems, Inc. + + + + +

Fill Left

+ Fills a selected range of at least two columns with the contents of the far right cell. +

+ If a selected range has only one row, the content of the far right cell is copied into all other cells of the range. If several rows are selected, the far right cells are copied into the cells to the left. diff --git a/source/text/scalc/01/02140500.xhp b/source/text/scalc/01/02140500.xhp index f63102b898..d6fae339b4 100644 --- a/source/text/scalc/01/02140500.xhp +++ b/source/text/scalc/01/02140500.xhp @@ -19,35 +19,37 @@ --> - Fill Sheets + Fill Sheets /text/scalc/01/02140500.xhp - -

Fill Sheets

-Specifies the options for transferring sheets or ranges of a certain sheet to the same cells on other selected sheets. + +

Fill Sheets

+ Specifies the options for transferring sheets or ranges of a certain sheet to the same cells on other selected sheets. +

-This menu command is only active if you have selected at least two sheets in the document. -To select multiple sheets, click each sheet tab while pressing CommandCtrl or Shift. -In contrast to copying an area to the clipboard, you can filter certain information and calculate values. +This menu command is only active if you have selected at least two sheets in the document. +To select multiple sheets, click each sheet tab while pressing CommandCtrl or Shift. +In contrast to copying an area to the clipboard, you can filter certain information and calculate values.

Filling a Sheet

- - - Select the entire sheet by clicking the empty gray box in the upper left of the sheet. You can also select an area of the sheet to be copied. - - - Press CommandCtrl and click the tab of the sheet where you want to insert the contents. - - - Select the command Sheet - Fill Cells - Sheets. In the dialog which appears, the check box Numbers must be selected (or Paste All) if you want to combine operations with the values. You can also choose the desired operation here. - - - Click OK. - - - This dialog is similar to the Paste Special dialog, where you can find additional tips. + + + Select the entire sheet by clicking the empty gray box in the upper left of the sheet. You can also select an area of the sheet to be copied. + + + Press CommandCtrl and click the tab of the sheet where you want to insert the contents. + + + Select the command Sheet - Fill Cells - Sheets. In the dialog which appears, the check box Numbers must be selected (or Paste All) if you want to combine operations with the values. You can also choose the desired operation here. + + + Click OK. + + +This dialog is similar to the Paste Special dialog, where you can find additional tips. diff --git a/source/text/scalc/01/02140600.xhp b/source/text/scalc/01/02140600.xhp index 3ee6a542da..15584eeb39 100644 --- a/source/text/scalc/01/02140600.xhp +++ b/source/text/scalc/01/02140600.xhp @@ -20,96 +20,99 @@ - Fill Series + Fill Series /text/scalc/01/02140600.xhp - - - + + + -

Fill Series

-Automatically generate series with the options in this dialog. Determine direction, increment, time unit and series type. -Before filling a series, first select the cell range. +

Fill Series

+Automatically generate series with the options in this dialog. Determine direction, increment, time unit and series type. +

+ +Before filling a series, first select the cell range.

-To automatically continue a series using the assumed completion rules, choose the AutoFill option after opening the Fill Series dialog. +To automatically continue a series using the assumed completion rules, choose the AutoFill option after opening the Fill Series dialog.

Direction

-Determines the direction of series creation. - +Determines the direction of series creation. +

Down

-Creates a downward series in the selected cell range for the column using the defined increment to the end value. - +Creates a downward series in the selected cell range for the column using the defined increment to the end value. +

Right

-Creates a series running from left to right within the selected cell range using the defined increment to the end value. - +Creates a series running from left to right within the selected cell range using the defined increment to the end value. +

Up

-Creates an upward series in the cell range of the column using the defined increment to the end value. - +Creates an upward series in the cell range of the column using the defined increment to the end value. +

Left

-Creates a series running from right to left in the selected cell range using the defined increment to the end value. +Creates a series running from right to left in the selected cell range using the defined increment to the end value.

Series Type

-Defines the series type. Choose between Linear, Growth, Date and AutoFill. - +Defines the series type. Choose between Linear, Growth, Date and AutoFill. +

Linear

-Creates a linear number series using the defined increment and end value. - +Creates a linear number series using the defined increment and end value. +

Growth

-Creates a growth series using the defined increment and end value. - +Creates a growth series using the defined increment and end value. +

Date

-Creates a date series using the defined increment and end date. - +Creates a date series using the defined increment and end date. +

AutoFill

-Forms a series directly in the sheet. The AutoFill function takes account of customized lists. For example, by entering January in the first cell, the series is completed using the list defined under %PRODUCTNAME - Preferences +Forms a series directly in the sheet. The AutoFill function takes account of customized lists. For example, by entering January in the first cell, the series is completed using the list defined under %PRODUCTNAME - Preferences Tools - Options - %PRODUCTNAME Calc - Sort Lists. -AutoFill tries to complete a value series by using a defined pattern. The series 1,3,5 is automatically completed with 7,9,11,13, and so on. Date and time series are completed accordingly; for example, after 01.01.99 and 15.01.99, an interval of 14 days is used. - +AutoFill tries to complete a value series by using a defined pattern. The series 1,3,5 is automatically completed with 7,9,11,13, and so on. Date and time series are completed accordingly; for example, after 01.01.99 and 15.01.99, an interval of 14 days is used. +

Unit of Time

-In this area you can specify the desired unit of time. This area is only active if the Date option has been chosen in the Series type area. - +In this area you can specify the desired unit of time. This area is only active if the Date option has been chosen in the Series type area. +

Day

-Use the Date series type and this option to create a series using all seven days of the week. Unit of Increment is day. - +Use the Date series type and this option to create a series using all seven days of the week. Unit of Increment is day. +

Weekday

-Use the Date series type and this option to create a series only using the five weekdays. Unit of Increment is day. - +Use the Date series type and this option to create a series only using the five weekdays. Unit of Increment is day. +

Month

-Use the Date series type and this option to form a series which unit of Increment is month. - +Use the Date series type and this option to form a series which unit of Increment is month. +

Year

-Use the Date series type and this option to create a series which unit of Increment is year. - +Use the Date series type and this option to create a series which unit of Increment is year. +

Start Value

-Determines the start value for the series. Use numbers, dates or times. - +Determines the start value for the series. Use numbers, dates or times. +

End Value

-Determines the end value for the series. Use numbers, dates or times. - +Determines the end value for the series. Use numbers, dates or times. +

Increment

-The term "increment" denotes the amount by which a given value increases. Determines the value by which the series of the selected type increases by each step. Entries can only be made if the linear, growth or date series types have been selected. +The term "increment" denotes the amount by which a given value increases. Determines the value by which the series of the selected type increases by each step. Entries can only be made if the linear, growth or date series types have been selected. diff --git a/source/text/scalc/01/02140700.xhp b/source/text/scalc/01/02140700.xhp index e3d66a88ad..982aa25fa9 100644 --- a/source/text/scalc/01/02140700.xhp +++ b/source/text/scalc/01/02140700.xhp @@ -20,186 +20,189 @@ -Fill Random Numbers +Fill Random Numbers /text/scalc/01/02140700.xhp - - -

Fill Random Numbers

-Populate a cell range with automatically generated pseudo random numbers with the selected distribution function and its parameters. - + + +

Fill Random Numbers

+Populate a cell range with automatically generated pseudo random numbers with the selected distribution function and its parameters. +

+ fill range;random numbers random rumbers;fill range random rumbers;distribution

-Choose Sheet - Fill Cells - Random Number +

Data

Cell Range

- -Define the range of cells to fill with random numbers. If you have previously selected a range, it will be displayed here. + +Define the range of cells to fill with random numbers. If you have previously selected a range, it will be displayed here.

Random number generator

Distribution

- -The distribution function for the random number generator. -Valid distributions function and their parameters are + +The distribution function for the random number generator. +Valid distributions function and their parameters are -Distribution +Distribution -Parameters +Parameters -Uniform +Uniform -Minimum: The minimum value of the sample. +Minimum: The minimum value of the sample. -Maximum: The maximum value of the sample. +Maximum: The maximum value of the sample. -Uniform Integer +Uniform Integer -Minimum: The minimum value of the sample. +Minimum: The minimum value of the sample. -Maximum: The maximum value of the sample. +Maximum: The maximum value of the sample. -Normal +Normal -Mean: The mean of the Normal distribution. +Mean: The mean of the Normal distribution. -Standard Deviation: The standard deviation of the Normal distribution. +Standard Deviation: The standard deviation of the Normal distribution. -The mean and standard deviation of the numbers generated may not equal the Mean and Standard Deviation inserted in the dialog. +The mean and standard deviation of the numbers generated may not equal the Mean and Standard Deviation inserted in the dialog. -Cauchy +Cauchy -Median: the median of the data or location parameter. +Median: the median of the data or location parameter. -Sigma: the scale parameter. +Sigma: the scale parameter. -The median and sigma of the generated numbers may not equal the data inserted in the dialog. +The median and sigma of the generated numbers may not equal the data inserted in the dialog. -Bernoulli +Bernoulli -p Value: The probability of success. +p Value: The probability of success. -Binomial +Binomial -p Value: The probability of success of each trial. +p Value: The probability of success of each trial. -Number of trials: the number of trials of the experiment. +Number of trials: the number of trials of the experiment. -Chi Squared +Chi Squared -Nu Value: a positive integer that specifies the number of degrees of freedom. +Nu Value: a positive integer that specifies the number of degrees of freedom. -Geometric +Geometric -p Value: The probability of success of each trial. +p Value: The probability of success of each trial. -Negative Binomial +Negative Binomial -p Value: The probability of success of each trial. +p Value: The probability of success of each trial. -Number of trials: the number of trials of the experiment. +Number of trials: the number of trials of the experiment. -Poisson +Poisson -Mean: The mean of the Poisson distribution. +Mean: The mean of the Poisson distribution.

Options

Enable custom seed

- -Set the initial value of the random number generator to a known value Seed. + +Set the initial value of the random number generator to a known value Seed.

Seed

- -Value set to initiate the random number generator algorithm. It is used to initialize (seed) the random number generator in order to reproduce the same sequence of pseudorandom numbers. Specify a positive integer number (1, 2, ...) to produce a specific sequence, or leave the field blank if you don't need this particular feature. + +Value set to initiate the random number generator algorithm. It is used to initialize (seed) the random number generator in order to reproduce the same sequence of pseudorandom numbers. Specify a positive integer number (1, 2, ...) to produce a specific sequence, or leave the field blank if you don't need this particular feature.

Enable rounding

- -Round the number to a given number of Decimal Places. + +Round the number to a given number of Decimal Places.

Decimal places

- -Number of decimal places of the numbers generated. + +Number of decimal places of the numbers generated. -- cgit