2 Using the export filters
2.6 Using Calc2xhtml
To export a Calc document to xhtml, choose XHTML 1.0 strict in the export dialog.
After you have typed in a file name, an options dialog will open:
The individual options are explained below (only where the differ from the options in Writer2xhtml). Click Export to initiate the export or Cancel to close the dialog without exporting the document.
Style options
Use style
This options works like in Writer2xhtml, except that the core styles from W3C are not displayed (as they are not suitable for table documents).
Sheet options
Display hidden sheets
If you have chosen to hide some sheets in Calc, you can select this option if you want to display them in the xhtml document anyway.
Display hidden rows and columns
The same applies, if you have chosen to hide some columns or rows in your spreadsheet.
Display filtered rows and columns
When you export the document, some rows or columns may be invisible because you have applied a filter in Calc. If you select this option, the invisible rows and columns will be exported to xhtml anyway.
Apply print ranges
If you check this option, the xhtml document will display the parts of the document which are selected for printing using print ranges in Calc. The display in the browser will thus be similar to what you get when you are printing the document from Calc. If the option is not checked, the result will instead resemble what you see when you edit the document in Calc.
Use title as heading
If you check this option, Calc2xhtml will insert the document title (File – Properties – Description – Title) as heading at the top of the xhtml document.
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 xhtml document.
File options
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 xhtml file. In any case, a simple navigation panel showing all sheet names will be added.