SpreadsheetGetcellformula()
Returns an array of structures (formula, row, column) looking for the formula. If rowNo/columnNo omitted, then all the formulae for the active sheet is returned
Usage
ARRAY = SpreadsheetGetcellformula(
p1,
p2,
p3
)
| Argument | Summary |
|---|---|
| p1 | spreadsheet object |
| p2 | rowNo [optional] |
| p3 | columnNo [optional] |
See Also
IsSpreadsheetobject
SpreadsheetAddcolumn
SpreadsheetAddfreezepane
SpreadsheetAddimage
SpreadsheetAddinfo
SpreadsheetAddrow
SpreadsheetAddrows
SpreadsheetAddsplitpane
SpreadsheetColumnfittosize
SpreadsheetCreatesheet
SpreadsheetDeletecolumn
SpreadsheetDeletecolumns
SpreadsheetDeleterow
SpreadsheetDeleterows
SpreadsheetDeletesheet
SpreadsheetFindcell
SpreadsheetFormatcell
SpreadsheetFormatcolumn
SpreadsheetFormatcolumns
SpreadsheetFormatrow
SpreadsheetFormatrows
SpreadsheetGetcellcomment
SpreadsheetGetcellformula
SpreadsheetGetcellvalue
SpreadsheetInfo
SpreadsheetMergecells
SpreadsheetNew
SpreadsheetQueryread
SpreadsheetQuerywrite
SpreadsheetRead
SpreadsheetReadbinary
SpreadsheetRemovecolumn
SpreadsheetSetactivesheet
SpreadsheetSetactivesheetnumber
SpreadsheetSetcellcomment
SpreadsheetSetcellformula
SpreadsheetSetcellvalue
SpreadsheetSetcolumnwidth
SpreadsheetSetfooter
SpreadsheetSetheader
SpreadsheetSetrowwidth
SpreadsheetShiftcolumns
SpreadsheetShiftrows
SpreadsheetWrite