search

highcharts / export-csv

Highcharts plugin to export chart data to CSV
http://www.highcharts.com/plugin-registry/single/7/Export-CSV
MIT License
76 stars 94 forks source link

Columnrange as datetime in inverted chart. Range millis to date #138

Closed Ben1902 closed 7 years ago

Ben1902 commented 7 years ago

Hello!

We have a situation. We have one series of type columnrange. The chart is inverted, so the points will have "low" and "high" as milliseconds since 1970. When exporting to XLS, it would be preferable to have a timestamp in some format (dd.mm.yyyy hh:mm.ss) instead of all the milliseconds.

This seems to be implemented for the X-axis label if it is datetime, but not if we have a inverted datetime chart where the points actually will have low and high as datetime milliseconds.

example

/Benjamin Krüger

TorsteinHonsi commented 7 years ago

Thanks for reporting!

Here's a demo with the fix applied: http://jsfiddle.net/8yrw2ah0/.

PS: Also check out the experimental X-range series, that will officially be part of Highcharts 6: http://jsfiddle.net/gh/get/library/pure/highcharts/highcharts/tree/samples/highcharts/studies/xrange-series/

Ben1902 commented 7 years ago

http://jsfiddle.net/kr2wng93/

Still not working. Try download to XLS

TorsteinHonsi commented 7 years ago

I see. It works for simple y values, but not for low and high values. Will have to find a way to link the low and high values to the Y axis, without doing the same with for example the z value on the bubble chart. I'll be back tomorrow.