I’m using LibreOffice 220.127.116.11 (X64) on Win10. This problem is known also to occur on a Mac running a recent version of LO.
I have a Google sheet which is auto-generated by a script. I want to download this into LO Calc and process it further locally. If I download it as a .xslx file and load this into Calc, all is fine. But if I download it as a .ods file, then date/time fields which have a time (HH:MM) of 20:00 appear corrupt and display as 00:00 with no date. This specific time is the only one that I’m aware of that goes wrong; it’s possible there are others, I haven’t tried them all.
Because there is an obvious workaround, this isn’t a serious problem. But I would have expected .ods to work at least as well as .xlsx, so I’m puzzled. It’s not clear whether the bug is in LO or in Google’s .ods translation.
I attach an extract from the content.xml file in the downloaded .ods, named example.ods. Note this is not an ods format file but an xml extract, but this forum apparently doesn’t allow me to upload .xml files. This shows the encoding for two lines of the spreadsheet (I have slightly edited the names for privacy reasons). The first displays correctly, the second does not. I’m not an expert, but there are (to me) no obvious differences in the way these lines are encoded.example.ods