Whole document tree 10.3. File FormatsIn the Save as.. dialog you can choose between various file formats. (see Figure 10-1) Similarly, in the Import.. dialog you can also choose between various file formats. (see Figure 10-2) Most of these formats are provided by plug-ins. If they don't appear on your list of available plug-ins use the Tools Plug-ins... menu item to verify that the appropriate plug-in has been loaded. 10.3.1. Gnumeric XML File FormatThe default file format and Gnumeric's native format is an xml based file. The file format is a ascii text based xml format. It is however, typically written and read in a gzip compressed form. The uncompressed format is human readable and designed to be easily parsed. It is very extensible. 10.3.2. Data Interchange FormatThis format is supported by the "Data Interchange Format (DIF) module" plug-in.
10.3.3. DVI TeX FormatThis format is supported by the "HTML & TeX" plug-in.
Creation of a dvi file with Gnumeric requires that groff has been installed. If a complete TeX installation is available it is probably advisable to use the LaTeX format (Section 10.3.8) instead, since the created LaTeX file can be extensively customized before creating the dvi file from it. 10.3.4. MS Excel (tm) File FormatsThis format is supported by the "MS Excel (tm) File Formats" plug-in. Gnumeric can open files from most recent versions of MS Excel (tm). It can also save files in MS Excel (tm) 95 format. 10.3.5. Experimental Bonobo EFS FormatThis format is supported by the "EXPERIMENTAL SAX based XML" plug-in.
10.3.6. Gnome Glossary PO File FormatThis format is supported by the "Gnome Glossary" plug-in.
10.3.7. HTML File FormatsThese formats are supported by the "HTML & TeX" plug-in. 10.3.7.1. HTML generated by Gnumeric
Very simple and well structured HTML tables can be opened by Gnumeric into an appropriate spreadsheet. In this process, Gnumeric will lose information on merged cells and most other formatting, but the main cell values should be preserved. 10.3.7.2. HTML 3.2 File Format
Gnumeric can create HTML 3.2 files. All sheets of the current workbook are exported. The tables in the HTML 3.2 file contain all cells, whether visible or not, including merged cells and spans. Horizontal as well as vertical alignment is preserved, as are font colors and some font characteristics (italic, bold). These files also include an appropriate preamble. 10.3.7.3. HTML 4.0 File Format
Gnumeric can create HTML 4.0 files. All sheets of the current workbook are exported. The tables in the HTML 4.0 file contain all cells, whether visible or not, including merged cells and spans. Horizontal as well as vertical alignment is preserved, as are some font characteristics (italic, bold) and cell background colors. These files also include an appropriate preamble. 10.3.7.4. HTML Fragment Format
Gnumeric can create HTML fragments. All sheets of the current workbook are exported. The tables in such a fragment file contain all cells, whether visible or not, including merged cells and spans. Horizontal as well as vertical alignment is preserved, as are some font characteristics (italic, bold) as well as cell background and font colors. These files do not contain any preamble. Note that each tag used in these files is valid in some HTML version, the combination of these tags in a Gnumeric generated HTML fragment may not be. 10.3.8. LaTeX 2e FormatThis format is supported by the "HTML & TeX" plug-in.
Only the top sheet of the current workbook is exported. The created LaTeX file can either be input into another LaTeX file (see Section 10.3.8.1) or latexed independently. See the content and Section 10.3.8.2 of the created file for various customization options. Example 10-5. Saving as LaTeX file The screenshot Figure 10-3 shows an example Gnumeric file. If we save this file as LaTeX file, tex it using pdflatex and open it using xpdf we obtain Figure 10-8. 10.3.8.1. Including Tables Into Other DocumentsTo include an exported Gnumeric table into another LaTeX document you need to use several packages \usepackage{color} \usepackage{array} \usepackage{longtable} \usepackage{calc} \usepackage{multirow} \usepackage{hhline} \usepackage{ifthen} and to add the following lines to the preamble of your document: \newlength{\gnumericTableWidth} \newlength{\gnumericTableWidthComplete} When you have set up your main document in this way, include each table with: \input{mygnumericfile.tex} 10.3.8.2. Customizing The LaTeX TablesTo switch from portrait to landscape for independently latexed tables, uncomment the line: %,landscape% to obtain \documentclass[12pt% ,landscape% ]{report} To change the column widths, look for the following section in the LaTeX file: %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% %% %% %% The following are the widths of the various columns. We are %% %% defining them here because then they are easier to change. %% %% Depending on the cell formats we may use them more than once. %% %% %% %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% \def\gnumericColA{107pt*\gnumericScale} \def\gnumericColB{89pt*\gnumericScale} \def\gnumericColC{98pt*\gnumericScale} \def\gnumericColD{89pt*\gnumericScale} \def\gnumericColE{89pt*\gnumericScale} To change the second column (Column B) to a width of 0.75 inches, we would simply have to modify this code to: \def\gnumericColA{107pt*\gnumericScale} \def\gnumericColB{0.75in} \def\gnumericColC{98pt*\gnumericScale} \def\gnumericColD{89pt*\gnumericScale} \def\gnumericColE{89pt*\gnumericScale} 10.3.9. Linear and Integer Program File FormatThis format is supported by the "Linear and integer expression (MPS) format module" plug-in.
10.3.10. Plan Perfect FormatThis format is supported by the "Plan Perfect" plug-in.
10.3.11. PDF FormatCurrently, Gnumeric cannot save directly as a PDF file; but, provided a standard tetex installation is available, the Gnumeric file can be saved as a LaTeX file (see Section 10.3.8), and turned into a PDF file using pdflatex. See Figure 10-8 for an example of a created PDF file. 10.3.12. SC/XSpread FormatThis format is supported by the "SC/XSpread Format" plug-in.
10.3.13. Text FormatThis format exports Gnumeric spreadsheets as straight text or imports them from straight text files. Both export (save as) as well as import can be highly customized. 10.3.13.1. The Text Export DruidAfter specifying the "Text File Export" Format and a file name in the "Save as.." dialog, the text export druid starts to guide you through the various options:
10.3.13.2. The Text Import DruidAfter specifying the "Text File Import" Format and a file name in the "Import.." dialog, the text import druid starts to guide you through the various options. On the first screen of the druid specify the basic format type (fixed width fields or fields separated by specific characters), as well as the line numbers of the lines to import. 10.3.13.2.1. The Text Import Druid for Separated Fields
10.3.13.2.2. The Text Import Druid for Fixed Width Fields
10.3.14. TROFF FormatThis format is supported by the "HTML & TeX" plug-in.
Files in this format are useful because they can be converted with the groff or troff commands into various other common formats. For example, given a TROFF file myfile.me, the command groff -me -t -Tps myfile.me >myfile.ps will create a postscript file of the corresponding table. Similarly, the command groff -me -t -Tascii myfile.me >myfile.ascii creates an ascii (straight text) file. Example 10-6. Creating an ASCII File If we save Figure 10-3 as a troff file hypothetical-sales.me and then execute the command groff -me -t -Tascii hypothetical-sales.me >hypothetical-sales.ascii then the file hypothetical-sales.ascii contains: Sheet 0 +----------+------------------+-------------+------------+---+ | | Operating System | | | | +----------+------------------+-------------+------------+---+ | | DOS | Linux | SCO | | +----------+------------------+-------------+------------+---+ | January | $1000.00 | $900.00 | $500.00 | | +----------+------------------+-------------+------------+---+ | February | $900.00 | $2500.00 | $300.00 | | +----------+------------------+-------------+------------+---+ | March | $800.00 | $4100.00 | $100.00 | | +----------+------------------+-------------+------------+---+ | April | $700.00 | $5700.00 | ($100.00) | | +----------+------------------+-------------+------------+---+ | May | $600.00 | $7300.00 | ($300.00) | | +----------+------------------+-------------+------------+---+ | June | $500.00 | $8900.00 | ($500.00) | | +----------+------------------+-------------+------------+---+ | July | $400.00 | $10500.00 | ($700.00) | | +----------+------------------+-------------+------------+---+ | August | $300.00 | $12100.00 | ($900.00) | | +----------+------------------+-------------+------------+---+ |September | $200.00 | $13700.00 | ($1100.00) | | +----------+------------------+-------------+------------+---+ | October | $100.00 | $15300.00 | ($1300.00) | | +----------+------------------+-------------+------------+---+ | November | $0.00 | $16900.00 | ($1500.00) | | +----------+------------------+-------------+------------+---+ | December | ($100.00) | $18500.00 | ($1700.00) | | +----------+------------------+-------------+------------+---+ | | | | | | +----------+------------------+-------------+------------+---+ | Totals: | $5400.00 | $116400.00 | ($7200.00) | | +----------+------------------+-------------+------------+---+ | | | | | | +----------+------------------+-------------+------------+---+ 1 |