Issue 112715 - Problem to delete subtotals
Summary: Problem to delete subtotals
Status: CONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
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: ---

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

 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?

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