Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | ODFF: Excels subtotal function knows two parameter sets. One to include hidden cell and one to exclude hidden cells. OpenOffice.org should behave the same way. | ||
---|---|---|---|
Product: | Calc | Reporter: | frank |
Component: | editing | Assignee: | AOO issues mailing list <issues> |
Status: | CONFIRMED --- | QA Contact: | |
Severity: | Trivial | ||
Priority: | P3 | CC: | cmoulin, issues, mrost, ooo, orcmid, rb.henschel, yanji.yj |
Version: | 680m56 | Keywords: | ms_interoperability, rfe_eval_ok |
Target Milestone: | --- | ||
Hardware: | All | ||
OS: | All | ||
Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
frank
2004-10-18 14:29:53 UTC
Frank, And the parameters are exactly what? Eike The parameters 1 to 11 does not ignore hidden cells while parameters 101 to 111 ignores hidden cells. This is for Excel 2003 Frank enhanced summary, set keywords and reassigned issue according to RFE process OpenOffice.org Issue Tracker - Feedback Request. The Issue you raised is currently assigned to 'Requirements' pending review, but has not been updated within the last 3 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 issue is still affecting version 3.0.1. The description of Excel behaviour http://office.microsoft.com/en-us/excel/HP100624631033.aspx?pid=CH100645361033 The set 101..111 is specified in ODF1.2 draft too. Adding ODFF to summary. *** Issue 108413 has been marked as a duplicate of this issue. *** *** Issue 120553 has been marked as a duplicate of this issue. *** The updated site for the excel behavior: https://support.office.com/en-us/article/SUBTOTAL-function-e27c301c-be9a-458b-9d12-b9a2ce3c62af This issue is still affecting version 4.1.1 (In reply to mrost from comment #10) > The updated site for the excel behavior: > > https://support.office.com/en-us/article/SUBTOTAL-function-e27c301c-be9a- > 458b-9d12-b9a2ce3c62af > > This issue is still affecting version 4.1.1 Thank you for confirming this. I assume you mean that both function numbers, 1 to 11 and 101 to 111 are still not supported. These are now specified for ODF 1.2 OpenFormula the same as for Excel. PS: The SUBTOTAL parameters specified for ODF 1.2 OpenFormula are not quite the same as those employed for the Excel p1, p2, ..., however. This may be an error in the OpenFormula specification and not in the Apache OpenOffice implementation. (In reply to orcmid from comment #11) > (In reply to mrost from comment #10) > > The updated site for the excel behavior: > > > > https://support.office.com/en-us/article/SUBTOTAL-function-e27c301c-be9a- > > 458b-9d12-b9a2ce3c62af > > > > This issue is still affecting version 4.1.1 > > Thank you for confirming this. I assume you mean that both function > numbers, 1 to 11 and 101 to 111 are still not supported. These are now > specified for ODF 1.2 OpenFormula the same as for Excel. > > PS: The SUBTOTAL parameters specified for ODF 1.2 OpenFormula are not quite > the same as those employed for the Excel p1, p2, ..., however. This may be > an error in the OpenFormula specification and not in the Apache OpenOffice > implementation. Function numbers 1 thru 11 work fine. It's function numbers 101 thru 111 that are the problem. At this point I'd be fine if both sets of numbers did the same thing, just so it wouldn't always give the formula errors when I open excel spreadsheets with subtotals. |