2.9.5 wcolor2mask


Contents

Brief Information

Mask worksheet cells that has been formatted

Additional Information

Minimum Origin Version Required: 2019

Command Line Usage

wcolor2mask;

wcolor2mask Mode:=1;

wcolor2mask Mode:=2;

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
Range irng

Input/Output

Range

<active>
 Specify the input data range.
What to convert Mode

Input

int

0
 Specify how to decide the cells to be masked.

Option list:

  • 0=Cells with colored background
    Mask the cells have been filled color.
  • 1=Cells with colored Text
    Mask the cells with colored text/numberic. Not for the default color "black".
  • 2=Cells with conditional format
    Mask the cells with conditional format.

Description

This X-Function can be used to mask the cells which have been formatted, including colored text, background or conditional formatted.

Related X-Functions

wcolor,wheatmap,wcolordup