In this article, you will find new features and enhancements added to Spread v8 categorized by platform.
Spreadsheet tables Tables are used to manage and analyze related data, sort, filter, and format data within a sheet. By using the table features, you can manage data in table rows and columns independently from data in other rows and columns in the worksheet. A table can include:
We also support importing and exporting Tables from or to Excel files.
In this release, we've changed the default appearance of the control to a flat style, removed any stylistic choices that give the illusion of 3D (such as drop shadows, gradients) and focused on a minimalist use of simple elements, typography and flat colors. It’s pure and simple, elegant and neat. We've also provided a skin which appears just like Excel 2013, a new tab strip layout, new header color scheme, selection, and more.
MultiRow MultiRow for WinForms is a powerful grid component that allows you to add custom tabular input and display screens to your Visual Studio applications. It has extensive flexibility that allows you to place cells anywhere on the grid surface, and create elaborate tabular displays with a record in multiple rows with borders and formatting. We've enhanced MultiRow a lot in this release, with multi-touch support, a variety of CellTypes enhancements, layout enhancements, and enhancements of the Designer. These enhancements help you implement a comprehensive grid into your application easily and quickly.
The subtotal function now does not calculate hidden cell data; it gets correct calculation result when the end user filters out some rows or hides some rows or columns.
Performane improvements When importing Excel files, Spread now reads the Excel file "On Demand" and then releases the memory once the block of data is imported. This reduces the memory footprint during importing and drops MemoryStream which was needed to read all OOXML data into memory. For exporting, Spread now uses an iterator class to get the data dynamically during exporting instead of preparing a data array before exporting to an Excel file.
Spread allows changing the position of the outline group icon, showing the icon on top of the grouped rows or to the left of grouped columns. You can also import/export this option to Excel files.
Spread for ASP.NET adds additional support for all modern browsers, including Internet Explorer, Chrome, FireFox, and Safari.
iPad touch support
In this release we've changed the default appearance of Spread for ASP.NET to a flat, modern style. We've removed any style elements that give a 3D illusion (such as drop shadows and gradients) and focused on a minimalist use of simple elements, typography and flat colors. It’s pure and simple, elegant and neat. In this release, we've also provided an Excel 2013-like skin, a new tab strip layout, header color scheme, selection, and more.
Use the QueryUI ThemeRoller to skin your Spread applications with just a few lines of code. ThemeRoller has a variety of default skins or you can create your own. In either case, you will add a modern and consistent look to virtually every facet of your Spread application.
When using date-time cell types, you can now display a calendar control from which users can pick dates.
Spread's clipboard features now support more modern browsers such as Safari on iPad and FireFox.
Print support enhanements Now you can easily print entire or partial worksheets and workbooks one or many at a time. Just like in Excel, you can customize several print settings including page order, orientation, and size. You can also specify alignment, margins, and whether to show a print header, gridlines, scale selection, page header/footer, and more. You can also print to a file instead of to a printer. This is useful when printing the workbook on a different printer from the one originally used. And in WPF applications, Spread includes a preview dialog box for previewing spreadsheets before printing.
Spread now imports Excel files asynchronously, loading data on demand for UI display while a background thread continues to load data. The end user sees the data displaying quickly, and the UI is still responsive while loading. This provides the end user with a smooth UI experience for Excel importing.
Structured reference Structured references make it much easier and more intuitive to work with table data when you are using formulas that reference a table (either portions of a table or the entire table). They are especially useful because table data ranges often change, and the cell references for structured references adjust automatically. This minimizes the need to rewrite formulas as rows and columns are added and deleted in a table, or when external data is refreshed.
In this release we've changed the default appearance of Spread WinRT to flat style, removed any stylistic choices that give a 3D illusion (such as drop shadows and gradients) and focused on a minimalist use of simple elements, typography and flat colors. It’s pure and simple, elegant and neat. We've also provided an Excel 2013-like skin in our Skin sample, with a new tab strip layout, new header color scheme, selection, and more.