-
-
Usually, you want to overwrite the loaded file. For this reason, the loaded file name is remembered. If the sheet doesn't have a file name, like after starting an empty sheet, you will be asked for a name when saving.
Occasionally, you may want to rename a sheet, like before making critical changes or when you load an existing sheet to have a start for making a new one. The Save As operation allows you to save the file under a new name.
The ASCII file format allows easy generation/modification of saved sheets by shell scripts. Note that when reading a .tpa file, either ordinary decimal or scientific formats for floating point number are recognized, as well as the exact hex floating point format used by default when saving. The default extension is .tpa.
XDR (eXternal Data Representation) is a standard invented by Sun Microsystems which defines a canonical way of storing/transporting data on external media. Its advantage is that it is widely available and that it defines a portable floating point number format. The native TEAPOT file format formerly used XDR to be portable across different machine architectures and operating systems. The advantage of this over the portable ASCII format was that due to the (usually) missing conversion calculations to ensure that any floating point constants would be saved/loaded exactly without conversion errors, the value of a cell might change slightly when saved and restored in the ASCII format. The XDR format was discontinued when the ASCII format was made exact by virtue of the exact hexadecimal “%a” style (“hexact”) of representing floating point values, and so there was no need for a specialized binary format. Old .tp files may be read, but TEAPOT no longer writes files in this format.
CSV (comma separated value) files only contain the data, not the expressions calculating it. Many spread sheets can generate this file format and many graphics programs like gnuplot(1) can read it. The field separator usually is a tab or comma, strings may be enclosed in double quotes and decimal numbers have a dot to mark the fractional part. One popular variation uses semicolons for separating fields and a decimal comma instead of a decimal point, which TEAPOT tries to autodetect.
On load, strings without quotes and with a 0x prefix followed by hexadecimal digits will be converted to integers. When loading CSV files, the sheet will not be cleared and the data will be load relative to the current cursor position.
TEAPOT can load simple SC sheets to convert them to TEAPOT's native format. While loading, TEAPOT converts all references to absolute cell positions to labels. This allows to insert and delete in such sheets without screwing the whole sheet up. TEAPOT can not save sheets in SC format, because SC lacks many features. For now, only the most basic SC features are supported.
TEAPOT can load simple WK1 sheets to convert them to TEAPOT's native format. By default, 1-2-3 cell references are relative, so don't be surprised by a big amount of relative references in the resulting TEAPOT sheet. For now, only the most basic 1-2-3 features are supported.
The generated formatted ASCII files contain about what you see on the screen. If your sheet has more than one layer, then the various layers will be saved separated by form feeds.
TEAPOT can generate tbl(1) table bodies in single files which are supposed to be used like this:
.TSYou will have to use soelim(1) to eliminate the .so requests before the tbl run. The options; are optional. If you use GNU roff, you will need to eliminate .lf requests, because this GNU roff extension confuses GNU tbl:
options;
.so filename
.TE
soelim file | grep -v '^\.lf'Alternatively, you can generate a stand-alone document, which needs no further operations to format and print. Note: If no block is marked, the whole sheet will be saved.
If you generate LATEX2e tables in single files, you include them in documents using the \include command. Alternatively, you can generate a stand-alone document, which needs no further operations to format and print. Note: If no block is marked, the whole sheet will be saved.
Analogous to LATEX output, this generates input suitable to the ConTEXt macro package.
You can generate html table bodies in single files which could be used in combination with server-side includes. This feature differs between the various servers, so refer to the manual for your web server for details, please.
Alternatively, you can generate a stand-alone document. Note: If no block is marked, the whole sheet will be saved.