Dear members
Thanks for your continued support and feedback, without which pqgrid wouldn't have been possible.
We have added lot of useful features in paramquery tool till date, yet there is more to be done keeping in view the fast evolution of javascript ecosystem and ever increasing number of js frameworks.
Here is our revised roadmap for immediate upcoming releases.
pqGridImport / embed images in cells and exportable to spreadsheet, pdf and html. ( in progress )
Enhancement of autofit layout. ( in progress )
Compact scrollbar mode to display scrollbars only in unfrozen ( rows and columns ) region. (in progress )
Add SidePanel with retractable toolpanels for columns, filters and conditional formatting. ( partially complete, currently on hold )
Add UI and API for spreadsheet compatible conditional formatting. ( in progress )
Improve accessibility and keyboard navigation. ( in progress )
Add integrated support for interactive charts ( in progress )
- Line charts, Stacked line charts, 100% stacked line charts.
- column / bar charts, stacked & 100% stacked charts
- Area charts, stacked & 100% stacked area charts
- combo charts, combination of line, area, bar, column charts.
- pie & doughnut charts,
- Radar chart
- scatter charts with trendlines
- Bubble charts
- Box and whisker chart
- Histogram
- Pareto chart
- Stock chart
- Treemap chart
- Sunburst chart
- Make them importable from Excel and exportable to Excel, image, svg and pdf.
Make inline editor prettier like Google sheets. ( Part complete and released )
Conditional drag & drop of columns, make the grid scroll while drag of columns
Import / Export of dropdown lists to / from Excel
Exploit inbuilt collapsible grouped rows interface of Excel
Add ability to enforce dataType of cell values while export to Excel
Cascading checkboxes in non grouping column in treegrid.
Highlight text support ( search instead of filtering ) with filter rules.
And the features listed in "Suggest new features" board. If you feel pressing need for a new feature in pqgrid, please don't hesitate to post it in "Suggest new features" board, we would do our best to provide that feature.
Complete and released features:pqSelect1. Add virtual rendering
2. Select All checkbox should select only the filtered options
pqGrid1. Animations while sorting, filtering, expand/collapse rows/ groups, autoRow height, collapse column groups, show hide columns/ rows, flex columns
2. pqgrid interface for Angular 2+, React js and Vuejs
3. Drag drop rows ( sortable in same grid ), in between different grids, in between grid and external components or plain divs. Support for plain grid, treegrid and grid with grouped rows
4. smooth scrolling ( with virtual rendering ) and native swipe support in touch devices
5. Pivot tables with running column totals
6. Context menu in Header bar and body of grid to easy access the functionality of merge cells, add/remove new rows/columns, cell formatting, styles and filtering. ( complete for filter and show hide columns )
7. RTL support.
8. Range based row selections from number cells.
9. Separate mode of spreadsheet like filtering: hide filtered out rows instead of taking them out of dataModel.data ( complete and released, but need to extend support for cascade filtering )
10. While Import/ Export and editing of spreadsheets: extend support to more styles
a) borders
b) comments
c) embed images / pictures
11. Add API and UI via buttons, dropdowns in toolbar to easily manipulate the spreadsheet styles based on selected range of cells.
12. Save and load state of open / closed nodes in grouping rows.
13. Save and load state of open / closed nodes in treegrid.
14. Import csv file. (v7.4.0)
15. Make rows height resizable similar to Excel. (v7.4.0)
16. a) Add tabbed interface to display multiple worksheets within a single grid. (v8.1.0)
b) Add support for cross reference formulas in multiple worksheets . (v8.1.0)
17. Add configurable ability to skip hidden columns while copy / paste. (v8.0.1)
18. Import/ Export of HYPERLINK formula and links to / from Excel ( v9.0.0 )
19. Extend support of column.copy property to grouped columns ( v9.0.0 )
20. Export to pdf ( v9.0.0 )
21. Hierarchy lines ( v9.1.0 )
22. Replace existing numbers and jQueryUI date formatting with Excel like numbers, currency, scientific, datetime and locale sensitive formatting (v10.1.0)
23. Save order of grouped columns. (v10.1.0)
On hold features:1. Google Material design: Most of the specifications are already in place.
2. Support for jsZip > 2.5.0. On hold because it would cause breaking changes.
Best Regards
The ParamQuery Team
