[Libreoffice-bugs] [Bug 87043] The SUBTOTAL() function in Calc does not ignore hidden rows as in Excel
https://bugs.documentfoundation.org/show_bug.cgi?id=87043 --- Comment #4 from Rajendra Parmar ca.rajendra.par...@gmail.com --- Created attachment 112806 -- https://bugs.documentfoundation.org/attachment.cgi?id=112806action=edit 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. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 87043] The SUBTOTAL() function in Calc does not ignore hidden rows as in Excel
https://bugs.freedesktop.org/show_bug.cgi?id=87043 Robinson Tryon (qubit) qu...@runcibility.com changed: What|Removed |Added Attachment #110499|application/xml |application/vnd.oasis.opend mime type||ocument.spreadsheet CC||qu...@runcibility.com -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 87043] The SUBTOTAL() function in Calc does not ignore hidden rows as in Excel
https://bugs.freedesktop.org/show_bug.cgi?id=87043 GerardF gerard.farg...@orange.fr changed: What|Removed |Added Status|NEEDINFO|RESOLVED CC||gerard.farg...@orange.fr Resolution|--- |DUPLICATE --- Comment #3 from GerardF gerard.farg...@orange.fr --- Calc only use only args 1 to 11, not 101 to 111. *** This bug has been marked as a duplicate of bug 60477 *** -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 87043] The SUBTOTAL() function in Calc does not ignore hidden rows as in Excel
https://bugs.freedesktop.org/show_bug.cgi?id=87043 Rajendra Parmar ca.rajendra.par...@gmail.com changed: What|Removed |Added Priority|medium |highest -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 87043] The SUBTOTAL() function in Calc does not ignore hidden rows as in Excel
https://bugs.freedesktop.org/show_bug.cgi?id=87043 m.a.riosv mari...@miguelangel.mobi changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||mari...@miguelangel.mobi Ever confirmed|0 |1 --- Comment #1 from m.a.riosv mari...@miguelangel.mobi --- Hi @Rajendra, thanks for reporting. Please can you attach a sample file, without personal/confidential information, where to verify the issue. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 87043] The SUBTOTAL() function in Calc does not ignore hidden rows as in Excel
https://bugs.freedesktop.org/show_bug.cgi?id=87043 --- Comment #2 from m.a.riosv mari...@miguelangel.mobi --- Created attachment 110499 -- https://bugs.freedesktop.org/attachment.cgi?id=110499action=edit Sample file for test LibreOffice help: SUBTOTAL 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. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 87043] The SUBTOTAL() function in Calc does not ignore hidden rows as in Excel
https://bugs.freedesktop.org/show_bug.cgi?id=87043 m.a.riosv mari...@miguelangel.mobi changed: What|Removed |Added Priority|highest |medium Severity|critical|normal -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs