Gesture-Based Spreadsheet Interaction on Mobile Devices
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Interacting with large spreadsheets on small screen devices, such as cell phones or tablets, is often difficult and tedious due to limitations in current input methods.
Innovation Solution
The use of gestures and sensor information, processed by a gesture manager, to interact with spreadsheets on computing devices, allowing users to perform actions like scrolling, zooming, and data manipulation through device movements and tilts, rather than relying solely on traditional input devices.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If traditional input devices (mice, keyboards, touch screens) are used to interact with large spreadsheets on small screen devices, then the device can display spreadsheet data, but the interaction becomes difficult and tedious
Solution Approach 1:
The patent replaces traditional mechanical input devices (mice, keyboards, touch screens) with gesture-based interaction using the device's motion sensors and accelerometer. Users perform gestures by moving the device physically (e.g., tilting, rotating, shaking) to manipulate spreadsheet data, eliminating the need for precise manual操作中 of small on-screen controls and significantly improving interaction efficiency on mobile devices.
2Quantity of substance
If the spreadsheet is made larger to accommodate more data, then more information can be displayed, but the device screen size limits the visible area
Solution Approach 1:
The patent introduces temporal and motion dimensions to the traditional two-dimensional spreadsheet interface. By incorporating gesture recognition and device motion detection, users can navigate large spreadsheets through three-dimensional physical movements (tilting, rotating, shaking the device), effectively adding a new dimension for data access that overcomes the limited screen real estate while maintaining access to extensive datasets.
3Adaptability or versatility
If more input controls are added to the interface to enable more spreadsheet operations, then functionality increases, but the interface becomes more complex and harder to use on small screens
Solution Approach 1:
The patent implements a universal gesture system where a single set of physical device movements can perform multiple spreadsheet operations. Different gestures (tilting in various directions, rotating, shaking, holding at specific angles) map to different spreadsheet functions (navigation, filtering, sorting, selecting), allowing one input mechanism to replace numerous separate controls and buttons, thereby maintaining high functionality while minimizing interface complexity.
Data Source
AI summary
Different gestures and actions are used to interact with spreadsheets. The gestures are used in manipulating the spreadsheet and performing other actions in the spreadsheet. For example, gestures may be used to move within the spreadsheet, select data, filter, sort, drill down/up, zoom, split rows/columns, perform undo/redo actions, and the like. Sensors that are associated with a device may also be used in interacting with spreadsheets. For example, an accelerometer may be used for moving and performing operations within the spreadsheet.