To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=94838 Issue #|94838 Summary|Diagram-Axis interval does only accept valid date valu |es Component|Spreadsheet Version|OOo 3.0 RC4 Platform|Macintosh URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|ui Assigned to|spreadsheet Reported by|uwealtmann
------- Additional comments from [EMAIL PROTECTED] Fri Oct 10 11:39:52 +0000 2008 ------- Open attatched test file DateInDiagramAxis.ods Activate Diagram Format > Axis > X-Axis > Scale Try to change major interval from 30.5 to 30.416 (which is the average lengh of a month) Error: "The major interval requires a positive number..." Suppose because number format of x-Axis is set to "Date" there is no possibility to fill in numbers which will not be interpreted as a valid date (31.3 is accepted, 31.2 not). So the error is: Even if an Axis consists of date values, the interval will never be a date but a number of days, hours or something else. So this is one exception of "Interval must be the same data type then axis itself" (which normally would be ok as an assumption). This is all because we don't have Day/Time-Diagram type. Really nice solution would be a selection combo for intervals, displaying Year/Month/Week/Day/Hour/Minute/Second instead of a value if axis' number format is set to a Date/Time type - with correct handling of resulting intervals of course (so we would have a Date/Time-Diagram type at last) :-) Tested on Mac and Win32 --------------------------------------------------------------------- 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]