2.2.3.32 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;

X-Function Execution Options

Please refer to the page for additional option switches when accessing the x-function from script

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.
  • senum: Single Enumerate
    For single cell enumeration. If the input cell is a number, it will add 1 to fill the extend range.
Fill Mode mode

Input

int

0


Option list

  • 0=dnd:Drag & Drop
  • 1=dbclick:Double Click

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.