Improve formula bar UX

[pladams9]

• Remove in-cell editing
• Double-clicking or hitting Enter opens editing mode and puts the focus in the formula bar
• Hitting Enter in the formula bar exits editing mode and saves the formula
• Hitting Esc in the formula bar exits editing mode and reverts to the previous formula
• Double-clicking the sheet closes editing mode
• Clicking in formula bar starts editing mode and activates small Save/Cancel buttons
• Clicking the sheet during editing mode adds cell addresses to formula

[pladams9]

Currently, the formula bar doesn't work the way that it does in Excel or other spreadsheet programs.

• There isn't any differentiation between editing in the cell or editing in the formula bar.
• Selecting a cell immediately puts the cursor at the end of cell contents (in the "hidden" entry). Typing doesn't replace as in Excel, but rather appends.

Does this have to work the way other programs do though? Since range selection will likely be very different (#5), and formula syntax is fairly different, maybe it's possible to break from the mold. Perhaps this means a more overt editing mode.

• No in-cell editing.
• Double-clicking or hitting Enter (or Space?) will open editing mode and put the focus in the formula bar.
• Hitting Enter in the formula bar exit editing mode, "save" the formula and recalculate the sheet.
• Clicking the sheet during editing mode would select ranges.
• A small Edit/Done Editing button (symbols) next to the formula box would also open/close editing mode.
• Perhaps double-clicking the sheet could close editing mode?

[pladams9]

Esc would of course be another option for exiting edit mode.