WP FREEZE FORMULAS

Home

4D v20

WP FREEZE FORMULAS


WP FREEZE FORMULAS ( targetObj {; recompute} )

Parameter	Type	Description
targetObj	Object	Range or element or 4D Write Pro document
recompute	Longint	Option to control recomputing

Description

The WP FREEZE FORMULAS command "freezes" the contents of the formulas in targetObj.

The command replaces each formula in the targetObj with its computed value (either static text or image). This creates a portable document since only the references of formulas are kept in the targetObj itself.

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 / text box), or
a 4D Write Pro document.

Notes:

If targetObj designates an offscreen area where formulas have not been previously computed, they will be evaluated before being frozen. In particular, formulas are not computed when an offscreen document is loaded.
When you pass a section in targetObj, only image formulas or formulas in text boxes anchored to this section or all sections are frozen. If anchored to a page or to the embedded view, their formulas are not frozen. Pass the document in targetObj to freeze all anchored element formulas.

The recompute optional parameter allows you to define if the formulas in targetObj must be recomputed before being frozen. You can pass one constant from the "4D Write Pro" theme:

Constant	Type	Value	Comment
wk do not recompute expressions	Longint	2	Specifies that all expressions in the document are not recomputed before printing or freezing.
wk recompute expressions	Longint	0	Specifies that all expressions in the document are recomputed before printing or freezing (default value).

By default, if recompute is omitted, expressions are recomputed.

Warning: Carry-over rows, if any, are transformed as regular rows when you freeze the targetObj. As a result, if the page size or orientation is modified, or if the document is exported, they may be shifted in the resulting layout.

Example

To freeze the formulas in a document:

WP FREEZE FORMULAS(WriteProArea)

To freeze all formulas in the first section of a document without recomputing:

WP FREEZE FORMULAS(WP Get section(WriteProArea;1);wk do not recompute expressions)