Invalid Data Display (#VALUE!) on Excel Paste In React

[Punit]

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!
      }
    });
  }
}

[paramvir]

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

[Punit]

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