Talk:Documentation/Calc Functions/SHEET

    From The Document Foundation Wiki

    SF Comments

    (1) Summary. It would be beneficial to clarify what is meant by “sheet number”. It would be easy for somebody to assume that the sheet named “Sheet1” would correspond to sheet number 1, which is only true if Sheet1 is at the left of the sheet tabs area of the Calc main window. Also, in the second sentence, change “any parameters” to “an argument” and change “spreadsheet” to “sheet”.
    (2) Returns. Suggest replacing with – “Returns a positive integer in the range 1 to the number of sheets in the spreadsheet, which is the sheet number for the given argument.”.
    (3) Arguments, Reference. Perhaps replace with – “Reference is a reference to a cell or a cell range, the name of a named range or a database range, or a text string giving the name of a sheet in quotation marks.”.
    (4) Additional details, 1st bullet. Suggest minor re-word as – “Hidden sheets are included when determining the sheet number”.
    (5) Additional details, 2nd bullet. This point feels as if it should be included in the Arguments section. Also, suggest rewording as - “If no argument is given, or if the argument does not specify a sheet, then the function returns the number of the sheet containing the formula.”.
    (6) Additional details, 3rd bullet. An average reader might not understand what this means. Please clarify.
    (7) Additional details, 4th bullet. Again, this feels as if it should be included in the Arguments section.
    (8) Additional details, 5th bullet. Insert “the” before “SHEET”. Please be more specific about why Calc’s implementation does not meet the ODF.
    (9) Examples, general. Please include the example of =SHEET(), an example of =SHEET(“Sales”), and an example of the form =SHEET($Sales.A1:$Profit.F20).
    (10) Examples, 1st example. Delete “document”.
    (11) Examples. 2nd example. In the Formula column, change “Sheet5” to “the fifth sheet”. In the Description column, change “number of Sheet5” to the “sheet number of “rabbit””.
    (12) Examples. 3rd example. Would it be worth including an example showing a call to the function passing the name of a named range that is in scope?
    (13) Related LibreOffice functions. The ODF considers SHEETS() to be related too.

    --Stevefanning (talk) 2020-12-23T11:28:50 (UTC)