formatter Method

Gets or sets the formatter for the cell.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.CellRange(sheet, row, col, rowCount, colCount, sheetArea);
var returnValue; // Type: any
returnValue = instance.formatter(value);

function formatter( 
   value : undefined
) : any;

Parameters

value: The cell formatter string or object.

Return Value

If no value is set, returns the cell formatter string or object; otherwise, returns the cell.

Example

The following examples set the formatter method.

Javascript

activeSheet.getCell(1,1).formatter("0.000%");

Javascript

activeSheet.getCell(1, -1).formatter("0.000%");
activeSheet.getCell(1,0).value("2");

Javascript

activeSheet.getCell(-1, 0).formatter("0.000%");
activeSheet.getCell(0,0).value("2");

Reference

CellRange type