Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | sum for filtered columns should be SUBTOTAL | ||||||
---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | mandreiana <marius.andreiana> | ||||
Component: | code | Assignee: | bettina.haberer | ||||
Status: | CLOSED IRREPRODUCIBLE | QA Contact: | issues@sc <issues> | ||||
Severity: | Trivial | ||||||
Priority: | P3 | CC: | issues | ||||
Version: | OOo 1.1 | ||||||
Target Milestone: | --- | ||||||
Hardware: | All | ||||||
OS: | All | ||||||
Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
Description
mandreiana
2004-03-23 16:31:44 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 *** closed double 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. Created attachment 14059 [details]
sample document to work on
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. 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 Hi Bettina, please see my latest comment. Frank 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 This is fixed in OOo 3.1 (and was probably before) : can someone close the issue? already implemented (or fixed) => closed closed because worksforme (ooo320m4) |