WP Get formulas

Home

4D v19

WP Get formulas


WP Get formulas ( targetObj ) -> Function result

Parameter	Type	Description
targetObj	Object	Range or element or 4D Write Pro document
Function result	Collection	Collection of formulas

The WP Get formulas command returns a collection of all formulas defined in targetObj.

In the targetObj parameter, you can pass:

a range, or
an element (table / row / cell(s) / paragraph / body / header / footer / section / subsection / inline or anchored picture), or
a 4D Write Pro document.

Returned value

WP Get formulas returns a collection of formula objects, each of them containing one or more of the following properties:

Property	Type	Description
[ ].fomula	Object	The formula string is available through [ ].formula.source. The formula is a copy of the formula found in the target. If you want to modify the formula, it must be re-inserted in the document to be taken into account
[ ].range	Object	Range of the formula (not returned for anchored picture formulas)
[ ].anchoredID	Text	ID of anchored picture (returned for anchored picture formulas only)
[ ].owner	Object	4D Write Pro document

Notes:

If you passed a subsection as target, formulas of the parent section are returned.
If several formulas are returned, the collection is ordered with respect to the formula order in the target, except for targets of type document and section (any order in this case).

To get all formulas in a document:

 C_COLLECTION($formulas)

 $formulas:=WP Get formulas(WriteProArea)

To get all formulas in the first section of a document:

 C_COLLECTION($formulas)

 $formulas:=WP Get formulas(WP Get section(WriteProArea;1))

To get the formulas of all anchored pictures in a document:

 C_COLLECTION($formulas)

 $formulas:=WP Get formulas(WriteProArea).query("anchoredID # null")