Opened 21 hours ago

Last modified 3 hours ago

#2344 reopened defect

Date and timestamp values are not exported correctly with the table exporter

Reported by: Nicklas Nordborg Owned by: everyone
Priority: critical Milestone: BASE 3.20.3
Component: coreplugins Version:
Keywords: Cc:

Description

It seems like in Excel they are always exported as strings and they are not using the configured preferences of the user. Example:

'2016-07-04	Mon Jul 04 13:30:00 CEST 2016

I think this may be a side-effect of the fix for #2336 which fixed a similar issue for numeric values, but probably made it worse for date and timestamp values.

Change History (4)

comment:1 by Nicklas Nordborg, 21 hours ago

Resolution: fixed
Status: newclosed

In 8333:

Fixes #2344: Date and timestamp values are not exported correctly with the table exporter

comment:2 by Nicklas Nordborg, 3 hours ago

Resolution: fixed
Status: closedreopened

Now the thousands separator setting is included for numeric values when exporting to CSV format.

comment:3 by Nicklas Nordborg, 3 hours ago

In 8334:

References #2344: Date and timestamp values are not exported correctly with the table exporter

This was a bit more complicated than expected. There are now some more alternatives depending on the value type and if the export is going to Excel or CSV.

comment:4 by Nicklas Nordborg, 3 hours ago

In 8335:

References #2344: Date and timestamp values are not exported correctly with the table exporter

Remove unsused import.

Note: See TracTickets for help on using tickets.