Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||sum for filtered columns should be SUBTOTAL|
|Status:||CLOSED IRREPRODUCIBLE||QA Contact:||issues@sc <issues>|
|Issue Type:||ENHANCEMENT||Latest Confirmation in:||---|
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
Hi, 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.. Frank *** This issue has been marked as a duplicate of 2977 ***
Comment 2 frank 2004-03-23 16:54:54 UTC
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
Hi, 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. Frank
Comment 7 frank 2004-03-25 10:06:28 UTC
Hi Bettina, please see my latest comment. Frank
Comment 8 ace_dent 2008-05-16 02:54:47 UTC
OpenOffice.org 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: http://download.openoffice.org/index.html or consider trying the new OOo 3 BETA (still in testing): http://download.openoffice.org/3.0beta/ 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: http://www.openoffice.org/issues/query.cgi Many thanks, Andrew Cleaning-up and Closing old Issues as part of: ~ The Grand Bug Squash, pre v3 ~ http://marketing.openoffice.org/3.0/announcementbeta.html
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)