Validating date entered by user when using DateCalendarCellType

Posted by: joe0569 on 15 November 2022, 12:38 am EST

  • Posted 15 November 2022, 12:38 am EST

    I would like to be able to validate data within a cell that is set as DateCalendarCellType. First I want to say that i like the calendar pop-up and want to use that interface with the user without adding as mask editor. However, I would like to be able to ensure two types of validation:

    1 - that the user has either selected a date or entered one via keyboard in mm/dd/yyyy format.

    2 - that the date entered or selected was not greater than today’s date.

    I am able to select a max and min value for an integer cell type and it validates perfectly, however I would like similar functionality for the DateCalendarCellType.

    Do you have a code sample for how to achieve this? I have been looking through the forum and cannot find one.

    My celltype is coded as follows:

                    ****Dim dc As New 
                    dc.Animated = True
                    dc.DateFormat = "MM/dd/yyyy"
                    dc.EnableOnClient = True
                    sv.Columns(9).CellType = dc**


  • Posted 15 November 2022, 6:33 pm EST


    For this, you may need to use the editStart event and validate the cell. Please refer to the following code snippet and let me know if you face any issues.

      function stoppedSpreadEdit(event) {
          window.status = "Edit stopped " + event.cell.outerHTML;
    //value the event.cell here according to you custom logic
    FpSpread1.addEventListener("EditStart", startSpreadEdit)




Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels