  |
GoFiler Legato Script Reference
Legato v 1.5d Application v 5.25a
|
| Table of Contents | < < Previous | Next >> |
Chapter Eight — Data Functions (continued)
Overview
The DataSheetIsCellNull function tests to see if the specified cell is null (a cell that exists only in the matrix).
Syntax/Parameters
Syntax
boolean = DataSheetIsCellNull ( handle hSheet, int row, int column );
boolean = DataSheetIsCellNull ( handle hSheet, string row, string column );
boolean = DataSheetIsCellNull ( handle hSheet, string address );
Parameters
hSheet
A handle to a Data Sheet Object.
row
An int or string specifying a zero-based row or Y position for the cell.
column
An int or string specifying a zero-based column or X position for the cell.
address
A string specifying the cell position by cell address such as “A1”.
Return Value
Returns TRUE if the cell is null or FALSE if it is not null or on failure. Use the GetLastError function to retrieve error information.
Remarks
A null cell is a position in the row-column matrix that is not defined or does not contain data or attributes. Cells are addressed via a sheet matrix, which in turn contains offsets to cell information within a large array. If a cell does not exist at the specified position, it is null. By default, when a sheet is created or expanded, new cells will be null. When data or attributes are set, the cell is not null. It is not possible to force a cell to be null.
Related Functions
Platform Support
Go13, Go16, GoFiler Complete, GoFiler Corporate, GoFiler, GoFiler Lite, GoXBRL
Legato IDE, Legato Basic
Page revised 2024-12-13
| Table of Contents | < < Previous | Next >> |
© 2012-2024 Novaworks, LLC. All rights reserved worldwide. Unauthorized use, duplication or transmission prohibited by law. Portions of the software are protected by US Patents 10,095,672, 10,706,221 and 11,210,456. GoFiler™ and Legato™ are trademarks of Novaworks, LLC. EDGAR® is a federally registered trademark of the U.S. Securities and Exchange Commission. Novaworks is not affiliated with or approved by the U.S. Securities and Exchange Commission. All other trademarks are property of their respective owners. Use of the features specified in this language are subject to terms, conditions and limitations of the Software License Agreement.