 |
|
|
Actuate Unveils Java Spreadsheet Bean-based
spreadsheet component excels Formula One Honored as Best Reporting Tool at JavaOne
|
Updated: 08/26/2002 Formula One for Java Actuate Corporation Direct: 888-422-8828 Formula One is a multipurpose 100% pure Java spreadsheet technology that is provides server-side and client-side solutions in Web-based and distributed computing environments. Formula One provides a spreadsheet application to end users on any platform. Formula One also supplies software developers with a robust development tool that enables them to deliver functionality and interactivity to Web pages, servlets, JSP and Java applications. Features
Spreadsheets on the Internet - Formula One enables you to put spreadsheets on the Internet in a variety of formats (Formula One .vts file, Excel .xls file and HTML). Formula One offers developers options in data delivery by writing spreadsheet and database data in Formula One .vts, Excel .xls and HTML file formats. This is especially effective when working with Oracle8i or application servers such as SilverStream, WebLogic and BlueStone. On these platforms, Formula One's JavaBean component gives developers the necessary tool to build Java applications and applets using a familiar spreadsheet paradigm and that are especially suited for Internet or intranet use.
Database Reporting - Formula One can be used in conjunction with the Oracle8i or any application server platform to retrieve, calculate, format and distribute data from a database in its native .vts file format, .xls file format, or as HTML depending on the client's needs. So for instance, the same single server-side application that generates 401(k) data or some other account balance can provide data to all its clients regardless of their operating systems. Formula One also reads .vts files, .xls files and HTML form data from clients, allowing it to receive data and update database records as required. Formula One also makes it simple for Excel-based data to be transmitted on the Internet. Data Presentation - Formula One delivers data in an intuitive tabular format with a wide selection of colors, fonts, font sizes and graphical objects such as buttons, check boxes and pull-down menus. Formula One provides developers with a wealth of options when it comes to data formatting and distribution. Formula One's Spreadsheet designer, which can be used as a standalone application on any desktop or launched from the Formula One applet or JavaBean by pressing a single function key, offers all of the data formatting features found in typical desktop spreadsheet applications. Formula One also automatically recognizes date, time, fraction, currency, percentage and scientific data entries. All of these features can be implemented by the user at runtime or preset by the developer at design time through calls to Formula One's extensive API.
Formula One's data presentation features
include options such as: 2D Charts: column, bar, high-low, line, pie, area,
step, combination, XY, 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. Read and Write Excel with Java - Formula One enables end users and developers, even those on non-Windows operating systems, to read and write the Microsoft Excel 2000 and earlier file formats. This feature provides an efficient means to move Excel data across the Internet or a network without relying on Windows or Excel to be present. Formula One provides a familiar spreadsheet interface, supports the Excel style formula syntax, Excel 2D charts and includes more than 320 of Excel's built-in functions. Strong client, strong server - Formula One also offers significant client-side functionality. In fact, using it as a standalone application offers the same intuitive spreadsheet interface, powerful calculations and data formatting options that users have leveraged in typical desktop spreadsheet applications.
Formula One 7.0: Spreadsheet Designer Having achieved Sun Microsystems' Java certification, Formula One's Spreadsheet Designer can be used by end users on any desktop operating system such as Windows, Solaris, or Linux. Developers who integrate the Formula One JavaBean can also allow their end users to launch the designer from their applications and applets with the press of a function key to provide a familiar spreadsheet environment for the entering and manipulation of data. Formula One's Spreadsheet Designer can also be leveraged by software developers to build powerful spreadsheets for use in their Java applications, applets, servlets and Java Server Pages. In addition to being cross platform, the Formula One file format is much smaller than the Excel file format, making it an ideal choice for Web-based computing environments. Standalone spreadsheet - It can be used by end-users as a standalone spreadsheet application on any desktop. Use in Java - It can be used by developers to format spreadsheets for use in Java applications, applets, servlets and JSP. It can also be launched from the Formula One JavaBean or applet to give users a robust means for editing or entering data into spreadsheets.
Formula One's chart types: Combination
The reporting tool for a Web-based
world In this type of use, Formula One offers a flexible reporting tool for developers and a consequent front-end analytical/calculation tool for end-users with advantages missing from Excel and other reporting tools, including: Server abilities - Starting on the server, Formula One easily connects to a wide variety of databases through server-side JDBC. Formula One's ability to manipulate data can be useful as data passes into or out of a database. Excel 95/97/2000 compatibility - Formula One can read and write the Excel 95/97/2000 format on servers and clients. Users who use Formula One to manipulate database reports can save the changes as a XLS file if they need to share data with another client running only Excel. Formula One even supports Excel 2D charts and more than 98% of Excel's functions. Multi-threaded - Formula One's multi-threaded architecture allows it to distribute and receive data from multiple users concurrently. Cross-platform - Leveraging the benefits of Java technology, Formula One can deliver its reports across multiple platforms through a Java applet, as part of a larger application, or as HTML. Lightweight - On the client, Formula One utilizes minimal system resources, enabling it to be used on laptops, hand-held computers and other mobile computing devices as well as desktop computers and workstations. Flexible - Formula One offers numerous data presentation options. Data can be sorted and formatted programmatically through an API of more than 400 properties, methods and events, or at runtime through the built-in Spreadsheet Designer. Easy deployment - Formula One supplies a robust set of functionality for database reporting. This expedites and simplifies deployment of reporting applications built with Formula One. Corporate Implementations - Numerous corporations have enjoyed success by leveraging Formula One as a reporting tool. Standard & Poors Compustat uses Formula One as a reporting tool to calculate portfolio data and distribute results to clients through the Internet. Another Tidestone customer, the City of Milwaukee, has deployed a Web-based timecard reporting system. SunGard Securities uses Formula One as a reporting and data collection tool. NASA Goddard uses Formula One in an application that analyses flight data. And GTE Enterprise Solutions uses Formula One to deliver data to mortgage wholesalers through the Internet. More Formula One for Java case studies Scalable Calculation Engine - Formula One utilizes its powerful spreadsheet knowledge to calculate large amounts of complex data and produce highly accurate results efficiently. Much like database reporting, the need for accurate and fast calculations in business applications is common. Calculations play critical roles in business applications such as computing order totals, mortgage payments and 401(k) balances. Accounting, banking and transaction processing applications are other examples where calculations are instrumental. In fact, nearly every vertical industry (finance, energy, insurance, healthcare, telecommunications, etc.) utilizes calculations in its day-to-day activities. As was the case with database reporting, Formula One usually delivers this functionality as a background task of applications or on servers. Developers can populate Formula One workbooks, insert values from a database, user input, or other data sources and extract the results.
Formula One's features as a calculation
engine include: Server-side or client-side - Formula
One's calculation engine can be implemented on server or client. Pricing and Availability |
