CN102999289B - The method and device that constituency parameter represents is generated in function expression - Google Patents
The method and device that constituency parameter represents is generated in function expression Download PDFInfo
- Publication number
- CN102999289B CN102999289B CN201210279731.5A CN201210279731A CN102999289B CN 102999289 B CN102999289 B CN 102999289B CN 201210279731 A CN201210279731 A CN 201210279731A CN 102999289 B CN102999289 B CN 102999289B
- Authority
- CN
- China
- Prior art keywords
- button
- input
- constituency
- cell
- parameter
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Landscapes
- User Interface Of Digital Computer (AREA)
- Telephone Function (AREA)
Abstract
The present invention relates to a kind of method that constituency parameter generating in the parameter input of function expression represents, described method includes: receives and responds the input selecting start element lattice in cell district, then not repeatedly generate the initial button that display one is associated with start element lattice in the parameter input of function；Receive and respond the input selecting end unit lattice in cell district, then not repeatedly generate the conclusion button that display one is associated with end unit lattice in the parameter input of function；Receive and respond and drag initial button to conclusion button or the input dragging the extremely initial button of conclusion button, generate in the parameter input of function expression and show that a constituency parameter being associated with the cell constituency of start element lattice to end unit lattice represents, delete initial button and conclusion button simultaneously.The present invention is easy to user operation.
Description
[technical field]
The present invention relates to computer communication field, be specifically related to one and apply to electrical form and when input cursor
Generate in the parameter input of function expression with start element lattice to knot when being positioned at the parameter input of function
What the cell constituency of bundle cell was associated the method and device that represents of constituency parameter.
[background technology]
As it is shown in figure 1, this is a kind of (for example, intelligent at the intelligent movable equipment with touch control operation function
Mobile phone) surface chart of the upper spreadsheet software using, the 10th, the interface of this spreadsheet software includes label area
District the 12nd, the horizontal expression in cell district district 13 and function command input area are shown in the 11st, the cell district list of cell district
14.In above-mentioned software, commonly used to entering line function calculating to a certain cell constituency, for example sue for peace,
Mean value etc..Under stating as a example by A1 cell to the summation operation of A4 cell at this on this software
Operating process, first, in function command input area 14 input summing function expression formula "=sum () ",
In then input cursor be positioned at " () ", then A1 cell simultaneously pinning is chosen to drag by touch control manner
Move han dle point to dragging A4 cell, complete A1 cell to the choosing in the cell constituency of A4 cell
Select, then, spreadsheet software according to select cell constituency in function command input area 14
Generate a constituency parameter in the bracket of "=sum () " to represent: " A1:A4 " (A1:A4, it is mono-that it is associated with A1
Unit's lattice are to the cell constituency of A4 cell: A1 cell, A2 cell, A3 cell, A4 cell),
I.e. completing the parameter input of summation, spreadsheet software extracts the cell constituency that constituency parameter represents associated
A1 cell, A2 cell, A3 cell, the content of A4 cell entering according to summing function rule
Row calculates.
From foregoing description, generate in the parameter input of function expression with start element lattice to terminating list
The step that the constituency parameter in the cell constituency of unit's lattice represents is: input cursor is positioned in function and to be inputted
In the bracket of parameter, choose start element lattice, then drag handle point to end unit lattice, thus complete
Select with the cell constituency of start element lattice to end unit lattice (for example: A1 cell is dragged to A7 mono-
Unit's lattice, are to select A1-A7 cell and B1-B7 cell), an association is generated in the parameter input of function
Constituency parameter in this cell constituency represents.This generating mode, is choosing the unit that leap amplitude is bigger
It during lattice constituency, not to position to accurate and flexible very much, operation extremely inconvenience, it is not easy to very much user and use.
[content of the invention]
The technical problem to be solved in the present invention is to provide one and applies to electrical form and when input cursor is positioned at
Generate with start element lattice to end unit in the parameter input of function expression during the parameter input of function
The method that the constituency parameter that the cell constituency of lattice is associated represents, it can be easy to user operation.
Above-mentioned technical problem can be realized by following two technical scheme respectively:
The first scheme is:
A kind of apply to electrical form and when inputting when cursor is positioned at the parameter input of function expression at letter
The parameter input generation of number expression formula is associated with the cell constituency of start element lattice to end unit lattice
The method that constituency parameter represents, described electrical form is provided with cell district, it is characterised in that described method bag
Include:
Receive and respond the input selecting start element lattice in cell district, the then ginseng at function expression
Number input not repeatedly generates the initial button that display one is associated with start element lattice；
Receive and respond the input selecting end unit lattice in cell district, the then ginseng at function expression
Number input not repeatedly generates the conclusion button that display one is associated with end unit lattice；
Receive and respond and drag the input that initial button extremely initiates button to conclusion button or dragging conclusion button,
It is then determined that initial button is to the cell constituency of conclusion button, generate in the parameter input of function expression
The constituency parameter that display one is associated with the cell constituency of start element lattice to end unit lattice represents, simultaneously
Delete initial button and conclusion button.
First scheme is:
A kind of apply to electrical form and when inputting when cursor is positioned at the parameter input of function expression at letter
The parameter input generation of number expression formula is associated with the cell constituency of start element lattice to end unit lattice
The device that constituency parameter represents, described electrical form is provided with cell district, it is characterised in that described device bag
Include:
Initial button generation module, for receiving and responding the input of selection start element lattice in cell district,
Then the parameter input at function expression not repeatedly generate one be associated with start element lattice initial by
Button；
Conclusion button generation module, for receiving and responding the input of selection end unit lattice in cell district,
Then the parameter input at function expression not repeatedly generate one be associated with the end of end unit lattice by
Button；
Constituency button generation module, terminates to conclusion button or dragging for receiving and responding the initial button of dragging
Button is to the input initiateing button, it is then determined that initial button is to the cell constituency of conclusion button, at function
It is related to the cell constituency of start element lattice to end unit lattice that the parameter input of expression formula generates display one
The constituency parameter of connection represents, deletes initial button and conclusion button simultaneously.
As seen from the above technical solution, the present invention program is by when input cursor, to be positioned at the parameter of function defeated
Enter to click on when locating start element lattice and end unit lattice to generate initial button and end in parameter input
Button, then carries out in parameter input being associated with the drag operation of initial button or conclusion button to generate
Start element lattice represent to the constituency parameter in the cell constituency of end unit lattice.Therefore, relatively current at letter
The mode that the parameter input generation constituency parameter of number represents, the present invention is highly convenient for user operation.
[brief description]
Fig. 1 is the electrical form using on the intelligent movable equipment have touch control operation function in background technology
The surface chart of software；
Fig. 2 and Fig. 5 is the schematic diagram that spreadsheet software uses the present invention.
[detailed description of the invention]
A kind of apply to electrical form and when inputting when cursor is positioned at the parameter input of function expression at letter
The parameter input generation of number expression formula is associated with the cell constituency of start element lattice to end unit lattice
The method that constituency parameter represents, described electrical form is provided with cell district, and the method includes:
Receive and respond the input selecting start element lattice in cell district, the then ginseng at function expression
Number input not repeatedly generates the initial button that display one is associated with start element lattice；
Receive and respond the input selecting end unit lattice in cell district, the then ginseng at function expression
Number input not repeatedly generates the conclusion button that display one is associated with end unit lattice；
Receive and respond and drag the input that initial button extremely initiates button to conclusion button or dragging conclusion button,
It is then determined that initial button is to the cell constituency of conclusion button, generate in the parameter input of function expression
The constituency parameter that display one is associated with the cell constituency of start element lattice to end unit lattice represents, simultaneously
Delete initial button and conclusion button.
From the angle completing calculating, described method also includes, extracts the cell that constituency parameter represents associated
The content of all cells in constituency simultaneously calculates according to function rule.
In this programme, which cell the cell constituency of start element lattice to end unit lattice specifically includes,
This and WPS form of the prior art or Microsoft's Excel form drag start element lattice to end unit lattice
As the regulation in the cell constituency selected, no longer specifically state at this.
A kind of apply to electrical form and when inputting when cursor is positioned at the parameter input of function expression at letter
The parameter input generation of number expression formula is associated with the cell constituency of start element lattice to end unit lattice
The device that constituency parameter represents, described electrical form is provided with cell district, and this device includes:
Initial button generation module, for receiving and responding the input of selection start element lattice in cell district,
Then the parameter input at function expression not repeatedly generate one be associated with start element lattice initial by
Button；
Conclusion button generation module, for receiving and responding the input of selection end unit lattice in cell district,
Then the parameter input at function expression not repeatedly generate one be associated with the end of end unit lattice by
Button；
Constituency button generation module, terminates to conclusion button or dragging for receiving and responding the initial button of dragging
Button is to the input initiateing button, it is then determined that initial button is to the cell constituency of conclusion button, at function
It is related to the cell constituency of start element lattice to end unit lattice that the parameter input of expression formula generates display one
The constituency parameter of connection represents, deletes initial button and conclusion button simultaneously.
From the angle completing calculating, described device also includes, performs computing module, is used for extracting described constituency
Parameter represents the content of all cells in associated cell constituency and calculates according to function rule.
As it is shown in figure 1, this is a kind of (for example, intelligent at the intelligent movable equipment with touch control operation function
Mobile phone) surface chart of the upper spreadsheet software using, the 10th, the interface of this spreadsheet software includes label area
District the 12nd, the horizontal expression in cell district district 13 and function command input area are shown in the 11st, the cell district list of cell district
14；The list of cell district shows that district 12 usually represents the row in cell district with different letters or monogram,
Horizontal expression district of cell district 13 is usually the horizontal stroke representing cell district with different letters or monogram.
Here, with the spreadsheet software that employs said method and device for row, statement is lower calculates electronic watch
In lattice, A1 cell is to cell constituency (A1-A4 cell and the B1-B4 cell) sum of B4 cell
Process:
As in figure 2 it is shown, first input summing function expression formula "=sum () " in function command input area 14,
Then input cursor is positioned in " () " (the parameter input that " () " is function expression), such as Fig. 3
Shown in, generate, in then selecting cell A1, " () ", the A1 button that display is associated with A1 cell, such as figure
Shown in 4, generate, in then selecting cell B4, " () ", the B4 button that display is associated with B4 cell, as
Shown in Fig. 5, drag A1 button to B4 button or B4 button to A1 button, determine A1 cell to B4
The cell constituency of cell, then generates display one constituency parameter in " () " and represents and (be embodied in A1:B4
Button), the A1 button before simultaneously deleting, B4 button, this A1:B4 button is associated with A1 cell extremely
The cell constituency of B4 cell；Cell constituency according to associated by A1:B4 button for the software is to extract
Content in A1-A4 cell, B1-B4 cell carries out read group total, and click empties, and just automatically empties letter
Number order input area 14.
The present invention is not limited to above-described embodiment, and for example, function can be average function or quadrature function
Deng range site lattice content as calculate parameter function；Therefore based on above-described embodiment, do not make wound
The simple replacement of the property made work, it should belong to the scope that the invention discloses.
Claims (2)
1. one kind apply to electrical form and when input when cursor is positioned at the parameter input of function expression
The parameter input of function expression generates and is associated with the cell constituency of start element lattice to end unit lattice
The method that represents of constituency parameter, the interface of described electrical form is provided with cell district and function command input area,
In function command input area input function expression formula, it is characterised in that described method includes:
Receive and respond the input selecting start element lattice in cell district, the then ginseng at function expression
Number input not repeatedly generates the initial button that display one is associated with start element lattice；
Receive and respond the input selecting end unit lattice in cell district, the then ginseng at function expression
Number input not repeatedly generates the conclusion button that display one is associated with end unit lattice；
Receive and respond and drag the input that initial button extremely initiates button to conclusion button or dragging conclusion button,
It is then determined that initial button is to the cell constituency of conclusion button, generate in the parameter input of function expression
The constituency parameter that display one is associated with the cell constituency of start element lattice to end unit lattice represents, simultaneously
Delete initial button and conclusion button.
2. one kind apply to electrical form and when input when cursor is positioned at the parameter input of function expression
The parameter input of function expression generates and is associated with the cell constituency of start element lattice to end unit lattice
The device that represents of constituency parameter, described electrical form is provided with cell district and function command input area, at letter
Number order input area input function expression formula, it is characterised in that described device includes:
Initial button generation module, for receiving and responding the input of selection start element lattice in cell district,
Then the parameter input at function expression not repeatedly generate one be associated with start element lattice initial by
Button；
Conclusion button generation module, for receiving and responding the input of selection end unit lattice in cell district,
Then the parameter input at function expression not repeatedly generate one be associated with the end of end unit lattice by
Button；
Constituency button generation module, terminates to conclusion button or dragging for receiving and responding the initial button of dragging
Button is to the input initiateing button, it is then determined that initial button is to the cell constituency of conclusion button, at function
It is related to the cell constituency of start element lattice to end unit lattice that the parameter input of expression formula generates display one
The constituency parameter of connection represents, deletes initial button and conclusion button simultaneously.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210279731.5A CN102999289B (en) | 2012-08-07 | 2012-08-07 | The method and device that constituency parameter represents is generated in function expression |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210279731.5A CN102999289B (en) | 2012-08-07 | 2012-08-07 | The method and device that constituency parameter represents is generated in function expression |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102999289A CN102999289A (en) | 2013-03-27 |
| CN102999289B true CN102999289B (en) | 2016-10-05 |
Family
ID=47927912
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210279731.5A Active CN102999289B (en) | 2012-08-07 | 2012-08-07 | The method and device that constituency parameter represents is generated in function expression |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102999289B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108984077A (en) * | 2017-06-02 | 2018-12-11 | 珠海金山办公软件有限公司 | A kind of convenient method, device and electronic equipment deleted and replicate content in document |
| CN109002427A (en) * | 2017-06-06 | 2018-12-14 | 珠海金山办公软件有限公司 | The method, apparatus and electronic equipment of refresh function parameter in electrical form |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1755668A (en) * | 2004-09-30 | 2006-04-05 | 微软公司 | Design of spreadsheet functions for working with tables of data |
| CN1790259A (en) * | 2004-12-15 | 2006-06-21 | 微软公司 | System and method for automatically completing spreadsheet formulas |
| CN101989176A (en) * | 2009-08-04 | 2011-03-23 | Lg电子株式会社 | Mobile terminal and icon collision controlling method thereof |
| CN102156614A (en) * | 2010-01-06 | 2011-08-17 | 苹果公司 | Device, method, and graphical user interface for manipulating tables using multi-contact gestures |
| CN102566901A (en) * | 2011-11-18 | 2012-07-11 | 珠海金山办公软件有限公司 | Method of controlling electronic forms on handheld touch devices |
-
2012
- 2012-08-07 CN CN201210279731.5A patent/CN102999289B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1755668A (en) * | 2004-09-30 | 2006-04-05 | 微软公司 | Design of spreadsheet functions for working with tables of data |
| CN1790259A (en) * | 2004-12-15 | 2006-06-21 | 微软公司 | System and method for automatically completing spreadsheet formulas |
| CN101989176A (en) * | 2009-08-04 | 2011-03-23 | Lg电子株式会社 | Mobile terminal and icon collision controlling method thereof |
| CN102156614A (en) * | 2010-01-06 | 2011-08-17 | 苹果公司 | Device, method, and graphical user interface for manipulating tables using multi-contact gestures |
| CN102566901A (en) * | 2011-11-18 | 2012-07-11 | 珠海金山办公软件有限公司 | Method of controlling electronic forms on handheld touch devices |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102999289A (en) | 2013-03-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105144057B (en) | For moving the equipment, method and graphic user interface of cursor according to the cosmetic variation of the control icon with simulation three-dimensional feature | |
| CN103761216B (en) | Edit the method and mobile terminal of text | |
| CN206178562U (en) | Electronic device and information processor | |
| CN101916161B (en) | Interface model selection method based on image of region pressed by finger and mobile terminal | |
| CN107422934B (en) | Icon setting method and electronic equipment | |
| CN110493018B (en) | Group chat creating method and device | |
| CN102566901A (en) | Method of controlling electronic forms on handheld touch devices | |
| CN102821193A (en) | Method for rapidly operating file of intelligent cell phone and intelligent cell phone | |
| CN105468279B (en) | Contact action identification and response method, device and game control method, device | |
| CN103577079B (en) | The method interacted with the application and electronic equipment are realized in electronic equipment | |
| WO2006137078A1 (en) | Method, article, apparatus and computer system for inputting a graphical object | |
| CN104049874A (en) | Touch handwriting generation method and system of stylus | |
| CN102117165A (en) | Touch input processing method and mobile terminal | |
| CN102999289B (en) | The method and device that constituency parameter represents is generated in function expression | |
| CN107329644A (en) | A kind of icon moving method and device | |
| CN102591471A (en) | Method and device for rapidly inputting emoticons | |
| CN101866261B (en) | A kind of method and mobile terminal realizing menu setecting | |
| CN108089796A (en) | The display methods and device of shortcut bar | |
| CN105630375A (en) | Auxiliary implementation method and system of information input on the basis of graphical interface | |
| CN102664822B (en) | Instant communication message sending method and client side based on input method | |
| CN105204754B (en) | The one-handed performance method and device of touch screen | |
| CN101770307A (en) | Handheld electronic device and operating method thereof | |
| CN107645612A (en) | A kind of information processing method and terminal device | |
| CN104407802B (en) | A kind of method and terminal of multiple affair input | |
| CN106339096A (en) | Method and device for quickly selecting texts and pictures |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| CP01 | Change in the name or title of a patent holder |
Address after: Jinshan software building No. 8 Jingshan Hill Road, Lane 519015 Lianshan Jida Zhuhai city in Guangdong Province Patentee after: Zhuhai Kingsoft Office Software Co., Ltd. Patentee after: Beijing Kingsoft office software Limited by Share Ltd Address before: Jinshan software building No. 8 Jingshan Hill Road, Lane 519015 Lianshan Jida Zhuhai city in Guangdong Province Patentee before: Zhuhai Kingsoft Office Software Co., Ltd. Patentee before: Beijing Kingsoft WPS Office Co., Ltd. |
|
| CP01 | Change in the name or title of a patent holder |