Просмотреть исходный

Set range formula Version 1 (Net)

Action group: Excel

Description

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

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

The formula will also be calculated in the merged cell.
If a range of only hidden cells is specified and the "Skip hidden" field is true, there will be no ** error. The action will simply not apply the formula anywhere. If only part of the range is hidden, the formula will apply to the available cells.
If the optional area fields are not filled in, the formula will be applied to the entire used area of the sheet.
If the search range is not restricted to columns, the formula will be applied to all columns of the used area within the range of the specified rows.
Priority is given to the "Column name" field if both the "Column name" and "Column index" fields are filled.
If only the row/column start index is filled, the range will start with that index and end with the last row/column of the data area.
If only the row/column end index is filled, the range will start with the first row/column of the data area and end with that index.
To select only 1 row/column, you must specify the same thing in both the start name/index and end name/index.

The robot will return an error if: