Insert Column Action
Event Function: InsertColumn
The Insert Column action inserts one or more columns into a table at the specified point.
Using the Events tab
Under | Enter | Example |
---|---|---|
Run Skip Condition |
If desired, enter skip conditions for the event. When the "Run Skip Condition" is evaluated to be true, the action is not performed. |
|
Table |
Table label |
"ABC" |
Insert at Column |
Insert at column position (Starting at 1) |
3 |
Column Type |
Specify the type of column (general, numeric cell, etc.) |
"GENERAL" |
Copy From Column |
Table column to copy from (Starting at 1) |
Used when Column type specified is "Copy of Current Column" |
Number of Columns to Insert |
Specify if more than 1 column is to be inserted |
2 |
Before/ After |
Select whether to insert before or after column specified in "Insert at Column". |
"After" |
Syntax (if entering it in the Equation bar)
ACTION("InsertColumn", expr1,expr2,expr3,expr4,exp5,exp6)
Where
expr1 = entry under Table
expr2 = entry under Insert at column
expr3 = Column type
expr4 = Copy from Column
expr5 = Number of Columns to insert
expr6 = Before/ After
How the example will appear in the Equation bar
ACTION("InsertColumn", "ABC", 2, "GENERAL" ,1, 2, "AFTER")
Copies the first column of Table ABC, including the cells, and two copies of it as the third and fourth column in the table. The cells in the table will be appropriately renumbered.
Notes
-
If you rename a table, none of the related events (sort, insert, delete column) for that table gets an updated name. However, you can use the celltable() function to create a reference to the table. If the event is within a table, you can use celltable() to get the table label automatically. If the event is outside of the table, you can use celltable(abc.a1), where abc.a1 is a cell number, to get the table label.
This function always returns the table label even when table abc is renumbered.