.ods files will open in read-only inside sharepoint online document library

Question

we have a file with.ods extension, but when we try to edit it using the browser, we get this message and the file opens in read-only:-

is there a way to fox this?

Thanks

Answer 1

Office on the web does not support editing for OpenDocument file formats.

Answer 2

Hi @john john ,

Some features in Excel for the web are partially supported, not supported or not Applicable in the OpenDocument Spreadsheet format. It will affect formatting ,usability, etc.

Therefore, when we open .ods file in in Excel for the web, some compatibility issues may occur and file shows in read-only mode once we want to edit.

This is the expected behavior and we could click Edit workbook to further edit the file.

For more information, please refer to the following article:

https://support.microsoft.com/en-us/office/differences-between-the-opendocument-spreadsheet-ods-format-and-the-excel-for-windows-xlsx-format-3db958c8-e0ac-49a5-9965-2c2f8afbd960#ID0EAABAAA=Web

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.