Posted 8 September 2017, 1:05 pm EST
We have a read only validation spread (OperationMode = ReadOnly) with selection unit set to Cell. When the user clicks inside the data area, I want the selection unit to be cell because we have a button that they click to open a form to fix invalid data.
But if they click in the RowHeader or ColulmnHeader I want the selection to be multi select so they can select one or more, contiguous or non contiguous rows for copying into Excel.
Lastly, if they click in the upper left hand corner I want to select the entire spread for copying. Any suggestions on how best to implement these different situations?