WriteMSStack
Appends a user-specified string from the spreadsheet to the operational status information in buffer 0 of the Machine Status Stack whenever the spreadsheet is updated. For more information, see Sensor Status View.
To shift the entire contents of each buffer to the next buffer in the Machine Status Stack, use the PushMSStack function. For more information, see PushMSStack.
Data stored in the stack is accessed using the GetMSBuffer command over a Native Mode connection or from the Machine Status Port. For more information, see GetMSBuffer and Machine Status Port.
WriteMSStack Inputs
Syntax: WriteMSStack(Event,String)
Parameter | Description |
---|---|
Specifies the event that forces an update.This parameter must be a reference to one of the following:
Note: When the default
Event reference is deleted, the value is replaced by a checkbox. If another
cell is referenced as an event, the function will conditionally run based
on the referenced cell. If the checkbox is enabled, the function will
always run when any inputs to the function are updated. |
|
A string or a reference to a cell containing a string. The maximum string length is 255 characters, including characters used as delimiters. For example, comma (,), semicolon (;), Carriage Return/Line Feed (CRLF), etc. User-defined XML tags can also be included in the string. |
WriteMSStack Outputs
Returns |
An MSStack data structure containing the text to append, or #ERR if the input String is invalid. |