The iOS Google Sheets app is a prime example of “if you must, it’s possible” app design. Apple’s Numbers app is slightly better, but still requires you to scroll in two dimensions. I’ve not seen a truly-mobile friendly spreadsheet app yet.
Design notes for a mobile-native spreadsheet
Focus on ease of authorship of new spreadsheets, not interacting with existing/legacy ones
re: Design notes for a mobile-native spreadsheet
One column view. Swipe L-R (with generous deadzones) to switch column. Optional fixed 1 row and/or column display for headings. Free scroll U-D for cells in column.
re: Design notes for a mobile-native spreadsheet
100% Visual/block-based formula programming. Obvious stuff (average column, sum column) built into UI eg on on-screen keyboard shortcut keys
re: Design notes for a mobile-native spreadsheet
Smart on-screen keyboard choices. Numbers only for numbers fields etc (Apple Numbers does this well)
- replies
- 2
- announces
- 0
- likes
- 1
re: Design notes for a mobile-native spreadsheet
Lots of live data integrations. Fetch price from product uri for big shops like Amazon eBay, currency conversions, etc