Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
en:user_guide:cellrange_basic [2021/01/10 14:12] 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> | {{indexmenu_n> | ||
| - | ====== | + | ====== |
| - | In the [[en: | + | In the [[en: |
| ===== Accessing cells and ranges ===== | ===== Accessing cells and ranges ===== | ||
| Line 25: | Line 25: | ||
| </ | </ | ||
| + | ==== 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 ===== | ===== Setting the value of a cell ===== | ||
| Line 69: | Line 72: | ||
| * the name of an employee can be found in the cell **wsReport!C2** . | * the name of an employee can be found in the cell **wsReport!C2** . | ||
| * the corresponding salary of this employee is on the **wsEmployees** master data worksheet. The wsEmployees worksheet contains employee names in column **B** and **E**; the corresponding salaries are in column **C** and **F**. | * the corresponding salary of this employee is on the **wsEmployees** master data worksheet. The wsEmployees worksheet contains employee names in column **B** and **E**; the corresponding salaries are in column **C** and **F**. | ||
| - | * the found salary must be written into **wsSalaries!D6** | + | * the cell value of the found salary |
| < | < | ||
| Cell Lookup | Cell Lookup | ||
| - | Value: [=wsReport!C2] | + | |
| - | | + | Range: $wsEmployees!B1: |
| - | | + | Cell Set Cell: wsSalaries!D6 |
| - | | + | Value: $wsEmployees![+[# |
| </ | </ | ||
| - | You can use the found cell in many ways (using **ceEmployee** as the [[en: | + | You can use the found cell in many ways (let's use **ceFound** as the [[en: |
| < | < | ||
| Line 92: | Line 95: | ||
| ===== Setting a fixed value to a range ===== | ===== Setting a fixed value to a range ===== | ||
| - | How would you insert the same value to a whole range? In MS Excel you can select the range, enter the value in one of the cells and press Ctrl+Enter. In Djeeni you can use the process step **Range Set** to achieve the same. Range Set works much like Cell Set: | + | How would you insert the same value to a whole range? In MS Excel you can select the range, enter the value in one of the cells and press Ctrl+Enter. In Djeeni you can use the process step **[[en: |
| < | < | ||
| - | Range Set | + | Range Set |
| | | ||
| | | ||
| - | Range Set | + | Range Set |
| | | ||
| | | ||
| - | Range Set | + | Range Set |
| | | ||
| </ | </ | ||
| - | Example: The input data source (wsYearlySell) contains dates from a certain year in months (column B) and day (column C) format. | + | Example: The input data source (**wsYearlySell**) contains dates from a certain year in months (column |
| < | < | ||
| Range Set | Range Set | ||
| - | Value: | + | Value: |
| </ | </ | ||
| - | Note how the range was specified using a [[en: | + | Note how the range was specified using a [[en: |
| ===== Copy or Move a range ===== | ===== 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/ | + | One of the most used data manipulation steps is to copy/move a range from one location to another. Djeeni has the **[[en: |