Entering data : Inserting series

Inserting an automatic series (F8)

This will fill a given range of cells with values that can be numbers/dates, formulas, built-in lists (day/month names), custom lists.
The type of the series is determined automatically and it depends on the entered initial one or two cells of that series.

If the first one or two cells don't match any of the above series types, a simple "copy" operation is performed.
If the first two cells are separated by some gap of empty cells, this gap will be duplicated within the rest of the inserted series.

*

Built-in numeric, date/time and formula series

If you specify only one element of the series, GS-Calc will use the following predefined default increments to calculate subsequent elements:
1 for numbers, 1 hours for time values and 1 day for date values, 1 column/row references in formulas.

Both relative and absolute cell references can be modified depending on the current settings in the Settings > Options window.

Choosing a specific custom list to insert series.

Click the "Fill" toolbar button and choose the desirable list or use the "Manage" dialog box and use the "insert" button.

If you choose a specific custom list by name:

*

Inserting formula based series

This enables you to define any type of data series including those referring to resources elsewhere in your workbooks.

For this series type you need to define a formula that determines the first item of the series. Then GS-Calc will accordingly update references in this formula to generate values in subsequent cells of the target cell range. Such a formula can either use the preceding value to generate the next one or each value can be calculated directly by using the item position within the series.

Used formulas are saved as a "recently used" list and references are updated automatically when applied to another worksheet location.

*

Inserting random series

You can use several popular distribution types. Additionally, for the uniform distribution you can choose to create a series of randomly selected custom list items.

*

Examples

Inserting a built-in series of month (system-dependend) names:

*

Inserting a series with embedded custom list items:

*

Inserting a built-in "2d" series of numbers:

*

Inserting series of numbers and dates:

*

Inserting series of formulas:

*

Inserting series with elements placed every n-th cell:

*

Inserting many series at once:

*