Mobile Spreadsheet Deck and Card Views
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Viewing and editing spreadsheets on mobile devices are cumbersome due to limited display capacity, requiring extensive scrolling and increasing the likelihood of errors.
Innovation Solution
The implementation of deck and card views for spreadsheets on mobile devices, allowing users to display and edit data in a more organized and user-friendly format, with options for customization and easy transitions between views.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Loss of information
If a spreadsheet is displayed on a mobile device in traditional grid format, then all data is available, but the display becomes cumbersome requiring extensive scrolling in multiple directions
Solution Approach 1:
The spreadsheet is segmented into individual row objects that can be displayed vertically one after another. Each row object contains the complete data for one row across multiple columns, allowing users to scroll through rows sequentially rather than navigating a complex grid. This segmentation transforms the traditional 2D grid into a series of discrete, manageable units that fit mobile display constraints.
Solution Approach 2:
The patent changes the display dimensionality by organizing spreadsheet data primarily in a vertical sequence of row objects rather than maintaining the traditional horizontal-grid layout. This dimensional reorganization allows data to be accessed by scrolling through rows vertically, which is more suitable for mobile device screens with limited horizontal space but adequate vertical scrolling capability.
2Quantity of substance
If a spreadsheet is displayed on a mobile device with limited screen space, then the entire dataset can be stored, but users cannot appreciate the size of the spreadsheet
Solution Approach 1:
The system performs preliminary action by providing a preview or summary indicator that shows the total number of rows or the extent of the spreadsheet data before the user commits to viewing the entire dataset. This allows users to understand the scale of the spreadsheet at a glance without having to scroll through all rows, maintaining context about data volume while adapting to mobile display limitations.
3Adaptability or versatility
If editing is enabled on a mobile device spreadsheet, then data can be modified, but mistakes become easy to make due to the cumbersome interface
Solution Approach 1:
Editing functionality is segmented and applied at the individual row object level rather than requiring users to navigate and select cells within a grid context. Each row object can be independently selected and edited, reducing the complexity of editing operations and minimizing the risk of accidental edits to wrong cells. This segmented approach simplifies the editing interface while maintaining full editing capability.
Data Source
AI summary
The present disclosure provides a novel approach to displaying spreadsheets on mobile devices (e.g., cell phones, tablets, etc.) so that they are more easily viewable by the user. Aspects of the present disclosure provide multiple different views of a spreadsheet and simple transitions among those views. The multiple views facilitate the display of important aspects of a spreadsheet and optimize the spreadsheet viewing area. In particular, deck and card views are disclosed, wherein each view corresponds to a different display format of the spreadsheet. Furthermore, editing the spreadsheet data is also provided within these views.