SYSTEMS WITH GESTURE-BASED EDITING OF TABLES

• US 20120013539A1
• Filed: 07/13/2010
• Published: 01/19/2012
• Est. Priority Date: 07/13/2010
• Status: Abandoned Application

• Current Assignee: Apple Inc.
• Original Assignee: Apple Inc.
• Inventors: Hogan, Edward P.A., Lehrian, Matthew
• Application Number:
  US12/835,697
• Publication Number:
  US 20120013539A1
• Time in Patent Office: Days
• US Class Current: 345/173
• CPC Class Codes: G06F 3/04883 for inputting data by handwriting, e.g. gesture or text
• CPC Class Codes: G06F 40/177 of tables; using ruled lines
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

Computing equipment such as devices with touch screen displays and other touch sensitive equipment may be used to display tables of data to a user. The tables of data may contain rows and columns. Touch gestures such as tap and flick gestures may be detected using the touch screen or other touch sensor. In response to a detected tap such as a tap on a row or column header, the computing equipment may select and highlight a corresponding row or column in a displayed table. In response to a flick gesture in a particular direction, the computing equipment may move the selected row or column to a new position within the table. For example, if the user selects a particular column and supplies a right flick gestures, the selected column may be moved to the right edge of a body region in the table.

Claims

1. Computing equipment, comprising:

a display on which a table of data is displayed;

a touch sensor array that detects touch gestures from a user including tap gestures and flick gestures; and

storage and processing circuitry that is configured to select a row or column of the table of data in response to a detected tap gesture and that is configured to move the selected row or column in response to a detected flick gesture.

2. The computing equipment defined in claim 1 wherein the display and touch sensor array are part of a touch screen, wherein the row or column contains a header and wherein the storage and processing circuitry is configured to select the row or column in response to the detected tap gesture when the detected tap gesture is made on a portion of the touch screen containing the header.

3. The computing equipment defined in claim 2 wherein the tap gesture is a single tap gesture and wherein the storage and processing circuitry is configured to select the row or column in response to the single tap gesture.

4. The computing equipment defined in claim 3 wherein the flick gesture is a single flick gesture and wherein the storage and processing circuitry is configured to move the selected row or column on the display in response to the single flick gesture.

5. The computing equipment defined in claim 4 wherein the storage and processing circuitry is configured to update row and column position data in storage when moving the row or column in response to the single flick gesture.

6. The computing equipment defined in claim 4 wherein the table contains a table body region and empty cells and wherein the storage and processing circuitry is configured to move the selected row or column to an edge of the table body region adjacent to the empty cells in response to the single flick gesture.

7. The computing equipment defined in claim 4 wherein the table contains a table body region and empty cells and wherein the storage and processing circuitry is configured to move the selected row or column to an edge of the table that is different from any edge in the table body region, so that at least some of the empty cells are interposed between the moved row or column and the edge of the table body region.

8. A method, comprising:

with computing equipment, displaying a table of data containing rows and column;

with a touch sensor array in the computing equipment, detecting a tap gesture and a flick gesture supplied by a user; and

in response to detecting the tap gesture, selecting a row or column in the table using the computing equipment; and

in response to detecting the flick gesture, moving the selected row or column within the table using the computing equipment.

9. The method defined in claim 8 wherein displaying the table comprises displaying the table on a touch screen display within the computing equipment and wherein selecting the row or column comprises highlighting the selected row or column on a display in response to detection of the tap gesture.

10. The method defined in claim 9 wherein the table comprises a body region having cells filled with data and comprises empty cells and wherein moving the selected row or column comprises moving data from the body region to an edge portion of the body region adjacent to the empty cells.

11. The method defined in claim 10 wherein the flick gesture comprises a single left flick gesture and wherein moving the selected row or column comprises moving a selected column to a left edge of the body region.

12. The method defined in claim 11 wherein the flick gesture comprises a downwards flick gesture and wherein moving the selected row or column comprises moving a selected row to a lower edge of the body region.

13. The method defined in claim 10 wherein moving the selected row or column comprises moving the selected row or column in response to a single flick gesture selected from the group of flick gestures consisting of:

a left flick, a right flick, an upwards flick, and a downwards flick.

14. The method defined in claim 9 wherein moving the selected row or column comprises updating row or column position information in storage in response to the detected flick gesture.

15. The method defined in claim 14 wherein the storage is located at a server and wherein updating the row or column position information comprises transmitting updated row or column position information from a client to a server over a communications network.

16. The method defined in claim 9 wherein displaying the table comprises displaying the table on the touch screen display with a spreadsheet application implemented on the computing equipment and wherein moving the selected row or column comprises updating a database using the spreadsheet application.

17. The method defined in claim 9 wherein displaying the table comprises displaying the table on the touch screen display with an operating system implemented on the computing equipment and wherein moving the selected row or column comprises moving a column associated with a particular data attribute using the operating system.

18. The method defined in claim 9 wherein displaying the table comprises displaying the table on the touch screen display with a music creation application implemented on the computing equipment and wherein moving the selected row or column comprises moving a selected track between rows in the table using the music creation application.

19. Computing equipment, comprising:

a touch screen display that contains a touch sensor; and

storage and processing circuitry with which a table of data is displayed on the touch screen display, wherein the storage and processing circuitry is configured to detect touch gestures using the touch sensor and is configured to rearrange the table of data in response to detection of a tap and flick gesture.

20. The computing equipment defined in claim 19 wherein the tap and flick gesture comprises a single tap on a header in the table that selects a portion of the table for movement and wherein the tap and flick gesture comprises a single isolated flick in a direction that indicates which direction to move the selected portion of the table.

21. The computing equipment defined in claim 20 wherein the selected portion comprises a selected row or column of the table, wherein the storage and processing circuitry is configured to highlight the selected row or column in response to detection of the tap on the header, and wherein the storage and processing circuitry is configured to display a manipulated version of the table of data on the touch screen display in response to detection of the flick gesture.