It would be useful to have a table/view current presentation object (
CurrentPresentation) exposed in the formula editor.
The context of
CurrentPresentation could be either the view name (for calcs outside of the view) or
thisView (for calcs within the view) – thus it could be different on each of the many different views of a table. It could hold the current modifications to the table/view list of rows (sort, filter, group, etc).
thisView.CurrentPresentation.Find(thisRow).IsOdd() --> blue
thisView.CurrentPresentation.Find(thisRow).IsEven() --> grey
MANY use cases would be made trivial by storing view presentation configurations in an object accessible via formula.
I’m constantly having to replicate the presentation configuration of a given view into a variable some place in order to do something. But it’s painful because it’s not linked to the actual configuration held by the view itself – so if the actual configuration changes, it breaks the functionality built on the hard-coded replication.
This is a ubiquitous design pattern for me, and I’m sure it would be for many others also, if it required less overhead to set up and maintain.
It could hold the current modifications to the table/view list of rows (sort, filter, group, etc).
This list could just be a property on each table/view.