|Test Case AOOTest-717: (Extend) Fill_Fill series_AutoFill_Down_Single column [Version : 1]|
|Author:||undefined - 19/11/2012 10:29:18|
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.
|#:||Step actions:||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:
1. Cell(1) = start value;
2. Cell(n) = Cell(n-1) + 1.
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).
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.
|Feature first available at which release:|
|Automation script name:|