Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Topics - paramvir

Pages: [1] 2 3 ... 19
Help for ParamQuery Pro / MOVED: Reorder columns
« on: June 02, 2023, 04:50:37 pm »

News / Upgrade to Pro Version 9.0.0
« on: May 31, 2023, 07:43:51 pm »
Dear All

We are delighted to announce the release of the highly anticipated version v9.0.0, packed with remarkable enhancements to elevate your experience. Here are the key features and improvements:

PDF Export: Introducing a brand-new feature that allows seamless export to PDF using the powerful pdfMake library. Now you can effortlessly generate professional-looking PDF documents directly from your application.

Example of pdf export:

Example of pdf export for non English languages:

Enhanced Export Functionality: We have completely revamped the export functionality based on valuable user feedback. You'll now enjoy a more streamlined and efficient export process for all formats, including xlsx, html, csv, and pdf. The following improvements have been implemented:

a) Introducing a new intermediate JavaScript object for exporting to CSV, HTML, and PDF. This object functions similarly to the JavaScript workbook for spreadsheets, enabling you to export multiple grids, nested grids, or grids with detail rows effortlessly.

b) We have introduced a new column property called "skipExport," which allows you to exclude specific columns from the export process. Unlike earlier versions, this property also supports grouped columns, providing you with more flexibility and control. The "skipExport" property replaces the previous "copy: false" property for export purposes.

c) You now have the ability to exclude hidden columns, rows, and sheets entirely from the exported data. Simply utilize the new parameters "skipHiddenRows," "skipHiddenCols," and "skipHiddenSheets" when invoking the exportData method.

d) Selectively export only the desired sheets out of a workbook.

e) Selectively export only the desired rows, columns, or cells using the new "selection" parameter. This feature grants you greater precision in exporting data.

f) We have introduced additional callback parameters such as "eachCell", "eachCellHead", "eachRow", "eachRowHead", and "eachCol", which provide granular control over the export process. These callbacks enable you to update cell, row, column properties, styles and values dynamically during the data export.

g) Enjoy exporting static and conditional styles to HTML and PDF formats, ensuring that the visual presentation of your data is preserved accurately.

Bootstrap Icons Integration: We now offer seamless integration of Bootstrap icons, allowing you to replace jQueryUI icons effortlessly. Simply include the pq-icons/pq.css file, and there is no need for any other changes. This enhancement ensures a more modern and cohesive look for your application.

Hyperlink Support: We are excited to introduce support for hyperlinks, both through the user interface and the HYPERLINK formula. You can now import hyperlinks from spreadsheets into the ParamQuery grid and vice versa, enabling seamless navigation within your application.

Grouped Columns: In response to user feedback, we have introduced a new mode for displaying children columns in the bottom-most row of the header. This approach eliminates the rowspan merge, providing a more natural and visually appealing appearance. Additionally, this enhancement allows for convenient filtering of the header row in exported spreadsheets, improving usability.

Additional Configuration Options: We have added a third tab to the Header menu UI, offering enhanced configuration options. You can now easily configure the "skipExport" option for individual columns, granting you finer control over the export process.

Improved File Downloading: We have replaced the saveAs library with a new built-in method, pq.saveAs(). This update significantly enhances the file downloading functionality, ensuring a smoother and more reliable experience.

New Controls: Introducing two new controls to enrich your application. The pqColorPicker enables users to select colors seamlessly, while the pqBorder picker facilitates the selection of border style, thickness, and color. These controls enhance the visual customization capabilities of your application.

Enhancement of pqSelect Library: The pqSelect library has undergone significant improvements. It can now be initialized from a div element, providing more flexibility in integrating the library into your application. Additionally, options can be directly passed via the data parameter, simplifying the setup process.

Range Object API Enhancement:
We've enriched the Range object API with convenient methods for effortless data and style manipulation. The following new methods have been added:

Insert Rows: Easily add new rows above or below a specific range using a single method call.

Insert Columns: Insert new columns to the left or right of a specified range with simplicity.

Hide and Show Rows and Columns: Toggle the visibility of rows and columns within a range using a single method, making it straightforward to control their display.

Borders: Apply borders to a range of cells in a single method call, allowing for customization of various border styles.

Frozen panes: New Freeze Panes and Unfreeze Panes API.

Improved Context Menu:
Our context menu feature has been enhanced with greater flexibility:

