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 and beforeLoad;

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 and insertColumn 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, and REGEXMATCH functions;
  • Improved ISERR and ISERROR 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 during virtualization.
  • Re-rendered readonly attributes for cells when the readonly attribute is changed at the column 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 using namespaces;
  • 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