Fill-Down like Excel

Fill-Down like Excel

Posted by: daryn-holmes on 14 September 2017, 12:13 pm EST

• 

  daryn-holmes

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 14 September 2017, 12:13 pm EST

  Hi,

  Does Wijmo 5 support ‘excel fill-down’ in any of the products?
  
  Flexgrid or Flexsheet?

  This is where you select a few cells in a row, move the mouse the bottom right, and then a + (plus) will appear.
  
  You can then drag that down, and excel will do its best to populate the cells below.

  Similar to this: https://www.youtube.com/watch?v=yPugRS6pJ78
  
  We don’t need the formula to be copied, only values.

  Thanks

• 

  daryn-holmes

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 12:13 pm EST

  This is sometimes called ‘drag and fill’.

  Thanks, Daryn

• 

  manish-gupta1

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 12:13 pm EST

  Hi Daryn,
  
  Currently, this feature is not supported in the FlexSheet/FlexGrid. The enhancement request is created for the same with tracking id 229151.
  
  This feature can be included in the future releases.

  Thanks,
  
  Manish Kumar Gupta

• 

  daryn-holmes

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 12:13 pm EST

  Thanks for the answer, where can I track it?

• 

  manish-gupta1

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 12:13 pm EST

  Hi Daryn,
  
  The provided is internal tracking id used to track reported issue status by another engineer in case of reported engineer absence.

  Thanks,
  
  Manish Kumar Gupta

• 

  kyle.m.vassella

  • Post Options:
  • Link
    Copy

  Posted 12 October 2018, 10:32 am EST

  Any updates on this feature in 2018? Has it perhaps been added to flex sheets or flex grid?

• 

  peter_murray

  • Post Options:
  • Link
    Copy

  Posted 17 May 2021, 4:53 pm EST

  I would also be curious if there any updates to this, even though it is now 2021. I have been searching the Flex Grid API for anything that comes close to this but have since found nothing.

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 17 May 2021, 11:27 pm EST

  Hi Peter,

  The autofill functionality is added to the FlexSheet by default in the latest versions. The allowAutoFill property can be used to enable/disable this behavior:

  https://www.grapecity.com/wijmo/api/classes/wijmo_grid_sheet.flexsheet.html#allowautofill

  In FlexGrid, you will need to add this feature manually by adding a small div at the bottom-right of the cell and handle the mousedown/mouseup events to copy the cell’s content to other cells. Please refer to the sample attached for reference.

  Regards,
  
  Ashwin

  drag_copy_paste.zip