Dear All
v3.4.0 has been launched with new cool features and few bug fixes as mentioned in the Change log.
1. autofill and fillHandle: Instead of entering data manually, fillHandle and autofill feature (which functions similar to autofill in Excel ) can be used to fill cells with data from other cells that follows a pattern or series.
Example:
https://paramquery.com/pro/demos/autofill2. summaryInTitleRow: new option to customize display of summary data in title rows. This feature can be exploited to hide the group by columns.
3. grouping without sorting. In previous versions data was first sorted before applying grouping. Now grouping can be done with or without sorting. The cells within the range grouping can also be sorted.
4. Convenient Range value() method to set and get value of all cells in the range as 2 dimensional arrays.
Best Regards
The ParamQuery Team
