getFormatter Method

Gets the cell formatter.

Syntax

Javascript (Usage)
Javascript (Specification)

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

function getFormatter( 
   row : number,
   col : number,
   sheetArea : SheetArea
) : Object;

Parameters

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

Return Value

Returns the cell formatter string or object for the specified cell.

Example

This example returns the format object for the active sheet.

Javascript

activeSheet.getCell(0, 1).formatter("M");
activeSheet.setValue(0, 1, new Date(2011, 2, 9));
var style = activeSheet.getFormatter(0,1,GC.Spread.Sheets.SheetArea.viewport);
alert(style);

Reference

Worksheet type

Product Support Forum | Print this page