in reply to date parsing

Do you mean an OpenDocument Spreadsheet (ods) file? LO Calc works with a lot of file formats, that's just its default. Can you show how you are reading the file?