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.


Messages - paramvir

Pages: [1] 2 3 ... 437
1
Bug Report / Re: Delete key behavior and blank paste bug
« on: July 12, 2026, 09:29:14 pm »
Thank you for reporting issue, am able to reproduce it and looking into it.

2
it's fixed in v11.2.1 and so the patch is not required.

3
Bug Report / Re: Delete key behavior and blank paste bug
« on: July 07, 2026, 06:14:06 pm »
Thank you for bringing this to our attention. We have tested these scenarios in the latest version but are unable to reproduce the issues as described. You can verify the standard behavior in our live demo here: https://paramquery.com/pro/demos/copy_paste

Here is how these features are designed to work in version 11.x:

Delete Key Functionality: The Delete key will clear the cell or selection as long as the grid cells have active focus. If the focus is lost or moved away from the selection, the keypress will not trigger the clear action. This is the intended behavior to prevent accidental data erasure.

Copy and Pasting Blank Cells: Copying and pasting a single, isolated blank cell is not supported by design. However, copying and pasting a range of multiple cells that contains blank cells works perfectly.

If you are seeing different behavior even when the selection has active focus, please share a minimal reproducible example or your grid configuration so we can investigate it further.

4
This is fixed in v11.2.1

5
You are completely right to question the use of firstR and firstC since they are not explicitly detailed in the public API documentation.

Currently, these properties are internally necessary to establish the anchor point for subsequent "Shift+click" operations when setting an initial selection programmatically.

You can safely use this approach as a permanent solution. We will either formalize these properties in the official API documentation or ensure that any future internal optimizations remain fully backward-compatible so your implementation won't break.

6
Please use grid.Range() API instead of setSelection.

Code: [Select]
        grid.Range({
            r1: 0,
            c1: 0,
            firstR:0,
            firstC:0
        }).select();

Ref: https://paramquery.com/pro/api#method-Range

7
pqgrid v11.2.0 Release Notes

Official jQuery 4 Support
  • This release introduces full compatibility with jQuery 4.0+, ensuring that pqgrid remains at the forefront of the evolving web ecosystem.
  • pqselect also introduces official support for jQuery 4.0+ in this cycle.
  • Developers can now leverage the performance enhancements of the latest jQuery core without worrying about library conflicts or legacy overhead.

Expanded Named and Locale-Sensitive Formatting
  • The grid now supports sophisticated formatting tokens such as Fixed, Standard, Short Date, Long Date, and Time, allowing for high-level abstraction of data presentation.
  • This formatting intelligence is fully integrated into the data lifecycle, extending beyond the UI to impact copy-paste operations, Excel/PDF/HTML/CSV exports, and data imports.
  • By adhering to locale-sensitive standards, the grid automatically adjusts displays for international audiences, ensuring that a "Short Date" is intuitively rendered and processed based on the user's regional settings.

Smart Inbuilt Format Picker UI
  • A new, context-aware Format Picker has been added to the standard toolbar, providing an out-of-the-box solution for end-user customization.
  • The UI dynamically detects the data type of the active cell—whether it is a number, date, or timestamp—and presents relevant formatting options accordingly.
  • This "Smart" picker allows users to toggle between currency styles, decimal precision, and various date-time strings on the fly, significantly reducing the need for custom developer-built configuration menus.
  • Note that this feature and associated API is available in Ultimate and OEM variants only

API enhancements
  • More inbuilt controls are added directly to the toolbar.items option. This provides an easier and declarative way to initialize the toolbar.
  • More useful and convenient ways to initialize the context menu are now available. More properties added to context menu items.
  • Key navigation is enhanced with an Enter mode similar to Excel. This mode allows all 4 arrow keys to be used to navigate out of an editing cell.

Native ECMAScript Modules (ESM) Support
  • This version introduces official ESM support via dedicated .mjs module files, allowing for modern development workflows and seamless integration into modern bundlers (such as Vite, Webpack 5, and Rollup) and native browser ESM support.
  • ESM distribution bundles are now included out of the box as .mjs files for pqgrid, jquery-ui-pack, pqselect, pqtouch and localization providing clean JavaScript imports and compatibility with optimized modern production pipelines.
Localization
  • New localization files for more regions have been added
  • More localization strings have been added
  • Use *.mjs localization files in ESM environment


8
Help for ParamQuery Pro / Re: Wrap Content Behaviour
« on: June 18, 2026, 09:31:04 pm »
CLearing the row height cache fixes the issue.

Code: [Select]
this.option('wrap', evt.target.checked);
//clear the row height cache before changing wrap of whole grid.
this.pageData().forEach(function(rd) {
    delete rd.pq_ht
})
this.refresh();

