These release notes for Spread version 8.0 include a summary of new features and some usage conditions. For a complete list of resolved issues, refer to Resolved Issues.
New Feature
Spread 8.0.20 adds the following new features:
- SSOwnerPrintDraw and SSOwnerPrintPageCount functions.
Spread 8.0.07 adds the following new features:
- Methods to open and save Excel 2007 xlsx formatted files. Refer to the Redistribution page for more information.
- The PMTXL formula function was added.
New Features
This version of the product has the following features added since version 7.0
- New Formula Functions
- Ability to create a custom cell
- A 64-bit DLL control
- Shape and color settings for cell notes
- New OCX methods for saving and loading to/from a buffer
- New event for circular references
Enhancements
This version of the product has the following enhancements added since version 7.0
- Enhanced appearance
- Enhanced appearance for headers and sheet corners
- Enhanced appearance for scroll bars
- Enhanced appearance for sheet tabs
- Enhanced selection highlighting
- Additional export options when exporting to HTML
- Users can apply a secondary sort using control-click
For more information, refer to the product overview in the User's Guide.
For a list of new properties, methods, and events, refer to ActiveX Changes.
For a list of new functions, structures, and messages, refer to DLL Changes.
Usage Conditions
Be aware of this additional information in this version of the product:
- Starting with Spread 7.0.41, page breaks are ignored when using the best fit options.
- The ExportToTextFile method and the ExportRangeToTextFile method both have a new flag for saving the false value of a check box cell.
- If you have a previous version of Spread, and want to upgrade projects, refer to Project Upgrade.
- You can enhance the drop-down list portion of the combo box cell by using the List Pro version 3.0 fpCombo control.
- Sample projects using the fpSpread and fpSpreadPreview controls are provided in the \SPREAD80\SAMPLES directory. New samples are available that demonstrate how to implement some of the more popular grid programming styles and features. These samples are available in the \SPREAD80\SAMPLES directory if you performed the default installation of the product. You have a royalty-free license to use the code in these samples.
- HTML export is intended to create a browser-independent HTML table. The HTML tables created by the export feature comply with the HTML 3.2 standard.
- When exporting to Excel, avoid using these symbols in the sheet name that Excel does not allow in a sheet name.
? / \ * [ ]
- If your printer does not support the fonts in the spreadsheet and shown on the preview page, Windows substitutes another font. Consequently, the printed spreadsheet is not the same as what you see on the preview page. To avoid this problem, use TrueType® fonts.
- If you are using virtual mode,
- The fpSpreadPreview control displays only the number of rows that are in the virtual buffer.
- Turn off virtual mode before exporting the spreadsheet to an HTML or XML file. If virtual mode is on when you export the spreadsheet, all rows are exported and only the rows in the virtual buffer contain data. The other rows are blank.
- If you use the Spread 8.0 ADO ActiveX control, please note that Access 2.0 databases do not seem to be compatible with ADO. Access 7.0 databases are.
- Before compiling a unicode version of Spread in VC++ go under Project -> Settings -> C/C++ tab, and add _unicode to the preprocessor definitions.
- If you are using the Spread control in C++, see C++ Development Considerations for more information about using the controls.