Differences

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

--- en:process_steps:range_cell [2020/01/07 17:12]
andraz
+++ en:process_steps:range_cell [2022/04/17 23:22] (current)
tiger
@@ Line 1: / Line 1: @@
-====== Range / Cell Group ======
+{{indexmenu_n>2}}
+====== Working with Ranges / Cells  ======
+You can work with cells and ranges on a worksheet in Djeeni much like you do it in MS Excel itself. To know for sure which cell or range is affected by a process step all cell and range references must be preceded by the [[en:concepts:djeeniname|Djeeni name]] of the containing worksheet:
+<code>
+  wsInput!D4
+  wsReport!A2:B6
+</code>
+Djeeni provides you with these range/cell related process steps:
+  * [[.range_cell:locatevalue|Cell Lookup]]: Find the first cell in a range with a specified value
+  * [[.range_cell:cellset|Cell Set]]: Set a value to a cell
+  * [[.range_cell:rangeset|Range Set]]: Set a value to every cell in a range
+  * [[.range_cell:rangeuse|Range Use]]: Define a named range to be used in further process steps
+  * [[.range_cell:rangecopymove|Range Copy/Move]]: Copy or move a range to another location
+  * [[.range_cell:columnreorder|Column Reorder]]: Reorder the columns of a worksheet in one step
+  * [[.range_cell:timestamp|Timestamp]]: Set the value of a cell to the current timestamp
+  * [[.range_cell:insertrowcolumn|Insert Row / Column]]: Insert rows/columns into an existing data set