Difference between revisions of "Documentation/How Tos/Calc: ROW function"
From Apache OpenOffice Wiki
< Documentation | How Tos
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
m (→Syntax:) |
||
(7 intermediate revisions by 5 users not shown) | |||
Line 1: | Line 1: | ||
− | __NOTOC__ | + | {{DISPLAYTITLE:ROW function}} |
+ | {{Documentation/CalcFunc SpreadsheetTOC | ||
+ | |ShowPrevNext=block | ||
+ | |PrevPage=Documentation/How_Tos/Calc:_INFO_function | ||
+ | |NextPage=Documentation/How_Tos/Calc:_ROWS_function | ||
+ | }}__NOTOC__ | ||
== ROW == | == ROW == | ||
Line 11: | 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 | + | : 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: === | ||
Line 20: | Line 25: | ||
: if entered in cell D2, returns <tt>'''2'''</tt>. Cell D2 is on the second row. | : if entered in cell D2, returns <tt>'''2'''</tt>. Cell D2 is on the second row. | ||
− | <tt>'''ROW(D5:D8)'''</tt> (entered with the | + | <tt>'''ROW(D5:D8)'''</tt> (entered with the {{key|Enter}} key) |
: returns <tt>'''5'''</tt>. This is <u>not</u> an array formula, so the row number of the first cell D5 is returned. | : returns <tt>'''5'''</tt>. This is <u>not</u> an array formula, so the row number of the first cell D5 is returned. | ||
− | <tt>'''ROW(D5:D8)'''</tt> (entered with | + | <tt>'''ROW(D5:D8)'''</tt> (entered with {{key|Ctrl|Shift|Enter}}) |
: returns the single column array <tt>'''{5; 6; 7; 8}'''</tt>, as this <u>is</u> an array formula. If this formula is entered in cell A1, A1 will display <tt>'''5'''</tt>, A2 <tt>'''6'''</tt>, A3 <tt>'''7'''</tt> and A4 <tt>'''8'''</tt>. | : returns the single column array <tt>'''{5; 6; 7; 8}'''</tt>, as this <u>is</u> an array formula. If this formula is entered in cell A1, A1 will display <tt>'''5'''</tt>, A2 <tt>'''6'''</tt>, A3 <tt>'''7'''</tt> and A4 <tt>'''8'''</tt>. | ||
− | {{ | + | {{SeeAlso|EN| |
* [[Documentation/How_Tos/Calc: COLUMN function|COLUMN]] | * [[Documentation/How_Tos/Calc: COLUMN function|COLUMN]] | ||
− | * [[Documentation/How_Tos/Calc: SHEET function|SHEET]] | + | * [[Documentation/How_Tos/Calc: SHEET function|SHEET]] |
* [[Documentation/How_Tos/Calc: Information functions|Information functions]] | * [[Documentation/How_Tos/Calc: Information functions|Information functions]] | ||
− | * [[Documentation/How_Tos/Calc: Spreadsheet functions|Spreadsheet functions]] | + | * [[Documentation/How_Tos/Calc: Spreadsheet functions|Spreadsheet functions]] |
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | ||
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | ||
+ | [[Category: Documentation/Reference/Calc/Spreadsheet functions]] |