by clearoffice
1. October 2009 06:22
The September Community Technical Preview (CTP) is now ready for download at www.clearoffice.com/download.html
This version includes the following improvements:
- Support for array formulas
It is now possible to enter formulas such as “SUM(A1:A3*B1:B3)”. The input mechanism is similar to Excel: To enter a regular formula, press “Enter”; to enter an array formula, press Control+Shift+Enter.
BIFF is the legacy binary format (with the .xls extension). Clear Office can now open most .xls files.
The spreadsheet framework includes a new control: WorkbookControl. The goal behind the WorkbookControl is to make workbook hosting in your application super easy. Once you have added the reference to the Clear Office assemblies, simply insert a <spreadsheet:WorkbookControl /> tag in your XAML and the Workbook will be visible in the designer.
Auto fill has been improved. In particular, auto fill now works on time values. For example, if a sheet contains 9 AM, auto fill will yield 10 AM, 11 AM, etc
As usual, contact support@clearoffice.com for any question or problem.