Messages

1

Help for ParamQuery Grid (free version) / Re: save data when batch-copy for select column and pivot grid

« on: Today at 10:45:01 am »

ShipVia (2nd column) in this example: https://paramquery.com/pro/demos/edit_select has different valueIndx, labelIndx and it works with copy paste.

editor.mapIndices is not designed for copy paste.

Please use formulas instead of editor.mapIndices in case there are any dependencies between different columns.

2

Help for ParamQuery Grid (free version) / Re: save data when batch-copy for select column and pivot grid

« on: November 22, 2024, 09:08:03 pm »

Please check this example: https://paramquery.com/pro/demos/datamap

3

Bug Report / Re: Some rows are not display when not been selected

« on: November 22, 2024, 08:53:25 pm »

Please share only relevant code in a jsiddle reproducing the issue.

4

Help for ParamQuery Grid (free version) / Re: save data when batch-copy for select column and pivot grid

« on: November 21, 2024, 11:23:04 am »

With your code, getChanges returns empty updateList even for inline editing of any cell.

5

Bug Report / Re: Some rows are not display when not been selected

« on: November 21, 2024, 08:31:26 am »

Which version of pqgrid is this? Do you see any error in the browser developer console.

Is it possible for you to share a jsfiddle: https://jsfiddle.net/adbghz7v/7/

6

Bug Report / Re: Issue with Date Filters in ParamQuery Grid with Custom Date Formats

« on: November 20, 2024, 12:16:43 pm »

This has been fixed since v10.0.0

7

Bug Report / Re: Another v10.0.0 bug with fix

« on: November 20, 2024, 12:00:50 pm »

This is fixed in v10.1.0

Test case:

https://jsfiddle.net/u0n296ym/1/

8

Bug Report / Re: Tiny bug in v10.0.1

« on: November 20, 2024, 11:58:48 am »

This is a duplicate of the issue already raised by you and this is fixed in v10.1.0

Test case:

https://jsfiddle.net/u0n296ym/1/

9

Bug Report / Re: Please change one line of code in next version

« on: November 20, 2024, 11:48:49 am »

This is fixed in v10.1.0

10

Bug Report / Re: Listener bug in v10.1.0

« on: November 20, 2024, 11:45:22 am »

I understand that your goal is to trigger filter on a certain timeout ( time lapse ). And if user press enter key before that time lapse, filtering should be triggered immediately and pending filter due to timeout shouldn't be triggered after that.

Default filter listener in v10.1.0 does that.

Please read the column.filter documentation for more details: https://paramquery.com/pro/api#option-column-filter

Please remove your custom code to get rid of the issues faced by you.

11

Help for ParamQuery Grid (free version) / Re: save data when batch-copy for select column and pivot grid

« on: November 19, 2024, 07:38:57 pm »

Batch editing is based on grid getChanges method.

getChanges include the updates due to copy paste in select lists similar to inline editing of individual editing of select lists.

So I don't see any issue there unless you share some technical details.

12

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 clear text icon in textboxes used in header filters and cell editors. 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

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

13

Help for ParamQuery Pro / Re: select vs autocomplete editor

« on: November 14, 2024, 09:59:18 pm »

use the appendTo option to set autocomplete parent to element larger than the grid.

https://api.jqueryui.com/autocomplete/#option-appendTo

14

Help for ParamQuery Pro / Re: Column Filtering works but all values still checked in filter

« on: November 13, 2024, 11:54:57 am »

Tabs can be chosen with help of menuUI.tabs option.

Code: [Select]

menuUI: {
      tabs: ["filter"],
},

https://jsfiddle.net/356Lpcx4/2/

Tab color depends upon the theme, please use theme of your choice.

15

Bug Report / Re: Bug in edit select demo version 9 and 10

« on: November 05, 2024, 06:59:14 am »

To show warning with red triangle, set pasteModel.allowInvalid to true.