2.2.3.39 wcellsel

Brief Information

Select worksheet cells using specified condition

Command Line Usage

1. wcellsel rng:=1! cond:=le val:=3; // whole sheet to select all cells < 3

2. wcellsel rng:=1 c:=gt v:=0.5; // sel col(1) for cells > 0.5

3. wcellsel c:=none; // clear all selection in active sheet

4. wcellsel;// same as above since none is the default

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 rng

Input/Output

Range

<active>
The specified range to select.
Condition condition

Input

int

none
The condition to select data

Option list:

  • eq:RefCol[ii] =
Equal to the specified Cutoff data
  • lt:RefCol[ii] <
less than the cutoff data
  • le:RefCol[ii] <=
No more than the cutoff data
  • gt:RefCol[ii] >
more than the cutoff data
  • ge:RefCol[ii] >=
No less than the cutoff data
  • ne:RefCol[ii] <>
Not equal to the cutoff data
  • none:Clear All
Cutoff Value val

Input

double

0.05
The cutoff data is used for condition.
Tolerance for Equal Testing tol

Input

double

1E-6
Tolerance used in comparing the values of the cell and the cutoff.

Description

This function is used to set cell(s) color with specified condition.