Legato
Legato

GoFiler Legato Script Reference

 

Legato v 1.4j

Application v 5.22b

  

 

Chapter EighteenDataView Integration (continued)

DataViewIsMergedCell Function

Overview

The DataViewIsMergedCell function tests whether a specific cell is within a merged region.

Syntax/Parameters

Syntax

boolean = DataViewIsMergedCell ( handle object, [int row, int column] | [string address] );

Parameters

object

A handle either to a Data View Object or to a window that employs Data View.

row and column

An optional pair of int values specifying the row and column of the cell. Or,

address

An optional string that can be used as a cell address as an alternative to specifying the row and column parameters.

Return Value

Returns TRUE if the cell is merged or FALSE if it is not merged or on failure. Use the GetLastError function to retrieve error information.

Remarks

A merged cell is a cell that theoretically does not exist because if has been merged over. Merged cells are always to the right or below the cell that contains the merged content. Since any cell can be accessed by row and column, it is possible to access cells that do not exist by virtue of being merged over.

Related Functions

Platform Support

Go13, Go16, GoFiler Complete, GoFiler Corporate, GoFiler, GoFiler Lite, GoXBRL