Export to Excel and Dates

[JNorth]

When trying to export a chart that contains the following values (X is a date column formatted as "d/mm/yyyy").

X Y
31/08/2009 7.58
1/09/2009 7.75
2/09/2009 4.16


The dates in the excel file are saved as

X Y
40056 7.58
40057 7.75
40058 4.16


When trying to set a format for the values using the chart editor it tries to export all values using the Value Format (d/mm/yyyy) that I selected. Using the Numeric Format dialog that displays and selecting the DateTime radio button. An error occurs when saving to Excel because it is using the Value Format to format the Y column.

Why isn't there a Value Format available for each Axis (or series even).

[Narcís]

Hi JNorth,

The same problem and solution were described here.

[JNorth]

Is it possible to get this as a feature request then. If I have a date specified in my series, then it should be exported as a string representation of the date, just as it is displayed on the chart.

I've made the changes myself, however we don't like making changes to third party code unless we really have to.

[Narcís]

Hi JNorth,

I'm afraid it's unlikely as those values are internally stored as double values. I think the easiest way to achieve that would be adding DateTime labels to series points and export those labels too.