When you save a workbook, Formula One saves the current view settings. When a view is attached to a workbook, the view settings are retrieved from the workbook.
Formula One for Java reads and writes several file formats. The following table lists Formula One for Java compatible file formats and associated file name extensions.
| Format | File Extension | Description |
|---|---|---|
| Formula One for Java | .vts | Formula One 3.x, 4.x, 5.x, 6.x and 7.x formats. |
| Excel 5.0, 7.0, 97, and 2000 | .xls | Microsoft Excel 5.0, 7.0, 97, and 2000 formats. |
| Tabbed-Text | .txt | Tab-delimited text file including number formatting information. |
| Tabbed-Text values only | .txt | Tab-delimited text without formatting information. |
| HTML | .htm/.html | hypertext markup language. |
| HTML data only | .htm/.html | hypertext markup language without formatting information. |
Since Formula One for Java has features not supported by Excel, files saved in the .vts file format cannot be read by Excel. In the .xls format each record represents a unique feature or property of the workbook. The .vts file format uses a significatnly more efficient method of storing records.
If your file contains features not supported by Excel, saving the workbook as an .xls file removes these features. Likewise, Excel contains features not supported by Formula One for Java. Unsupported features are ignored when Formula One for Java loads an Excel worksheet or workbook.
Important If you load an Excel file that contains features not supported by Formula One for Java those features are ignored. If you then write the imported file from Formula One for Java as an Excel file those features are lost.
Formula One for Java cannot read password-protected Excel files. If you intend to read files from Excel, do not password-protect them.
