2.2.3.39 wcellsel

Contents

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.