pleroma.debian.social

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.
replies
1
announces
0
likes
0

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)

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