Unable to open ods files created in LibreOffice on Andriod device using Google Drive. Files created in Collabora (or LibreOffice Viewer) on an Andriod device have a mime type of: "Application/vnd.oasis.opendocument.spreadsheet type" These files stored in Google Drive and can be opened from the mobile apps. However, if the files it opened in LibreOffice Desktop from Google Drive and saved, the mimetype gets changed to: "Application/x-vnd.oasis.opendocument.spreadsheet type" (the additioin of the "x-") These files can NOT be opened from the mobile apps. So it appears the problem is with LiberOffice Desktop or Google Drive. But not sure how to fix it.
Thanks for the report. Can you please attach sample files? (One created with LO viewer, with the application/vnd.oasis.opendocument.spreadsheet mimetype, and the one with the extra "x-"? Just to clarify: 1. You create an ODS with LO Viewer, save it, the mimetype is correct 2. You open and save the same file with LO desktop (7.6.4.1): the mimetype gets the extra "x-" 3. Such file can't be opened in the mobile apps but can on desktop. Is that correct? Related: - https://askubuntu.com/questions/1236632/cant-open-ods-file-i-created-and-saved-in-google-drive-no-application-for-a - https://stackoverflow.com/questions/68488973/in-which-cases-the-mimetypes-of-google-docs-changes - https://phabricator.kde.org/D9706 Looks like it's Google Drive that modifies the mimetype of the file, assuming it's a non-standard mimetype even though it is listed by IANA: https://www.iana.org/assignments/media-types/media-types.xhtml See this documentation: https://developers.google.com/drive/api/guides/ref-export-formats Only ODS is affected; ODT and ODP don't get the extra "x-". In any case, LO Viewer should still open files with such a mimetype, so maybe something to also change on our end.