DragFill with Hidden Columns in between

Posted by: niranjan-pulipati on 8 September 2017, 12:36 pm EST

  • Posted 8 September 2017, 12:36 pm EST

    Hi,


    I am working with FpSpread with Windows. While trying to DragFill, the values for columns after a Hidden column are not getting filled in.


    Is there any solution to overcome this?Also apart from the DragFillBlock event what are the other events that are raised with this DragFill? 


    Thanks


    Niranjan

  • Replied 8 September 2017, 12:36 pm EST

    Niranjan,


    Make sure you are the latest maintenance release (2.5.2009). I tested this with this version and the data was pasted into all cells, even across hidden columns.


    The DataModel's Changed event will fire when the data is filled into the block of cells.

  • Replied 8 September 2017, 12:36 pm EST

    I want to skip over the Hidden columns on a dragfill.  How would I do that?
  • Replied 8 September 2017, 12:36 pm EST

    There is a dragfillblock event with a cancel parameter.  It has the following information.  You could use code to put the text in only the cells you want:

    <table class="FilteredItemListTable">

    <tr>
    <th>Property</th>
    <th>Description</th></tr>
    <tr>
    <td class="LinkCell">Cancel
    </td>
    <td class="DescriptionCell">Gets or sets whether to cancel the fill. </td></tr>
    <tr>
    <td class="LinkCell">ColumnBegin
    </td>
    <td class="DescriptionCell">Gets the column index of the top left cell of the
    range being used for the fill. </td></tr>
    <tr>
    <td class="LinkCell">ColumnEnd
    </td>
    <td class="DescriptionCell">Gets the column index of the bottom right cell of the
    range being used for the fill. </td></tr>
    <tr>
    <td class="LinkCell">DataOnly
    </td>
    <td class="DescriptionCell">Gets the data only flag. </td></tr>
    <tr>
    <td class="LinkCell">Direction
    </td>
    <td class="DescriptionCell">Gets the direction of the fill. </td></tr>
    <tr>
    <td class="LinkCell">NumberToCopy
    </td>
    <td class="DescriptionCell">Gets the number of rows or columns being filled.
    </td></tr>
    <tr>
    <td class="LinkCell">RowBegin
    </td>
    <td class="DescriptionCell">Gets the row index of the top left cell of the range
    being used for the fill. </td></tr>
    <tr>
    <td class="LinkCell">RowEnd
    </td>
    <td class="DescriptionCell">Gets the row index of the bottom right cell of the
    range being used for the fill. </td></tr></table>
Need extra support?

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

Learn More

Forum Channels