Modified December 2017; see History

Using this option, shared lists (combo boxes) can be associated with individual cells rather than just entire columns. To implement, first define one or more lists (associated with column 0) using the CellList option:

CellList=id, item1, item2, ...itemN

The format of CellList is identical to List except that it must begin with a single case-sensitive letter, a-z or A-Z, which serves as an identifier for the list, allowing up to 52 lists to be defined.

To associate one of the predefined lists with a cell, use the cformat code "s" to define the column as being capable of referencing the lists. cformat "s" is similar in concept to B (background cell color) in that it reserves the first character of each cell in the column for the index letters that associate the cell with one of the predefined lists.

Notes

•   In addition to the index letters, which associate the individual cell with a pre-defined list, you can also use the following codes to make the cell non-editable, or to treat it as a normal editable cell.

•   If the column also uses cformat B, then the first character of the column is for the cell color code, and the second character will be for the CellList ID.

•   As with cell background colors, the byte reserved for the CellList ID must also be accounted for in the answer array.

•   There is no limit on the length of an individual combo list (defined with List= or CellList=). A 4K limit in an earlier version of A-Shell has been eliminated.

•   The sample program XTRA5C illustrates some of these variations.

History

2017 December, A-Shell 6.5.1622:  CellList id codes can now include both upper and lower case characters (previously only lower case), extending the total range from 26 (a-z) to 52 (a-z, A-Z).