SpreadJS 10

New Spread.Views - a data presentation component to help you quickly create modern data layouts.
November 21, 2016
New Version

Features

  • New Component - Spread.Views - This is a data presentation component that helps you quickly create modern data layouts such as grid, news feed, trellis, card, masonry, timeline, and more.
  • Speed Improvements - The SpreadJS code has been completely refactored, allowing for better performance, a smaller size and a more intuitive API. For backward compatibility, a migration.js file is also included.
  • Client-side Excel I/O - Spread.Sheets V10 introduces the new client-side Excel IO. A Windows Server is no longer required for importing and exporting Excel files into and from SpreadJS. Instead, pure JavaScript code can be used to provide simpler and more user-friendly Excel import and export functionality. This new client-side Excel IO can import and export XLSX files to and from the SpreadJS JSON format.
  • Cross-Platform Designer - Spread.Sheets 10 features a new cross-platform Designer for Windows, MacOS, and Linux to make designing your spreadsheets as easy and familiar as using Microsoft Excel.
  • Cell Padding and Labels - Design perfect spreadsheet form layouts with new padding and labeling properties for each cell. Cell watermarks can be displayed in the background to assist the user in filling forms quickly and easily.
  • Range Selection Control - Select ranges in Spread.Sheets with enhanced control over the selection, including selections from different sheets and multiple selections. In addition, you can edit these selections from a textbox and update them manually or type out the references. This selection method provides an easier way to select ranges and have those selections update in the sheets.
  • Copy/Paste Enhancements - Copying and pasting in Spread.Sheets has been enhanced to provide more functionality over previous versions. Now you can copy and paste additional features from and to Excel and Spread, such as styles, spanned cells, multiple non-contiguous cells, and headers. Spread.Sheets will now add rows and/or columns when the destination range is not enough to contain the copied cells. In addition, the events related to copying and pasting have been enhanced to add more information regarding the specific data that was copied or pasted, which can be useful when handling these events.
  • Year Sparkline/MonthSparkline - Create beautiful at-a-glance dashboards of annual and monthly activity with a single function call. This new sparkline format allows you to summarize large amounts of data in a single cell.
  • Async Function Enhancements - The Async function has been enhanced in Spread.Sheets to allow the user to call long running functions without locking the control UI. It is ideal for retrieving data from a Web API to create connected spreadsheets and dashboards.
SpreadJS

SpreadJS

Complete spreadsheet solution for JavaScript applications.

Got a Question?

Live Chat with our MESCIUS (formerly GrapeCity) licensing specialists now.