Issue 110347 - Error with the Data > Subtotals Sum
Summary: Error with the Data > Subtotals Sum
Status: RESOLVED FIXED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 3.2
Hardware: PC Windows XP
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2010-03-23 21:26 UTC by johnmcbay
Modified: 2013-08-02 14:11 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
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 johnmcbay 2010-03-23 21:26:55 UTC 
I have selected a range of cells in a spreadsheet. I have sorted the data by one
of the fields. When I go to Data > Subtotals, the Sum for the first group does
not include the amount of the first numerical item in the group and as a result,
the Grand Sum is also off by the same amount.

If I include the row above the actual data (which in my case is a set of column
descriptions), the Subtotal routine works correctly.
Comment 1 Edwin Sharp 2013-08-02 12:22:39 UTC 
Please attach spreadsheet.
Comment 2 gonzales 2013-08-02 14:01:07 UTC 
(In reply to Edwin Sharp from comment #1)
> Please attach spreadsheet.

This bug is no longer present in the latest version of OpenOffice that I downloaded a few days ago.
Comment 3 Edwin Sharp 2013-08-02 14:11:03 UTC 
Thank you.