Spreadsheet Cell Insertion Deletion via Touch Gesture Recognition
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current spreadsheet software on touch screen devices requires complex multi-step operations for inserting or deleting cells, rows, and columns, making quick and visual operations difficult to perform.
Innovation Solution
A method and device that utilize touch and click information, along with gesture recognition, to determine the target and type of operation, allowing for simplified insertion or deletion of cells, rows, or columns by analyzing touch point movements on a touch screen.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If traditional multi-step operations are used for inserting or deleting cells, rows, or columns in spreadsheet software on touch screen devices, then the operation reliability is maintained, but the ease of operation deteriorates and the productivity decreases
Solution Approach 1:
The patent replaces traditional mechanical keyboard operations (Ctrl+C, Ctrl+V, menu selections) with touch screen gesture operations. Users can directly touch, drag, and drop cells, rows, or columns on the touch screen to perform insertion and deletion operations, eliminating the need for complex multi-step keyboard commands and menu navigation.
Solution Approach 2:
The system automatically detects touch gestures and interprets user intent to perform the appropriate operation. When a user drags a cell or selection across the screen, the system automatically determines whether to insert or delete based on the gesture pattern, eliminating the need for users to manually select operation types from menus.
2Productivity
If traditional multi-step operations are used for inserting or deleting cells, rows, or columns in spreadsheet software on touch screen devices, then the operation reliability is maintained, but the productivity deteriorates
Solution Approach 1:
The system prepares the spreadsheet data structure in advance to facilitate quick insertion and deletion operations. When a user performs a drag gesture, the system has pre-configured the data models and event handlers ready to execute the operation immediately, rather than requiring sequential menu navigation and confirmation steps.
Solution Approach 2:
The patent enables users to skip traditional intermediate steps (menu selection, confirmation dialogs, multiple clicks) by using direct touch gestures. A single drag gesture can complete an insertion or deletion operation that previously required multiple sequential steps, significantly reducing operation time.
3Ease of operation
If gesture recognition is implemented for insertion and deletion operations on touch screen devices, then the ease of operation improves and productivity increases, but the device complexity increases
Solution Approach 1:
The patent divides the touch screen interface into distinct operational zones and segments different gesture types (tap, drag, long-press) to trigger different operations. Each cell, row, and column is segmented as an independent selectable unit, allowing the system to process simple, discrete gesture events rather than requiring complex overall gesture interpretation.
Solution Approach 2:
The touch screen interface is designed to handle multiple operations (selection, insertion, deletion, movement) through a universal gesture recognition system. The same touch interface mechanisms are used for various spreadsheet operations, reducing the need for separate specialized controls and simplifying the overall system architecture.
Data Source
AI summary
Disclosed is a method for inserting or deleting cells, rows or columns in a spreadsheet, comprising: obtaining touch and click information on a touch screen; determining target cells or target rows or columns; obtaining moving information about a touch point on the touch screen; according to a preset logic for judging operation type, judging that the operation to be performed is an insertion operation or a deletion operation; and determining locations and number of cells, rows or columns to be inserted or deleted, and performing an insertion or deletion operation. In addition, also disclosed is a device for inserting or deleting cells, rows or columns in a spreadsheet, including: an information acquisition module, a target determination module, an operation type judgment module and an operation execution module. The method and device in the present invention can simplify the operation in a spreadsheet in a gesture identification manner, to quickly and visually insert or delete cells, rows or columns, and increase efficiency.