Jspreadsheet Change Log
06/11/2024
jspreadsheet
11.11.2
- Types review;
- Added support for string[] as the first argument in setStyle.
03/11/2024
jspreadsheet
11.11.1
- Types review;
@jspreadsheet/sheets
3.1.0
- Removed the secret key from the authentication flow;
02/11/2024
@jspreadsheet/client
- Added compression support;
@jspreadsheet/server
- Added compression support;
- Introduced
before
events for authentication and request transformations; - The auth property has been dropped; please use
beforeConnect
andbeforeLoad
;
31/10/2024
@jspreadsheet/print
- LemonadeJS studio integration;
29/10/2024
jspreadsheet
11.11.0
- Fixed positioning issues for media in frozen columns and rows;
- Enabled passing a calendar format option to the calendar widget;
- Added sorting for range filters;
- Introduced a preCalculation option to enable immediate calculations or defer them to on-demand (scroll) calculations;
- Added caching to the method for retrieving worksheets by name;
- minDimensions now adjusts automatically to match the table's row and column count;
23/10/2024
jspreadsheet
11.10.4
- Improved
getTokensFromRange
to account for both column and row ranges; - Enhanced token renaming to discard #REF! during range transformations;
- Fixed getValidation(0) to correctly return the first validation;
- Fixed validation range updates when adding or removing rows or columns within the validation range;
21/10/2024
jspreadsheet
11.10.3
- Improved handling of a few minor GC;
- Fixed the HTML data grid editor type to properly manage undefined data values;
@jspreadsheet/render
5.6.0
- Export groups of rows and columns.
- Export cells with the checkbox type.
- Fix the export of cells with boolean values to ensure they are correctly imported by the parser.
- Export links defined in columns.
- Fix the export of links containing XML reserved characters.
- Restrict the number of rows, columns, and characters in worksheet names to prevent issues during export. This restriction uses a new event called onerror.
- Fix the export of links.
20/10/2024
@jspreadsheet/parser
5.6.0
- Import groups of rows and columns;
- Import cells with the checkbox type;
- Adjust shape rotation import from radians to degrees to work correctly in Jspreadsheet;
- Handle possible errors when importing certain spreadsheet properties;
jspreadsheet
11.10.2
- Applied merge performance optimization for large spreadsheets;
- Validated if the cell anchor for media corresponds to an existing cell;
- Fixed media history undo for charts;
- Prevented media from being deleted or edited in non-editable data grids;
- Removed the external updateFormula worksheet method;
- Updated chart config when changes in the data grid affect the chat data range;
18/10/2024
@jspreadsheet/charts
6.5.1
- Automatically review the chart data range when changes are made in the spreadsheet;
17/10/2024
@jspreadsheet/charts
6.5.0
- Set the current data grid selection as default range when adding charts via context menu.
- Disabled chart width and height ratio to prevent flickering on reload.
- Jspreadsheet now handles reference updates.
- Prevented errors when undefined is included in the data provided to the chart.
jspreadsheet
11.10.1
- Fixed issue with renaming worksheets.
16/10/2024
jspreadsheet
11.10.0
- Optimized calculations and chain creation;
- Fixed scrolling to prevent recalculations during cell creation;
- Added new internal references for filter DOM elements;
11.9.7
- Forced updates during
insertRow
andinsertColumn
on read-only cells; - Made image uploads read-only on spreadsheets with
editable: false
;
@jspreadsheet/parser
5.5.5
- Fix getTheme for correct color handling.
09/10/2024
jspreadsheet
11.9.6
- Fixed defaultColAlign to respect specific column definitions;
- Extended caching for all formulas during initialization;
- Added a new argument to
getConfig
to apply settings at the spreadsheet level; - Moved persistence calls to the end of operations;
- New event:
onchangeconfig
05/10/2024
jspreadsheet
11.9.4
- Updated cell anchors during media updates;
- Ensured cell anchors are properly defined when inserting new media;
- Improved spreadsheet progress bar functionality;
@jspreadsheet/render
5.5.3
- Fixed chart title issue during export;
03/10/2024
@jspreadsheet/render
5.5.1
- Fixed background color handling for shapes during export;
02/10/2024
jspreadsheet
11.9.3
- Fixed cancel prompt when renaming a column to preserve the original value;
- Fixed translation issue for calendar strings;
30/09/2024
jspreadsheet
11.9.2
- Automatic scrolling when using the fill handler.
27/09/2024
@jspreadsheet/formula-pro
5.4.3
- Cleaned up formula names that are not present in Excel or Google Sheets;
- Updated
REGEXEXTRACT
,REGEXREPLACE
, andREGEXMATCH
functions; - Improved
ISERR
andISERROR
to catch errors caused by incorrect function names; - The adjust precision feature has been improved;
jspreadsheet
11.9.1
- Applied DOM properties using
setProperty
only on existing columns duringvirtualization
. - Re-rendered
readonly
attributes for cells when thereadonly
attribute is changed at thecolumn level
. - Updated
formulas
during multi-selection paste. - Enhanced data object identification during loading to account for
null
values. - Update getWorksheetName to block the search for blank worksheet names;
25/09/2024
jspreadsheet
11.9.0
- Fixed loading of initial
validations
when usingnamespaces
; - Ensured the
dropdown editor
remains open when navigating via keyboard; - Updated filter icon dimensions and set filters: false when filters are hidden;
- Updated CSS for line-height: normal and frozen rows control;
- Fixed execution and shifting of formulas when the formula name is similar to a cell name;
24/09/2024
@jspreadsheet/charts
6.3.1
- Updated canvas DOM solely to prevent losing resize controls during real-time updates.
@jspreadsheet/search
5.0.0
- Added
keyboard navigation
; - Enabled closing search using the keyboard;
jspreadsheet
11.8.1
- Patched issue with deleting columns when array entries contain empty data;
11.8.0
- Fixed rowDrag settings to properly block row dragging;
- Fixed issue with CTRL- to remove columns and rows;
- Fixed mousedown behavior with CTRL on Mac;
- Standardized persistence calls at the end of methods;
- Added column filter property support for individual columns;
- Introduced autoNames option to automatically detect column names from the data object when not explicitly declared. Default: true;
- Added jss_object class to ignore keyboard and paste events for all child elements;
- Fixed issue with deleting a column not updating the data correctly;
- Standard edition now updates formula references, but does not update validations or defined names;
- Improved ordering of persistence dispatch methods;
16/09/2024
jspreadsheet
11.7.2
- Consider initial column filters even when the filters property is disabled;
- Fixed initial loading and scroll calculation when both filters and frozen rows are enabled;
14/09/2024
jspreadsheet
11.7.1
- Fix the Backspace shortcut issue for Mac;
- Improved behaviour when moving the browser window, ensuring focus returns to the selected spreadsheet;
- Enabled media movement to negative positions when no viewport is defined;
11/09/2024
jspreadsheet
11.7.0
- Added
options.url
for generating links in the text editor type; - Improved the masking system to better handle large numbers and scientific notation;
10/09/2024
jspreadsheet
11.6.2
- Positioning media elements using cell anchor reference fix;
09/09/2024
jspreadsheet
11.6.1
- Fixed mouseup behavior for the dropdown new item prompt;
@jspreadsheet/search
4.1.0
- Improved keyboard controls for enhanced navigation and usability;
07/09/2024
@jspreadsheet/parser
5.5.4
- Fixed the import of dropdown content;
- Fixed the import of charts with transparent colors;
- Standardized the import of transparent chart colors as "transparent" (previously could also be "none");
- Fixed the import of shapes generated with the "render" extension;
- Enabled the import of list validations with cross-worksheet references;
- Fixed the import of theme files when the filename differs from the default;
- Corrected the import of minDimensions, ensuring proper handling of merged cell sizes;
@jspreadsheet/render
5.5.0
- Fixed dropdown content export by removing reserved XML characters;
- Enabled the export of dropdowns;
- Fixed an issue with exporting definedNames that was introduced during the dropdown export implementation;
- Corrected the export of charts with transparent colors;
- Fixed the export of shapes with transparent colors;
- Corrected the export of list validations with cross-worksheet references;
- Fixed the export of dropdown values;
- Fixed the export of list validations without a dropdown menu;
- Exported data grid cell-embedded images as cell-bound images rather than floating images;
jspreadsheet
11.6.0
- Introduced a new (cell range filter)[/docs/filters];
- Updated filter properties and methods for enhanced functionality;
11.5.6
- Improved positioning of media elements during onload and resize;
- Introduced a new cellAnchor property for media elements;
- Added a new getMedia method for worksheets;
- Updated dynamicSource to accept definedNames;
05/09/2024
jspreadsheet
11.5.5
- Improved setValue in batch operations to ensure formulas are re-calculated within the topology chain.
- Enhanced getDataFromRange to accept worksheet names;
- Fixed the
dynamicSource
property use for dropdowns;
31/08/2024
jspreadsheet
11.5.4
- Fixed the toolbar font-family dropdown to correctly select fonts, even when the font name includes white spaces;
- Fixed data grid filter position;
- Enhanced setProperties to accept a new type as a custom editor object;
31/08/2024
jspreadsheet
11.5.3
- New rows now default to an empty array upon insertion;
11.5.2
- Prevent console errors when using the Tab and Enter keys with no active selection;
- Added a select-all option for nested headers;
24/08/2024
jspreadsheet
11.5.1
- Prevent default keydown behavior on read-only cells.
11.5.0
- Fixed data grid filter position when using nestedHeaders with frozenColumn;
- Included the onclick event for data grid dispatch;
- Aligned the Backspace shortcut behavior with Excel and Google Sheets;
- Introduced a new method, worksheetInstance.getStyleIndexes(cell?: string), to retrieve style indexes;
- oncopy now accepts an overwrite value;
- Added the force property for value setting during batch execution;
Note: Starting from version 11.5.0, worksheet.options, worksheet.getConfig(), and spreadsheet.getConfig() will return style indexes to enhance performance during persistence.
@jspreadsheet/search
4.0.3
- Automatically focus on the search input when opening the modal.
20/08/2024
jspreadsheet
11.4.12
- setFilter forces an array of strings to lowercase;
- Applying a filter on load forces the array of strings to lowercase;
- Consider null as blank during filtering;
- Fix data grid filter position when using nestedHeaders with frozenColumn;
@jspreadsheet/parser
5.5.2
- Fix the import of files generated with the render extension in the parser extension, setting a default theme.
- Fix the import of conditional formatting with "text" and "equal to" criteria in the parser extension.
17/08/2024
@jspreadsheet/render
5.4.4
- Export hidden worksheets;
- Fix exporting of the ">" character in cell contents;
- Fix exporting of transparent borders in pie charts;
- Export line breaks;
- Fix exporting of unlocked merges in the render extension;
- Fix grid line export in the render extension;
@jspreadsheet/parser
5.5.1
- Import the default column width in the parser extension.
- Data grid media positions fix;
14/08/2024
@jspreadsheet/bar
5.0.7
- Block the data grid edition in case the cell is not in edition mode
Jspreadsheet
11.4.11
- oneditionstart can return false to block the edition;
@jspreadsheet/render
5.4.3
- Export merge properties to locked cells;
06/08/2024
@jspreadsheet/charts
6.3.0
- Compatibility with CSP safe inline
- Background and color updates
@jspreadsheet/render
5.4.2
- Charts background and color updates
05/08/2024
Jspreadsheet
11.4.10
- When filters: false but filters are enabled on the column level + sorting fix;
02/08/2024
Jspreadsheet
11.4.9
- Case-sensitive filters
- added ctrl+shift.* shortcuts
- added @types locked:boolean for the Cells interface
29/7/2024
@jspreadsheet/parser
5.5.0
- Fix the import of the default font size for axis labels and chart legends.
- Fix the import of omitted colors in pie charts.
- Fix the import of notes.
- Fix an error in the import of the "bold" style in shared strings.
26/7/2024
Jspreadsheet
11.4.7
- Accept numbers as worksheet names;
11.4.6
- Update on the toolbar undo & redo button state;
- setWidth & setHeight will work with editable: false to improve the user experience;
- Filter false on checkbox column types fix;
Bar
5.0.6
- suggestions: false to prevent download the formulas' documentation;