2.2.3.3 colhide

Menu Information

Column:Hide/Unhide Columns:Hide

Column:Hide/Unhide Columns:Unhide

Brief Information

Hide or unhide selected columns

Additional Information

Minimum Origin Version Required:8.5.1

X-Function not designed for Auto GetN Dialog.


Command Line Usage

1.colhide irng:=col(C) operation:=0;//Hide column C

2.colhide irng:=col(1):col(4) operation:=0;//Hide the first 4 columns

3.colhide irng:=(col(2),col(4)) operation:=1;//Show the 2nd and 4th column

Variables

Display
Name
Variable
Name
I/O
and
Type
Default
Value
Description
Input irng

Input

Range

<active>
Specify the input column range to be hidden or shown.
Operation operation

Input

int

0
Specify whether to hide or show(unhide) the input column range.

Option list:

  • hide:Hide{0}
    Hide the input columns.
  • unhide:Unhide{1}
    Show the input columns.
  • all:Unhide All{2}
    Show all columns in the Worksheet.

Description

This X-Function is used to hide or show specified columns. To call the X-function from the menu, select columns in the worksheet and select Column:Hide/Unhide Columns and specify whether to hide or unhide the selected columns; or right-click on the selected columns and select Hide/Unhide columns.

Note: the hidden columns will be ignored in the plotting and analysis process. If you update the hidden range after plot or analysis operation, it will triggers the graph redrawing or analysis recalculation.