Property Getters/Setters Summary | ||
---|---|---|
function | getEndColumn() | |
The end column of the area. | ||
function | getEndRow() | |
The end row of the area. | ||
function | getExternalFileName() | |
Get the external file name if this is an external reference. | ||
function | isArea() | |
Indicates whether this is an area. | ||
function | isExternalLink() | |
Indicates whether this is an external link. | ||
function | getSheetName() | |
Indicates which sheet this reference is in. | ||
function | getStartColumn() | |
The start column of the area. | ||
function | getStartRow() | |
The start row of the area. |
Method Summary | ||
---|---|---|
function | getValue(rowOffset, colOffset) | |
Gets cell value with given offset from the top-left of this area. | ||
function | getValue(rowOffset, colOffset, calculateFormulas) | |
Gets cell value with given offset from the top-left of this area. | ||
function | getValues() | |
Gets cell values in this area. | ||
function | getValues(calculateFormulas) | |
Gets cell values in this area. | ||
function | toString() | |
Returns the simple string representation of this area. |
Property Getters/Setters Detail |
---|
isExternalLink : boolean | |
function isExternalLink() |
getExternalFileName : String | |
function getExternalFileName() |
getSheetName : String | |
function getSheetName() |
isArea : boolean | |
function isArea() |
getEndColumn : Number | |
function getEndColumn() |
getStartColumn : Number | |
function getStartColumn() |
getEndRow : Number | |
function getEndRow() |
getStartRow : Number | |
function getStartRow() |
Method Detail |
---|
getValues | |
function getValues() |
getValues | |
function getValues(calculateFormulas) |
calculateFormulas: boolean
- In this range, if there are some formulas that have not been calculated,
this flag denotes whether those formulas should be calculated recursivelygetValue | |
function getValue(rowOffset, colOffset) |
rowOffset: Number
- row offset from the start row of this areacolOffset: Number
- column offset from the start row of this areagetValue | |
function getValue(rowOffset, colOffset, calculateFormulas) |
rowOffset: Number
- row offset from the start row of this areacolOffset: Number
- column offset from the start row of this areacalculateFormulas: boolean
- Whether calculate it recursively if the specified reference is formulatoString | |
function toString() |