Cell Value Change Event

11 posts, 0 answers
  1. Avnish
    Avnish avatar
    3 posts
    Member since:
    Nov 2015

    Posted 11 Nov 2015 Link to this post

    How can I add an event handler to a change in a cell value? This may be in works for the full release but does anyone have a temp solution for this?

     

    Thank You!

  2. Avnish
    Avnish avatar
    3 posts
    Member since:
    Nov 2015

    Posted 11 Nov 2015 in reply to Avnish Link to this post

    EDIT: Found a temporary solution -->

     

    $('#spreadsheet .k-spreadsheet-cell-editor').bind('focusout', function () {
        var toolTip = $('.k-tooltip');
        var cell = $(toolTip).eq(1).text();
        var value = $(this).text();
        alert(cell + " -> " + value);
    });​

  3. Kendo UI is VS 2017 Ready
  4. Alex Gyoshev
    Admin
    Alex Gyoshev avatar
    2500 posts

    Posted 16 Nov 2015 Link to this post

    Hello Avnish,

    At this time there is no change event in the widget, but it has been logged for consideration for future releases. You can vote on UserVoice to raise its priority.

    Regards,
    Alex Gyoshev
    Telerik
     
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
     
  5. John Tobin
    John Tobin avatar
    16 posts
    Member since:
    Mar 2008

    Posted 20 Jan in reply to Alex Gyoshev Link to this post

    Hi Alex,

     I could really use this spreadsheet widget. Currently I use the silverlight spreadsheet control but have to move to a HTML 5 version very soon. Have you any idea if a cell value changed event might be included in the next release?

    Thanks,

    John

  6. Alex Gyoshev
    Admin
    Alex Gyoshev avatar
    2500 posts

    Posted 21 Jan Link to this post

    Hello John,

    We have not implemented this yet, but it is likely that it will land soon. There have been many requests for that specific event.

    Regards,
    Alex Gyoshev
    Telerik
     
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
     
  7. John Tobin
    John Tobin avatar
    16 posts
    Member since:
    Mar 2008

    Posted 29 Feb in reply to Alex Gyoshev Link to this post

    Hi Alex,

    seems that the onchange event has been released in the in Q1 2016.

    However, i was expecting to get the object ( in this case the cell ) that fired the onchange event.

    Instead, seems that the sender is the worksheet itself.

    So, Is there another way to achieve this? That is, get the cell whose values has changed?

     

    Regards,

     

  8. Alex Gyoshev
    Admin
    Alex Gyoshev avatar
    2500 posts

    Posted 02 Mar Link to this post

    Hello John,

    See the change event documentation, the range property of the event argument should provide that. The event is introduced in 2016.Q1.SP1, version 2016.1.226.

    Regards,
    Alex Gyoshev
    Telerik
     
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
     
  9. John Tobin
    John Tobin avatar
    16 posts
    Member since:
    Mar 2008

    Posted 02 Mar in reply to Alex Gyoshev Link to this post

    Hello Alex,

    unfortunately the Range object is not able to return the position of the cell (i.e.:  "C2" or "B5").

    It is possible to get the value(), but, as far as i can see, not the R1C1 position of the cell.

    Regards,

     

  10. Alex Gyoshev
    Admin
    Alex Gyoshev avatar
    2500 posts

    Posted 03 Mar Link to this post

    Hello John,

    Currently such data is not exposed in the public API. You could access it via a private API -- e.range._ref.print(), but that is not recommended and may break without notice. Can you please elaborate what is the use case behind this?

    Regards,
    Alex Gyoshev
    Telerik
     
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
     
  11. John Tobin
    John Tobin avatar
    16 posts
    Member since:
    Mar 2008

    Posted 03 Mar in reply to Alex Gyoshev Link to this post

    Hi Alex,

    thanks for your clarification.

    I am actually trying to extend the 'cell object', in order to contain not only a Value and layout attributes. I would attach custom objects , with own properties.

    And what i m trying to do is to individuate exactly which cell of the sheet has fired the onChange event. Also a Row-Col index would work. In order, then to get the 'cell object' and loop through its properties.

     

    Is it something i can achieve at this stage?

     

    Thanks

     

  12. Alex Gyoshev
    Admin
    Alex Gyoshev avatar
    2500 posts

    Posted 03 Mar Link to this post

    Hello John,

    There is an undocumented forEachCell method on the range, which was just documented. It accepts a callback, which will be called for each cell, and will receive the row index, column index, and cell options. Then you can maintain a hash with the row/column indices.

    Regards,
    Alex Gyoshev
    Telerik
     
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
     
Back to Top
Kendo UI is VS 2017 Ready