https://bugs.documentfoundation.org/show_bug.cgi?id=157268
--- Comment #9 from MikeD <m...@mata-ni-bula.com> --- Hi Ady, Your latest in comment #8 is essentially correct. Is it a BUG: yes in that what appears to be correct data does not produce the logical result. It is also, to some extent a feature enhancement requirement: In that time formatting is so variable,one needs to specify both an input and output format - possibly also with a test to translate the applied format on the source data. It does also reflect a loophole in the on line documentation for this aspect of calc: On line searches shows numerous threads across different sites with users having trouble with the time format - one even including "resort to windows/excel as this is not possible with calc" or to that effect. As regarding the steps to reproduce, I have detailed those above, repeated herein, and also included the sample file demonstrating the erroneous result. Steps to Reproduce: 1.Generate two columns of data, Col A is 00:00:00 to 23:45:00 in 15 minute intervals, format as time. 2. Column B is numerical data, 1 ..96, or constant with a few different points for calibration. 3.Select Both columns, and then Insert>Chart>x-y scatter chart, finish. I am also frustrated to a certain extent in selecting the format axis option when the chart area is selected. There seem to be diverse selection modes with different menu options that are exclusive. If charts get an overhaul then I feel that this could be improved too. -- You are receiving this mail because: You are the assignee for the bug.
