Issue 110347

Summary:	Error with the Data > Subtotals Sum
Product:	Calc	Reporter:	johnmcbay <johnmcbay>
Component:	programming	Assignee:	AOO issues mailing list <issues>
Status:	RESOLVED FIXED	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	elish, gonzales, issues
Version:	OOo 3.2	Keywords:	needmoreinfo
Target Milestone:	---
Hardware:	PC
OS:	Windows XP
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

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.