Issue 112716 - Problem in change function of Data > Subtotals
Summary: Problem in change function of Data > Subtotals
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.2.1
Hardware: Unknown Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2010-06-26 03:11 UTC by gbpacheco
Modified: 2013-07-14 20:59 UTC (History)
2 users (show)

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

Subtotals test file (9.54 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-06-26 03:13 UTC, gbpacheco
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description gbpacheco 2010-06-26 03:11:34 UTC

 1. Open the file Subtotals_test_2.ods in attachment
 2. select B4:D13
 3. apply the subtotals (Data menu > Subtotals), choosing:
    Group by: Code 
    Calculate subtotals for: Price
    Use function: Sum
 4. click OK.

 The subtotals will be apply to the cells. Then, after this, return to Data >
Subtotals to change the function to Average.

 When you click in Average (in 'Use function' list), the first option in the
'Calculate subtotals for' (in this case, 'Code') will be selected too. 

 If an user with basic knowledge clicks OK without correct the option, #DIV/0!
appears if the column contains text, like the column Code.

 I think it´s happening because the first option in the 'Calculate subtotals
for' is always highlighted after a first application of Subtotals. 

 My suggest is select the option used in the last configuration of Subtotals. In
this case, Price should be selected after the first use.

Comment 1 gbpacheco 2010-06-26 03:13:07 UTC
Created attachment 70231 [details]
Subtotals test file
Comment 2 Edwin Sharp 2013-07-06 19:27:51 UTC
As given in description - when selecting average code is checked for no reason.
After uncheck code sum is the result and not average.

Rev. 1499775 Win 7
Comment 3 Edwin Sharp 2013-07-14 20:59:02 UTC
Test Case ID AOOTest-355 :: Version : 1
Data-)Subtotals_Delete Subtotals on different subtotal ranges in one sheet.