Device and method for positioning unit grid position in electronic form designated area

A spreadsheet and designated area technology, applied in the computer field, can solve problems such as interfering with the user's use process, inability to complete, and reducing user experience.

Active Publication Date: 2008-07-02
BEIJING KINGSOFT OFFICE SOFTWARE INC +1
View PDF0 Cites 19 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Although this method solves the positioning problem, it interferes with the user's original use process, and the user needs to click the mouse several times for this, thus reducing the user experience
For users who are not proficient in operating this step, this function cannot be completed

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
  • Device and method for positioning unit grid position in electronic form designated area
  • Device and method for positioning unit grid position in electronic form designated area
  • Device and method for positioning unit grid position in electronic form designated area

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0065] The specific embodiments of the present invention will be described below with reference to the accompanying drawings. Although the present invention is described below with a preferred embodiment, it is not intended to limit the present invention.

[0066] like figure 1 , 2 , 3, 4, and 5, describe a method of actually locating the header row in the "AutoFilter" function of a spreadsheet.

[0067] The auto filter function is to display a header row in a specified area in a spreadsheet, usually a complete table, and each column of the header row has an auto filter button to perform an auto filter operation on the current column. Normally, the title row will be positioned in the first row of the area, but when there are merged cells in the first row of the area, the position of the title row is not suitable at this time, and it is necessary to enter the automatic positioning process described in the present invention. Perform a positioning operation on the title row, th...

Embodiment example 2

[0085] The following specifically describes a method of actually locating the cell where the calculation result is located in the "AutoSum" function of the spreadsheet:

[0086] 1) The user selects the area and starts the automatic summation;

[0087] 2) The default calculation result cell of the system is in the first row of the current column;

[0088] 3) The positioning device displays the positioning mark in the first row;

[0089] 4) The positioning device jumps the mouse to the middle of the first row of cells;

[0090] 5) The user drags the mouse or uses the keyboard Up and Down keys to adjust the row where the cell is located;

[0091] 6) The user clicks the mouse or presses the Enter key to determine the row where the final calculated position is located.

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 provides a device and a method for assisting users in determining cell grid position in an appointed region of an electronic form, which can flexibly determine positions of cell grids in the appointed region of the electronic form at simple operation to meet the requirement of users. The device for determining the positions of cell grids in the appointed region in the electronic form comprises a computer input equipment, a display equipment and a host computer, which are connected with each other, as well as a positioning module for receiving the user's input and determining the current positioning position, a drawing module for drawing a positioning mark in the electronic form, and an electronic form page information module, in which screen coordinate information of the form's window region and logic coordinate information of each cell grid, row and column are stored.

Description

technical field [0001] The invention relates to the computer field, in particular to a device and a method for helping users locate cells in a designated area when editing electronic forms. Background technique [0002] In the operation of spreadsheets, such an operation scenario is often encountered: in an area specified by the user, it is necessary to reconfirm the position of a group of cells (maybe a row or a column or a rectangle) in this area . For this kind of operation behavior, the existing technology usually has corresponding default rules, such as displaying feasible positioning (for the row) on the first line or the bottom line of the specified area, but the default rules are not always Effective, and not always in line with user requirements. At this point, the user needs to intervene to reconfirm the target position. For example, take the automatic filter function in a spreadsheet as an example. When the user selects the merged cells in the first row of the ...

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): G06F17/24
Inventor 张祖缘陈波何卫东
Owner BEIJING KINGSOFT OFFICE SOFTWARE INC
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap