Posted 10 July 2019, 1:44 am ESTIs there a way to highlight the entire row of the currently selected cell?
Highlight row when selecting a cell
Posted by: gordon.proctor on 10 July 2019, 1:44 am EST
Replied 10 July 2019, 5:13 pm ESTHello,
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
Replied 10 July 2019, 7:30 pm ESTThanks 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 ESTHello,
You are right, for the requirement you have mentioned, setting the backcolor of the active row is the only solution.