is there any cell drag feature like MS excel in flex grid or flex sheet ?

Posted by: rizwan on 6 February 2020, 8:36 pm EST

  • Posted 6 February 2020, 8:36 pm EST

    I have a requirement in which i need to apply value of current cell to the cells below by dragging it ? is there any cell drag feature like MS excel in flex grid or flex sheet ? or can we build it in wijmo ?
  • Replied 9 February 2020, 2:33 pm EST

    Hi Rizwan,

    The FlexSheet control has a property known as allowAutoFill that enables the autofill feature just like excel. Try setting this property to true and let us know whether it works for you.

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

    Regards,
    Ashwin
  • Replied 9 February 2020, 5:51 pm EST

    Hi Ashwin,
    I have tried what you suggested and its giving me following error.
    Can't bind to 'allowAutoFill' since it isn't a known property of 'wj-flex-sheet


    If you can share a running stackblitz example, that would be really helpful.
  • Replied 10 February 2020, 2:35 pm EST

    Hi Rizwan,

    The allowAutoFill property was added in v5.20192.624 so that the users can disable the autofill feature. Before this version, the autofill was allowed by default. You may verify the same using the demo below:

    https://www.grapecity.com/wijmo/demos/Grid/FlexSheet/Bound/purejs

    ~regards
  • Replied 10 February 2020, 11:13 pm EST

    Hi Ashwin,

    Thanks for sharing above link and this is exactly what my requirement is. but for some reason its not working for me by default or even by enabling autofill property. I am using wijmo version 5.20191.615 and it is not showing me that drag icon by default. Please suggest.
  • Replied 11 February 2020, 2:37 pm EST

    Hi Rizwan,

    You can verify that the autofill is working by creating a new application with FlexSheet and testing autofill in this. If it works fine, that means there is an issue with your existing project. You can also verify that the autofill works in the provided version by using the sample and screenshot below:

    https://stackblitz.com/edit/angular-vu6nnr



    ~regards
  • Replied 11 February 2020, 4:48 pm EST

    Hi Ashwin,

    Thanks for sharing the sample with the same version. :) I can't say this for sure but since we are using custom styling and formatting in flex sheet cells so this may be blocking this feature or there could be other things in my project. I am gonna change that for a while and will see if that works.
  • Replied 12 February 2020, 2:29 pm EST

    Hi Rizwan,

    I don't think that styling the flexsheet must have caused the issue of autofill. Nevertheless, let us know your results.

    ~regards
Need extra support?

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

Learn More

Forum Channels