However, files with a password-protected sheet cannot be saved or opened.įiles with IRM turned on cannot be saved.įiles with of this type protection cannot be saved. ods format and open it again in Excel, protection without a password is supported. Threaded Comments will be converted to legacy comments when you save the file in. Formatting on the comment might not be supported when you save the file in. ods format and open it again in Excel, Local Names, Named expressions, and names to discontinuous ranges are not supported.Ĭomments with content are round-tripped. ods format and open it again in Excel, Image, First page or Odd/even options are not supported.

ods, the pre-1900 dates won't save correctly. There might be issues with Hyperlink styles. To see information about graphic features, see the Graphics Elements table at the end of this article. Not Applicable The feature was introduced in a later version of Excel for Windows. If you plan to save your Excel worksheet in the OpenDocument Spreadsheet format, don’t use this feature or you risk losing content, formatting, and functionality of that part of your worksheet. Not Supported The feature in Excel isn’t supported in the OpenDocument Spreadsheet format. No text or data is lost, but formatting and how you work with text or graphics might be different. Partially Supported Both Excel and the OpenDocument Spreadsheet format support this feature, but formatting and functionality might be affected. Content, formatting, and functionality won’t be lost.

Supported Both Excel and the OpenDocument Spreadsheet format support this feature. The table below shows which Excel features are fully, partially, or not supported in the OpenDocument Spreadsheet (.ods) format. What is supported when I save an Excel spreadsheet in the OpenDocument Spreadsheet format? Under Save workbooks, in the Save files in this format list, click the file format you want to use by default.

Openoffice ods