Issue 112716

Summary: Problem in change function of Data > Subtotals
Product: Calc Reporter: gbpacheco <gbpacheco>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues
Version: OOo 3.2.1   
Target Milestone: ---   
Hardware: Unknown   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Subtotals test file none

Description gbpacheco 2010-06-26 03:11:34 UTC
Hi!

 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.

 Thanks!
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.