This dialog can be used to fill a column with a
numerical sequence within groups defined by another selected factor column.
The pattern or sequence of numbers which is used to fill each group,
and is inserted from row 1 onwards, and is repeated as necessary to fill
each group. If the length of a group is not an exact multiple of the pattern
length, the remainder of the group will be filled with part of the pattern.
Column
Select a column from the drop-down list to have the cells
filled with the numerical sequence.
Within Groups defined by Factor
List of factors within the current spreadsheet that can be used to define the groups.
Each group will have an identical, but independent sequence applied to the
corresponding column that is to be filled.
Starting Value
First value in the sequence.
Ending Value
Last value in the sequence. If this differs from the Starting Value
by an exact number of Increments it will be included in the
pattern, otherwise the pattern will terminate at the value less than the ending value (greater than in the case
of a negative increment).
Increment
The increment used to form intermediate values in the sequence. A negative
increment must be specified if the Starting Value
is greater than the Ending Value.
Number of Repeats
Allows a pre-multiplier to be applied to the sequence, so that each element
is repeated the specified number of times.
Ignore restrictions/filters
When selected, rows that have been restricted/filtered will be excluded
from the cells filled. The sequence of values will be inserted into the
cells, jumping over the filtered/restricted cells, so if units 2 and 5
are restricted you will get the sequence 1 * 2 3 * 4.
Fill Selected Rows only
When selected, only the cells in the column that belong in the currently selected
rows will be filled. This option is only available if there is a row selection defined on
the sheet before opening the dialog.
Preview
This list illustrates the sequence of numbers that will be inserted
in to the column. For very long sequences, the list only displays
the first 20 and last 20 items, separated by a '...' item.
OK
Use the specified sequence to fill the column and close the dialog.
Apply
Use the specified sequence to fill the column
and leave the dialog open for another fill operation.
Cancel
Close the dialog without making any changes.
See Also
Spreadsheet Column Fill
Fill a Column using a List
Fill a Column with Dates or Times
Spreadsheet Calculate Menu