I'm trying to create the appearance of a column selection but need the selection mode to be single as I only want only one column to be selected at any time (and preferably also so that certain columns cannot be selected)
If I allow extended selection the user can select multiple cells using mouse or keyboard and I have to deal with it after the fact, and programmatically fixing selection also trigger SelectionChanged events..
I am aware of the FAQ entry about column selection, but it doesn't really cut it for me for several reasons.
1) I want the user to be able to select by clicking anywhere in the column, not just the header. This can be worked around.
2) I cannot programmatically select multiple cells with SelectionMode=Single.
How can I achiveve the desired effect?