Issue with Decimal Value Paste from Excel in pqGrid v11

[Punit]

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 ?

[paramvir]

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

[paramvir]

Please include the Fixed format too.

Code: [Select]

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

Updated stackblitz

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