Apache OpenOffice (AOO) Bugzilla – Issue 94838
Diagram-Axis interval does only accept valid date values
Last modified: 2013-02-24 21:22:28 UTC
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
Created attachment 57109 [details] prepared test file
This is duplicate to issue 87900. For a workaround look there. BTW: If you try to get the grid on every 1. of a month, entering 30.146 will not work. *** This issue has been marked as a duplicate of 87900 ***
close the duplicate