Recent Posts

41

Help for ParamQuery Pro / Re: Issue with Decimal Value Paste from Excel in pqGrid v11

« Last post by paramvir on April 16, 2026, 11:07:55 am »

Thanks for sharing stackblitz.

i've added the following fix in pqgrid.jsx to accept copy-paste of numbers from Excel

Code: [Select]

    const _isDateFormat = pq.isDateFormat;
    pq.isDateFormat = function (fmt) {
      return fmt == 'Standard' ? false : _isDateFormat.call(this, fmt);
    };

Final stackblitz:

https://stackblitz.com/edit/vitejs-vite-5akectub?file=index.html,src%2Fmain.jsx,src%2Fpqgrid.jsx

Please let me know if you need further assistance

42

Help for ParamQuery Pro / Re: Issue with Copy Functionality Inside Grid

« Last post by luckduck on April 16, 2026, 05:36:49 am »

Thank you for your answer. Have a nice day.

43

Help for ParamQuery Pro / Issue with Decimal Value Paste from Excel in pqGrid v11

« Last post by Punit on April 15, 2026, 06:39:44 pm »

Dear Team,

I am encountering an issue while copying and pasting decimal values from Excel into pqGrid (version 11).

In my Excel sheet, the values are in decimal format. However, when I copy these values and paste them into pqGrid, they appear as #VALUE! instead of the expected numeric or string values.

Here are the details:

pqGrid version: v11
Column dataType: string
Expected behavior: Decimal values should paste correctly as-is (regardless of format subtype)
Actual behavior: Pasted values are converted to #VALUE!

Additionally, I tested the same functionality using pqGrid version 10, and the copy-paste behavior works correctly there without any issues.

For your reference, I have also uploaded a StackBlitz project demonstrating the issue in pqGrid v11.

[ Url removed due to inclusion of SDK source files. ]

Could you please help identify the cause of this behavior and suggest a solution ?

44

Help for ParamQuery Pro / Re: Issue with Copy Functionality Inside Grid

« Last post by paramvir on April 15, 2026, 08:35:11 am »

Moving away from the Clipboard API in pqGrid v11 is unfortunately not feasible because modern browsers have standardized on this secure interface to protect user data, making it a core dependency for the grid’s internal copy-paste logic. Since the browser itself blocks these features on insecure origins as a hard security requirement, there is no programmatic workaround that can reliably bypass the need for a Secure Context. To restore this functionality in your production environment without a massive architectural downgrade, the most effective path forward is to serve your internal site over HTTPS, which will satisfy the browser's security protocols and allow the native clipboard functions to execute correctly.

45

Bug Report / Re: ESC does not restore value after Delete in editor mode (v11)

« Last post by paramvir on April 15, 2026, 08:31:28 am »

Thanks for the correction!

Yes, that is the correct approach for resolving ReferenceError when a variable is being accessed but has not been declared within the scope.

46

Bug Report / Re: ESC does not restore value after Delete in editor mode (v11)

« Last post by luckduck on April 15, 2026, 06:03:01 am »

 The code you provided works correctly.
However, I encountered the following error: Uncaught ReferenceError: gExcel is not defined

So I added a declaration for gExcel like below.
Could you please confirm if this is the correct approach?

Code: [Select]

!function(e){var gExcel = null;e(document).off(".pqExcel").on("keydown.pqExcel",function(c){var t,n,i=e(document.activeElement),l=i.parent(),o=l.is(".pq-focus-mgr:not(.pq-editor-outer)"),r=o,p=c.key,E=c.keyCode,u=e.ui.keyCode,g=e=>{t=i.closest(".pq-grid"),n=t.pqGrid("instance")};if(!o||E!=u.UP&&E!=u.DOWN||c.preventDefault(),o&&E==u.DELETE&&(g(),n?.clear()),pq.isCtrl(c)&&r&&(g(),gExcel||i.length&&n)){if(!gExcel)try{if(n.options.selectionModel.native)return!0;gExcel=new cExcel(n)}catch(e){return!0}i=gExcel.initClip(i,l),"f"!=p&&"F"!=p||e(document).trigger("keyup.pqExcel")}}).on("keyup.pqExcel",function(e){if(!pq.isCtrl(e)&&gExcel){gExcel=null}}).on("click.pqExcel keydown.pqExcel",function(c){"click"!=c.type&&e.ui.keyCode.ENTER!=c.keyCode||e(c.target).trigger("pq:clickE")})}(jQuery);

47

Bug Report / Re: ESC does not restore value after Delete in editor mode (v11)

« Last post by paramvir on April 14, 2026, 10:36:53 am »

To resolve this issue, please include the following patch in your project. It must be loaded after the pqgrid.js library to function correctly.

Code: [Select]

!function(e){e(document).off(".pqExcel").on("keydown.pqExcel",function(c){var t,n,i=e(document.activeElement),l=i.parent(),o=l.is(".pq-focus-mgr:not(.pq-editor-outer)"),r=o,p=c.key,E=c.keyCode,u=e.ui.keyCode,g=e=>{t=i.closest(".pq-grid"),n=t.pqGrid("instance")};if(!o||E!=u.UP&&E!=u.DOWN||c.preventDefault(),o&&E==u.DELETE&&(g(),n?.clear()),pq.isCtrl(c)&&r&&(g(),gExcel||i.length&&n)){if(!gExcel)try{if(n.options.selectionModel.native)return!0;gExcel=new cExcel(n)}catch(e){return!0}i=gExcel.initClip(i,l),"f"!=p&&"F"!=p||e(document).trigger("keyup.pqExcel")}}).on("keyup.pqExcel",function(e){if(!pq.isCtrl(e)&&gExcel){gExcel=null}}).on("click.pqExcel keydown.pqExcel",function(c){"click"!=c.type&&e.ui.keyCode.ENTER!=c.keyCode||e(c.target).trigger("pq:clickE")})}(jQuery);

Kindly let me know if you need further assistance.

48

Bug Report / Re: ESC does not restore value after Delete in editor mode (v11)

« Last post by paramvir on April 14, 2026, 08:51:26 am »

Both issues are related; I'll share the fix soon.

49

Help for ParamQuery Pro / Issue with Copy Functionality Inside Grid

« Last post by luckduck on April 14, 2026, 07:27:51 am »

In pqGrid version 11, copying cell content via Ctrl + C seems to rely on the navigator.clipboard API, which requires a secure (HTTPS) context.

Our system runs on an internal network over HTTP, so this functionality is not available.

As this issue impacts a production environment, we would appreciate any possible workaround or alternative approach.

Thank you in advance.

50

Bug Report / Re: ESC does not restore value after Delete in editor mode (v11)

« Last post by luckduck on April 14, 2026, 07:17:02 am »

I have an additional question regarding another issue.

In my environment, I am using the treeModel. When the summaryInTitleRow option is enabled, pressing the Delete key while the editor is active causes the editor to close immediately.

Due to this, combined with the previously mentioned issue, the original cell data is already removed, and the validation logic is triggered twice, resulting in behavior that differs from pqGrid version 9.

As a result, the existing data in the cell is completely cleared, and the editor is closed, leading to total data loss.

I am not sure if the issue with the editor closing on the Delete key should be considered in the same context, but since it is affecting our production system, a quick resolution is required.

If there is a solution, I would greatly appreciate it if you could share it along with example source code.

Thank you.