Natural input for spreadsheet actions

Patent metadata

Field	Value
Publication number	US-10732825-B2
Application number	US-201715637788-A
Country	US
Kind code	B2
Filing date	Jun 29, 2017
Priority date	Jan 7, 2011
Publication date	Aug 4, 2020
Grant date	Aug 4, 2020

Abstract

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.

First claim

What is claimed is:

1. A method for interacting with a spreadsheet, comprising:
receiving an indication to change a view of the spreadsheet, wherein the indication includes an indication to perform an operation including one or more of:
a zoom out operation with respect to the spreadsheet in response to moving a touch input device in a first direction, and
a zoom in operation with respect to the spreadsheet in response to moving the touch input device in a second direction, and
wherein the zoom out operation and the zoom in operation slow at one or more predetermined locations within the spreadsheet, wherein the one or more predetermined locations are automatically prepositioned within the spreadsheet based at least in part on an arrangement of data within the spreadsheet; and

updating a display of the spreadsheet.

2. The method of claim 1 , wherein the indication to change the view of the spreadsheet is a gesture received on the touch input device.

3. The method of claim 2 , wherein the gesture comprises one of:
a karate chop gesture,
a chart gesture,
a comment gesture,
a grip gesture,
a gesture within a gesture box, and
a sort gesture.

4. The method of claim 3 , wherein a different operation is performed based on the gesture.

5. The method of claim 4 , wherein the different operation comprises one of:
in response to receiving the karate chop gesture on the spreadsheet, inserting at least one of a row and a column in the spreadsheet near a location of the karate chop gesture;
in response to receiving the chart gesture, inserting at least one of: a trend line on a displayed chart in the spreadsheet and a chart in the spreadsheet;
in response to receiving the comment gesture, displaying a comment box to receive a comment at a location near a received gesture location;
in response to receiving the gesture within the gesture box, determining a gesture command from the gesture and performing the gesture command on the data within the spreadsheet; and
in response to receiving the sort gesture, sorting at least a portion of data within the spreadsheet.

6. The method of claim 5 , wherein performing a gesture command further comprises:
displaying a vortex animation in response to a cut command or in response to a paste command.

7. The method of claim 1 , further comprising:
receiving sensor information, wherein the sensor information comprises accelerometer data used to change the view of the spreadsheet.

8. The method of claim 7 , wherein the accelerometer data is used to perform one or more of the zoom out operation and the zoom in operation.

9. The method of claim 1 , further comprising:
in response to performing the zoom out operation, displaying a thumbnail for each sheet within a workbook associated with the spreadsheet when a zoom level exceeds a threshold.

10. A computer system, comprising:
at least one processor; and
at least one memory storing computer-executable instructions that when executed by the at least one processor cause the computer system to:
receive an indication to change a view of a spreadsheet, wherein the indication includes an indication to perform an operation including one or more of:
a zoom out operation with respect to the spreadsheet in response to moving a touch input device in a first direction, and
a zoom in operation with respect to the spreadsheet in response to moving the touch input device in a second direction,
wherein the zoom out operation and the zoom in operation slow at one or more predetermined locations within the spreadsheet, wherein the one or more predetermined locations are automatically prepositioned within the spreadsheet based at least in part on an arrangement of data within the spreadsheet; and

update a display of the spreadsheet.

11. The computer system of claim 10 , wherein the indication to change the view of the spreadsheet is the gesture received on a touch input device.

12. The computer system of claim 11 , wherein a different operation is performed based on the gesture.

13. The computer system of claim 10 , the computer-executable instructions further causing the computer system to:
receive sensor information, wherein the sensor information comprises accelerometer data used to change the view of the spreadsheet.

14. The computer system of claim 13 , wherein the accelerometer data is used to perform one or more of the zoom out operation and the zoom in operation.

15. The computer system of claim 10 , the computer-executable instructions further causing the computer system to:
in response to performing the zoom out operation, display a thumbnail for each sheet within a workbook associated with the spreadsheet when a zoom level exceeds a threshold.

16. A computer storage medium comprising computer-executable instructions that when executed by a processor cause the processor to:
receive an indication to change a view of a spreadsheet, wherein the indication includes an indication to perform an operation including one or more of:
a zoom out operation with respect to the spreadsheet in response to moving a touch input device in a first direction, and
a zoom in operation with respect to the spreadsheet in response to moving the touch input device in a second direction,
wherein the zoom out operation and the zoom in operation slow at one or more predetermined locations within the spreadsheet, wherein the one or more predetermined locations are automatically prepositioned within the spreadsheet based at least in part on an arrangement of data within the spreadsheet; and

update a display of the spreadsheet.

17. The computer storage medium of claim 16 , wherein the indication to change the view of the spreadsheet is a gesture received on the touch input device.

18. The computer storage medium of claim 17 , wherein a different operation is performed based on the gesture.

19. The computer storage medium of claim 16 , the computer-executable instructions further causing the processor to:
receive sensor information, wherein the sensor information comprises accelerometer data used to change the view of the spreadsheet.

20. The computer storage medium of claim 19 , wherein the accelerometer data is used to perform one or more of the zoom out operation and the zoom in operation.

Assignees

• Microsoft Technology Licensing Llc

Inventors

• Campbell John
• Lin Amy
• Waldman Lawrence
• Der Sherman
• Cheng Karen
• Doan Christopher
• Constantine Thomas
• Rothschiller Chad
• Ma Yun

Classifications

• G06F2203/04806

  Zoom, i.e. interaction techniques or interactors for controlling the zooming operation · CPC title

• G06F3/0485

  Scrolling or panning · CPC title

• G06F40/18

  of spreadsheets (form-filling G06F40/174) · CPC title

• G06F2200/1614

  Image rotation following screen orientation, e.g. switching from landscape to portrait mode · CPC title

• G06F3/04845

  for image manipulation, e.g. dragging, rotation, expansion or change of colour · CPC title