DragFill with Hidden Columns in between

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

  • Posted 8 September 2017, 12:35 pm EST

    <P>Hi,</P>
    <P>I am working with FpSpread with Windows. While trying to DragFill, the values for columns after a Hidden column are not getting filled in.</P>
    <P>Is there any solution to overcome this?Also apart from the DragFillBlock event what are the other events that are raised with this DragFill? </P>
    <P>Thanks</P>
    <P>Niranjan</P>
  • Replied 8 September 2017, 12:36 pm EST

    <P>Niranjan,</P>
    <P>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.</P>
    <P>The DataModel's Changed event will fire when the data is filled into the block of cells.</P>
  • Replied 8 September 2017, 12:36 pm EST

    I want to skip over the Hidden columns on a dragfill.  How would I do that?<br>
  • 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:<br><br><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><br>
Need extra support?

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

Learn More

Forum Channels