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 ... 20

Help for ParamQuery Grid (free version) / MOVED: using Grid Toolbar buttons to check/uncheck a a checkbox field on a grid

« on: January 17, 2025, 08:58:44 pm »

This topic has been moved to Help for ParamQuery Pro.

https://paramquery.com/forum/index.php?topic=4962.0

News / Upgrade to Pro Version 10.1.0

« on: November 18, 2024, 01:52:05 pm »

Dear All

In continuation with the 10th version series of ParamQuery Pro, we are excited to announce the latest update, version v10.1.0, packed with enhancements and crucial bug fixes!

Key Enhancements:

Much faster Spreadsheet Loading: Our latest optimization delivers a dramatic improvement in performance when working with large spreadsheets. Enjoy substantially faster loading times, enhancing your efficiency and productivity.

Clear Text Icon in Header Filters and cell editors: Added a convenient '✖' icon in textboxes to clear text, it can be used in header filters, cell editors or toolbar. Enable this feature by simply adding the attribute is='clear-text' to any input with type "date", "text", or "number".

Examples:

Cell editors: https://paramquery.com/pro/demos/editing_custom
Toolbar filter textbox: https://paramquery.com/pro/demos/pivot_tabs
Header filters: https://paramquery.com/pro/demos/filter_initial

Enrichment of Tabs API:
1) Set grid options across all spreadsheet tabs with single API call.
2) Invoke grid methods across all spreadsheet tabs together.

Example: set localFmt option and compute formulas across all tabs with single API call:

https://paramquery.com/pro/demos/format_date

Improved filter listener:
Multiple filter listeners in string format i.e., 'timeout keyup', etc are introduced in header filter textboxes which trigger the filtering when specified events are fired without any concern of duplicate filter triggering when multiple events are fired together. The default listener is 'timeout change', which is generally sufficient and typically doesn't require any modifications. Check out the column.filter.listener for more details:
https://paramquery.com/pro/api#option-column-filter

Stay tuned for more updates and enhancements as we continue to improve your PQ experience!

Best Regards
The ParamQuery Team

News / Upgrade to Pro Version 10.0.0

« on: October 11, 2024, 12:01:26 pm »

Dear All

We are thrilled to announce the release of PQGrid v10.0.0, a significant milestone as we prepare to integrate interactive charts in future versions. This version includes important enhancements and bug fixes:

Formatting Revamp:

We've enhanced our number and date formatting to align with popular spreadsheet applications like MS Excel and Google Sheets. This feature has been implemented using plain JavaScript and modern browser APIs from scratch, without any dependencies. As a result, we have transitioned away from jQueryUI date formatting, as outlined in the upgrade guide.

Examples:

https://paramquery.com/pro/demos/format_number

https://paramquery.com/pro/demos/format_date

New API Options:
Define number and date formatting for editors and filter values, and parse formatted user inputs back to primitive values, eliminating the need for defining or simplifying the custom editors and filters for simple tasks.

For example by using column.fmtDateEdit option, the date editors in this demo are much easier to define than in earlier versions:

https://paramquery.com/pro/demos/editing_custom

Extended Export Support:
   Export images to PDF and HTML formats.

State Management:
   Save and load state support for nested columns.

Styling Enhancements:
   Add styles to range selection overlays.

Formula Parsing Engine Upgrade:
   Improved engine to support advanced Excel functions in future versions.

Lazy Data Model Initialization:
   Enable dataModel.location = 'lazy' after initialization.

Custom Dropdown Filter Titles:
   filter.title(values, column) callback to display custom values in dropdown filter titles.

We hope you enjoy these new features and improvements. Thank you for your continued support!

Please do remember to check the upgrade guide for this version: https://paramquery.com/pro/upgrade/index

Best Regards
The ParamQuery Team

Help for ParamQuery Pro / MOVED: selectionModel - toggle - BUG

« on: March 18, 2024, 07:48:50 am »

This topic has been moved to Bug Report.

https://paramquery.com/forum/index.php?topic=4777.0

News / Upgrade to Pro Version 9.1.0

« on: November 29, 2023, 03:19:53 pm »

Dear All

