Highlight row when selecting a cell

Highlight row when selecting a cell

Posted by: gordon.proctor on 10 July 2019, 1:44 am EST

• 

  gordon.proctor

  • Post Options:
  • Link
    Copy

  Posted 10 July 2019, 1:44 am EST

  Is there a way to highlight the entire row of the currently selected cell?

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 10 July 2019, 5:13 pm EST

  Hello,

  You can set the operation mode of Spread control to Row in order to show the complete row selected on cell click.
  
  You can use the code as follows:

  fpSpread1.OperationMode = OperationModeRow

  Thanks,
  
  Deepak Sharma

• 

  gordon.proctor

  • Post Options:
  • Link
    Copy

  Posted 10 July 2019, 7:30 pm EST

  Thanks for your prompt reply Deepak,

  I suspected that row selection would not work for us but I tried it anyway.

  We still want to see on the grid which cell is selected but have the row highlighted so that associated data on the row is more easily seen.
  
  In OperationModeRow you can not see which cell is selected, presumably because no cell is selected.

  In OperationModeRow, we also are having issues with not displaying the correct cells data in our formula bar. only when another cell in the current row is selected is our formula bar updated properly. This works perfectly when not in OperationModeRow.

  We really only want one cell selected, so I suspect I’ll have to iterate all cells in the row and change the background colour to highlight the row. I’ll need to remember the old background colours and apply them when moving rows.

  I was hoping to avoid this complication. Do you think there is an easier way?

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 15 July 2019, 4:40 pm EST

  Hello,

  You are right, for the requirement you have mentioned, setting the backcolor of the active row is the only solution.

  Thanks,
  
  Deepak Sharma