How to add custom cell type that opens a kendoDateTimePicker to a SpreadJs Cell

How to add custom cell type that opens a kendoDateTimePicker to a SpreadJs Cell

Posted by: jose.kurian on 17 October 2017, 12:09 pm EST

• 

  jose.kurian

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 17 October 2017, 12:09 pm EST

  Overview:
  
  Adding the kendoDateTimePicker to a greapecity spreadjs spreadsheet library cell. On edit of the cell in the spreadsheet, the date time picker is created by the cell. When the user selects the date or time the spreadsheet cell will be updated with value from the kendo date time picker and the date time picker is closed.
  
  Issue:
  
  The date time picker is created and displayed successfully with the initial value in the date time picker. The initial value gets transferred to the spreadsheet control’s cell. It does not update the value in the date time picker when the user selects a different date. The only value it holds is the initial value set to the date time picker at the time of creation.
  
  The date picker is not able to set the values in the date picker; value property in the kendo date time picker is null. In other words, the user clicked date is not being set to the kendo date time picker. Instead it just closes.

  • "* “Why is the date time picker not updating the value when user selects a date?”

  • “How could I retrieve the value from the date time picker?”

  • "How to tell the spreadsheet that the date time picker control generated is part of the editing cell? In other words, How we can bind the DateTimePicker as an editor of the spread? "

  "

  Code sample attached.kdp spread.zipkdp spread.zipkdp spread.zip

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 18 October 2017, 12:24 am EST

  Hello,

  It seems that the sample application could not be attached. Could you attach that again for us to look into the issue?

  Thanks,
  
  Deepak Sharma

• 

  jose.kurian

  • Post Options:
  • Link
    Copy

  Posted 18 October 2017, 2:17 am EST

  Sample attached

  kdp spread.zip

• 

  jose.kurian

  • Post Options:
  • Link
    Copy

  Posted 18 October 2017, 2:18 am EST

  kdp spread.zip

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 24 October 2017, 2:56 am EST

  Hi Jose,

  Please take a look at the sample application which uses the jquery datetime picker and works fine with the custom celltype.

  Thanks,
  
  Deepak SharmaCustomDatePickerCelltype.zip

• 

  jose.kurian

  • Post Options:
  • Link
    Copy

  Posted 26 October 2017, 1:23 pm EST

  We don’t use Jquery date time picker, we user kendo for certain reasons. We were following the example for jquery date picker.

  Could you help me with the answer to this question:
  
  How to tell the spreadsheet that the date time picker control generated is part of the editing cell? In other words, How we can bind the DateTimePicker as an editor of the spread?

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 31 October 2017, 2:32 am EST

  Hi Jose,

  Sorry for long delay!
  
  I am working on this issue, please allow me some more time.

  Thanks,
  
  Deepak Sharma

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 1 November 2017, 2:45 am EST

  Hello,

  I found that the value in the Kendo DateTimePicker is not updating. It always returns null GetEditorValue method. I have asked our development team to look into this issue. I will let you know as soon as I hear anything on this.
  
  The tracking id for this issue is #248817

  Thanks,
  
  Deepak Sharma

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 8 November 2017, 8:08 pm EST

  Hello,

  Please refer to attached modified sample, provided by our dev team.

  Thanks,
  
  Deepak SharmaSpreadJSCustomCellType.zip