You cannot highlight cells and see the total in Spreadsheet in OneStream. Is this on the radar? Is there a way to get a subtotal without using the Sum function?

We were talking with the users how OS is meant to replace their current Excel model and the lady raised her hand and said ""OS can't highlight 2 numbers and add them, how can it replace our Excel model?"".
In addition to not being able to 'paste special'' just formulas, we cannot do other 'paste special' options - I often want to transpose what I'm pasting, (shifting stuff from rows to columns). Is there a way to do this in our Excel? Also - similar to the highlighting 2 cells for a subtotal - you cannot use arrow keys to navigate a formula, (like + 2 cells up times 2 cells over) - you have to type the cell refs not navigate to them. (Sorry - as a tax person I'm a BIG Excel navigator!!)