spread code creation editing - SpreadJS

Release Notes: was incorrect. A custom formula would not show in edit mode. The workbook would not display correctly after switching sheets. The context menu would not work correctly after 14.2.0. The “Margun Gothic” font ... was different from Microsoft Excel. Specifically selected content could not be deleted when in edit mode. Scrollbars would appear in the ribbon after setting the v-show property. Some conditional formats would ... other cells outside of a cell’s edit box would throw an error. The cell state manager had undo/redo issues. There was an incorrect label in the “Replace” dialog in the CN version. The status of sheet tabs ...

Release Notes: not be edited after importing a sheet. DataLabels were not visible in specific frameworks. Deleting a row would cause xlookup to return a #VALUE error. A specific formula result was different from Excel. An error ... and context Menu Clear Content did not do the same thing. Specific custom formatting would show an error in the console. Demo: An error code was thrown in a specific Vue sample. Drop down list items would ...

Release Notes: New data presentation component helps you quickly create modern data layouts. 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 ...

Release Notes: Calculation Fix The ISREF and INDIRECT functions would have different formula results. A specific formula was incorrect. The formula editor would show as undefined for the listSeparator when the culture was changed. A custom function would not show in a sheet. Chart Fix The order of charts in a ...

Release Notes: not be selected in an editable comboBox cell. Exporting PivotTables when counting multiple column value caused a formatting error. Copying content from an external source into SpreadJS removed line breaks. Certain ...

Release Notes: circumstances. Printing Fix: The cutting action would incorrectly change the printing area. Tables in a Data Source Sheet would not update correctly if added by code. Table Column Data Formulas did not work ...

Release Notes: the formatter will become invalid after exporting Excel. Function ISFORMULA is now working correctly with the column formula. Resolved the issue where all significant digits are not displayed in the editing ...

Release Notes: and slider dropdown, respectively. Added support for using customized themes and font styles over the worksheet to change its appearance. Added a new Formula Editor Panel that makes it easy to create, edit ... analysis in a TableSheet. Individual modules are now available on NPM. Added support for setting read-only custom names that cannot be edited or deleted from the Name Manager Dialog in SpreadJS Designer. ... as in Excel. Added support for copying Excel styles and data of cells from Spread to Excel properly. An evaluation sheet is now available while exporting to Excel with no license or trial license. The GC prefix ...

Release Notes: to the Data Manager Table Views- You can now utilize a View from a DataManager as the data source for a table in a worksheet. Data Source Spread Transformation- In some cases, the data in the DataManager could ... simply specify "spread: true" to ensure that the first-level children of an object are spread out into separate fields. Spreadsheet Filters- TableSheets now allows you to filter multiple columns ... in SpreadJS, you can select a sheet tab at the bottom of the workbook to include a reference to it in the formula and stay in edit mode. However, there may be too many sheets to display at one time, ...

Release Notes: been added so the developer can cancel the edit if needed. 0 ...

Release Notes: be edited, only Pivot ranges, just like Excel. With this release, end-users are now able to edit PivotTable cell values and then update and reload the data source of a PivotTable to reflect the changes. ...

Description: Excel-like experience. Code-Free Extensibility and Customization with the SpreadJS Designer- Quickly design a complex spreadsheet layout using a familiar UI with the desktop designer app- no learning curve ...

Release Notes: adding a column. When using backspace to enter cell editing, the behavior of arrow keys was different from Excel. Getting the SpreadSettingDialogTemplate would be undefined. Some PivotTables would not sort ...

Release Notes: could not be edited properly in FireFox. Adding a style from a dialog would make the selection change. ButtonClicked event could not be triggered after a button was clicked. Edit mode couldn’t be stopped ...

Release Notes: in shapes and change the offset and scaling to show patterns of images. Text Edit- Double-clicking in a shape now allows the user to edit the text within the shape. Format the text with a simple behavior, ... in the workbook are displayed. By default, they are displayed at the bottom of the Spread instance, but can now move to the top to better fit your application's design. Restrict Pasting to Invisible ...

Release Notes: options were not applied correctly. Designer: Applying font styles would cause the SpreadJS instance to become unresponsive. Designer: Setting sheet protection properties with code wouldn’t work. Designer: ...

Release Notes: Improves Excel importing and exporting. Clipboard data can now be cleared when starting cell edit or using the Esc key. Line length of borders was inconsistent after importing a Microsoft Excel ... to Excel. Scrolling and editing was slow after importing an SSJSON. SetCollapsed() would not work with the index from outline.group(index). ChartArea would expand when a trendline was added to a chart ... text when the cell entered edit mode. "Check All” in the filter dialog would not work after checking one option in the filter. Setting CALC_PRECISION would still result in a lack of precision. ...

Release Notes: Improves Spreadsheet Designer and CSV import/export. CMD+Z did not work in edit mode on Apple macOS. Print preview and results were inconsistent in some cases. Connector shapes not correctly added ...

Release Notes: an error. Calling clearSelection after setting sheet protection caused the page to hang. Editing cells would trigger unexpected commands. iPad behavior was different from PC when double-clicking ...

Release Notes: for date formatted cells on subsequent edits. Data labels are correctly imported in Clustered Column and XY (Scattered) charts. JSZip library is upgraded to 3.3.0. Word-wrap of rich text is supported while ... to null. The Median formula returns correct value if first cell in the range is cleared by using delete key. Spread Web designer shows new icons for Menu bar. Range of filter is updated correctly when copied ...