Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

 

Test Case AOOTest-717: (Extend) Fill_Fill series_AutoFill_Down_Single column [Version : 1]
Author:undefined - 19/11/2012 10:29:18
Summary:

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.

Preconditions:

#:Step actions:Expected Results:
1

Expected results

2

New a spreadsheet.

New spreadsheet is created.

3

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

Sequence... menu item should be disabled.

4

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

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

5

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.

6

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

Ditto.

7

Undo several times, then redo several times.

Undo and redo should perform properly.

8

Save and close file.

9

Re-open the file.

Filled contents should be saved properly.

Execution type:Manual
Importance:Medium
Test Focus:
Feature first available at which release:
Automation script name:
Testsuite set:
Requirements None
Keywords: None

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.