The SUBTOTAL() function in Calc does not ignore hidden rows. This is very vital issue for all commercial operations. Only because of this simple reason, millions, like me, are not migrating from Excel to Calc. Please, consider this issue in forth coming 4.4 version.
Hi @Rajendra, thanks for reporting.
Please can you attach a sample file, without personal/confidential information, where to verify the issue.
Created attachment 110499 [details]
Sample file for test
Calculates subtotals. If a range already contains subtotals, these are not used for further calculations. Use this function with the AutoFilters to take only the filtered records into account.
The function works with filtered records, not with manually hidden records.
This behaviour it's from ever, inherited from OpenOffice.
Calc only use only args 1 to 11, not 101 to 111.
*** This bug has been marked as a duplicate of bug 60477 ***
Created attachment 112806 [details]
Subtotal() function does not ignore hidden rows -
Subtotal() function does not ignore hidden rows in CALC. Most users of spreadsheets, need such facility of and on. EXCEL offers this facility. To make the Libreoffice effectve and attract user to shift over to CALC from EXCEL, this change is must and need immediate attention.