Ctrl x on cell range doesnt fire cell changed event for all selected cells

Posted by: aspnetdev on 8 September 2017, 2:55 pm EST

  • Posted 8 September 2017, 2:55 pm EST


    I am trying to capture Farpoint Spread SheetView's CellChanged event whenever a cell's value is cut(ctrl+x) by user. This event is fired as expected when user selects a single cell and cuts that cell's value. 

    However, when user selects  multiple cell range and cuts those cells' values - CellChanged event is only fired for one time (i.e. only for one cell). I was expecting that this event will be fired multiple times for each cell selected in the cell-range (just like when values are pasted into cell-range - that seems to fire CellChanged event for all cells in the range).

    Please advise how can I capture the CellChanged event when values are being cut from the cell-range.

    This is a windows forms application. And I have following input map set.  map.Put(new Keystroke(Keys.X, Keys.Control), SpreadActions.ClipboardCutValues);


  • Replied 8 September 2017, 2:55 pm EST

    The SheetView CellChanged event args has the following properties. If the event is fired for a CellRange it will only fire once, the Row and Column properties will give you the top left cell and the ColumnCount and RowCount will give you the rest of the CellRange the event was fired for.

    <table class="FilteredItemListTable">

    <td class="LinkCell">Column
    <td class="DescriptionCell">Gets the column index. </td></tr>
    <td class="LinkCell">ColumnCount
    <td class="DescriptionCell">Gets the number of columns. </td></tr>
    <td class="LinkCell">Row
    <td class="DescriptionCell">Gets the row index. </td></tr>
    <td class="LinkCell">RowCount
    <td class="DescriptionCell">

    Gets the number of rows.

Need extra support?

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

Learn More

Forum Channels