Differences

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

--- en:user_guide:cellrange_basic [2021/01/10 14:56]
tiger [Accessing a cell by looking its value up]
+++ 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 =====