Issue 108413 - ODFF: SUBTOTAL with function indexes 101..111
Summary: ODFF: SUBTOTAL with function indexes 101..111
Status: CLOSED DUPLICATE of issue 35718
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 3.0.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-01-18 12:44 UTC by dipesh
Modified: 2013-08-07 15:13 UTC (History)
3 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description dipesh 2010-01-18 12:44:28 UTC 
The Excel documentation/specs say that the first argument, the function index, needs to be >=1
and <=11. But what Excel does when the value is >=100 is to index=index%100 the function
index.

As example the formula "=SUBTOTAL(106,22);" produces in Excel the result 22. In Calc the result
is an error. In KSpread we fixed the formula to also return 22.
Comment 1 ooo 2010-01-20 16:33:31 UTC 
Actually the function indexes 101..111 are not identical to 1..11. Excel
excludes also manually hidden rows for 101..111, which it does not for 1..11.

This will also be specified in the upcoming ODF OpenFormula standard, see
http://tools.oasis-open.org/issues/browse/OFFICE-2030
Comment 2 dipesh 2010-01-22 12:24:26 UTC 
Thanks Eike. We fixed it in KSpread. What we do now is;

if(index>100) {
    index=index%100;
    selectedRange = excludeHiddenRows(selectedRange);
}
Comment 3 Regina Henschel 2010-04-12 17:59:15 UTC 
I close this one, because issue 35718 has got votes.

*** This issue has been marked as a duplicate of 35718 ***
Comment 4 Regina Henschel 2010-04-12 17:59:51 UTC 
closing, duplicate