Dear All
Thanks for your support and feedback, we are glad to announce yet another version and with this version we have moved significantly closer to a powerful web based spreadsheet by introducing the following features:
1. Merged cells. We can now have merged cells that can span over hundred of thousand of rows and columns similar to our support for unlimited rows and columns.
2. Range object for collective manipulation of cells. It makes the manipulation of cells so much easier for example the content of 1st column from left can be cut and paste onto the 3rd column from left in a single line of code.
grid.range( { c1: 0 } ).cut( { dest: { c1: 2 } );
3. Cut the selected cells/rows/columns and use the data for paste later on. It can be done with click of a button or use of Ctrl / Command X.
4. Delete the selections with delete key.
5. Column based selections. We already have row and cell based selections , in this version we have also added column based selections.
And we have the following updates as for the grid features:
1. Checkbox columns have been revamped in this version to support their use in transactional editing, support validations, display disabled checkboxes and to support overriding their default rendering with column.render and header cell rendering. As a tradeoff, we had to drop support for IE8 for this feature as this old browser has many inconsistencies for checkbox.
2. New lightweight events which can be directly bound to grid instance. Its API is similar to the jQuery based events e.g., it has methods on, one and off to bind callbacks with events.
3. Export of rendered cells. It's quite helpful when we want to format the exported cells.
4. Asynchronous post rendering.
5. Improvement in conditional styles whereby class, style and HTML attributes can be injected into a row or cell based upon any run time condition in rowInit and column.render respectively.
Note: There are breaking changes in this version, so please refer to the upgrade guide when you migrate to this version from an older one.
As always we welcome valuable feedback from the members and please suggest us the features you would like in your upcoming projects.
Best Regards
The ParamQuery Team