Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method and device for inserting or deleting cells or rows and lines in spreadsheet

一种电子表格、单元格的技术,应用在电数字数据处理、数据处理的输入/输出过程、特殊数据处理应用等方向,能够解决无法单元格和行列插入和删除等问题,达到直观插入和删除、提高效率的效果

Active Publication Date: 2012-08-15
ZHUHAI KINGSOFT OFFICE SOFTWARE +1
View PDF5 Cites 21 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Therefore, the current spreadsheet software that can run on touch screen devices cannot perform intuitive and fast insertion and deletion of cells, rows and columns like the traditional operation method

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and device for inserting or deleting cells or rows and lines in spreadsheet
  • Method and device for inserting or deleting cells or rows and lines in spreadsheet
  • Method and device for inserting or deleting cells or rows and lines in spreadsheet

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] In order to further illustrate the technical means adopted by the present invention and the achieved effects, the technical solutions of the present invention will be clearly and completely described below in conjunction with the accompanying drawings and preferred embodiments.

[0024] see figure 1 , is a schematic flowchart of a method for inserting or deleting cells or rows and columns in an electronic form according to the present invention. The method for inserting or deleting cells or rows and columns in the electronic form of the present invention comprises the following steps:

[0025] S101 acquires touch and click information on the touch screen;

[0026] First of all, it is necessary to obtain the touch and click information on the touch screen.

[0027] Taking inserting and deleting operations on cells, rows and columns in a spreadsheet on an Android device as an example, basic click events on an Android device are divided into ACTION_DOWN finger press even...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a method for inserting or deleting cells or rows and lines in a spreadsheet. The method comprises the following steps of: obtaining touch clicking information on a touch screen; determining target cells or target rows or lines; obtaining touch point moving information on the touch screen; judging a logic according to a preset operation type, and judging whether to carry out inserting operation or deleting operation; and determining the positions and the number of the cells or the rows or lines needing to be inserted or deleted, and carrying out the inserting or deleting operation. In addition, the invention also discloses a device for inserting or deleting the cells or the rows or lines in the spreadsheet. The device comprises an information obtaining module, a target determining module, an operation type judging module and an operation executing module. According to the method and the device which are disclosed by the invention, the operation in the spreadsheet can be simplified through a gesture identification mode, the fast and visual inserting and deleting of the cells and rows and lines are realized, and the efficiency is increased.

Description

technical field [0001] The invention relates to the technical field of electronic form operation on a touch screen device, in particular to a method for inserting or deleting cells or rows and columns in an electronic form and a device for inserting or deleting cells or rows and columns in an electronic form. Background technique [0002] Insertion and deletion of cells, rows and columns are high frequency operations in spreadsheet software on touch screen devices. On the touch screen device, with the enhancement of the functions of the spreadsheet software and the increase of function entries, the high-frequency operations of inserting and deleting cells, rows and columns are more complicated and difficult to realize. For example, the insertion and deletion of cells, rows and columns in existing spreadsheets requires multi-step operations. Therefore, the current spreadsheet software that can run on a touch screen device cannot perform intuitive and rapid insertion and dele...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F3/048G06F3/041G06F17/24G06F3/0488
CPCG06F40/18G06F2203/04808
Inventor 王晖曾思洁赵威
Owner ZHUHAI KINGSOFT OFFICE SOFTWARE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products