Legato
Legato

GoFiler Legato Script Reference

 

Legato v 1.5d

Application v 5.25a

  

 

Chapter EightData Functions (continued)

DataSheetMergeCells Function

Overview

The DataSheetMergeCells function merges cells into a single cell at the top left most position.

Syntax/Parameters

Syntax

int = DataSheetMergeCells ( handle hSheet, int row, int column, int col_span);

int = DataSheetMergeCells ( handle hSheet, string row, string column, int col_span);

int = DataSheetMergeCells ( handle hSheet, string address, int col_span);

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”.

col_span

A int value specifying the number of cells to merge.

Return Value

An int as ERROR_NONE or a formatted error code on failure.

Remarks

The function assumes the cells to the right are null cells. The width of the sheet must accommodate the span value.

Related Functions

Platform Support

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

Legato IDE, Legato Basic

Page revised 2024-12-13