Device, method, and graphical user interface for manipulating tables using multicontact gestures

Abstract

An electronic device having a display and a touch-sensitive surface, displays a table having a plurality of rows, a plurality of columns, and a plurality of cells. The device detects a gesture on the touch-sensitive surface that includes movement of one or more of a first contact and a second contact. When the detected gesture is a pinch gesture at a location that corresponds to one or more respective columns in the table and has a component that is perpendicular to the one or more respective columns, the device decreases the width of the one or more respective columns. When the detected gesture is a de-pinch gesture at a location that corresponds to one or more respective columns in the table and has a component that is perpendicular to the one or more respective columns, the device increases the width of the one or more respective columns.

1 - 20 . (canceled) 
     
     
         21 . A method, comprising:
 at an electronic device with a display and a touch-sensitive surface:
 displaying a table comprising a plurality of rows and a plurality of columns, wherein each column includes a column header and a plurality of cells; 
 detecting a first contact at a location on the touch-sensitive surface that corresponds to a first column in the plurality of columns; 
 detecting a first gesture on the touch-sensitive surface, wherein the first gesture includes movement of the first contact in a direction on the touch-sensitive surface that corresponds to a direction on the display that is along the first column; and, 
 in response to detecting the first gesture, sorting the first column based on content of the cells in the first column. 
   
     
     
         22 . The method of  claim 21 , wherein:
 when the first gesture is in a first direction, the sorting is in accordance with a first sort order; and   when the first gesture is in a second direction that is opposite the first direction, the sorting is in accordance with a second sort order, wherein the second sort order is the opposite of the first sort order.   
     
     
         23 . The method of  claim 21 , including, in response to detecting the first gesture, sorting all of the rows of the table based on the content of the cells in the first column. 
     
     
         24 . The method of  claim 21 , wherein:
 a respective row of the plurality of rows has an initial location;   the respective row includes a respective cell that is in the first column; and   displaying an animation of the respective row moving from the initial location to a final location that is determined based on a location of the respective cell in the first column after the first column has been sorted.   
     
     
         25 . The method of  claim 24 , wherein the animation is displayed in response to detecting the first gesture moving over the respective cell. 
     
     
         26 . The method of  claim 21 , wherein sorting the first column includes sorting the first column based on a first criteria, and the first criteria is automatically determined based on a type of the content of the cells in the first column. 
     
     
         27 . The method of  claim 21 , wherein the sorting of the first column is performed only when the first gesture includes movement greater than a predefined threshold. 
     
     
         28 . The method of  claim 21 , wherein the first contact is initially detected at a location of the touch-sensitive surface that corresponds to a column header for the first column. 
     
     
         29 . The method of  claim 21 , wherein sorting the first column based on the content of the cells in the first column includes sorting the first column in accordance with a first sort order, the method including:
 detecting a second contact on the touch-sensitive surface at a location that corresponds to the first column;   detecting a second gesture on the touch-sensitive surface, wherein the second gesture includes movement of the second contact in a first direction on the touch-sensitive surface that corresponds to a direction on the display that is along the first column, and subsequent movement of the second contact in a second direction on the touch-sensitive surface that is substantially opposite the first direction; and,   in response to detecting the second gesture, re-sorting the first column based on the content of the cells in the first column in accordance with a second sort order, wherein the second sort order is opposite the first sort order.   
     
     
         30 . An electronic device, comprising:
 a display;   a touch-sensitive surface;   one or more processors;   memory; and   one or more programs, wherein the one or more programs are stored in the memory and configured to be executed by the one or more processors, the one or more programs including instructions for:   displaying a table comprising a plurality of rows and a plurality of columns, wherein each column includes a column header and a plurality of cells;   detecting a first contact at a location on the touch-sensitive surface that corresponds to a first column in the plurality of columns;   detecting a first gesture on the touch-sensitive surface, wherein the first gesture includes movement of the first contact in a direction on the touch-sensitive surface that corresponds to a direction on the display that is along the first column; and,   in response to detecting the first gesture, sorting the first column based on content of the cells in the first column.   
     
     
         31 . The device of  claim 30 , wherein:
 when the first gesture is in a first direction, the sorting is in accordance with a first sort order; and   when the first gesture is in a second direction that is opposite the first direction, the sorting is in accordance with a second sort order, wherein the second sort order is the opposite of the first sort order.   
     
     
         32 . The device of  claim 30 , including, in response to detecting the first gesture, sorting all of the rows of the table based on the content of the cells in the first column. 
     
     
         33 . The device of  claim 30 , wherein:
 a respective row of the plurality of rows has an initial location;   the respective row includes a respective cell that is in the first column; and   displaying an animation of the respective row moving from the initial location to a final location that is determined based on a location of the respective cell in the first column after the first column has been sorted.   
     
     
         34 . The device of  claim 33 , wherein the animation is displayed in response to detecting the first gesture moving over the respective cell. 
     
     
         35 . The device of  claim 30 , wherein sorting the first column includes sorting the first column based on a first criteria, and the first criteria is automatically determined based on a type of the content of the cells in the first column. 
     
     
         36 . The device of  claim 30 , wherein the sorting of the first column is performed only when the first gesture includes movement greater than a predefined threshold. 
     
     
         37 . The device of  claim 30 , wherein the first contact is initially detected at a location of the touch-sensitive surface that corresponds to a column header for the first column. 
     
     
         38 . The device of  claim 30 , wherein sorting the first column based on the content of the cells in the first column includes sorting the first column in accordance with a first sort order, the method including:
 detecting a second contact on the touch-sensitive surface at a location that corresponds to the first column;   detecting a second gesture on the touch-sensitive surface, wherein the second gesture includes movement of the second contact in a first direction on the touch-sensitive surface that corresponds to a direction on the display that is along the first column, and subsequent movement of the second contact in a second direction on the touch-sensitive surface that is substantially opposite the first direction; and,   in response to detecting the second gesture, re-sorting the first column based on the content of the cells in the first column in accordance with a second sort order, wherein the second sort order is opposite the first sort order.   
     
     
         39 . A computer readable storage medium storing one or more programs, the one or more programs comprising instructions, which when executed by an electronic device with a display and a touch-sensitive surface, cause the device to:
 display a table comprising a plurality of rows and a plurality of columns, wherein each column includes a column header and a plurality of cells;   detect a first contact at a location on the touch-sensitive surface that corresponds to a first column in the plurality of columns;   detect a first gesture on the touch-sensitive surface, wherein the first gesture includes movement of the first contact in a direction on the touch-sensitive surface that corresponds to a direction on the display that is along the first column; and,   in response to detecting the first gesture, sort the first column based on content of the cells in the first column.   
     
     
         40 . A graphical user interface on an electronic device with a display, a touch-sensitive surface, a memory, and one or more processors to execute one or more programs stored in the memory, the graphical user interface comprising:
 a table comprising a plurality of rows and a plurality of columns, wherein each column includes a column header and a plurality of cells;   wherein:
 a first contact is detected at a location on the touch-sensitive surface that corresponds to a first column in the plurality of columns; 
 a first gesture is detected on the touch-sensitive surface, wherein the first gesture includes movement of the first contact in a direction on the touch-sensitive surface that corresponds to a direction on the display that is along the first column; and, 
 in response to detecting the first gesture, the first column is sorted based on content of the cells in the first column.