There has been much discussion on the Sheet pane and it seems there are some workarounds out there i just don't remember them.
2) The popup input for formulas can be resized- that is, as long as you want to make it. Another step but you will have what yoyo had before. You can also drag it about by grabbing that little dot.
Once you have single clicked on a cell, the contents of that cell are displayed along the bottom of the window. Double click on a cell with a formula in it and the results of the formula are diplayed there. This is updated as you change the formula. That is nice.
<softly into the corner> You can have some of what you are used to.