Apache OpenOffice (AOO) Bugzilla – Issue 6724
BUG! axis interval max: transforms time data 24:00:00 to 00:00:00 then saying "error, min must be smaller max." when clicking OK
Last modified: 2013-02-24 21:21:38 UTC
x-axis data is in time format (time mask HH:MM:SS applied to cells containing x- axis data). when manually entering the maximum data value for the x-axis interval length (in the above time mask format of course) which is 24:00:00, when clicking Ok, 2 things hapen. First, 24 becomes 00, Second an error is displayed "min grater than max please". I assume it is then also impossible to work with times crossing day border like 23:00:00 to 03:00:00 (that means one can't chart such data appropriately!) Please correct!
It's not a bug ! One day has 24 Hours starting with 0:00 ending with 23:59:59 so this is correct if you use HH:MM:SS as number format. If you use [hh]:mm:ss as numberformat it will work. Frank
closed as invalid
if I change masks in source data, this is not updated in the chart (=> enhancement suggestion ... -> new issue) but I like to have hh:mm:ss then I CAN'T MANUALLY have 23:00:00 to 24:15:00 NEITHER can I have 23:00:00 to 00:15:00 currently.
parhaps the problem hasn't become clear: one can't have sth like 23:00:00 to 24:00:00 charted, because when clicking OK, 24:00:00 transform into 00:00:00 and then a pop-up message box appears saying: error, min must be smaller than max and one is left with the scale dialog. no manual day-border-cross charts -- That's the problem
You have just to add 24 hours. For your example from 23:00 to 3:00 just set the minimum to 23:00 and the maximum to 27:00. The 27 reflects that it's 3 at the next day. This must be so, as we have no 24:00 but only 00:00. For values between 23:00 and 00:15, just write 23:75. Or add the date to the time values like 1.1.2000 23:00 2.1.2000 0:15 Maybe there is another Issue next to this which effects this one. Have a look in the next 643 build. This Issue is closed, as it normally works as expected and will not changed. So no RFE or new Issue is needed. I close it. Frank
closed
>just set the minimum to 23:00 and the maximum to 27:00. The 27 >reflects that it's 3 at the next day. >For values between 23:00 and 00:15, just write 23:75. >Or add the date to the time values like 1.1.2000 23:00 2.1.2000 0:15 all 3 do not work in 1.0.0 even if they did, -they would be a workaround- , do you think that's "useful" ? Must reopen, sorry.
Created attachment 2439 [details] test it here: enter 23:75:00 -- doesn't work, same problem
lars-fst: your "workaround" is not the way software for computers should be
> Maybe there is another Issue next to this which effects this one. > Have a look in the next 643 build When will 643 be released? Also I don't have Ms Visual C++ Compiler , so I can't compile from sources. Also will 643 work parallely with OOo 1.0.0 with no effect on 1.0.0 at all? Reason: I have another issue: recognize multiple day changes automati- cally so that I can omit the Day/Month/Year data in the cells (reason for example: presentation reason, that I want no Day; humans are capable of recognizing the day change (and setting the color to white may be irritating in the future; there should be a special function for that (I would be able to see in Navigator, that day data is hided), see issue 7047)
why irritating: I might forget to copy these cells also if I want to copy everything as long a chart copies without own container are not easily possible (see issue 6508) or I might add data and overwrite these cells if I don't look at the "edit prompt" quick enough and then distorting the chart. Ah, it comes to my mind: does the chart accept 2 columns as x-data (Hey! You wouldn't have to implement that for THIS reason (day/time), if you have the automatic day change recognition! (always also think of course: should we do it as an option, where place it then, or do it always...))
> recognize multiple day changes automatically somehow, if I save the problematic SXC as XLS, and open it in Calc, it is still all shown within 1x 24h, but the curve is linking the real chronologically correct data points, where as in SXC, the curve jumps between the data points of the same hour but different day. The chart in Calc was only build on Time data though... hmmm (the here attached SXC is old and not for demonstrating that problem)
> recognize multiple day changes automatically Oh my god ! Suddenly it works: there are many such Charts behaviour (see issue 6704): Does it have to be "initiated" once, where it doesn't work, so that it works in the following times ? Please respond !
i reproduced the bug; not what I thought would happen, but you can see the bug nevertheless (in 1 document!); something has to be done... (no offense; I just wanted to say that this problem may be deep and spread...) -> new issue!
> recognize multiple day changes automatically see issue 7400 now for that but note: I would like the auto-day change to be actually charted using 3x24 h , not 1x24 h .... This issue 6724 is still not resolved
Only solutions: use the time format [HH]:MM or a mixed Date/Time format e.g.: DD.MM.JJ HH:MM:SS
Closed because wontfix