Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Saving and Opening Sheets in HTML

Saving Sheets in HTML

Office Calc saves all the sheets of a Calc document together as an HTML document. At the beginning of the HTML document, a heading and a list of hyperlinks are automatically added which lead to the individual sheets within the document.

Numbers are shown as written. In addition, in the HTML tag, the exact internal number value is written so that after opening the HTML document with Office you know you have the exact values.

  1. To save the current Calc document as HTML, choose File - Save As.

  2. In the File type list box, in the area with the other Office Calc filters, choose the file type "HTML Document (Office Calc)".

  3. Enter a File name and click Save.

Opening Sheets in HTML

Office offers various filters for opening HTML files, which you can select under File - Open in the Files of type list box:

  • Choose the file type "HTML Document (Office Calc)" to open in Office Calc.

All Office Calc options are now available to you. However, not all options that Office Calc offers for editing can be saved in HTML format.