We are excited to announce the release of version v9.1.0, with important enhancements and some bug fixes.

Version 9.1.0 is the latest release in the series, following versions 9.0.0, 9.0.1, and 9.0.2. The release notes for version 9.0.0 can be accessed via the following link: https://paramquery.com/forum/index.php?topic=4627.0

1) Performance boost: In this version you would experience significant drop in usage of system resources ( RAM and CPU ) thus leading to slick user experience especially noticeable in case of large number of records as compared to previous versions.
Example of loading 10 million records in pqgrid: https://paramquery.com/pro/demos/virtual_scroll

2) Scaling support: This version of pqgrid supports css scaled transforms for grid as a whole or any of its ancestors ensuring proportional scaling of whole grid for a more versatile and dynamic user experience.

3) Hierarchical lines in case of row grouping, pivot and treegrid. By visually connecting related rows, users can quickly understand the organization and hierarchy of the information presented in the grid.

Examples:
https://paramquery.com/pro/demos/group_rows_hidden
https://paramquery.com/pro/demos/treegrid

4) Keyboard navigation: You can skip some of the columns with new column.skipFocus option while navigating through the cells with tab and arrow keys.

5) Enhancement in Row detail API ( detailModel.hasChild ) to skip row details and hide expand icons for specified rows.
Example: https://paramquery.com/pro/demos/nesting_local

Best Regards
The ParamQuery Team

ParamQuery Pro Evaluation Support / MOVED: When rowSpanHead mode is set to true, sorting functionality is not working

« on: September 26, 2023, 07:50:09 am »

This topic has been moved to Help for ParamQuery Pro.

https://paramquery.com/forum/index.php?topic=4710.0

News / Upgrade to Pro Version 9.0.2

« on: September 11, 2023, 07:02:49 pm »

Dear All

We are pleased to announce the release of version v9.0.2, a bug fix update for version 9.0.0

Release notes for version 9.0.0 are here: https://paramquery.com/forum/index.php?topic=4627.0

Some of the fixes are related to validation tooltip, copy/paste of text with line breaks, import/export to xlsx w.r.t ISO datetimes and difference of timezones, pivot grandsummary for count function, row selections.

Best Regards
The ParamQuery Team

Bug Report / MOVED: [pqgrid 9.0.1] treeGrid Problem

« on: August 22, 2023, 02:22:39 pm »

This topic has been moved to Help for ParamQuery Pro.

https://paramquery.com/forum/index.php?topic=4690.0

Bug Report / MOVED: EndSelect and SelectChange couldn't be triggered when use button to add new row

« on: August 21, 2023, 10:49:24 am »

This topic has been moved to Help for ParamQuery Grid (free version).

https://paramquery.com/forum/index.php?topic=4688.0

ParamQuery Pro Evaluation Support / MOVED: Inquiry about import excel date format (pqgrid 9.x)

« on: August 09, 2023, 06:52:52 am »

This topic has been moved to Bug Report.

https://paramquery.com/forum/index.php?topic=4673.0

Help for ParamQuery Pro / MOVED: type datetime render

« on: July 31, 2023, 06:55:15 am »

This topic has been moved to Bug Report.

https://paramquery.com/forum/index.php?topic=4667.0

News / Upgrade to Pro Version 9.0.1

« on: July 20, 2023, 05:06:21 pm »

Dear All

We are pleased to announce the release of version v9.0.1, a bug fix update to version 9.0.0

Release notes for version 9.0.0 are here: https://paramquery.com/forum/index.php?topic=4627.0

In this version, we have improved the support for unicode character-based languages such as Chinese, Korean, and Japanese w.r.t the editModel.pressToEdit option, enabling users to type directly on a cell that opens up the editor without losing any typed characters. This improvement ensures a seamless experience for users working with these languages.

We value the diversity of our user base and are committed to meeting their needs.

Additionally, any compatibility issues between the build process of pqgrid and recent versions of Angular till v16 have been successfully addressed and resolved.

We encourage you to update to v9.0.1 to benefit from these enhancements.

If you have any questions or feedback, please don't hesitate to reach out to our support team. Thank you for your continued support.

Best Regards
The ParamQuery Team