Djeeni Documentation

User Tools

Site Tools

Trace:

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
en:concepts:djeeniformula [2023/07/25 00:06]
tiger [Djeeni formula extensions overview] 		en:concepts:djeeniformula [2023/07/26 14:41] (current)
tiger [Last row in a column]
Line 25: Line 25:
 | Last column with data in row 1 | [#ColumnEnd] or #ColumnEnd | - | [$wsName!**[#ColumnEnd]**2] | | Last column with data in row 1 | [#ColumnEnd] or #ColumnEnd | - | [$wsName!**[#ColumnEnd]**2] |
 | Last column with data in a specific row | [#ColumnEnd%%|%%Row] | - | [$wsName!**[#ColumnEnd%%|%%2]**2] | | Last column with data in a specific row | [#ColumnEnd%%|%%Row] | - | [$wsName!**[#ColumnEnd%%|%%2]**2] |
 +| First column after last with data in row 1 | [#ColumnNext] or #ColumnNext | - | [$wsName!**[#ColumnNext]**2] |
 +| First column after last one with data in a specific row | [#ColumnNext%%|%%Row] | - | [$wsName!**[#ColumnNext%%|%%2]**2] |
 | Last row with data in column A | [#RowEnd] or #RowEnd | - | [$wsName!C**#RowEnd**] | | Last row with data in column A | [#RowEnd] or #RowEnd | - | [$wsName!C**#RowEnd**] |
 | Last row with data in a specific column | [#RowEnd%%|%%Column] | - | [$wsName!C**#RowEnd%%|%%C**] | | Last row with data in a specific column | [#RowEnd%%|%%Column] | - | [$wsName!C**#RowEnd%%|%%C**] |
 +| First row after the last one with data in column A | [#RowNext] or #RowNext | - | [$wsName!C**#RowNext**] |
 +| First row after the last one with data in a specific column | [#RowNext%%|%%Column] | - | [$wsName!C**#RowNext%%|%%C**] |
 | Current row/column of the innermost Row/Column List | [#] or # | - | [$wsName!F**#**] | | Current row/column of the innermost Row/Column List | [#] or # | - | [$wsName!F**#**] |
 | Current row/column of a specified Row/Column List | [#%%|%%DjeeniName]  | - | [$wsName!F**[#%%|%%rlRowList]**] | | Current row/column of a specified Row/Column List | [#%%|%%DjeeniName]  | - | [$wsName!F**[#%%|%%rlRowList]**] |
Line 110: Line 114:
 <code> <code>
   [$wsExample!C[#RowEnd|B]]    'the cell in column C that is next to the last cell in column B   [$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> </code>
  
Line 124: Line 142:
 <code> <code>
   [$wsExample![#ColumnEnd|4]3]    'the cell in row 3 that is above the last cell in row 4   [$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> </code>
  

Page Tools

en/concepts/djeeniformula.1690236418.txt.gz ยท Last modified: 2023/07/25 00:06