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):

Just like in Excel you can also assign formulas to cells by starting your value with “=”:

  Range Set    Cell/Range=wsExample!C2    Value= =[$wsExample!B2]+3

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.