WP TABLE SPLIT CELLS

Home

4D v20 R7


WP TABLE SPLIT CELLS ( targetObj ) \| ( tableRef ; startColumn ; startRow {; columnCount{; rowCount}} )

Parameter	Type	Description
targetObj	Object	Range or element or 4D Write Pro document
tableRef	Object	Table reference
startColumn	Longint	Position of first cell column
startRow	Longint	Position of first column row
columnCount	Longint	Number of columns to split
rowCount	Longint	Number of rows to split

Description

The WP TABLE SPLIT CELLS command splits the intersecting selection of cells in the targetObj or tableRef (defined by startColumn, startRow, columnCount, and rowCount). A cell will be split only if it has already been merged horizontally, vertically, or both; otherwise, the cell will not be modified.

Pass either:

targetObj:
- a range, or
- an element (row / body / paragraph / anchored image / header / footer / section / subsection), or
- a 4D Write Pro document

If targetObj does not intersect with a table or text range where a selection of cells can be retrieved, the command doesn't do anything.

If targetObj intersects one or many cells that haven’t been merged before, the WP TABLE SPLIT CELLS command does nothing.

tableRef - a table reference.
startColumn and startRow - define the left top coordinates of the first cell to split.
columnCount and rowCount (optional) - specify respectively the number of columns and the number of rows to be splitted.

If rowCount is omitted, it is the equivalent of passing 1 (default value). If both columnCount and rowCount are omitted, it is the equivalent of splitting a single cell, and if it hasn’t been merged before nothing happens.

If startColumn plus ColumnCount or startRow plus rowCount exceeds the number of columns/rows in tableRef, or if startColumn or startRow is greater than the number of columns/rows in tableRef, the returned range contains the maximum possible columns/rows which means every cell in the table (if it has been merged before) is splitted.

Example

You want to designate a range of cells (that contain some already merged cells) and split it:

 WP TABLE SPLIT CELLS($table;3;2;1;1)

  //or

 $cells:=WP Table get cells($table;3;2;1;1)

 WP TABLE SPLIT CELLS($cells)

Result:

Data from the already merged cell is kept all in the first (top left) cell after the split, the other resulting cells from the split remain empty.

For more details, please refer to Merging and splitting cells.