Ctrl+R for filling row cells

Posted by: davide.vago on 5 April 2020, 7:39 pm EST

  • Posted 5 April 2020, 7:39 pm EST

    Good morning/afternoon

    I'm reaching you out as I have a requirement to enable the filling functionality via keyboard shortcut as per standard spreadsheet behaviour:

    ref.
    ----
    Ctrl+R in Excel and other spreadsheet programs
    In Microsoft Excel and other spreadsheet programs, pressing Ctrl+R fills the row cell to the right with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Right arrow to select multiple cells. Then press Ctrl+R to fill them with the contents of the original cell.

    ----

    I'm currently using the commandManager() to register shortcuts but I'm not sure how to proceed with these kind of commands where there is a selection change involved.

    Do you have any suggestion for this specific implementation?

    Looking forward to hearing from you
  • Replied 7 April 2020, 11:12 pm EST

    Hi Davide,

    Sorry for the delay, We are working on this case and will provide you with an update soon.

    Regards
    Sharad
  • Marked as Answer

    Replied 8 April 2020, 10:37 pm EST

    Hi Davide,

    Sorry for the delay. To support excel-like row fill, you may create a custom command as demonstrated in the following sample:
    https://codesandbox.io/s/spread-js-starter-3i1o0

    Regards
    Sharad
Need extra support?

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

Learn More

Forum Channels