|
Sets may be addressed in two ways depending on the possibility of duplicate entries. The syntax is
Set =nameofset Rng=DataRange Dimensions Values=valueoptions SymbolOptions
Dset=nameofset Rng=DataRange Dimensions SymbolOptions
where
| Set= | reads the set elements and optionally an associated set of element explanatory text or indicators. Duplicates will cause read errors. When writing the element name and the explanatory text is written if the range specification permits. Set also introduces an option values which indicates how any associated data should be interpreted. |
Namely when valueoptions equal
| Auto | Based on the range, row and column dimensions for the set, the program decides on the value type to be used. This is the default for Values. |
| NoData | There is no data range for the set; all tuples will be included. |
| YN | Only those tuples will be included that have a data cell that is not empty and does not contain '0', 'N' or 'No'. |
| String | All tuples will be included. The string in the data cell will be used as the associated text for the tuple. |
Furthermore when Auto is active then it takes different values depending on rdim and cdim, the form of the range and whether the range contains set elements and data or the data filed is blank.
If Rdim = 0 or Cdim = 0 and the range gives
The top left corner then Values=String
A block with no data then Values=Nodata
A block with data then Values=String
If Rdim > 0 and Cdim >0 then Values=YN
| Dset= | Reads a set of strings from a field in the spreadsheet and enters the unique ones into the set. Duplicate labels in the range specified do not generate an error message. Dset cannot be used to write to the spreadsheet. |
|