![]() Download it and save it as samle.xls and open it with text editor. ![]() ![]() Note: First column appears to have a valid date, but it has single quote character in front of it, so it is string not date.īellow is whole document. īut date is imported as number (I intentionally added red color in style to see if style is acceped): The closes think that I found on web is the following:Įxcel XML, how can I get Excel to display my DateTime field in yyyy-MM-dd format? - Stack Overflow which suggest to add new Style and then add this style definition in Cells. I need something like Type=“Date” but it looks it does not exists. The cause of the problem is date cells are set as String. They are sorted by string, not the actual date. You notice first and last are from January and second one is February. The are currently sorted (dd.mm.yyyy), then and then. ![]() But this program for date cells sets as type=String, so all date data are imported as “String” and when sorting the date data in column they are sorted alphabetically instead of date. Hi, I have a program that generated XML file and this file should be opened with Calc.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |