Difference between revisions of "Documentation/How Tos/Calc: ROW function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m |
m (→Syntax:) |
||
Line 16: | Line 16: | ||
: If <tt>'''reference'''</tt> is omitted, the row number of the current cell (containing the formula) is returned. | : If <tt>'''reference'''</tt> is omitted, the row number of the current cell (containing the formula) is returned. | ||
− | : If <tt>'''reference'''</tt> is a range of cells <u>and</u> the formula is entered as an array formula (by pressing {{key|Ctrl|Shift|Enter}} rather than | + | : If <tt>'''reference'''</tt> is a range of cells <u>and</u> the formula is entered as an array formula (by pressing {{key|Ctrl|Shift|Enter}} rather than {{key|Enter}}) a single column array of row numbers is returned. |
=== Example: === | === Example: === |