2.2.3.8 colmirror


Contents

Menu Information

Worksheet: Create Mirror Columns from Sili

Brief Information

Collect columns from similar sheets to create mirrors

Command Line Usage

1. colmirror irng:=[Book1]Sheet1!Col(1) orng:=[Book1]Sheet1!Col(2);

2. colmirror irng:=col(A) orng:=col(B) scope:=2 match:=1 unit:=1;

3. colmirror irng:=[Book1]Sheet1!Col(2) orng:=[Book2]Sheet1!Col(2) xcol:=1 bkrow:=1

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
Source Column irng

Input

Range

<active>
 Specify one source column. All columns in the search scope that match this Source Column will be collected, mirrored, and output to the Destination Column.
Destination Columns orng

Output

Range

[<new>]<new>!<new>
 Specify the target column beginning from which the mirror columns will be output.
Add X Column xcol

Input

int

0
 If the Source Colulmn is a Y column, use this option to control whether to copy its corresponding X column. Allowed values:
  • no:None {0}
Do not copy the X column.
  • this:Common X Column {1}
Copy the Source Column's X column and use it as the common X for all the mirror columns. The output should be XYYY... structure.
  • sheet:From Each Sheet {2}
Copy its own X column for each mirror column. The output should be XYXYXY... structure.
From Similar Sheets sheets

Input

int

1
 Check this checkbox to search for worksheets with the same number of columns as the source sheet and only columns meeting the condition below (Must Match Column Label, Must Match Units and Match Column Designations) will be collected and used as mirror sources.

Allowed values: 0=false, 1=true

Find Similar Sheets In scope

Input

int

1
 Choose the search scope for applicable worksheets. Allowed values:
  • bk:Active Book {0}
  • fd:Active Folder {1}
  • sf:Active Folder (Recursive) {2}
  • proj:Project{3}
Must Match Column Label match

Input

int

1
 Check this checkbox to require the matched columns to share the same label row as the Source Column. Allowed values:
  • no:None{0}
Match by column index.
  • ln:Long Name{1}
Match by column Long Name
  • cmt:Comment{2}
Match by column Comment
Must Match Units unit

Input

int

1
 Chech this checkbox to require matched columns to have the same Units as the Source Column.

Allowed values: 0=false, 1=true

Match Column Designations desig

Input

int

0
 Check this checkbox to require the matched columns to have the same Plot Designations as the Source Column.

Allowed values: 0=false, 1=true

Use Source Column Labels label

Input

int

1
 Check this checkbox to copy Source Column label rows to the mirror columns.

Allowed values: 0=false, 1=true

Add Label Row for Sheet Names shrow

Input

int

0
 Add a "Sheet Name" label row to show the source worksheet.

Allowed values: 0=false, 1=true

Add Label Row for Book Names bkrow

Input

int

0
 Add a "Book Name" label row to show the source workbook.

Allowed values: 0=false, 1=true

Description

Origin 2026b introduces Mirror Column, which references a source column. This X-Function "colmirror" is used to batch-create mirror columns from multiple sheets that match certain conditions, such as column label rows and plot designation, and collect them into one worksheet.

Related X-Functions

col2mirror, colcopy, col2mirror