# Release Notes for Version 15.2.0 ## Content ## Enhancements from the Previous Release The following features and enhancements have been incorporated into this version of the product: * SpreadJS now implements a picture as a shape instead of a floating object. * SpreadJS supports [picture geometry type, transparency, contrast, brightness, and cropping](/spreadjs/docs/v18/features/UnderstandingShapes/picture-shape). * SpreadJS supports [recoloring in pictures](/spreadjs/docs/v18/features/UnderstandingShapes/picture-shape). * [SpreadJS Designer](/spreadjs/docs/v18/spreadjs-designer-component/designerinterface/spdesigntab) is enhanced with the picture format tab. * SpreadJS supports the [InvalidOperation event ](/spreadjs/api/v18/classes/GC.Spread.Sheets.Events#invalidoperation)for more actions when the sheet is protected. * SpreadJS supports [navigation in selection](/spreadjs/docs/v18/features/keyboard-actions/selection-navigation) using tab/shift+tab key and enter/shift+enter key. * SpreadJS supports the [name box component](/spreadjs/docs/v18/spreadjs-designer-component/spdesignerwork/name-box). * SpreadJS’s cell types are enhanced to support [DataObjects](/spreadjs/docs/v18/features/cells/celltypes/dataobject-cell) in a worksheet cell. * TableSheet now supports the API to get the current changing info using [getchanges method](/spreadjs/docs/v18/features/tablesheet/data-operations). * Table slicers support the [multiselect option](/spreadjs/docs/v18/features/tablegen/slicer). * TableSheet now supports combobox and multicolumn lists to enhance [lookup column presentation](/spreadjs/docs/v18/features/tablesheet/tablesheet-relationships/look). * Added [dynamic reference flag](/spreadjs/docs/v18/formulareference/formulaoverview/cellreferences) to enhance the performance of calculations and lower memory usage. * Pivot table is enhanced to support [EnableDataValueEditing](/spreadjs/docs/v18/features/pivot-table/refresh-data-source) option that enables editing values in the pivot table at runtime. * Users can get the source and target of [cross workbook formula](/spreadjs/api/v18/classes/GC.Spread.Sheets.Workbook#getexternalreferences). * Users can now apply variable [styles to different ranges](/spreadjs/docs/v18/features/cells/cell-states/row-col-states) within the hover cell state. * Users can load the tablesheet template without data by [changing the data source dynamically](/spreadjs/docs/v18/features/tablesheet/data-operations/change-datasource-dya). * Users can use the [new Excel array manipulation functions](/spreadjs/docs/v18/formulareference/FormulaFunctions). * Users can use new Excel [text manipulation functions](/spreadjs/docs/v18/formulareference/FormulaFunctions/text-functions). * Users can update the datasource of the Tablesheet without [refreshing the page using the fetch method](/spreadjs/docs/v18/features/tablesheet/data-operations/change-datasource-dya). * Users can display the [customized column value](/spreadjs/docs/v18/features/tablesheet/tablesheet-views) using the formatter formula. * SpreadJS now supports React 18. * SpreadJS now supports Angular 14. ## Resolved Issues The following issues have been resolved since the last release: * SpreadJS Designer has resolved the Find/Replace Dialog to show Cell References. * Pivot table operations are updated to handle its inconsistent nature with Excel. * SpreadJS Designer is updated to import ssjson file. * SpreadJS is updated to import xlsx file. * SpreadJS Designer has resolved an issue by adding the ListValidator. * SpreadJS has resolved workbook’s #VALUE! Errors to enhance its performance. * SpreadJS has resolved the missing text issue while importing the workbook. * SpreadJS has resolved the auto-select issue while using the editable combo box cell. * SpreadJS now allows the drag and fill the table. * Users can now change filters while inserting a new row to the table. * SpreadJS has updated FormulaTextBox's bind method to give information regarding their parameters and use cases. * SpreadJS has resolved the inconsistency in a cell’s word wrap. * SpreadJS is updated to export Excel files that can be successfully exported in Excel 2013 and 2007. * SpreadJS has resolved issues to operate charts consistently. * Slicers in SpreadJS are updated to export with special characters. * SpreadJS Designer is fixed to show print previews efficiently. * SpreadJS has resolved issues to import table slicers. * Users can now replace the values in filtered rows. * Users can now access the used range with the help of getUsedRange. * SpreadJS is updated to set data labels for the selected series. * Users can now create the pivot table using all the sheet data. * While performing Excel IO, the user can now skip an additional '@' symbol that was added to the formula. * Display position of toolbar’s submenu is revised now. * SpreadJS has resolved pasting from the clipboard issue by setting the tag or style which clears the clipboard cache. * Users can now access the value field settings dialog. * Users can now easily access the hyperlinks after performing import export. * SpreadJS has improved the performance for copying large columns on Mac. * Users can now keep the scroll bar still after dragging the field when there are many field lists. Also, it will retain the location of scrollbar. * SpreadJS has resolved issues of showing #VALUE while importing Excel file. * SpreadJS will allow the user to retain the formatting while importing. * The page crash issue of the setColumnVisible method has been resolved. * Charts in SpreadJS will now retain the correct data source even after setting the ignorehidden property to false. ## Breaking Changes from the Previous Release This version of the product has the following changes: * Slicers are now enhanced to use the sheet and shapes base instead of the DOM base. A new plugin `gc.spread.sheets.slicers.js` must be added when using table slicer, table slicer data, item slicer, and pivot slicer. As slicer is a shape-based feature, the `gc.spread.sheets.shapes.js` plugin is added as a dependency while using the table, item, and pivot slicers prior to referring to the slicer plugin.