# Release Notes for Version 16.1.0

## Content

## Enhancements from the Previous Release

<span style="mso-ascii-font-family:Calibri;
mso-fareast-font-family:Calibri;mso-hansi-font-family:Calibri;mso-bidi-font-family:
Calibri;color:black;mso-themecolor:text1" lang="EN-US">The following features and enhancements have been incorporated into this version of the product.</span>

* <span lang="EN-US">Added various</span>[<span lang="EN-US"> Input Mask </span>](/spreadjs/docs/v18/features/cells/mask-)<span lang="EN-US">Style options.</span>
* <span class="ui-provider gr b c d e f g h i j k l m n o p q r s t u v w x y z ab ac ae af ag ah ai aj ak" dir="ltr">Added support</span><span lang="EN-US"> to set a password while</span>[<span lang="EN-US"> protecting a worksheet </span>](/spreadjs/docs/v18/features/worksheet/celllock)<span lang="EN-US">and verify the password while unprotecting it.</span>
* <span lang="EN-US">Enhanced the Combo chart to display it as a</span>[<span lang="EN-US"> Gauge chart</span>](/spreadjs/docs/v18/features/Charts/ChartTypes/CreatingComboChart)<span lang="EN-US">.</span>
* <span lang="EN-US">Added support for resizing the Conditional Formatting Rules Manager and Name Manager dialogs.</span>
* <span style="color:black" lang="EN-US">Added support for </span>[format hints for formula results](/spreadjs/docs/v18/features/formulas/formulauser)<span style="color:black">. After inputting a formula, SpreadJS now reads the formula to get the suggested format and set it to the cell.</span>
* <span lang="EN-US">Added support for rendering </span>[<span lang="EN-US">sparklines in auto shapes and picture shapes</span>](/spreadjs/docs/v18/features/UnderstandingShapes/sparkline-shape)<span lang="EN-US">.</span>
* <span lang="EN-US">Added various </span>[<span lang="EN-US">RegEx functions</span>](/spreadjs/docs/v18/formulareference/FormulaFunctions/regex-functions)<span lang="EN-US"> i.e. Extract, Match and Replace.</span>
* <span style="color:black" lang="EN-US">Implemented </span>[transformation of object column, when a user marks it as spread in the data source schema](/spreadjs/docs/v18/features/tablesheet/table)<span style="color:black" lang="EN-US"> then the column will be spread as first level properties.</span>
* Added support for [wrapping text in checkbox cell type](/spreadjs/docs/v18/features/cells/celltypes/cellcheckbox)
* <span lang="EN-US">Added support for </span>[<span lang="EN-US">editing font size and type decimals in the edit area of the numeric box</span>](/spreadjs/docs/v18/spreadjs-designer-component/spdesignerwork/edit-font-size)<span lang="EN-US">.</span>
* <span lang="EN-US">Added support for using </span>[<span lang="EN-US">AllSheetsList button when entering a formula</span>](/spreadjs/docs/v18/features/formulas/set-formulas)<span lang="EN-US"> at runtime while maintaining the editing status.</span>
* <span lang="EN-US">Added support for the </span>[<span lang="EN-US">ShowZeros option to enable users to display the zero values in the cell</span>](/spreadjs/docs/v18/features/cells/display-zero-values)<span lang="EN-US">.</span>
* <span lang="EN-US">In SpreadJS Designer two new buttons have been added to implement </span>[<span lang="EN-US">Z-order of the shapes for arranging shapes</span>](/spreadjs/docs/v18/spreadjs-designer-component/spdesignerwork/shape-selection-pane)<span lang="EN-US">.</span>
* <span lang="EN-US">Added support to </span>[<span lang="EN-US">insert cut /copied cells to tables</span>](/spreadjs/docs/v18/features/cells/insert-cut-or-copied-cells)<span lang="EN-US">.</span>
* <span lang="EN-US">Added </span>[<span lang="EN-US">SpreadJS support in NextJS</span>](/spreadjs/docs/v18/javascript-frameworks/spreadjs-with-nextjs)<span lang="EN-US">.</span>
* <span lang="EN-US">Added </span>[<span lang="EN-US">SpreadJS support in Nuxt</span>](/spreadjs/docs/v18/javascript-frameworks/spreadjs-with-nuxtjs)<span lang="EN-US">.</span>
* <span lang="EN-US">Added</span>[<span lang="EN-US"> Angular 15 support</span>](/spreadjs/docs/v18/javascript-frameworks/angular)<span lang="EN-US">.</span>
* <span lang="EN-US">Implemented the </span>[<span lang="EN-US">allowFloat option to handle dropdown positioning and size of combo box</span>](/spreadjs/docs/v18/features/cells/celltypes/cellcombo)<span lang="EN-US">.</span>
* <span lang="EN-US">Added support to allow users to </span>[<span lang="EN-US">invert the negative values of a bar or a column chart</span>](/spreadjs/docs/v18/features/Charts/ChartTypes/CreateColumnChart)<span lang="EN-US">.</span>
* <span lang="EN-US">Implemented </span>[<span lang="EN-US">textbox shapes</span>](/spreadjs/docs/v18/features/UnderstandingShapes/text-on-shapes)<span lang="EN-US"> support.</span>
* <span lang="EN-US">Added support for </span>[<span lang="EN-US">“Sort by Value” in pivot tables</span>](/spreadjs/docs/v18/features/pivot-table/sort-pt)<span lang="EN-US"> so that users can sort and organize data in various ways.</span>
* <span style="font-family:Segoe UI,sans-serif;
    color:#172B4D;letter-spacing:-.05pt;background:white" lang="EN-US">Added support for </span>[setting subtotal position for a single field](/spreadjs/docs/v18/features/pivot-table/pivot-table-layout) in a PivotTable.
