In Spread.Sheets, you can customize the format of each cell so that the data is displayed however you like. This can be useful when you have raw data that comes from a database, and you want to show a user-friendly format of that data.
To set the formatter for a cell use the setFormatter method to set a formatter string to a cell, and use the getFormatter method to get the cell formatter. You can also get the cell, column, or row by using the formatter method to get and set the formatter for the cell. For example:
sheet.setValue(9, 6, new Date(2013,3,1));
sheet.setFormatter(9, 6, 'd-mmm;@');
You can set a general format for a cell. Create a GeneralFormatter and set it to the cell. For example:
var generalFormat = new GC.Spread.Formatter.GeneralFormatter(
var cell = sheet.getCell(0, 0);