2.2.3.66 wrowhide

1 Menu Information
2 Brief Information
3 Command Line Usage
4 X-Function Execution Options
5 Variables
6 Description
7 Related X-Functions

Menu Information

Right-click Context Menu of the row(s): Hide/Unhide Rows:Hide
or
Right-click Context Menu of the row(s): Hide/Unhide Rows:Unhide

Brief Information

Hide or unhide selected rows

Command Line Usage

1. wrowhide irng:=[Book1]Sheet1![2]:[5] operation:=0; // hide row2 to 5 in Book1 Sheet1

2. wrowhide irng:=([1]:[2],[5]:[6]) operation:=0; //hide row1 to 2 and row 5 to 6 in active sheet.

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

Input

irng

Input

Range

Specify the input row range to be hidden or shown.

Operation

operation

Input

int

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

Option list:

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

Description

This X-Function is used to hide or show specified rows. To call the X-function from the menu, right-click on the selected rows and select Hide/Unhide Rows.

Note: the hidden rows 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.