Upgrade to version 10

Overview

We tried to keep the best possible compatibility until legacy affected the performance. In those cases, we implemented fundamental changes described in the document below. With that in mind you will get one of the best tools in the market. We have optimized all areas of Jspreadsheet, increasing our test coverage and performance.

What is new?

The highlights for version 10 are:

• Formula engine based on mapping;
• Formula Pro integrated with formulajs;
• Formula Pro supports @ operator and can use column names calculations;
• Copy formulas cross worksheets;
• Copy and paste, handler fill includes cell format and style;
• Spreadsheet History to the global level with cascade options;
• New spreadsheet-level style;
• We drop support to Jquery syntax; Polyfill is available.
• Column grouping;
• Worksheet floating images.

Upgrades

Before you considering upgrade, please be aware that fundamental changes listed below and the impacts that might need on your code.

General changes

Settings

Events

Methods

Style

In order to improve the performance, version 10 brings significant changes to the style management in cells as described in the table below..

Rows

Updates on the signature of events and methods to make possible manage non-consecutive cells.

Columns

There where several changes and improvements in the columns managements, for example.

• Insert and delete non-consecutive columns
• Group a collection of columns
• render() to transform the value before show to the user.

Formulas

History

The history feature, which includes undo and redo actions, has been moved from the spreadsheet level to the screen level in the latest version of Jspreadsheet. The main reason for this change is to allow JSS to manage the history of different spreadsheets on the screen that may have relationships with each other, such as cross-formula calculations.

Jquery Polyfill

If you wish to continue using jQuery with Jspreadsheet version 10, please follow the guide below. We have provided a sample code block for your convenience.

// Jquery Support
if (typeof(jQuery) !== 'undefined') {
    (function($){
        $.fn.jspreadsheet = $.fn.jexcel = function(mixed) {
            let container = $(this).get(0);
            if (! container.jspreadsheet) {
                return J($(this).get(0), arguments[0]);
            } else {
                if (typeof(arguments[0]) == 'number') {
                    let n = arguments[0];
                    let i = 2;
                } else {
                    let n = 0;
                    let i = 1;
                }
                return container.jspreadsheet[n][mixed].apply(
                    container.jspreadsheet[n],
                    Array.prototype.slice.call(arguments, i)
                );
            }
        };
    })(jQuery);
}