In this article, you will find new features and enhancements added to Spread v9 categorized by platform.
Windows 10, Visual Studio 15, and Excel 2016 Support
- Spread will work in Visual Studio 15.
- Applications you create with Spread will work in Windows 10 and Edge.
- Spread will import/export Excel 2016 files and includes Office 2016 themes.
Spread Studio running in Windows 10 and Visual Studio 15 with an Excel 2016 theme.
Preview and Print Data Views
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.
Excel Import/Export Component
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.
Fixed Position Floating Objects
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.
- Enhanced Paste: Choose to paste all, values, formatting, or formulas.
- Tab Color: Change tab color in the designer UI.
Excel-like Behavoir Enhancements
- Hidden row and column indicator
- Disable sheet navigation
- Ignore hidden rows and columns when scrolling
- Disable copy for locked cells
- Protect sheets and cells
Smoother, More Accurate Scrolling
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.
Diagonal Line Borders
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.
Enhanced High DPI Support
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.
Enhanced Numerical Cell Types
Spread has a new number cell type (GcNumberCellType) that adds many features and properties to numerical cells. Features include:
- Alternate text
- Display fields
- Context menu
- Negative color
- Recommended value
- Drop-down window
- Drop-down calculator
- Popup window
- Side buttons
- Toggle sign with minus key
- Japanese keyboard support
- Delete with delete and backspace
- Percentage support
- Improved paste behavior
New Chart Line Styles (with Excel I/O Support)
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:
- Compound type
- Dash type
- Arrows (cap type, cap size, arrow size, arrow type)
- Join type
Spread's new line chart.
Touch-friendly Date Picker
Spread now includes a date picker that supports touch interaction.
New Selection Style Options
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.
- Choose to highlight the active cell in a selected range or to have the same background as the others. In Excel, that cell would not have a selection background.
- Choose to not highlight the selected row and cloumn header. In Excel, they would be highlighted.
- Show row editing selector.
- Enhanced Selection Border: When selecting a range, Spread will draw a border around the entire selection by default.
- Optional Filtering Behavior: When row filters are set, Spread automatically applies filter rules to any new data or styles entered or edited. This is not the case in Excel. The filter needs to be explicitly executed. Spread now has the option to use Excel-like behavior.
- Editing Cell Keeps Vertical Alignment: When editing a cell, its vertical alignment will be preserved. Previously the alignment would change to top when editing.
- Remote Desktop Support: Spread fully supports the use of remote desktop in runtime.
- Improved PDF Export Performance: PDFs are creates approximately 10% faster.
- Shape Text Alignment: Spread now supports alignment of text inside a shape.
- Row/Column Move Performance Improvement: When you move, rows and columns in Spread, it shows a clone of your selection while you drag them. Sometimes, that causes a performance issue. You can now disable that indicator or create your own behavior.
Touch Support for Edge and Chrome
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.
Support for AJAX Control Kit v15.1
Spread now supports these AJAX Control kit v15.1 extender Cell Types:
- Combo box
- Filtered text
- Masked edit
- Mutually exclusive checkbox
- Numeric spinner
- Slide Show
- Text box with watermark