Version 3.0 of Formula One provides a variety of new features. Among the new features provided by this version:
OCX Support. Formula One functionality is available through OCX properties and methods.
Enhanced Excel Support. Version 3.0 provides a number of new and improved features that make Formula One even more Excel-compatible such as:
Excel 5.0 support. Formula One can now read and write Excel 5.0 files.
Workbooks. Support for Excel-type multiple sheet workbooks. This means that Formula One supports 3-D cell referencing (Sheet1:Sheet5!A1:C10.) Additionally, many worksheet editing methods such as InsertRange, DeleteRange, MoveRange
, etc. can work on multiple worksheets at the same time. This time-saving feature keeps you from having to perform the same over and over in your code to modify a series of worksheets.
Cell References. Formula One can now parse range references with . or . . in addition to
A1:B2 or A1.B2 or A1..B2)
Entering Text. You can now use a leading apostrophe (’) to enter numbers as text.
New Worksheet Functions. The worksheet functions SUMIF, COUNTIF, CONCATENATE, ROUNDUP and ROUNDDOWN have been added to this version in enhance Excel 5 compatibility.
Connection to ODBC databases. By using the new ODBCConnect, ODBCQuery, and ODBCDisconnect methods, you can retrieve information from an ODBC database and place it in your Formula One workbook.
New Built-In Chart Object. You can now select a range of data, click on the chart tool, and draw a First Impression chart on your worksheet.
Built-In DLL. In this version of Formula One, the DLL is built directly into the OCX. The only file you have to distribute with your application is VCF132.OCX. (MFCANS32.DLL and OC30.DLL must also be present.)
Validation Rules. You can now create validation rules to ensure users enter appropriate data in cells. Validation rules include a formula against which to test the cell entry and a message to be displayed if validation fails. There is also a new
ValidationFailed event to allow you to program a response when validation fails.
AutoFill Feature. Formula One now provides the ability to autofill worksheet cells with common lists such as month names and days of the week. You can also add your own autofill lists.
