Differences

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

--- en:concepts:djeeniformula [2023/07/26 14:37]
tiger [Djeeni formula extensions overview]
+++ en:concepts:djeeniformula [2023/07/26 14:41] (current)
tiger [Last row in a column]
@@ Line 114: / Line 114: @@
 <code>
   [$wsExample!C[#RowEnd|B]]    'the cell in column C that is next to the last cell in column B
+</code>
+===== Next row in a column =====
+You can find the next row after the last one with data in column A by typing **[#RowNext]**. If you are inside a Djeeni formula extension you may leave [] out and type simply **#RowNext**:
+<code>
+  [$wsExample!C#RowNext]    'the cell in Column C that is in the row of the first empty cell in column A
+</code>
+You can refer to the first row after the last one with data of any column by typing **[#RowNext%%|%%ColumnLetter]**:
+<code>
+  [$wsExample!C[#RowNext|B]]    'the cell in column C that is next to the first empty cell in column B
 </code>
@@ Line 128: / Line 142: @@
 <code>
   [$wsExample![#ColumnEnd|4]3]    'the cell in row 3 that is above the last cell in row 4
+</code>
+===== Next column in a row =====
+You can find the first column after the last one with data in row 1 by typing **[#ColumnNext]**. If you are inside a Djeeni formula extension you may leave [] out and type simply **#ColumnNext**:
+<code>
+  [$wsExample!#ColumnNext3]    'the cell in row 3 that is under the first empty cell in row 1
+</code>
+You can refer to the last column of any row by typing **[#ColumnNext%%|%%RowNumber]**:
+<code>
+  [$wsExample![#ColumnNext|4]3]    'the cell in row 3 that is above the first empty cell in row 4
 </code>

User Tools

Site Tools

Differences

Page Tools