Talk:Documentation/Calc Functions/SHEETS

SF Comments

 * (1) Summary. Suggest changing “any parameters” to “an argument”.
 * (2) Syntax. The Reference argument should be surrounded by square brackets to indicate that it is optional.
 * (3) Returns. Suggest replacing with – “Returns a positive integer in the range 1 to 10000, which is the total number of sheets for the given argument.”.
 * (4) Arguments, Reference. Perhaps replace with – “Reference is a reference to a cell or a cell range, or the name of a named range or a database range.
 * (5) Arguments, general. How does the function behave if the argument is a named range that contains multiple areas?
 * (6) Additional details, 1st bullet. Suggest minor re-word as – “Hidden sheets are included when determining the number of sheets”.
 * (7) Examples, general. Please include an example with a single cell reference such as =SHEETS($Sales.C4).
 * (8) Examples, 1st example. Suggest adding the following after the formula – “where Sheet2 follows Sheet1, and Sheet3 follows Sheet 2”.
 * (9) Examples, 2nd example. Maybe re-word Description as – “Since there is no argument supplied, the function counts all sheets in the document”.
 * (10) Examples, 3rd example. Suggest adding the following in the Formula column – “and Sheet2 follows Sheet 1”. Delete the second sentence of the Description because it adds no value.
 * (11) Related LibreOffice functions. The ODF considers SHEET to be related too.

--Stevefanning (talk) 2020-12-23T12:03:42 (UTC)