Legato
Legato

GoFiler Legato Script Reference

 

Legato v 1.4i

Application v 5.22a

  

 

Chapter EightData Functions (continued)

DataSheetIsCellNull Function

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