# HTML Export (Calc)

org.openoffice.da.writer2xhtml.oxt/export_calc.xhp
HTML Export (Calc)
Exports the current document to HTML format.
Choose File - Export - HTML 1.0 strict
or File - Export - HTML 1.1
or File - Export - HTML5
or click the HTML5-button in the toolbar
General
Select the style to use for the HTML document
- Original formatting
  produces an HTML document which uses the same style as the original document. The document will look quite similar to the original when viewed in a browser. If you choose to create separate files for each sheet, a simple navigation panel with links to all sheets will be added as a header and footer.
- Original formatting with navigation panel
  also produces an HTML document which uses the same style as the original document. This setting will add a navigation panel to the left to navigate through the files.
- Clean HTML
  produces a HTML document without any CSS styling. Use this if you only want to export the content of the file, but not the formatting.
- Custom
  is a user defined format. To configure the custom format, choose Tools - Options - Writer2xhtml.
Select the units to use for dimensions in the HTML document, either the original units, pixels or relative units (recommended)
Select a scaling to apply to all dimensions in the document
Select a scaling to apply to all column dimensions in the document
Sheets
Check this to display all sheets, even if they are hidden
Display hidden sheets
If you have chosen to hide some sheets in %PRODUCTNAME Calc, you can select this option if you want to display them in the HTML document anyway.
Check this to display all rows and columns, even if they are hidden
Display hidden rows and columns
The same applies, if you have chosen to hide some columns or rows in your spreadsheet.
Check this to display all rows and columns, even if they are filtered
Display filtered rows and columns
When you export the document, some rows or columns may be invisible because you have applied a filter in %PRODUCTNAME Calc. If you select this option, the invisible rows and columns will be exported to HTML anyway.
Check this to export the print ranges rather than the complete contents of the sheets
Apply print ranges
If you check this option, the HTML document will display the parts of the document which are selected for printing using print ranges in %PRODUCTNAME Calc. The display in the browser will thus be similar to what you get when you are printing the document from %PRODUCTNAME Calc. If the option is not checked, the result will instead resemble what you see when you edit the document in %PRODUCTNAME Calc.
Check this to insert the document title as a heading
Use title as heading
Use sheet names as headings
If you check this option, Calc2xhtml will insert the document title (File – Properties – Description – Title) as heading at the top of the HTML document.
Check this to insert the sheet name as a heading above each sheet
Use sheet names as headings
If you check this option, Calc2xhtml will insert the name of each sheet as a heading above the sheet in the HTML document.
Check this to create a separate file for each sheet
Save sheets in separate files
If you select this option, Calc2xhtml will produce a separate file for each sheet, otherwise all sheets will be exported to the same HTML file. In any case, a simple navigation panel showing all sheet names will be added.
File names
Select how to create file names for the secondary HTML files
When you choose to save the sheets in separate files, Writer2xhtml produces several HTML files. You can use this option to specify how to create file names for the secondary HTML files. Let us say that you document is named "document" and your sheets are named "Sheet 1", "Sheet 2" and "Sheet 3".
- Base file name + number
  will use a sequential numbering scheme. With the example, it will produce the files document.html, document1.html, document2.html.
- Base file name + section
  will replace the number with the current sheet name. With the example, it will produce the files document.html, document-sheet-2.html, document-sheet-3. Note that the first sheet name is not included in the file name.
- Section
  will do the same, but only include the base file name for the first file. With the example, it will produce the files document.html, sheet-2.html, sheet-3.html.
Check this to save images in a subdirectory relative to the exported document
Special content
Check this if you want to export notes (annotations) in the document
Check this if you want to export all meta data (using the Dublin Core standard)
Figures
Check this to use the natural size of images rather than the size defined in the document