Vous êtes ici: Help Topics > Customization > Calculation > Insert Column Action

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.

Insert Column Action

Cookie Notice