Сравнение версий

Ключ

  • Эта строка добавлена.
  • Эта строка удалена.
  • Изменено форматирование.

...

The action allows you to execute a formula in a selected range in an Excel document.

Icon


Parameters

Input parameters  

...

Settings of parameters

Property

Description

Type

Example of filling in

Obligatory to fill in the field

Parameters

Context

Action context for working with an Excel document

Excel instance

Excel context

Yes

Start row

The number of the line from which the formula will be applied.

Numeric


No

Start column name

The name of the column from which the formula will be applied. If the field is not filled in, the value from the "Start column index" field is taken.

String


No

Start column index

The index of the column starting from which the formula will be applied. If the field is not filled in, the initial boundary of the used area will be taken.

Numeric


No

End row

The number of the line to which the formula will be applied.

Numeric


No

End column name

The name of the column to which the formula will be applied. If the field is not filled in, the value from the "End column index" field is taken.

String


No

End column index

The index of the column to which the formula will be applied. If the field is not filled in, the final boundary of the used area will be taken.

Numeric


No

Formula

A formula to be applied to the specified range. The formula starts with the "=" symbol.

String


Yes

Local language

If true, the formula will be read in the local language, otherwise it will be read in English.

Boolean

true

No

Register

If the value is "true", the formula remains unchanged, otherwise - all letters will become capitalized.

Boolean

true

No

Skip hidden

If true, no formula will be applied to the hidden cells.

Boolean

true

No

...