CSV export: date-time formatting. Respond to user comment & make better for Excel
CARBONES.eu web application
Brought to you by:
marktjackson
Menu
▾
▴
#121 CSV export: date-time formatting. Respond to user comment & make better for Excel
Accepted
nobody
None
Low
Defect
2012-02-13
2011-12-09
Anonymous
No
Originally created by: alastair... (code.google.com)@gmail.com
Originally owned by: alastair... (code.google.com)@gmail.com
Charts: CSV export.
Excel displays our date-time values with just the times by default.
The actual values in the CSV do contain dates and times.
We might be able to improve this behaviour by formatting our date-time values slightly differently.
We could leave the times out for the averaging periods where they are not relevant: i.e. only include the times for the 3-hourly data.
Low priority issue. The scientific partners don't seem to use Excel.
Related
View and moderate all "tickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
Originally posted by: mark.tun... (code.google.com)@gmail.com
Matthias Forkel from MPI-BGC Jena made a related comment in email 30 Jan 2012. He said
Download time series as csv:
It would be easier if the Date/time is formatted as YYYY-mm-dd HH:MM:ss (i.e. remove the digit from the seconds: ss.s)
View and moderate all "tickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
Originally posted by: mark.tun... (code.google.com)@gmail.com
(No comment was entered for this change.)
Summary: CSV export: date-time formatting. Respond to user comment & make better for Excel