Differences

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

--- en:process_steps:range_cell [2020/02/24 10:51]
tiger
+++ en:process_steps:range_cell [2022/04/17 23:22] (current)
tiger
@@ Line 1: / Line 1: @@
+{{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 Djeeni name of the containing worksheet:
+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>
@@ Line 8: / Line 9: @@
 </code>
-Djeeni provides you with these process steps:
+Djeeni provides you with these range/cell related process steps:
-  * Range Use
+  * [[.range_cell:locatevalue|Cell Lookup]]: Find the first cell in a range with a specified value
-  * Range Set
+  * [[.range_cell:cellset|Cell Set]]: Set a value to a cell
-  * Range Copy/Move
+  * [[.range_cell:rangeset|Range Set]]: Set a value to every cell in a range
-  * Column Reorder
+  * [[.range_cell:rangeuse|Range Use]]: Define a named range to be used in further process steps
-  * Timestamp
+  * [[.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

User Tools

Site Tools

Differences

Page Tools