To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103949 Issue #|103949 Summary|XY Chart not working if a X cell is set to "Not Availa |ble" Component|Spreadsheet Version|OOO310m11 Platform|All URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|fda
------- Additional comments from f...@openoffice.org Sat Aug 1 15:01:11 +0000 2009 ------- If all X values are numerical values, the X-scale is OK, But if one (or more) X value is equal to "Not Available" (from the function NA() ), the X-scale is wrong. The chart looks like a line chart, but the chart type is displayed as an XY chart. Note that if the #N/A value is in the Y column, there is no problem with the Y scale (#N/A is ignored). I think #N/A values should be ignored if among X values. Exemple: 1) with the following values, X scale goes from 0 to 40 on the graph (==> ok) X Y 0 0,1 10 0,2 20 0,3 30 0,4 40 0,5 2) with the following values, X scale goes from 1 to 5 on the graph (==> not ok) X Y 0 0,1 10 0,2 =NA() 0,3 30 0,4 40 0,5 --------------------------------------------------------------------- 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