Issue 112715 - Problem to delete subtotals
Summary: Problem to delete 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 02:26 UTC by gbpacheco
Modified: 2013-07-06 19:33 UTC (History)
4 users (show)

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

Subtotals test file (9.46 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-06-26 02:36 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 02:26:55 UTC

 1. Create a example spreadsheet like the file attachment;
 2. select cells;
 3. apply the subtotals (Data menu > Subtotals), choosing:
    Group by: Code 
    Calculate subtotals for: Price
    Use function: Average
 4. click OK.

  The subtotals will be apply to the cells. Then, after this, return to Data >
Subtotals to delete the subtotals:
 1. go to Data > Subtotals;
 2. click Delete

 The cells will be return to the original structure. Now, create a new subtotals
with a diferent function (Sum instead of Average).
 1. go to Data > Subtotals;
 2. apply the subtotals, choosing:
    Group by: Code 
    Calculate subtotals for: Price
    Use function: Sum
 3. click OK.

 The subtotals will be apply. However, the function wich will be used is
Average, not Sum. It´s a bug or my mistake?

Comment 1 gbpacheco 2010-06-26 02:36:13 UTC
Created attachment 70230 [details]
Subtotals test file
Comment 2 gbpacheco 2010-06-26 02:48:53 UTC
An additional information: if, instead to use the Delete button, you:
  - select 'none' in Group by;
  - click OK,

 the subtotals will be erased completely and the second use of subtotals will be
apply without problems, with the function Sum.
Comment 3 ohallot 2010-07-01 22:23:30 UTC
I confirm this buggy behaviour.
Comment 4 cno 2010-08-30 22:35:42 UTC
Hi Gbpacheco,

Can you pls try how it works if you, *before* applying the Subtotal function
again, first ut the focus in a cell outside the range?
For me, it works OK if I do that.
(Still a bug, however, IMO)

Greetings from Budapest ;-) -Cor
Comment 5 Edwin Sharp 2013-07-06 19:33:23 UTC
As given in description.

Rev. 1499775 Win 7