Display with any Event: Trigger the context menu with any event, such as right-click, button click or double click, according to your preferences.

Show on Any Control: Associate the context menu with various controls beyond the grid itself, expanding its usage to buttons, input fields, and more.

To see an example demonstrating these enhancements, visit: Example Link:

These improvements offer more control and customization options for your context menus.

Lazy loading of scripts: On demand lazy loading of JavaScript files, using pq.getScripts method for fast initial loading of page and saving network bandwidth. This is useful for example when you are not sure if user is going to use export PDF functionality, so pdfmake js files can be loaded only when user clicks export to PDF.

PS: We highly recommend consulting the upgrade guide when transitioning from earlier versions to ensure a smooth upgrade process and leverage the full potential of the new features.

Thank you for your continued support, and we look forward to providing you with an exceptional user experience with version v9.0.0 of our software.

Best Regards
The ParamQuery Team

News / Upgrade to jquery-ui-pack v1.13.2
« on: January 13, 2023, 02:17:46 pm »
Dear npm users

FYI, jquery-ui-pack is jQueryUI published on npm in commonjs format for ease of use in Angular, React and Vue projects.

All credit to jqueryUI team for release of v1.13.2 of jQueryUI few months ago, jquery-ui-pack v1.13.2 has also been released based on the latest version of jQueryUI.

Best Regards
The ParamQuery Team

News / Upgrade to Pro Version 8.7.0
« on: January 04, 2023, 04:59:54 pm »
Dear All

We are glad to announce release of the new version v8.7.0 with bug fixes and following enhancements:

1) The header cells can be focused and navigated with keyboard similar to body cells.

Default actions are taken with specific keys in header cells which is documented in beforeHeadKeyDown event here.

Supporting API updates:
option: column.clsFilter
Methods: focusHead, addClassHead, removeClassHead
Events: beforeHeadKeyDown, focus, focusHead, blur, blurHead

2) Lazy loading: This version extends support for all dataModel sub-properties which were applicable to remote loading until now for lazy loading too like beforeSend, contentType, dataType, error, getData, method, postData, postDataOnce, etc.

3) Hierarchy/row details: UI supports icon in header cell to toggle the state between collapse all / expand all of all detail rows.

API updates:
Detail() object to manipulate detail rows programmatically.

4) Context menu: Support to display context menu in the empty area of the grid too with contextMenu.bodyItems sub-option.

5) pqSelect: support for jQuery v3.x

Best Regards
The ParamQuery Team

News / Upgrade to Pro Version 8.6.0
« on: September 05, 2022, 09:01:18 pm »
Dear All

We are excited to announce release of the new version v8.6.0

Background or lazy loading of data was first introduced in v8.5.0 to make loading big data quite user friendly.
This version introduces more improvements in it to make it as robust and applicable to most of the use cases which could be implemented with remote loading of data.

Background loading has been used in these 2 examples:



Few additional options have been added in Pivot tooPanel API.

Besides there are few important bug fixes in rowTemplate ( for nested data ) and row grouping vis-a-vis multiple column sorting.

Best Regards
The ParamQuery Team

News / Upgrade to Pro Version 8.5.0
« on: August 09, 2022, 04:21:12 pm »
Dear All

Thank you all for your support. We feel glad to announce release of the new version v8.5.0

Besides bug fixes, it offers following updates and / or new features:

a) Treegrid with batch editing:

b) Background loading of large remote data:

Best Regards
The ParamQuery Team

News / Upgrade to Pro Version 8.4.0
« on: June 07, 2022, 11:15:18 am »
Dear All

Thank you all for your support. We feel glad to announce release of the new version v8.4.0

Besides bug fixes, it offers overall enhancement of the editors

1. Editors have got additional capability to scroll along with the grid cells. There is still a backward compatible option to make sticky editors.

2. More options to support custom editors. Example:

3. refreshCompareBy option to refresh only the affected cells (found automatically by grid) rather than all cells in the viewport after editing a cell. That means we no longer need these

Code: [Select]
cellSave: function(){


Code: [Select]
cellSave: function(evt, ui){

Example of usage:

4. Experimental feature to support rendered editors which means simultaneous opening of multiple editors in grid.

5. Some copy related events ( beforeCopy, copy ) have also been added in this version.

Note: Please refer upgrade guide for breaking changes w.r.t. editors.

Best Regards
ParamQuery Team

Pages: [1] 2 3 ... 19