Features Added to Formula One for Java 7.0.0
- (Enhanced in 7.0.) Read/Write Excel Files: Formula One 5.5 currently can create, import, and export Microsoft Excel workbooks for Excel versions 5 and 7 (Word 95). Formula One v. 7.0 includes support for the Excel 97 and Excel 2000 formats.
- (Enhanced in 7.0.) Functions: Formula One 5.5 currently supports 133 worksheet functions of Excel's 329. Formula One v. 7.0 provides 325 of Excel's 329 functions. This feature is aided by 7.0's added support of array formulas, which output multiple numbers to a wide variety of cells. These additional functions will make the standalone Formula One 7.0 application more attractive to specialized end users such as accountants and engineers.
- (Enhanced in 7.0.) Extended Date Range: Formula One 5.5 currently accepts dates through Dec. 31, 2078. Formula One 7.0 supports dates through Dec. 31, 9999.
- (Enhanced in 7.0.) Enlarged Workbook Capacity: Formula One 5.5 workbooks are limited to 16,384 rows, 256 columns, and 256 sheets. The capacity of Formula One 7.0 workbooks has been expanded to more than a billion rows, 32,768 columns, and 32,768 sheets.
- (Enhanced in 7.0.) Performance: Formula One 7.0's performance has been greatly enhanced, matching and exceeding in some cases the power of traditional desktop spreadsheet applications. The performance is most apparent in the functionality of its completely rewritten calculation engine, cell-to-cell copying, reading and writing spreadsheets, and printing.
- (New in 7.0.) Java 2 support: Formula One 7.0 includes support for the Java 2 JDK.
- (New in 7.0.) Swing: Formula One 7.0 includes support for Java's Swing user interface classes.
- (New in 7.0.) Java 2D support: Formula One 7.0 takes advantage of the Java2D classes of the Java 2 JDK, enabling users and developers to draw lines of varying weights and styles, use different patterns and gradients for background fills, rotate text, superimpose graphics on other graphics, and leverage more printing options.
- (New in 7.0.) Model/View/Controller Architecture: Formula One 7.0 includes a new API that will enable developers to unbundle the model (workbook) from the view (GUI) if necessary. Tidestone will build multiple GUIs to run under JDK 1.1, JFC (Swing), Personal Java, WFC/ActiveX, and others.
- (New in 7.0.) 2D charting: Formula One 7.0 includes 2D charting for use in conjunction with Formula One spreadsheets to graphically display spreadsheet data. The charts offer Excel compatibility and include column, bar, high-low (or stock type), line, pie, area, step, combination, XY (scatter), bubble, doughnut, and "Studies",a chart type that enables multiple sets of data to share the same category axis but plot on separate value axes.
- (New in 7.0.) Undo and Redo: Formula One 7.0's standalone application enables users to perform multiple undos and redos through the keyboard or a mouse and pull-down menu command.
- (New in 7.0.) InfoBus: Formula One 7.0 plugs into the InfoBus architecture enabling it to share data with other software that supports InfoBus.
- (New in 7.0.) Pluggable Recalculation Engine: Formula One 7.0 allows developers to replace the standard Formula One calculation engine with optional specialized recalculation engines. Each specialized recalculation engine's performance is tailored to a different type of application and carries different size footprints and capabilities, allowing users and developers to determine which engine works best for their application.
- (New in 7.0.) Add-in worksheet functions: Developers will have the ability to write custom functions for use in Formula One 7.0 worksheets.
- (New in 7.0.) Thread Pooling: In Formula One 5.5, each group of workbooks has a corresponding thread. So for example, an application with 300 groups must have 300 threads. In Formula One 7.0, groups are independent of threads, allowing for more efficient resource sharing among groups.
- (New in 7.0.) Modular .jar files: Formula One 7.0 offers a pre-determined set of jar files. This way, developers and web builders only need to deploy the Formula One .jar files that are being utilized in an application thereby reducing download times.
|
|