9
Bug Report / Re: v11.1.0 Ctrl-C throws an error
« on: June 05, 2026, 10:18:02 pm »
Because this security restriction is enforced directly by the browser engine (Chromium, WebKit, Gecko) rather than the grid framework, it is unfortunately impossible to implement a workaround within the software itself. If the site is served over
Code: [Select]
http:// (and is not localhost), the browser completely removes the
Code: [Select]
navigator.clipboard object from the global window scope for security reasons.

However, since you are in a local development/testing environment, you can easily bypass this browser restriction using one of the following solutions:

Solution 1: Enable the Insecure Origin Flag in Chrome/Edge (Easiest for testing) 
You can explicitly tell your browser to treat your specific local HTTP URL as a secure context.

  • Open Chrome or Edge and navigate to:
    Code: [Select]
    chrome://flags/#unsafely-treat-insecure-origin-as-secure (or
    Code: [Select]
    edge://flags/#unsafely-treat-insecure-origin-as-secure)
  • Change the dropdown to Enabled.
  • In the text box provided, paste your local server's URL (e.g., http://your-local-server-ip:port).
  • Relaunch the browser. The clipboard API will now work seamlessly on that specific address.

Solution 2: Map the Remote Server to Localhost via SSH 
If you have SSH access to that server, you can map its web port directly to your machine. This tricks the browser into seeing it as a local site:

  • Run the following command in your local terminal:
    Code: [Select]
    ssh -L 8080:localhost:80 user@remote-server-ip
    • You can then access the site in your browser via http://localhost:8080. Because it uses the "localhost" hostname, the browser automatically unlocks the clipboard API.
    Moving forward, modern web security models require either a secure context (HTTPS/localhost) or explicit browser flag exceptions for applications utilizing clipboard, camera, geolocation, or crypto APIs.

10
Bug Report / Re: v11.1.0 Ctrl-C throws an error
« on: June 05, 2026, 05:38:31 pm »
Copy and paste functionality in recent versions of ParamQuery Grid relies on the modern
Code: [Select]
navigator.clipboard API. The error "Cannot read properties of undefined (reading 'write')" explicitly indicates that the browser is blocking access to this API.

To resolve this issue, please ensure the following environment requirements are met:

  • Use HTTPS or Localhost: Modern browsers restrict the Clipboard API strictly to Secure Contexts. The
Code: [Select]
navigator.clipboard object will be undefined if your application is running over standard
Code: [Select]
http:// on a remote server or IP address. It will only function over
Code: [Select]
https:// or
Code: [Select]
http://localhost
    for local development.
  • Keep Document Focus: The browser requires active page focus to modify the clipboard. If your cursor or focus is currently inside the Browser Developer Tools (Console/Elements panel) while you press Ctrl+C, the operation will fail. Make sure to click inside the grid cells before testing the shortcut.

11
Please check this example:

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

Code: [Select]
  editorKeyDown(evt, ui) {
      if (globalEditByPress) {
          let c1, r1;
          //check left and right key with key names
          if (evt.key == "ArrowRight") {
              c1 = this.getNextVisibleCI(ui.colIndx + 1);
              r1 = ui.rowIndxPage
          } else if (evt.key == 'ArrowLeft') {
              c1 = this.getPrevVisibleCI(ui.colIndx - 1);
              r1 = ui.rowIndxPage
          } else if (evt.key == 'ArrowUp') {
              r1 = this.getPrevVisibleRIP(ui.rowIndx);
              c1 = ui.colIndx
          } else if (evt.key == 'ArrowDown') {
              r1 = this.getNextVisibleRIP(ui.rowIndx);
              c1 = ui.colIndx
          }
          if (r1 != null && c1 != null) {
              this.focus({
                  rowIndxPage: r1,
                  colIndx: c1
              });
              this.Range({
                  r1,
                  c1
              }).select();
              return false; //to prevent default handing of keys b
          }
      }
  },

12
That is an interesting requirement.

You are right: pqGrid doesn't differentiate how the editor is initiated, and there is no example for this specific dual-mode behavior currently.

I am looking into a customizable solution for this. If it works cleanly, I will provide you with the custom code shortly; otherwise, we will look into implementing this natively in an upcoming version of the grid.

13
Please check the styling section of this example:

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

14
It sounds like the issue may be related to outdated or incompatible frontend assets after the upgrade. Please try the following steps:

1. Update CSS files 
Make sure you’ve replaced all older ParamQuery CSS files with the ones from version 11.1.0. Missing or outdated styles can affect drag-and-drop visuals.

2. Verify dependencies 
Check that your versions of jQuery and jQuery UI are compatible with ParamQuery v11.1.0, as mismatched versions can cause UI issues like this.

3. Clear browser cache 
Perform a hard refresh (Ctrl + F5) or clear the browser cache to ensure the latest CSS and JS files are loaded.

After these steps, the column drag preview should display correctly while grouping.

Let me know if the issue persists or if you need help verifying compatibility.

15
Thank you for reporting the issue.

Pages: [1] 2 3 ... 437