Convert OTS to NUMBERS
Turn OTS documents into NUMBERS. Each sheet becomes a Numbers sheet holding one table, named after it and in the same order.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop OTS files on the dialor turn it to pick what to do
A Numbers file from your template.Each sheet becomes a Numbers sheet with one table. Values and formatting stay.
What you get
A Numbers file with one sheet for each sheet in the OTS file, in the same order and with the same names. Each sheet holds one table.
Values, number and date formats are kept. So are fonts, bold, italic, underline, text and fill colors, alignment and borders. Merged cells, column widths and row heights are kept too.
What changes
Formulas become their last computed values, so the cells show numbers and text but no longer calculate. Numbers keep 15 significant digits.
Fonts that Numbers does not have become Helvetica Neue. Hidden sheets, rows and columns are shown.
What is left out
Charts, images, comments and links are not copied into the Numbers file.
A document of more than 300,000 cells fails with
unsupported_elements.
OTS and NUMBERS.What each format is.
The formats
OpenDocument Spreadsheet Template
A LibreOffice Calc template. New spreadsheets start from a copy of it.
- Extensions
- .ots
- MIME type
- application
/vnd .oasis .opendocument .spreadsheet -template - Kind
- Documents
Apple Numbers
Apple Numbers spreadsheets from macOS and iOS.
- Extensions
- .numbers
- MIME type
- application
/vnd .apple .numbers - Kind
- Documents
In your code.The same OTS to NUMBERS conversion through the API, for your app or your agent.
$ cv convert report.ots report.numbers$ cv convert report.ots report.numbersQuestions.What people ask about OTS to NUMBERS.
No. Each formula becomes the last value it computed. The cell keeps the result, not the calculation.
No. They are shown in the Numbers file.
No. Charts, images, comments and links are left out.
The document has more than 300,000 cells. Documents over that size are not converted.