To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=112716
Issue #|112716
Summary|Problem in change function of Data > Subtotals
Component|Spreadsheet
Version|OOo 3.2.1
Platform|Unknown
URL|
OS/Version|Windows XP
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|editing
Assigned to|spreadsheet
Reported by|gbpacheco
------- Additional comments from gbpach...@openoffice.org Sat Jun 26 02:11:34
+0000 2010 -------
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!
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
