# Status

Inserts a simulated LED status light display element into the spreadsheet. The Status cell displays the specified value as a red, yellow, or green LED, with text labels for each color.

Inputs

The Status function Functions are tools that are available in Spreadsheet for processing and analyzing acquisitions or other results. You can add functions to your Spreadsheet job to create tool chains and produce results for specific applications. has the following syntax:

Status(Status, Label: Positive, Label: Zero, Label: Negative, Color: Positive, Color: Zero, Color: Negative)

See the table for a description of the available parameters:

Parameter | Description
Status | References a cell to monitor for its status.
Label | The text that is displayed when the status value is positive, 0, or negative.
Status Value |  |
Positive | > 0 | Specifies the text that is displayed when Status is positive.
Zero | = 0 | Specifies the text that is displayed when Status is 0.
Negative | < 0 | Specifies the text that is displayed when Status is negative.
Color | The LED color that is displayed when the status value is positive, 0, or negative.
Status Value |  | LED Color
Positive | > 0 | Specifies the LED color that is displayed when Status is positive. Default Color = 0x00ff00, Lime; Max = 0xffffff
Zero | = 0 | Specifies the LED color that is displayed when Status is 0. Default Color = 0xff0000, Red; Max = 0xffffff
Negative | < 0 | Specifies the LED color that is displayed when Status is negative. Default Color = 0xffff00, Yellow; Max = 0xffffff
Note: Named colors can be selected using the color picker control in the Property Sheet. The color can also be specified as Cell References to another cell that returns a color value as a 24-bit number. Given red, green, and blue values in the range 0-255, an RGB color value can be calculated using the formula (red * 65536) + (green * 256) + blue. Expressed in hexadecimal, this is in the 0xRRGGBB format. For example, the hexadecimal constant 0xFF8020 translates to: red=255, green=128, blue=32.

Outputs

Results | An LED status light element.