Highlight row when selecting a cell

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

  • Posted 10 July 2019, 1:44 am EST

    Is there a way to highlight the entire row of the currently selected cell?
  • Replied 10 July 2019, 5:13 pm EST


    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

    Deepak Sharma
  • Replied 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?
  • Replied 15 July 2019, 4:40 pm EST


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

    Deepak Sharma
Need extra support?

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

Learn More

Forum Channels