ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: Punit on March 25, 2026, 07:00:42 pm

Title: Invalid Data Display (#VALUE!) on Excel Paste In React
Post by: Punit on March 25, 2026, 07:00:42 pm

When data is copied from Excel and pasted into pqGrid, it is displayed as ‘#VALUE!

beforeValidate: function (evt, ui) {
  if (ui.source === "paste") {
    const grid = this;

    // Block all new row additions on paste
    ui.addList.length = 0;

    // Loop through updated rows
    ui.updateList.forEach(({ newRow, rowData }) => {
      for (const dataIndx in newRow) {
        if (!newRow.hasOwnProperty(dataIndx)) continue;

        const col = grid.getColumn({ dataIndx });
        console.log(col, "=rowData-paste");

        const elementType = rowData?.ElementType;
        let val = newRow[dataIndx];

        console.log(val, "=paste-value");
        // output #VALUE!
      }
    });
  }
}

Title: Re: Invalid Data Display (#VALUE!) on Excel Paste In React
Post by: paramvir on March 25, 2026, 10:33:35 pm

copy paste from Excel to pqgrid works fine in general, can you please share example spreadsheet and specific cells which cause this issue.

Title: Re: Invalid Data Display (#VALUE!) on Excel Paste In React
Post by: Punit on March 26, 2026, 04:03:25 pm

When I copy data from Excel in Indian number format and paste it into pqGrid, it doesn’t work. The Indian number format is not supported