I implemented a big grid with tons of columns. I have 9 columns pinned to the left and over 60 on the right. When I scroll to the right, Single cell selection works fine on pinned cells but multi selection with left-click and drag selects non pinned cells behind the pinned ones instead of selecting the pinned cells.
I am looking for the end results to be as close as possible as Excel’s Freeze Column functionality. I would like to be able to select the far right pinned column with the last showing non pinned column on the left while using Drag-Selection.
I know there is probably no built-in solution, but any clue would help.