Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

478
Views
In handsontable after select a day from date picker new row added

I'm using handsontable version 10, I have a issue after selecting a date from date picker it will added a new row. How I can disable that? But I need to get a new row with "enter key"

any one can test with this code,

document.addEventListener("DOMContentLoaded", function() {
var container2 = document.getElementById('example2'),
hot2;


hot2 = new Handsontable(container2, {
data: Handsontable.helper.createSpreadsheetData(5, 5),
colHeaders: true,
minSpareRows: 1,
columns: [
    {
        type: 'date',
        dateFormat: 'MM/DD/YYYY',
        correctFormat: true,
        datePickerConfig: {
            firstDay: 0,
            showWeekNumber: true,
            numberOfMonths: 1,
            licenseKey: 'non-commercial-and-evaluation',
            disableDayFn(date) {
                // Disable Sunday and Saturday
                return date.getDay() === 0 || date.getDay() === 6;
            }
        }
    },
    {
        type: 'text',
    },
    {

    },
    {

    }
    ]  });});
about 4 years ago · Juan Pablo Isaza
1 answers
Answer question

0

In your settings, there's a minSpareRows: 1 which adds a new line in the table each time you feel any of those cells in the last row

Handsontable adds a new row with minSpareRows

so when you pick a date in the cell index 5 app automatically adds a new row.

about 4 years ago · Juan Pablo Isaza Report
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!