Differences

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

--- en:user_guide:cellrange_basic [2021/01/10 14:21]
tiger [Setting a fixed value to a range]
+++ en:user_guide:cellrange_basic [2022/04/19 18:46] (current)
tiger [Accessing and Setting Data in Cells or Ranges]
@@ Line 1: / Line 1: @@
 {{indexmenu_n>5}}
-====== Accessing and Setting Data in Cells or Ranges  ======
+====== Working with Data in Cells/Ranges  ======
-In the [[en:user_guide:worksheet_basic|previous section]] we saw how to identify worksheets. The next step is to access the data on a worksheet.
+In the [[en:user_guide:worksheet_basic|previous section]], we have learned how to identify worksheets. The next step is to access data on a worksheet.
 ===== Accessing cells and ranges =====
@@ Line 25: / Line 25: @@
 </code>
+==== Absolute cell reference ====
+MS Excel uses the **$** notation to prevent formulas to change their cell references when copied or moved from one cell to another (e.g. $F7,T$23). In Djeeni, cells are referenced using the above Djeeni notation that does not require and also does not allow **$**. Never use **$** in any cell reference within Djeeni.
 ===== Setting the value of a cell =====
@@ Line 73: / Line 76: @@
 <code>
   Cell Lookup     Djeeni name: ceEmployee
-                   Value: [=wsReport!C2]
+                  Value: [=wsReport!C2]
-                   Range: $wsEmployees!B1:E#RowEnd
+                  Range: $wsEmployees!B1:E#RowEnd
-   Cell Set        Cell: wsSalaries!D6
+  Cell Set        Cell: wsSalaries!D6
-                   Value: $wsEmployees![+[#ceEmployee|column]+1][#ceEmployee|row]
+                  Value: $wsEmployees![+[#ceEmployee|column]+1][#ceEmployee|row]
 </code>
@@ Line 105: / Line 108: @@
 </code>
-Example: The input data source (wsYearlySell) contains dates from a certain year in months (column B) and day (column C) format.  The data must be added to a multi-year summary sheet. Before adding the dates they must be completed by the year part (in Column D)
+Example: The input data source (**wsYearlySell**) contains dates from a certain year in months (column **B**) and day (column **C**) format.  The data must be added to a multi-year summary sheet. Before adding the dates they must be completed by the year part (in Column **D**)
 <code>
   Range Set     Range: wsYearlySell!D2:D[#RowEnd|C]
-                Value: 2020
+                Value: 2021
 </code>
-Note how the range was specified using a [[en:concepts:djeeniformula|Djeeni formula]] to match the already entered days in Column C
+Note how the range was specified using a [[en:concepts:djeeniformula|Djeeni formula]] to match the already entered days in Column **C**
 ===== Copy or Move a range =====
-One of the most used data manipulation steps is to copy/move a range from one location to another. Djeeni has the **Copy/Move Range to** process step to carry out this operation, including the options that are provided by MS Excel itself. It can be specified if the range is coped or moved; if it overwrites the target range or will be inserted; and if only values or also formatting and formulas must be copied/moved.
+One of the most used data manipulation steps is to copy/move a range from one location to another. Djeeni has the **[[en:process_steps:range_cell:rangecopymove|Copy/Move Range to]]** process step to carry out this operation, including the options that are provided by MS Excel itself. It can be specified if the range is coped or moved; if it overwrites the target range or will be inserted; and if only values or also formatting and formulas must be copied/moved.

User Tools

Site Tools

Differences

Page Tools