A group of actions: Excel
The action sets value format in the specified cell
Action icon
Settings
| Property | Description | Type | Filling example | Mandatory field |
| Parameters | ||||
| Context | Action context for working with an Excel document | Robin.Excel | Excel context | Yes |
| Column of the cell | Column of the cell in which the value format will be set. | Robin.String | Yes | |
| Row of the cell | Row of the cell in which the value format will be set. | Robin.Numeric | Yes | |
| Format | Format to be set in the selected cell. | Robin.String | Yes | |
| Format mask | Mask for creating a custom format. Rules for custom format masks: 1) Any custom text (kg, people, pcs and the like) or symbols (including spaces) must be enclosed in quotes. 2) You can specify several (up to 4) different format masks separated by semicolons. Then the first of the masks will be applied to the cell if the number in it is positive, the second - if it is negative, the third - if the cell content is zero, and the fourth - if the cell contains not a number, but text. 3) ** 0 (zero) ** - one obligatory familiarity (digit), i.e. this place in the format mask will be filled with a digit from the number that the user enters into the cell. If there is no number for this familiarity, then zero will be displayed. For example, if you apply the mask 0000 to the number 12, you get 0012, and if you apply the mask 0.00 to the number 1.3456, you get 1.35. 4) ** # (hash) ** - one optional familiarity - roughly the same as zero, but if there is no number for the familiarity, then nothing is displayed 5) ** (space) ** - used as a separator of groups of digits three between thousands, millions, billions, etc. 6) ** [] ** - in square brackets before the format mask, you can specify the font color. The following colors are allowed: black, white, red, blue, green, yellow, cyan. | Robin.String | No | |
Обзор
Инструменты контента