The following spreadsheet was configured to
Display the raw values for CWSERV_ARRAY, an array point with ten (10) elements, and
Let a user perform a setpoint on the array:
The procedure is as follows:
Highlight the number of rows or columns to match the number of elements of the row to be displayed. (Cells R5C3 through R14C3 were selected.)
Enter the SCSERV command. For example,
Press Ctrl+Shift+Enter on the keyboard.
Note: You must press Ctrl+Shift+Enter when entering a formula for a range of cells on the spreadsheet. If you press Enter, only the first cell of the range will contain data. In the case of array points, this means that only the first array element's value is displayed.
The following macro is the one associated with the Set button above.
To change the setpoint, enter the new values in R5C4 through R14C4, and click Set.
Sample spreadsheets and macros.