2.2.3.31 wautofill

Brief Information

Auto fill worksheet cells based on values from a specified input range

Command Line Usage

wautofill irng:=[Book1]Sheet1!Col(1)[2]:Col(2)[4] orng:= [Book1]Sheet1!Col(1)[2]:Col(3)[6] action:=repeat;

Variables

Display
Name
Variable
Name
I/O
and
Type
Default
Value
Description
Input irng

Input

Range

<active>

Specified Input Range.

Output orng

Output

Range

<unassigned>

Specified Output Range to fill See the syntax here.

Action action

Input

int

repeat

This action list is to specify the fill action mode.
Option list

  • repeat: Repeat
    It will repeat the data just as copy from left to right and from up to down.
  • enum: Enumerate
    If the data is enumerate data, then it will fill the enumerate data to the extend range.
  • ran: Randomize
    If will fill the random data to the extend range in the output range from 0 to the max data in the Input Range.
  • ins: Insert and Delete
    Just as Randomize mode.

Description

This function is used to fill the Worksheet automatically.

We can only fill the cells automatically in the output range. If the output range max column index > input range max column index, it will fill horizontally. If the output range max row index > input range max row index, it will fill vertically. If both, then it will fill totally. Else it will not do anything.