This step is only applicable for target worksheets. 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):
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 “=”:
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.