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/02/28 15:52] tiger |
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** is the Djeeni counterpart of data entry on a worksheet. You can enter a value into a single | + | This step is only applicable for target worksheets. |
| - | < | + | {{ :en: |
| - | Range Set Cell/ | + | |
| - | Range Set Cell/ | + | |
| - | Range Set Cell/ | + | |
| - | </ | + | |
| - | You do not have to use double quotes to assign text values. | + | A value or formula can be set to a range with the following parameters: |
| - | Just like in Excel you can also assign formulas to cells by starting your value with =: | + | * **Range**: Complete Djeeni range reference |
| + | * **Value / formula**: MS Excel value or formula | ||
| - | < | + | 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. | ||