Release Notes for Version 16.1.0

Enhancements from the Previous Release

The following features and enhancements have been incorporated into this version of the product.

• Added various Input Mask Style options.

• Added support to set a password while protecting a worksheet and verify the password while unprotecting it.

• Enhanced the Combo chart to display it as a Gauge chart.

• Added support for resizing the Conditional Formatting Rules Manager and Name Manager dialogs.

• Added support for format hints for formula results. After inputting a formula, SpreadJS now reads the formula to get the suggested format and set it to the cell.

• Added support for rendering sparklines in auto shapes and picture shapes.

• Added various RegEx functions i.e. Extract, Match and Replace.

• Implemented transformation of object column, when a user marks it as spread in the data source schema then the column will be spread as first level properties.

• Added support for wrapping text in checkbox cell type

• Added support for editing font size and type decimals in the edit area of the numeric box.

• Added support for using AllSheetsList button when entering a formula at runtime while maintaining the editing status.

• Added support for the ShowZeros option to enable users to display the zero values in the cell.

• In SpreadJS Designer two new buttons have been added to implement Z-order of the shapes for arranging shapes.

• Added support to insert cut /copied cells to tables.

• Added SpreadJS support in NextJS.

• Added SpreadJS support in Nuxt.

• Added Angular 15 support.

• Implemented the allowFloat option to handle dropdown positioning and size of combo box.

• Added support to allow users to invert the negative values of a bar or a column chart.

• Implemented textbox shapes support.

• Added support for “Sort by Value” in pivot tables so that users can sort and organize data in various ways.

• Added support for setting subtotal position for a single field in a PivotTable.

• Added the enabled property to control the interaction of form controls in SpreadJS form controls.

• Added “Enable accessibility” option in the SpreadJS Designer.

• Added an option to add/delete rows in column headers and add/delete columns in row headers.

• Added support for icons style decoration embedded inside of or outside of the cells.

• Added support for cell reference option while using getPivotData functions for PivotTable.

• Added support for implementing multiple filters options in TableSheet.

• Added support to reorder TableSheets and worksheets together.

• Added support to change the default row-header command to select the row instead of pin.

• Added some column header Style Rules for TableSheet.

• Implemented improved setRowCount and setColumnCount methods to guard against deleting rows/ columns having data.

• Added support for copy pasting wordWrap text from one SpreadJS to another or from SpreadJS to Excel and vice versa.

• Added support for resizing the filter dropdown.

• Added support for maintaining the wordwrap of cells while copy pasting from one sheet to another.

Resolved Issues

The following issues have been resolved since the last release:

• Resolved the zoom speed issue while importing a file with shapes.

• Resolved formula textbox support appending the column selection in one table.

• Resolved the change in default row header click issue in TableSheet.

• Resolved exported HTML content issue that prevented wrapping.

• Resolved the thickness issue of sparklines.

• Resolved the edit mode issue where you could remove all rows using backspace.

• Resolved the values issue that was displayed in charts.

• Resolved the SUMIFs result issue when a range contains an error.

• Resolved the table column reference issue by clicking the column header during the formula edit.

• Resolved the chart size issue when printing.

• Resolved an exception issue thrown on loading the given SSJSON file.

• Resolved the Excel error issue displayed when a PivotTable was opened after changing the sheet name.

• Resolved the relationship name issue from the SpreadJS Designer.

• Users can now set the column visibility to false in the data source view.

• Resolved the columns issue with opening and closing parenthesis in column captions that could not be checked or unchecked from the field section of the TableSheet panel.

• Users can now add a relationship in the data source in SpreadJS Designer, the fields can be duplicated in all other tables.

• Users can now close the “Data Validation” dialog without entering the required values.

• Users can now open an xlsx file with SpreadJS Designer.

• Resolved the lost property issue ‘pivot=1’.

• Resolved the countfis function issue where the input box is missing a condition input box.

• Removed the cell button which was not working in SpreadJS Designer.

• Resolved the left and the upper sides of the border issue.

• Resolved the memory leak in SpreadJS Designer's React component.

• Resolved the font size issue when the axis title is wrong.

• Resolved the gridlines issue which was incorrectly shown when importing in an excel file.

• Users can now refer to another sheet’s cell when isPrintLineVisible is set true.

• Users can now use del key to delete a formula.

• Users can now export SpreadJS charts that are consistent with the schema.

• Resolved the TableSheet formatting issue which was cleared when the DataManager was updated and a new URL throws an API error.

• Resolved the chart name issue that changed after Excel import/export

• Resolved the parameter description issue of the SpreadJS function OR.

• Resolved the issue of cell’s actual font size that changed after SpreadJS import export.

• Resolved the scatter XY Chart issue in Excel file which imported incorrectly in SpreadJS.

• Users can now set the hyperlink for PivotTable cells.

• Users can now open a specific Excel file exported from the SpreadJS Designer.

• Resolved lost and undefined form control properties in the JSON schema.

• Resolved the comment author property issue when SpreadJS opens and saves an xlsx file.

• Resolved the MS Excel problem when the Excel file is exported from SpreadJS.

• Resolved the result issue of MIN/MAX formula providing a different result compared to Excel.

• Resolved the image loss issue while hiding rows when PrintLineVisible option is set to true.

• Resolved the sheet binding issue that was impacting the values of merged cells.