Spread.Sheets Documentation
getFormatter Method
The row index.
The column index.
The sheet area. If this parameter is not provided, it defaults to viewport.
Gets the cell formatter.
Syntax
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.
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);
See Also

Reference

Worksheet type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.