Issue 26877 - sum for filtered columns should be SUBTOTAL
Summary: sum for filtered columns should be SUBTOTAL
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: bettina.haberer
QA Contact: issues@sc
Depends on:
Reported: 2004-03-23 16:31 UTC by mandreiana
Modified: 2009-11-16 14:31 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

sample document to work on (7.65 KB, application/vnd.sun.xml.calc)
2004-03-25 07:29 UTC, mandreiana
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description mandreiana 2004-03-23 16:31:44 UTC
I'm not sure this is a defect or enhancement.

On MS Excel, filter a sheet by a code. 
Press SUM icon for a column, the formula used will be SUBTOTAL( 9; range ).
Calc will use the regular SUM, which gives the total for all sheet. Please use
SUBTOTAL automatically when the sheet is filtered.

Also, in MS Excel there are additional empty rows on filtered sheet, as usual,
available for entering new data. In Calc you have to disable filter to get back
to  empty rows after the data rows.
Comment 1 frank 2004-03-23 16:54:35 UTC

I think you're talking about the Autofilter. If so, this Issue is a double to
Issue 2977. Please have a look on it. I will close this Issue as a double. If
the description of Issue 2977 will not fit, feel free to reopen this Issue and
add a step by step description about what you want to achieve..


*** This issue has been marked as a duplicate of 2977 ***
Comment 2 frank 2004-03-23 16:54:54 UTC
closed double
Comment 3 mandreiana 2004-03-25 07:26:47 UTC
Not a duplicate. I don't see how to reopen as in regular Bugzilla. 
Will attach sample document and comments.

------- Additional comments from rtrout Wed Mar 24 13:29:04 -0800 2004 -------

mandreiana I don't think this issue is intended to address your problem with the
sum toolbar icon for choosing sum/subtotal. You will need to check for other
issues or create one yourself.
Comment 4 mandreiana 2004-03-25 07:29:00 UTC
Created attachment 14059 [details]
sample document to work on
Comment 5 mandreiana 2004-03-25 07:31:47 UTC
1. select the filter Altele
2. press on Sum icon (sigma) and select F column (2 values)

SUM will give the result for all rows, including those which aren't displayed.
The MS Excel behaviour is better, automatically using the formula SUBTOTAL( 9;
range ) and giving the proper result.

Please fix this in OOo too.
Comment 6 frank 2004-03-25 10:05:51 UTC

so we have to Issues in  one.

Using sum for all rows even the hidden ones is a double to Issue 2977.

Using subtotal instead of sum is another Issue which has to be handled as an
Request for Enhancement. I re-open this Issue as Enhancement and reassign it.

Bettina, the summary of this Issue is : Use subtotal instead of sum if you click
on the Sum Icon with active Autofilter.

IMHO the solution to skip hidden cells in the sum function should be enough so
solving Issue 2977 should be the goal.

Comment 7 frank 2004-03-25 10:06:28 UTC
Hi Bettina,

please see my latest comment.

Comment 8 ace_dent 2008-05-16 02:54:47 UTC Issue Tracker - Feedback Request.

The Issue you raised has the status 'New' pending further action, but has not
been updated within the last 4 years. Please consider re-testing with one of the
latest versions of OOo, as the problem(s) may have already been addressed.
Either use the recent stable version:
or consider trying the new OOo 3 BETA (still in testing):
Please report back the outcome so this Issue may be Closed or Progressed as
necessary - otherwise it may be Resolved as Invalid in the future. You may also
wish to search for (and note) any duplicates of this Issue that may have
advanced further by checking the Issue Tracker:
Many thanks,
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~
Comment 9 camillem 2009-11-16 13:40:07 UTC
This is fixed in OOo 3.1 (and was probably before) : can someone close the issue?
Comment 10 oc 2009-11-16 14:30:42 UTC
already implemented (or fixed) => closed
Comment 11 oc 2009-11-16 14:31:21 UTC
closed because worksforme (ooo320m4)