2.2.3.66 wrowhide


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

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

Input

int

0
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.

Related X-Functions

colhide