Apache OpenOffice (AOO) Bugzilla – Issue 6704
chart axis scale works not correctly with data masks
Last modified: 2013-02-24 21:21:15 UTC
if for example x-data is time HH:MM:SS, entering 0:10:0 in interval field of scale in x-axis of axis of format menu, the interval shown is not every 10 minutes, but above enterd length becomes simply 0,01 in that field and on the chart there is shown an interval length of ~ 14 minutes (I didn't get the relation with my data; 0,01 ^= 1% of total x-"range"-data, 1% of 1 day? (=0,24 hours ~25% of 1 h ~15 min.)).
! Partly it works, partly not, see attached document. it works in the chart on sheet 1 eg. interval length 00:15:00 (but on clickig OK it becomes sth like 0,0068214683242341). it doesn't in the chart on sheet 2; 00:15:00 becomes 0.01. Also, manually entering 0.00x values is possible on sheet 1 -- suddenly? Compare issue 6278 ! How to reproduce: 1st. The document provided is different than mentioned above -- because : I loaded it and tried it again and suddenly it works in sheet 2! Now: Open Calc anew. insert a new sheet from the provided document. enter chart, got to x-axis scale remove the tick from automatic main interval length type 00:15:00 click OK look at the chart : error ! go back: you'll see it is 0.01 now ! Don't forget that when it works, it suddenly is possible to enter 0.00x values - hmmm
Created attachment 2429 [details] test-case
It's a double to Issue 6278, so I set the flags. Frank *** This issue has been marked as a duplicate of 6278 ***
closed
this is peculiar behaviour this screams to be reimplemented from the ground up. there has to be a clean clear principle which this "function" follows [did you read my first additional comment completely?] READ HERE: Do you know what is peculiar: this morning I download the attachement created above and the problem is gone. I check the original document and open it and : the problem is gone: when I closed it (and it was saved) there was sth like 14:23 (mm:ss) interval and the properties showed 0,01. I had closed and opened it several times yesterday and the problem always was there and always occured as described. Today it shows up as 36:00 (mm:ss) interval. 1st: that's different then when saved 2nd: entering 00:15:00 now works -produces correct result (3rd: as mentioned already, then eg 0.0005 also works) double -- sure? Try to create a new chart (from the data) and look whether the problem is there, please ! not opened - as saved is very bad habit !! Please give me "feedback", thanks, Lars
I've just reproduced it: in general, when you create a new chart from data, which just has been pasted into the document, and the x-axis-data of this data is formatted with a time mask (the data origined from a csv import by the way), you can't have a 00:15:00 value for interval length - it becomes 0.01; but if you save, exit and load again, you can enter 00:15:00; it becomes 0.0066683264236 and shows up as 00:15:00 intervals correctly in the chart. Pleeeease, do sth. about it and tell me that you are aware of it - if you are; if you aren't ... ; -- pull yourself together ! ... or is that really also fixed with issue 6278 ?!?
If I set something as double, it's a double. So don't touch these things before you have checked the double in the correct release. Also learn to be polite. *** This issue has been marked as a duplicate of 6278 ***