* <span lang="EN-US">Added the </span>[<span lang="EN-US">enabled property to control the interaction of form controls</span>](/spreadjs/docs/v18/features/UnderstandingShapes/form-controls)<span lang="EN-US"> in SpreadJS form controls.</span>
* <span lang="EN-US">Added “Enable accessibility” option in the SpreadJS Designer.</span>
* <span lang="EN-US">Added an option to add/delete rows in column headers and add/delete columns in row headers.</span>
* <span lang="EN-US">Added support for icons style decoration embedded inside of or outside of the cells.</span>
* <span lang="EN-US">Added support for cell reference option while using getPivotData functions for PivotTable.</span>
* <span lang="EN-US">Added support for implementing multiple filters options in TableSheet.</span>
* <span lang="EN-US">Added support to </span>[<span lang="EN-US">reorder TableSheets and worksheets together</span>](/spreadjs/docs/v18/features/tablesheet/tablesheet-operations/reorder)<span lang="EN-US">.</span>
* <span lang="EN-US">Added support to change the default row-header command to select the row instead of pin.</span>
* Added some column header Style Rules for TableSheet.
* <span lang="EN-US">Implemented improved setRowCount and setColumnCount methods to guard against deleting rows/ columns having data.</span>
* <span lang="EN-US">Added support for copy pasting wordWrap text from one SpreadJS to another or from SpreadJS to Excel and vice versa.</span>
* <span lang="EN-US">Added support for </span>[<span lang="EN-US">resizing the filter dropdown</span>](/spreadjs/docs/v18/features/rows-columns/filter)<span lang="EN-US">.</span>
* <span lang="EN-US">Added support for maintaining the wordwrap of cells while copy pasting from one sheet to another.</span>

## Resolved Issues

<span style="color: rgb(34, 34, 34); font-family: system-ui, -apple-system, Segoe UI, Roboto, Helvetica Neue, Noto Sans, Liberation Sans, Arial, sans-serif, Apple Color Emoji, Segoe UI Emoji, Segoe UI Symbol, Noto Color Emoji, Font Awesome 5 Free; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;">The following issues have been resolved since the last release:</span>

