See Notes in ODF Family for more information about the flat XML-only variant of ODF files. The ODF specification covers two physical forms for ODF documents, a flat form as a single XML file and a package form based on the ZIP_6_2_0 format. The same namespace and markup is used for tables in textual documents. The primary ODF markup used for spreadsheets is specified in the table: namespace, with the element as a container for each worksheet. This shortcoming led to interoperability problems resolved in version 1.2.

The key difference between ODF_spreadsheet_1_1 and ODF_spreadsheet_1_2 is that the later version incorporates the OpenFormula specification for formulas and functions, whereas ODF_spreadsheet_1_1 allowed any syntax for strings representing formulas. The ISO/IEC 26300:2015 specification is equivalent. The format, an international standard, is specified in the ODF 1.2 specification as published by OASIS.

It is one of several subtypes in the ODF family for particular content categories. The OpenDocument Spreadsheet Document Format (ODS), Version 1.2 (given the short name ODF_spreadsheet_1_2 here) is an XML-based format for editable spreadsheet documents.

Part of OASIS Open Document Format for Office Applications, Version 1.2 and the equivalent ISO 26300:2015. A new dialog box shall open, enter and confirm your password.OpenDocument Spreadsheet Document Format (ODS), Version 1.2. Open your document in OpenOffice and click on Tools > Protect document and choose whether you want to secure the whole document or the current sheet.Ģ. To protect your important data, you can either assign a password to a sheet, follow these instructions:ġ. How to protect your spreadsheet with a password on OpenOffice Calc? Verify your password and click OK to set and save your settings.You must make a note of your password, as Open Office does not offer any password recovery options. A dialog box will appear, prompting you to enter a password.Note that this option will not be shown if you attempt to save your document in a format other than an file.Click on the option that reads Save with password.Below the Name and Document Type fields, you will see a few additional save options. Once the document opens, head to File > Save As.Launch OpenOffice and open the document you'd like to protect by going to File > Open.How to password protect your OpenOffice document? Protect your spreadsheet with a password on OpenOffice Calc.Password protect your OpenOffice document.

Openoffice xls