To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=51302 Issue #:|51302 Summary:|Consolidation issue Component:|Spreadsheet Version:|680m109 Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P4 Subcomponent:|formatting Assigned to:|spreadsheet Reported by:|abdul
------- Additional comments from [EMAIL PROTECTED] Tue Jun 28 03:55:24 -0700 2005 ------- If you uncheck the options 'Row labels' and 'Column labels' ,Consolidation is not happening 1.Open the document that contains the cell ranges to be consolidated. 2.Choose Data - Consolidate to open the Consolidate dialog. 3.From the Source data area box, select a source cell range to consolidate with other areas. 4.Click Add to insert the selected range in the Consolidation areas field. 5.Select additional ranges and click Add after each selection. 6.Specify where you want to display the result by selecting a target range from the Copy results to box 7.Select 'Sum' function from the Function box 8. Choose 'More' and Uncheck 'Row labels' and 'Column labels' and click 'OK' OOo 1.9.109 not consolidation the selected areas --------------------------------------------------------------------- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]