Looks like you entered/copy-pasted/converted from a date/time format other than the one you specified for the column. Could you provide some details on how you entered the values into the column?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I found the problem. In openoffice the text cells were not formatted as text. thats why they did not copy over.
I think you can add a warning when copying over the cells and detecting that text isn't formatted correctly.
I have attached the source xlsx file
thank you
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Looks like you entered/copy-pasted/converted from a date/time format other than the one you specified for the column. Could you provide some details on how you entered the values into the column?
copy paste from openoffice.
i have to manually rewrite the month name
Okay. What did you enter in the "Format" field of the first column and what does the copy-pasted data look like?
I found the problem. In openoffice the text cells were not formatted as text. thats why they did not copy over.
I think you can add a warning when copying over the cells and detecting that text isn't formatted correctly.
I have attached the source xlsx file
thank you
Btw when you plot the data in that file i included the x axis doesn't show all the month names and there are extra ticks in between the major ticks.
It would appear that the abbreviated month name importer is not working correctly (it imports just the month of May).