Ctrl+R for filling row cells

Ctrl+R for filling row cells

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

• 

  davide.vago

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 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