Prolem autofill in hotTable

Questions
,
1

Currently, I’m experiencing a problem in my table. For example, I have 25 rows of data displayed in a hottable. After using autofill to drag down 25 rows, the data is successfully displayed. However, the issue is that when I drag the autofill past row 25, rows 26, 27, etc., appear. How can I resolve this issue?

image
image1810×268 20.9 KB
<HotTable

  ref={ref}

  data={data}

  copyPaste={true}

  beforePaste={handleBeforeCopyPaste}

  multiSelect={true}

  search={true}

  afterChange={handleAfterChange}

  columns={hotColumns}

  width="100%"

  rowHeaders={true}

  colHeaders={true}

  autoWrapRow={true}

  height={900}

  autoWrapCol={true}

  renderAllRows={false}

  viewportRowRenderingOffset={20}

  pagination={false}

  fillHandle={

    {

      direction: 'vertical',

      autoInsertRow: true

    }



  }

  beforeKeyDown={handleBeforeKeyDown}

  afterOnCellMouseDown={handleAfterOnCellMouseDown}

  afterPageSizeChange={handleAfterPageSizeChange}

  observeChanges={false}

  licenseKey="non-commercial-and-evaluation"

  contextMenu={true}

  stretchH="all"

  dragToScroll={true}

  autoColumnSize={{ allowSampleDuplicates: true, }}

  autoRowSize={false}

  outsideClickDeselects={false}

  rowHeights={13}

  viewportColumnRenderingOffset={10}

  manualRowResize={false}

  manualColumnResize={true}

  wordWrap={false}

  afterPageChange={handleAfterPageChange}

/>
2

Hi @dat.vo

Could you please specify what should happen (expected result)?

  1. Would you like to block the autofill that creates new rows
  2. Autofill the data from the 2nd column all the way down and do the same for the dates and weights columns automatically to avoid the validation marking those columns invalid?
3

thank you, I’ve fixed it done

1 Like
4

Great! Thank you for the update. We can close this thread.