Differences

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

--- en:user_guide:cellrange_basic [2021/01/10 14:26]
tiger [Copy or Move 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>

User Tools

Site Tools

Differences

Page Tools