Talk:Documentation/Calc Functions/SUBTOTAL

    From The Document Foundation Wiki

    SF Review comments

    (1) Arguments. Text “Range is the reference to the cell that are included” in not grammatically correct.
    (2) Arguments, 1st bullet point. Should “Number” be changed to “Function”?
    (3) Arguments, 2nd bullet point. Insert “a” before “numeric value”.

    --Stevefanning (talk) 2020-09-27T15:16:44 (UTC)


    A regular user's review comments

    (1) Range. It must be clarified the difference between hidden and filtered out rows. I had a hard time trying to understand an error, and the difference, yet sutil, it's important. It must be reminded to the user that consult the wiki for this sort of inside info.
    (2) Examples shown here only comprise explicit range references, and never a named range nor a database range. This is only the kind of inside info required in this wiki. How a database range is to be used to have a specific column summary?
    (3) When using an autofilter (changing criteria to filter out), should I use manual refresh of sheet calculation? Is it mandatory to be manual? (I cannot make it to do automatically, can I?) A note with these considerations must help a lot.

    LobaLuna (talk) 2023-02-12T19:52:52 (UTC)