Eui: [EuiDataGrid] Allow sticky columns

[pickypg]

I got some feedback on a particularly wide usage of data grid where some people would like to lock some columns so that when they are forced to horizontally scroll, they get the column(s) that they're most interested in stuck on the screen.

I assume that the same applies to a sticky row in the same way that spreadsheets support both directions.

[chandlerprall]

👍Sticky columns & rows is on the feature list, but hasn't yet been roadmapped / planned.

[kertal]

@chandlerprall think we need also a a sticky column for Discover. in case there's a time column, it's always first and shouldn't be moveable. the horizontally scrolling feature would be nice, but not necessary for the initial use case

[chandlerprall]

For completeness, @kertal and I talked on Slack about this being a blocker for Discover. The hard requirements will be given some more thought first. While sticky columns is on the list, getting development time against it is the harder part right now so the smallest set of requirements will be much faster to implement. This can provide a good opportunity to start developing an API without building out the entire interaction - e.g. programmatically define a sticky column but don't give the user any menus for managing, etc.

[kertal]

FYI @chandlerprall, found a solution for Discover, no more potential blocker it is:

https://github.com/elastic/kibana/pull/67259#issuecomment-641903996

[github-actions[bot]]

👋 Hey there. This issue hasn't had any activity for 180 days. We'll automatically close it if that trend continues for another week. If you feel this issue is still valid and needs attention please let us know with a comment.

[pickypg]

Still needed.