In data manipulation one frequently needs to check and cross check totals by hiding or unhiding some of the data fields. It is therefore of utmost importance that hiding / unhiding should have direct and automatic effect on the resultant figure (total). The Excel has this function which is very much helpful. Because of this limitation in CALC, millions of libreoffice users have to turn to Excel. Inclusion of this functionality will enhance the utility value of the Libreoffice and will attract millions of people to use it. I had previously reported this as bug and requested to improve the functionality but it is not considered any seriously. See it is not cosmetic enhancement but it is improvement of a critical nature which will go a long way in establishing LO as the market leader.
Created attachment 117697 [details] Subtotal function example Worksheet
(In reply to Rajendra Parmar from comment #0) > > I had previously reported this as bug and requested to improve the > functionality but it is not considered any seriously. Which bug number? Thank you
(In reply to raal from comment #2) > (In reply to Rajendra Parmar from comment #0) > > > > I had previously reported this as bug and requested to improve the > > functionality but it is not considered any seriously. > > Which bug number? Thank you Found it : https://bugs.documentfoundation.org/show_bug.cgi?id=87043 and this bug has been tagged as duplicate of https://bugs.documentfoundation.org/show_bug.cgi?id=60477 Still open. I think it is necessary to solve this bug in order to comply with ODF specifications. (Even if I use SUBTOTAL only with filters)
So this bug is again duplicate of bug 60477? As I read the descriptions, I doesn't see a difference between this bug a bug 87043. Closing this as duplicate of bug 60477. @Rajendra, if this bug is different than 60477, set again to unconfirmed and please explain why it's different. If it's duplicate, please do not create new bugs. Thanks *** This bug has been marked as a duplicate of bug 60477 ***
Played again, bug 60477 is resolved, =SUBTOTAL(109;B3:B18) works as expected. But this bug is about recalculation after hiding row. Steps to reproduce> - open attached file. B19 and B36 = 1017 (=SUBTOTAL(109;B3:B18) ) - select row 14 - hide row Actual results> B19 = 1017 CTRL+SHIFT+F9
Played again, bug 60477 is resolved, =SUBTOTAL(109;B3:B18) works as expected. But this bug is about recalculation after hiding row. Steps to reproduce> - open attached file. B19 and B36 = 1017 (=SUBTOTAL(109;B3:B18) ) - select row 14 - hide row Actual results> B19 = 1017 HARD RECALCULATION: CTRL+SHIFT+F9 B19 = 615 Expected results: B19 = 615 LO 4.4.5, win7
(In reply to raal from comment #6) > Played again, bug 60477 is resolved, =SUBTOTAL(109;B3:B18) works as > expected. > But this bug is about recalculation after hiding row. Hi, I confirm that very annoying need to force a recalculation Version 5.0.3.2 and 5.1.0.0.beta1-buildfix1 / Vista 32b Best regards
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.1.6 or 5.2.3 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20170103
*** Bug 106985 has been marked as a duplicate of this bug. ***
Adjusting earliest version, since function indexes 101-111 started working in 4.4.0.3.
Arul Michael, are you planning to work on this issue, or you just wanted to add yourself to the CC list?
(In reply to Aron Budea from comment #11) > Arul Michael, are you planning to work on this issue, or you just wanted to > add yourself to the CC list? I am planning to work on this. Thanks Arul
Arul Michael committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=970b431f1a7b6b96c4c9536657ce4fe9d8f5b585 tdf#93171 Subtotal function with function indexes don't update It will be available in 5.4.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Arul Michael committed a patch related to this issue. It has been pushed to "libreoffice-5-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=318b6b8ea87cba41995436bbc44818a068b35b6d&h=libreoffice-5-3 tdf#93171 Subtotal function with function indexes don't update It will be available in 5.3.4. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Arul Michael committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=47cbf098ee6019a2090b2e933439fd4aa399ed20 New HintId and unit test for hidden rows and SUBTOTAL, tdf#93171 follow-up It will be available in 5.4.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Arul Michael committed a patch related to this issue. It has been pushed to "libreoffice-5-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=70ca2d0bc42a0360055b9c54e6e5edd3ef9317b8&h=libreoffice-5-4 New HintId and unit test for hidden rows and SUBTOTAL, tdf#93171 follow-up It will be available in 5.4.0.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Polite ping: is this bug fixed? if so, please close it as RESOLVED FIXED
I have tested the function and found that it omits the hidden row for the range selected for the SUBTOTAL() but it does not effect subsequent referred cells. Referred cells result does not change. This may be addressed.
I tested and it works; hiding row14; its calculate automatic the subtotal Version: 6.0.0.0.alpha0+ Build ID: 8c82e4877181f55f2fe186b341d504e5782a4f9c CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; Locale: nl-BE (en_US.UTF-8); Calc: group Version: 5.3.4.2 Build ID: SlackBuild for 5.3.4 by Eric Hameleers CPU Threads: 8; OS Version: Linux 4.9; UI Render: default; VCL: kde4; Layout Engine: new; Locale: nl-BE (en_US.UTF-8); Calc: group
Created attachment 134655 [details] Sample files in LO and Excel showing working of Subtotal() function I have also attached Similar subtotal example prepared in LO Calc but it does not appear above. If not linked, the receiver is requested to prepare the same file in LO to check the operation of function in LO.
Referred cells result does not change. This may be addressed. I tested it again and yes your wright Version: 6.0.0.0.alpha0+ Build ID: 1ec04aa8d8f37c82c78d6b98e030a34769d3123e CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2017-07-18_22:38:27 Locale: nl-BE (en_US.UTF-8); Calc: group
This bug is not assigned (anymore), changing to NEW.
Investigating.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=c84332184a5de3e4180514cf6e3282597ffe5dd6 Resolves: tdf#93171 follow-up, notify dependents of subtotal formula cells It will be available in 6.0.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Pending review https://gerrit.libreoffice.org/41530 for 5-4 5-3 is not affected.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=de4a0f769501b0b79b05e007ae340af344017dd0&h=libreoffice-5-4 Resolves: tdf#93171 follow-up, notify dependents of subtotal formula cells It will be available in 5.4.2. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.