In this article, you will find new features and enhancements added to Spread v9 categorized by platform.
Spread Studio running in Windows 10 and Visual Studio 15 with an Excel 2016 theme.
Include a print button on your page that opens the standard browser print window. SpreadJS supports all the printing options you will need including best fit, gridlines, borders, header, footer, margins, page fit, page size, and page breaks. Print settings are also preserved when importing and exporting Excel files.
Filter and analyze data with SpreadJS's Excel-like table slicer. You can use the slicer in two ways. Use a standard Excel-like button slicer that gives a convenient set of button filters. Alternately, use the slicer widget to add convenient controls, such as buttons, checkboxes, and sliders, that allow you to slice data by values, date ranges, and number ranges. The first gives a classic Excel experience while the second provides a more interactive experience you expect from a robust data grid. You can even use bar charts as slicer controls to provide drill-down functionality. SpreadJS's slicer can be even be used independently. Variations of the SpeadJS Table Slicer.
SpreadJS supports Chinese character sets.
Until now, SpreadJS's Excel Import/Export features required an installed web service. ExcelIO is now a component that enables you to distribute it without license worry and exposes a public API making it easier to work with.
The floating obect now has a property to fix its position so you can add a chart, image, or other obect that won't scroll off the screen as users navigate your spreadsheet.
Rather than scroll by row or column, which can provide a choppy scrolling experience, the view now scrolls by pixel, which provides a smooth experience. Pixel based scrolling also enables the user to leave the view scrolled to a part of a cell. Previously, the view would always snap to a row or column border. This is especially beneficial in touch scenarios.
Enjoy more control over design with diagonal borders that draw lines inside of cells. This is useful for crossing out cells or drawing borders around rotated text. Example of diagonal borders in Spread.
Spread and applications created with spread are DPI aware and will automatically scale. Spread also includes two icon sets for interface buttons and other indicators, one for normal DPI and one for high (200% DPI). This ensures interface buttons, such as filter drop downs, and other icons, such as indicators used in conditional formatting, always look the best they can. The screen shot below shows what a conditional formatting scenario looks like before and after this enhancement. Comparison of icons with and without high DPI support.
Spread has a new number cell type (GcNumberCellType) that adds many features and properties to numerical cells. Features include:
New numeric cell type properties.
Spread now allows you to set the style of the series in line charts, much like Excel does. You can set these properties in code or use the designer. Supported properties are also preserved when importing Excel files with line charts. Options include:
Spread's new line chart.
Spread now includes a date picker that supports touch interaction.
Spread behaves the same as Excel in order to give users a familiar experience, but sometimes developers want to alter certain behaviors. In this case, we have added optional style properties related to cell selection.
Spread's web apps will support touch interaction in Microsoft Edge and Google Chrome. In the image below, notice the touch handles on the selected cell range. Range selection with touch handles.
Spread now supports these AJAX Control kit v15.1 extender Cell Types: