2.2.3.1 col2mirror


Contents

Menu Information

Worksheet: Convert to Mirror Columns

Brief Information

Convert source referencing column(s) to mirror column(s)

Command Line Usage

1. col2mirror scv:=0 colcpy:=1;

2. col2mirror colcpy:=1 label:=1 -u;

3. col2mirror scope:=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
Column Formula scv

Input

int

1
 Specify whether to convert column(s) filled by column formula that refer to other column(s) (via Set Column Values or F(x)).

Allowed values: 0=false, 1=true.

Column Copy Output colcpy

Input

int

0
 Specify whether to convert column(s) created by Worksheet: Copy Column to.

Allowed values: 0=false, 1=true.

Convert Scope scope

Input

int

2
 Specify the search and conversion scope. Available options:
  • sh:Active Sheet {0}
  • bk:Active Book {1}
  • fd:Active Folder {2}
  • sf:Active Folder (Recursive) {3}
  • proj:Project{4}
Use Source Column Labels label

Input

int

1
 When Column Formula is selected, check this checkbox to copy label rows from the source column. For Column Copy Output, whether to use the source column labels is controlled by whether and which label row(s) are checked under Copy Labels branch in the Copy Column to dialog.

Allowed values: 0=false, 1=true

Output List of Converted Columns dump

Input

int

0
 Specify whether to output a list of converted columns. Available options:
  • none:None {0}
  • msg:To Message Log {1}
  • note:To Notes Window {2}
  • pad:To Notepad {3}

Description

Origin 2026b introduces Mirror Column, which references a source column. For linking columns created in older versions, whether by column formula (simple reference, no calculation involved) or the Copy Column to dialog, you can use this X-Function "col2mirror" to scan the specified scope and convert these linking columns to mirror columns.

Related X-Functions

colcopy, colmirror, colmove, wselcol, colswap