Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
en:process_steps:range_cell:rangeset [2020/03/12 13:20] andraz |
en:process_steps:range_cell:rangeset [2024/02/24 14:17] (current) tiger |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | {{indexmenu_n> | ||
| ====== Range Set ====== | ====== Range Set ====== | ||
| - | The process step **Range Set** (together with **Cell Set**) is the Djeeni counterpart of data entry on a worksheet. You can multiply a single value to a range of cells (you do not have to use double quotes to assign text values): | + | This step is only applicable for target worksheets. |
| - | {{djeeni:range_set.png}} | + | {{ :en: |
| + | |||
| + | A value or formula can be set to a range with the following parameters: | ||
| + | |||
| + | * **Range**: Complete Djeeni range reference with worksheet Djeeni name, column letter and number | ||
| + | * **Value / formula**: MS Excel value or formula | ||
| Just like in Excel you can also assign formulas to cells by starting your value with " | Just like in Excel you can also assign formulas to cells by starting your value with " | ||
| - | < | + | {{ : |
| - | Range Set Cell/ | + | |
| - | </ | + | |
| Please note that Djeeni considers the best practice to create your worksheet template first with formulas and then use Djeeni for filling it with data. Setting formulas in a Djeeni process is most of the time unnecessary. | Please note that Djeeni considers the best practice to create your worksheet template first with formulas and then use Djeeni for filling it with data. Setting formulas in a Djeeni process is most of the time unnecessary. | ||