setFormatter Method

Sets the cell formatter.

Syntax

var instance = new GC.Spread.Sheets.Worksheet(name);
var returnValue; // Type: any
returnValue = instance.setFormatter(row, col, value, sheetArea);

function setFormatter( 
   row : number,
   col : number,
   value : Object,
   sheetArea : SheetArea
) : any;

row: The row index.
col: The column index.
value: The formatter string or object.
sheetArea: The sheet area. If this parameter is not provided, it defaults to viewport.

Example

This example sets the format object for the active sheet.

activeSheet.setValue(2, 3, new Date(2011, 2, 9));
activeSheet.setFormatter(2,3,"M",GC.Spread.Sheets.SheetArea.viewport);