Difference between revisions of "Documentation/How Tos/Calc: COLUMN function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m |
m |
||
(2 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | __NOTOC__ | + | {{DISPLAYTITLE:COLUMN function}} |
+ | {{Documentation/CalcFunc SpreadsheetTOC | ||
+ | |ShowPrevNext=block | ||
+ | |PrevPage=Documentation/How_Tos/Calc:_AREAS_function | ||
+ | |NextPage=Documentation/How_Tos/Calc:_COLUMNS_function | ||
+ | }}__NOTOC__ | ||
== COLUMN == | == COLUMN == | ||
Line 11: | Line 16: | ||
: If <tt>'''reference'''</tt> is omitted, the column number of the current cell (containing the formula) is returned. | : If <tt>'''reference'''</tt> is omitted, the column 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 row array of column numbers is returned. |
=== Example: === | === Example: === | ||
Line 26: | Line 31: | ||
: returns the single row array <tt>'''{4; 5; 6}'''</tt>, as this <u>is</u> an array formula. If this formula is entered in cell A1, A1 will display <tt>'''4'''</tt>, B1 <tt>'''5'''</tt> and C1 <tt>'''6'''</tt>. | : returns the single row array <tt>'''{4; 5; 6}'''</tt>, as this <u>is</u> an array formula. If this formula is entered in cell A1, A1 will display <tt>'''4'''</tt>, B1 <tt>'''5'''</tt> and C1 <tt>'''6'''</tt>. | ||
− | {{ | + | {{SeeAlso|EN| |
* [[Documentation/How_Tos/Calc: ROW function|ROW]] | * [[Documentation/How_Tos/Calc: ROW function|ROW]] | ||
* [[Documentation/How_Tos/Calc: SHEET function|SHEET]] | * [[Documentation/How_Tos/Calc: SHEET function|SHEET]] |