column selection with SelectionMode=Single

Mar 24, 2009 at 6:50 AM
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?