Difference between revisions of "Documentation/How Tos/Calc: SHEET function"

From Apache OpenOffice Wiki
Jump to: navigation, search
(See also:)
m
 
(7 intermediate revisions by 4 users not shown)
Line 1: Line 1:
__NOTOC__
+
{{DISPLAYTITLE:SHEET function}}
 +
{{Documentation/CalcFunc SpreadsheetTOC
 +
|ShowPrevNext=block
 +
|PrevPage=Documentation/How_Tos/Calc:_ROWS_function
 +
|NextPage=Documentation/How_Tos/Calc:_SHEETS_function
 +
}}__NOTOC__
  
 
== SHEET ==
 
== SHEET ==
Line 18: Line 23:
 
: returns the current sheet number (of the sheet containing the formula).
 
: returns the current sheet number (of the sheet containing the formula).
  
=== See also: ===
+
{{SeeAlso|EN|
'''[[Documentation/How_Tos/Calc: ROW function|ROW]]''',
+
* [[Documentation/How_Tos/Calc: ROW function|ROW]]
'''[[Documentation/How_Tos/Calc: COLUMN function|COLUMN]]'''
+
* [[Documentation/How_Tos/Calc: COLUMN function|COLUMN]]
  
'''[[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]]

Latest revision as of 12:12, 2 February 2024



SHEET

Returns the sheet number, given a reference.

Syntax:

SHEET(reference)

returns the sheet number of reference, where reference is a reference to a cell.
If reference is omitted, the sheet number of the current sheet (containing the formula) is returned.

Example:

SHEET(Sheet2.C4)

returns 2, if you have 3 sheets - Sheet1, Sheet2, Sheet3 - in that order, because Sheet2 is the second sheet.

SHEET()

returns the current sheet number (of the sheet containing the formula).



See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_SHEET_function&oldid=259996"
Views
Personal tools
Navigation
Tools