Method setAtCell

handsontable/src/dataMap/dataSource.ts:223–277

* Set the provided value in the source data set at the provided coordinates. * * @param {number|string} row Physical row index. * @param {number|string} column Property name / physical column index. * @param {*} value The value to be set at the provided coordinates.

(row: number | string, column: string | number, value: unknown)

   * @param {*} value The value to be set at the provided coordinates.
   */
  setAtCell(row: number | string, column: string | number, value: unknown) {
    // Normalize row: accept string numeric indices (e.g. '0', '1') passed by setSourceDataAtCell,
    // but reject prototype-pollution keys like '__proto__', 'constructor', 'prototype'.
    let normalizedRow: number;

    if (typeof row === 'string') {
      const parsed = Number(row);

      if (Number.isNaN(parsed) || !Number.isInteger(parsed) || parsed < 0) {
        return;
      }
      normalizedRow = parsed;
    } else if (typeof row !== 'number' || !Number.isInteger(row) || row < 0) {
      return;
    } else {
      normalizedRow = row;
    }

    if (normalizedRow >= this.countRows() || (typeof column === 'number' && column >= this.countFirstRowKeys())) {
      // Not enough rows and/or columns.
      return;
    }

    if (this.hot!.hasHook('modifySourceData')) {
      const valueHolder = createObjectPropListener(value);

      this.hot!.runHooks('modifySourceData', normalizedRow, column, valueHolder, 'set');

      if (valueHolder.isTouched()) {
        value = valueHolder.value;
      }
    }

    const dataRow = this.modifyRowData(normalizedRow);

    if (!Number.isInteger(column)) {
      // column argument is the prop name
      if (Array.isArray(dataRow)) {
        // String numeric column with array data — convert to number and write directly, same as
        // the integer path below. setProperty rejects arrays, so this must be handled here.
        const numericIndex = Number(column);

        if (!Number.isNaN(numericIndex) && Number.isInteger(numericIndex) &&
            numericIndex >= 0 && numericIndex < this.countFirstRowKeys()) {
          dataRow[numericIndex] = value;
        }
      } else if (isObject(dataRow)) {
        setProperty(dataRow as Record<string, unknown>, String(column), value);
      }
    } else if (Array.isArray(dataRow)) {
      dataRow[column as number] = value;
    } else if (isObject(dataRow)) {
      setProperty(dataRow as Record<string, unknown>, String(column), value);
    }
  }

  /**
   * Get data from the source data set using the physical indexes.