Differences

This shows you the differences between two versions of the page.

--- en:process_steps:range_cell:rangeset [2020/02/28 15:42]
tiger created
+++ en:process_steps:range_cell:rangeset [2024/02/24 14:17] (current)
tiger
@@ Line 1: / Line 1: @@
+{{indexmenu_n>2}}
 ====== 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 cell or the same value into a range of cells:
+This step is only applicable for target worksheets. The process step **Range Set** (together with **[[..range_cell:cellset|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):
-<code>
+{{ :en:process_steps:range_cell:rangeset1.png?nolink&800 |}}
-  Range Set    Cell/Range=wsExample!A4:A5    Value=Age
-  Range Set    Cell/Range=wsExample!B4    Value=54
-  Range Set    Cell/Range=wsExample!B5    Value=52
-</code>
-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 with worksheet Djeeni name, column letter and number
+  * **Value / formula**: MS Excel value or formula
-<code>
+Just like in Excel you can also assign formulas to cells by starting your value with "=":
-  Range Set    Cell/Range=wsExample!A4    Value= =[$wsExample!A4]+3
-</code>
+{{ :en:process_steps:range_cell:rangeset2.png?nolink&800 |}}
+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.

User Tools

Site Tools

Differences

Page Tools