VP ADD SPAN

Home

4D v19

VP ADD SPAN


VP ADD SPAN ( rangeObj )

Parameter	Type	Description
rangeObj	Object	Range object

Description

The VP ADD SPAN command combines the cells in rangeObj as a single a span of cells.

In rangeObj, pass a range object of cells. The cells in the range are joined to create a larger cell extending across multiple columns and/or rows. You can pass multiple cell ranges to create several spans at the same time. Note that if cell ranges overlap, only the first cell range is used.

Notes:

Only the data in the upper-left cell is displayed. Data in the other combined cells is hidden until the span is removed.
Hidden data in spanned cells is accessible via formulas (beginning with the upper-left cell).

Example

To span the First quarter and Second quarter cells across the two cells beside them, and the South area cell across the two rows below it:

use this code:

  // First quarter range

 $q1:=VP Cells("ViewProArea";2;3;3;1)

 

  // Second quarter range

 $q2:=VP Cells("ViewProArea";5;3;3;1)

 

  // South area range

 $south:=VP Cells("ViewProArea";0;5;1;3)

 

 VP ADD SPAN(VP Combine ranges($q1;$q2;$south))

The created spans: