To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=88825 Issue #|88825 Summary|When changing graph range with discontinous ranges, it | also resets graph statistics (e.g. mean) Component|Spreadsheet Version|OOo 2.3 Platform|All URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|zanttu
------- Additional comments from [EMAIL PROTECTED] Tue Apr 29 05:48:22 +0000 2008 ------- Further information: Fedora 8, RPM is "openoffice.org-calc-2.3.0-6.14.fc8". Steps to reproduce: 1. Open blank spreadsheet 2. Insert values A, B, C, D into column A 3. Leave column B blank (this is important) 4. Insert values 1, 2, 3, 4 into column C 5. Select using mouse and control range A1:A3 and C1:C3 (e.g. leave A4 and C4 unselected) 6. Choose Insert>Chart 7. Click Finish (graph defaults are ok) 8. Double-click on any graph bar to get the "Data Series" dialog open 9. In "Data Series" dialog choose "Statistics" tab 10. Click "Mean value" checkbox to ON value (checked) 11. Click OK (close dialog) Note that the graph has a mean value line. 12. Right-click over the graph, select "Data Ranges" 13. Increase range to include A4 and C4 elements, e.g. change "Data range" from "$Sheet1.$A$1:$A$3;$Sheet1.$C$1:$C$3" to "$Sheet1.$A$1:$A$4;$Sheet1.$C$1:$C$4" 14. Click OK (close dialog) Observe that the graph no longer has a mean value line. Note: This bug *does not* show up if you have continuous graph range, e.g. if you put values into column B instead of C and select range A1:B3 at start and extend it to A1:B4 -- the mean value won't be removed in that case. --------------------------------------------------------------------- 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]