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

Abstract

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.