Aller au contenu principal
Version: 20 R6 BETA

VP SET FORMULA

VP SET FORMULA ( rangeObj : Object ; formula : Text { ; formatPattern : Text } )

ParamètresTypeDescription
rangeObjObject->Objet plage
formulaText->Formule ou méthode 4D
formatPatternText->Format du champ

Description

The VP SET FORMULA command assigns a specified formula or 4D method to a designated cell range.

In rangeObj, pass a range of the cell(s) (created for example with VP Cell or VP Column) whose value you want to specify. If rangeObj includes multiple cells, the formula specified will be linked in each cell.

The formula parameter specifies a formula or 4D method name to be assigned to the rangeObj.

If the formula is a string, use the period . as numerical separator and the comma , as parameter separator. If a 4D method is used, it must be allowed with the VP SET ALLOWED METHODS command.

The optional formatPattern defines a pattern for the formula.

You remove the formula in rangeObj by replacing it with an empty string ("").

Exemple 1

VP SET FORMULA(VP Cell("ViewProArea";5;2);"SUM($A$1:$C$10)")

Exemple 2

Pour supprimer la formule :

VP SET FORMULA(VP Cell("ViewProArea";5;2);"")

Exemple 3

VP SET FORMULA($range; "SUM(A1,B7,C11)") //"," pour séparer les paramètres

Voir également

Cell format
VP Get Formula
VP SET FORMULAS
VP SET VALUE