Google Integrator V2 - Online Help
Google Integrator V2
Questions / Feedback?

CellDetailInputValue Property

This property contains the input (actual physically entered) value of the current cell.

Syntax

 gspreadsheets.getCellDetailInputValue([callback])
 gspreadsheets.setCellDetailInputValue( cellDetailInputValue, [callback])

Default Value

""


Callback

The 'callback' parameter specifies a function which will be called when the operation completes (or an error is encountered). If the 'callback' parameter is not specified, then the method will block and will not return until the operation completes (or an error is encountered).

The callback for the getCellDetailInputValue([callback]) method is defined as:

function(err, data){ }

'err' is the error that occurred. If there was no error, then 'err' is 'null'.

'data' is the value returned by the method.

The callback for the setCellDetailInputValue([callback]) method is defined as:

function(err){ }

'err' is the error that occurred. If there was no error, then 'err' is 'null'.

'err' has 2 properties which hold detailed information:

err.code
err.message

Remarks

This property contains the input (actual physically entered) value of the current cell.

This property contains the input (actual physically entered) value of the current cell specified by CellIndex.

Note that this property can return formulas (such as "=SUM(1, 1)". In such a case that you want the computed value, instead of the formula, you can check if the returned CellDetailInputValue starts with "=". If so, then use the value contained within CellDetailNumericValue

The size of the array is controlled by the CellDetailCount property.

This property is not available at design time.

Data Type

String

 
 
Copyright (c) 2017 /n software inc. - All rights reserved.
Build 2.0.6240.0