To verify that automatically fill works properly - fill series - auto fill - down. Automatically generate series with the options in this dialog. Determine direction, increment, time unit and series type.. Before filling a series, first select a cell range. Left and Right are enabled only when selected range covers more than one columns. Up and Down are enabled only when selected range covers more than one rows. End value and Increment are disabled if series type is AutoFill. Time unit section is enabled only when series type is Date. Start/End value supports numbers, dates, and times.

Expected results

New a spreadsheet.

New spreadsheet is created.

Select one cell, then choose 'Edit -) Fill'.

Sequence... menu item should be disabled.

Select some cells in one row, then choose 'Edit -) Fill -) Sequence...'.

Fill Series dialog opens, fill direction Up and Down should be disable.

1. Set fill direction as Down.

2. Select AutoFill in series type.

3. Input a number into start value.

4. Click OK button.

Selected cells should be filled properly:

Algorithm

Example

1. Cell(1) = start value;

2. Cell(n) = Cell(n-1) + 1.

Settings

Results

1. number of selected cells = 5.

2. fill direction = down.

3. series type = auto fill.

4. start value = -1.8.

Repeat steps 3 and 4 several times, try different start value (numbers, dates, times).

Ditto.

Undo several times, then redo several times.

Undo and redo should perform properly.

Save and close file.

Re-open the file.

Filled contents should be saved properly.