MultiStatus
Inserts an array of simulated LED status lights into the spreadsheet. The function displays the specified bits from a control value as a single LED with two color states.
MultiStatus Inputs
Parameter | Description | ||||
Value |
Specifies the control value (-2147483648 to 2147483647; Default = 0). Note: Any number outside this value range will be treated as zero but will not cause the function to return #ERR.
|
||||
Start Bit |
Specifies the first bit of the control value (0 to 31; Default = 0). |
||||
Number of Bits |
Specifies how many bits to display (1 to 32; Default = 10). Each bit corresponds to one LED. |
||||
Reverse Order |
Determines which bit represents the least- significant bit of the array.
|
||||
Color 0 |
Sets the LED color used to represent a zero bit. (Default = 0xFF0000 (red), Max: 0xFFFFFF) |
||||
Color 1 |
Sets the LED color used to represent a one bit. (Default = 0x00FF00 (lime), Max: 0xFFFFFF) |
- 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.
MultiStatus Example
A spreadsheet is configured as follows:
A1 = EditInt(0,255)
A2 = MultiStatus(A1,0,8,0,0xFF0000,0x00FF00)
If you increment the EditInt control in cell A1, you can observe how the MultiStatus function displays the binary representation of the cell it references (in this case, A1):