Method for inserting or deleting cells, rows or columns in spreadsheet and a device therefor

1. A method for inserting or deleting cells, rows or columns in a spreadsheet, characterized in that the method comprises the steps of:

obtaining touch and click information of more than one touch points present on a touch screen;

determining target rows or columns of cells according to touch and click locations on the touch screen;

obtaining moving information about the touch points on the touch screen;

judging that an operation to be performed is an insertion operation or a deletion operation according to said moving information about the touch points on the touch screen and a preset logic for determining operation type; and

determining locations and number of rows or columns to be inserted or deleted according to a result of the judging step and a displacement of the touch points included in said moving information about the touch points on the touch screen, and performing said insertion or deletion operation,

wherein determining target rows or columns of cells according to touch and click locations on the touch screen comprises:

generating a screenshot of rows or columns to be moved based on the touch and click locations on the touch screen if two touch points are present on the touch screen and moving the screenshot in real time according to the locations of the touch points; and

setting a first mode for inserting/deleting a row in which only a vertical displacement of fingers is calculated or a second mode for inserting/deleting a column in which only a horizontal displacement of the fingers is calculated according to an actual location of the screenshot,

wherein the setting the first mode for inserting/deleting the row or the second mode for inserting/deleting the column according to an actual location of the screenshot comprises: in the case that a current mode is the first mode for inserting/deleting a row, in responding to the vertical displacement of the screenshot being smaller than a certain rated value and the horizontal displacement of the screenshot being larger than the certain rated value relative to a original location of the screenshot, switching the current mode to the second mode for inserting/deleting a column; and in the case that the current mode is the second mode for inserting/deleting a column, in responding to the vertical displacement of the screenshot being larger than the certain rated value and the horizontal displacement of the screenshot being smaller than the certain rated value relative to the original location of the screenshot, switching the current mode to the first mode for inserting/deleting the row.

2. The method for inserting or deleting cells, rows or columns in a spreadsheet according to claim 1 , characterized in that, the step of determining target rows or columns includes the step of:

determining target rows or columns according to touch and click locations on the touch screen, if a touch and click duration on the touch screen exceeds a preset duration.

3. The method for inserting or deleting cells, rows or columns in a spreadsheet according to claim 1 , characterized in that, the preset logic for determining operation type comprises:

judging the moving direction of the touch points on the touch screen according to said moving information about the touch point on the touch screen; and

judging that the operation to be performed is an insertion operation or a deletion operation according to said moving direction of the touch points on the touch screen.

4. The method for inserting or deleting cells, rows or columns in a spreadsheet according to claim 3 , characterized in that, judging that the operation to be performed is an insertion operation or a deletion operation according to said moving direction of the touch points on the touch screen comprises the steps of:

judging that the operation to be performed is an insertion operation if said moving direction of the touch points on the touch screen is rightward or downward; and

judging that the operation to be performed is a deletion operation if said moving direction of the touch points on the touch screen is leftward or upward.

5. The method for inserting or deleting cells, rows or columns in a spreadsheet according to claim 3 , characterized in that, after the two steps of determining target rows or columns of cells according to said touch and click information on the touch screen and judging that the operation to be performed is an insertion operation or a deletion operation according to said moving direction of the touch points on the touch screen, the method comprises the steps of:

determining the locations and number of the rows to be inserted or deleted and performing corresponding insertion or deletion operation if said moving direction of the touch points on the touch screen is upward or downward; and

determining the locations and number of the columns to be inserted or deleted and performing corresponding insertion or deletion operation if said moving direction of the touch points on the touch screen is leftward or rightward.

6. A device comprising: a processor and a memory, wherein a plurality of executable modules including an information acquisition module, a target determination module, an operation type judgment module and an operation execution module are stored in the memory, which are executable by the processor to insert or delete cells, rows or columns in a spreadsheet; wherein,

the information acquisition module is executed to obtain touch and click information and moving information about a touch point on a touch screen;

the target determination module is executed to judge whether more than one touch point is present on the touch screen, wherein when only one touch point is present on the touch screen the target determination module is further executed to determine target cells according to said touch and click information on the touch screen, and when more than one touch point is present on the touch screen, the target determination module is executed to determine target rows or columns of cells according to touch and click locations on the touch screen;

the operation type judgment module is executed to judge that the operation to be performed is an insertion operation or a deletion operation according to said moving information about the touch point on the touch screen and a preset logic for determining operation type; and

the operation execution module is executed to determine locations and number of cells to be inserted or deleted, or locations and number of rows or columns to be inserted or deleted according to a judgment result from the operation type judgment module and a displacement of the touch point included in said moving information about the touch point on the touch screen, and to perform corresponding insertion or deletion operation, and

wherein the target determination module is further executed to:

generate a screenshot of rows or columns to be moved based on the touch and click locations on the touch screen when two touch points are present on the touch screen and move the screenshot in real time according to the locations of the touch points; and

set a first mode for inserting/deleting a row in which only a vertical displacement of fingers is calculated or a second mode for inserting/deleting a column in which only a horizontal displacement of the fingers is calculated according to an actual location of the screenshot,

wherein the target determination module is further executed to: in the case that a current mode is the first mode for inserting/deleting a row, in responding to the vertical displacement of the screenshot being smaller than a certain rated value and the horizontal displacement of the screenshot being larger than the certain rated value relative to a original location of the screenshot, switch the current mode to the second mode for inserting/deleting a column; and in the case that the current mode is the second mode for inserting/deleting a column, in responding to the vertical displacement of the screenshot being larger than the certain rated value and the horizontal displacement of the screenshot being smaller than the certain rated value relative to the original location of the screenshot, switch the current mode to the first mode for inserting/deleting the row.

7. The device according to claim 6 , characterized in that, the operation type judgment module is used to judge a moving direction of the touch point on the touch screen according to said moving information about the touch point on the touch screen, and

further to judge that the operation to be performed is an insertion operation or a deletion operation according to said moving direction of the touch point on the touch screen.

8. The device according to claim 7 , characterized in that, after the target determination module is executed to determine target cells or target rows or columns of cells according to said touch and click information on the touch screen and the operation type judgment module is executed to judge that the operation to be performed is an insertion operation or a deletion operation according to said moving direction of the touch point on the touch screen,

if said moving direction of the touch point on the touch screen is upward or downward, the operation execution module is executed to determine locations and number of the rows to be inserted or deleted, and perform corresponding insertion or deletion operation; or

if said moving direction of the touch point on the touch screen is leftward or rightward, the operation execution module is executed to determine locations and number of the columns to be inserted or deleted, and perform corresponding insertion or deletion operation.

9. The method for inserting or deleting cells, rows or columns in a spreadsheet according to claim 1 , characterized in that, the method further comprises the steps of:

obtaining touch and click information of only one touch point present on a touch screen;

determining target cells according to said touch and click information on the touch screen;

obtaining moving information about the touch point on the touch screen;

judging that an operation to be performed is an insertion operation or a deletion operation according to said moving information about the touch point on the touch screen and a preset logic for determining operation type; and

determining locations and number of cells to be inserted or deleted according to a result of the judging step and a displacement of the touch point included in said moving information about the touch point on the touch screen, and performing said insertion or deletion operation.