* <span lang="EN-US">Resolved the zoom speed issue while importing a file with shapes.</span>
* <span lang="EN-US">Resolved formula textbox support appending the column selection in one table.</span>
* <span lang="EN-US">Resolved the change in default row header click issue in TableSheet.</span>
* <span lang="EN-US">Resolved exported HTML content issue that prevented wrapping.</span>
* <span lang="EN-US">Resolved the thickness issue of sparklines.</span>
* <span lang="EN-US">Resolved the edit mode issue where you could remove all rows using backspace.</span>
* <span lang="EN-US">Resolved the values issue that was displayed in charts.</span>
* <span lang="EN-US">Resolved the SUMIFs result issue when a range contains an error.</span>
* <span lang="EN-US">Resolved the table column reference issue by clicking the column header during the formula edit.</span>
* <span lang="EN-US">Resolved the chart size issue when printing.</span>
* <span lang="EN-US">Resolved an exception issue thrown on loading the given SSJSON file.</span>
* <span lang="EN-US">Resolved the Excel error issue displayed when a PivotTable was opened after changing the sheet name.</span>
* <span lang="EN-US">Resolved the relationship name issue from the SpreadJS Designer.</span>
* <span lang="EN-US">Users can now set the column visibility to false in the data source view.</span>
* <span lang="EN-US">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.</span>
* <span lang="EN-US">Users can now add a relationship in the data source in SpreadJS Designer, the fields can be duplicated in all other tables.</span>
* <span lang="EN-US">Users can now close the “Data Validation” dialog without entering the required values.</span>
* <span lang="EN-US">Users can now open an xlsx file with SpreadJS Designer.</span>
* <span lang="EN-US">Resolved the lost property issue ‘pivot=1’.</span>
* <span lang="EN-US">Resolved the countfis function issue where the input box is missing a condition input box.</span>
* <span lang="EN-US">Removed the cell button which was not working in SpreadJS Designer.</span>
* <span lang="EN-US">Resolved the left and the upper sides of the border issue.</span>
* <span lang="EN-US">Resolved the memory leak in SpreadJS Designer's React component.</span>
* <span lang="EN-US">Resolved the font size issue when the axis title is wrong.</span>
* <span lang="EN-US">Resolved the gridlines issue which was incorrectly shown when importing in an excel file.</span>
* <span lang="EN-US">Users can now refer to another sheet’s cell when isPrintLineVisible is set true.</span>
* <span lang="EN-US">Users can now use del key to delete a formula.</span>
* <span lang="EN-US">Users can now export SpreadJS charts that are consistent with the schema.</span>
* <span lang="EN-US">Resolved the TableSheet formatting issue which was cleared when the DataManager was updated and a new URL throws an API error.</span>
* <span lang="EN-US">Resolved the chart name issue that changed after Excel import/export</span>
* <span lang="EN-US">Resolved the parameter description issue of the SpreadJS function OR.</span>
* <span lang="EN-US">Resolved the issue of cell’s actual font size that changed after SpreadJS import export.</span>
* <span lang="EN-US">Resolved the scatter XY Chart issue in Excel file which imported incorrectly in SpreadJS.</span>
* <span lang="EN-US">Users can now set the hyperlink for PivotTable cells.</span>
* <span lang="EN-US">Users can now open a specific Excel file exported from the SpreadJS Designer.</span>
* <span lang="EN-US">Resolved lost and undefined form control properties in the JSON schema.</span>
* <span lang="EN-US">Resolved the comment author property issue when SpreadJS opens and saves an xlsx file.</span>
* <span lang="EN-US">Resolved the MS Excel problem when the Excel file is exported from SpreadJS.</span>
* <span lang="EN-US">Resolved the result issue of MIN/MAX formula providing a different result compared to Excel.</span>
* <span lang="EN-US">Resolved the image loss issue while hiding rows when PrintLineVisible option is set to true.</span>
* <span lang="EN-US">Resolved the sheet binding issue that was impacting the values of merged cells.</span>