Cell Data Formats

Cells have a format property, inherited from the range class, that determines how the cell’s data is parsed and displayed. By default, a new cell’s format is set to automatic, and will attempt to interpret the inserted data into the correct format. Set the format property if the data, such as a numeric value, can be interpreted to be used by more than one format, otherwise leave the format property set to the default of automatic.

The following script will create a small table displaying the various available cell formats:

The created table:


(above left) The cell formats table. (above right) A selected cell with popup menu format.


(above left) A selected cell with stepper format. (above right) A selected cell with slider format.