The following features have been added to this version of the product.
Checkbox list celltype is now supported to allow users to create interactive checklists and to-do lists with multi-selection field values.
Radio button list celltype is now supported to provide users with the ability to choose and select a single item from a list of several options available within a cell in the worksheet.
Button list celltype is now supported to allow users to embed a group of items within a single cell where one or multiple options can be selected to record user responses.
Range template celltype is now supported to enable users to define a template of cell ranges as a single celltype and apply that template to one or more cells across the worksheet.
Users can configure custom cell styles when different Cell States (like edit, hover, active, select, etc.) are matched in a worksheet.
Support for Cell Buttons (predefined buttons like drop-down buttons, undo/redo buttons, enable/disable buttons, spin buttons, etc.) is now provided to allow users to configure additional functionalities in the cells of the worksheet.
Users can select data easily and quickly using the Cell Dropdowns feature that inserts a custom drop-down menu with specific properties for creating advanced input forms and interactive dashboards.
The Auto Merge feature has been introduced in order to allow users to automatically merge the neighboring cells containing duplicate text.
Support for Formula Auditing has been provided to allow users to display relationships between formulas and cells by tracing the precedent and dependent cells in the worksheet.
Users can work with dynamic array formulas like UNIQUE, FILTER, RANDARRAY, SORT, SORTBY, SEQUENCE, and SINGLE to build cache-friendly data structures.
The Split Resize feature has been introduced to allow users to resize the current row or column along with the next visible column or row without affecting the remaining rows and columns in the worksheet.
Dynamic Column sizing is now supported to allow users to configure the column widths and row heights in such a way that the viewport is filled exactly as per the weighted proportion (* symbol) specified by the user.
The Scroll by Pixel feature has been introduced to provide support for Excel-like precision scrolling.
Now, users can rotate text in cells to change the way data appears in a cell.
Custom Legend Formatting, Positioning, and Styling are now supported while working with legends in the charts.
Users can configure display units on the value axis while working with charts in the spreadsheets.
Adding Trendlines to charts is now supported in order to enable users to quickly analyze the overall trends (ups and downs in the data points), show data movements over a period of time, or simply correlate two different variables.
Adding Error Bars in charts is now supported to allow users to identify margins of error, and standard deviations and showcase data variability along with measurement accuracy, etc.
Users can add hover animation and style to allow users to interact with the data points in the chart.
Users can change the vertical axis to a logarithmic scale to allow users to customize the minimum and maximum scale values of the vertical axis (also called the value axis).
Users can display empty cells and null values in charts just like in Excel. This feature is helpful in plotting the missing data in a chart and quickly identifying and correcting any issues with the data.
Customization of chart area border is now supported.
Now, SpreadJS remembers the sheet view position just like in Excel whenever a workbook is saved.
The AGGREGATE function is now supported just like in Excel.
New theme Excel 2016 Black has been introduced in this version.
The "Auto expand table area" feature is now supported. While working in SpreadJS Designer, users can input data in the next row or the column next to the table area, and the table will be automatically expanded. When users perform the cut, copy, paste operations, the drag fill operations (towards right direction or downwards direction), or the drag-drop operation, if the paste area exceeds the range of the table, then also the table will be automatically expanded.
Now, table columns and rows can be inserted and deleted through the built-in context menu in the SpreadJS Designer.
Now, users can select a table column, row, or the entire table via moving cursors at multiple positions in the worksheet. For example - users can select a table column by hovering over the top edge of the table column header until the cursor changes to the down arrow and then the header can be clicked to select the table column. Users can also select the row or top-left corner of the table to select the table.
Users can use either the "TAB key" or "Shift+TAB" key to quickly switch between the cells in the table or expand the table range.
With the newly introduced "Fixed scrolling table headers" feature, the table headers can be displayed in the column header when users scroll the table data and the table header is out of the worksheet's visible area.
Table UI enhancements - The following UI enhancements have been introduced while working with tables in spreadsheets:
While working with tables, users can add a "total row" just like in Excel. The total row formulas are also supported to allow users to quickly display the table footer dropdown and select the dropdown list to choose and insert the desired summary function.
Now, users can easily resize tables using the table resizing handler.
Advanced column binding features are supported to allow users to bind formatter and celltypes to table columns.
The following issues have been resolved since the last release.
The formula calculation results are now accurate upto utmost precision.
The result of performing an auto row height operation via double clicking the row is now accurate.
No content errors are displayed while importing the excel files.
When the cell contains multiline text and the "Ctrl+Z" keyboard shortcut is used in edit mode, then no DOMException is thrown now.
The STDEVA formula now calculates correct results.
No styles are missed while exporting the SSJSON file to Excel.
No #Value errors are thrown while calculating functions after importing the Excel file.
Now, Excel files can be imported with SpreadJS without any issues.
While working with SpreadJS in Chinese IME the symbol "=" can now be entered in the cells without going into the edit mode.
The wordwrap feature in SpreadJS now works in the same way as in Excel.
Now, forms can be deleted normally without any issues. The error "Cannot read property 'getRowCount' of null" is not thrown now.
While importing Excel files into SpreadJS, the original border is not lost now .
While exporting to a PDF file, the border remains intact and doesn't get narrowed.
No errors are thrown when hidden forms are displayed again using sheet.visible() method.
Now, the floating point precision problems have been resolved and no calculation errors are thrown while calculating the ROUND function.
Now, SpreadJS performance is consistent on all operating systems including MAC, Linux, and Windows (Chrome 67).
The position of the shapes embedded in the worksheet remains intact even when the "zoom" of the worksheet is changed.
While working with charts, gridlines and labels on the right side are displayed without any issues.
Now, users can set the scale interval of x-axis while working with charts.
Different chart types can be displayed in the same legend area now. Also, users can modify the chart line type of the legends in the chart.
When the formula parameter is a specific string, now the parameter will not change automatically, and the operation of selecting the cell will not cause any errors.
Now, no erros are thrown after deleting the worksheet.
The result of the formula execution in SpreadJS now works in the same way as in Excel.
While importing Excel files in SpreadJS, the style of the chart title remains intact.
After disabling the shape resize feature, the shape resizing cursor is not displayed now.
While using fallback fonts, there is no effect on the performance of the export to PDF operation now.
The scrolling now works faster with thousands of rows (50,000 rows) bound in a table.
Another shape below the clicked shapes is not selected unexpectedly now.
No errors are thrown while working with QR code in the spreadsheets.
The Chart menu of the SJS Designer now works properly without any issues.
The import operation now takes comparatively less time and works much faster than before.
Custom cell styles now work as expected.
Upon opening the exported Excel file, now users can recover the warning messages without any hassle.
While exporting Excel files, the column bar doesn't get overlapped if the secondary axis is set.
When users right click on the spreadsheet, now the context menu for the shape works as expected and is not shown if the shape is hidden.
The imported Excel file now displays the correct format.
The data source of the chart is now highlighted correctly if the source is split via commas.
If a workbook contains SUBTOTAL formula and the workbook is destroyed as a result of routing to another page or due to false condition for *ngIF then the error "TypeError: Cannot read property 'getRowCount' of null" error is not thrown now.
The drag fill operation for the filtered rows now works just like in Excel without any issues.
Now, users can correctly import the Excel file that contains cross workbook formula references.
Now, users can easily copy paste the line break content using formula textbox.
Zooming of shapes now works correctly without any issues.
Now the Excel file is exported correctly even when multiple files are exported in a loop.
The SMALL formula now works in the same way as in Excel.
Charts can now be rendered for specific height values without any issue.
The Filter dialog now displays instantly when the conditional format is set by the user.