История страницы
...
Name | Description |
---|---|
Context | The action context for working with an Excel document |
Start row | The number of the row from which the formula will be applied. |
Start column name | The name of the column from which the formula will be applied. |
Start column index | The index of the column from which the formula will be applied. |
End row | The number of the row to which the formula will be applied. |
End column name | The name of the column to which the formula will be applied. |
End column index | The index of the column to which the formula will be applied. |
Formula | The formula that will be applied to the specified range. |
Local language | If true, the formula will be read in the local language, otherwise it will be read in English. |
Register | If true, the formula will remain unchanged, otherwise all letters will be capitalized. |
Skip hidden | Hidden If true, the formula will not be applied to hidden cells. |
Settings
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 |
...
A given formula is executed in a given range.