CN103336762A - Method and terminal for pointing out relative rank and column values in spreadsheet - Google Patents
Method and terminal for pointing out relative rank and column values in spreadsheet Download PDFInfo
- Publication number
- CN103336762A CN103336762A CN2013102941274A CN201310294127A CN103336762A CN 103336762 A CN103336762 A CN 103336762A CN 2013102941274 A CN2013102941274 A CN 2013102941274A CN 201310294127 A CN201310294127 A CN 201310294127A CN 103336762 A CN103336762 A CN 103336762A
- Authority
- CN
- China
- Prior art keywords
- value
- label value
- absolute
- position information
- relative position
- 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.)
- Granted
Links
Images
Abstract
The invention provides a method for pointing out relative rank and column values in a spreadsheet. The method for pointing out the relative rank and column values in the spreadsheet comprises the following steps that a terminal obtains input relative position information parameters and sheet area parameters, the terminal determines relative position information in a selected area and absolute position information corresponding to the relative position information, and the terminal converts the relative position information into absolute position information and displays the absolute position information as a prompt message. Correspondingly, the invention further provides the terminal for determining the position information of a designated area in the spreadsheet. The method and terminal for pointing out the relative rank and column values in the spreadsheet has the advantages that the problem that the spreadsheet is poor in flexibility due to the fact that a prompt message of the relative rank and column values cannot be provided in the prior art is solved, the flexibility of the spreadsheet is improved, and the editing efficiency of the spreadsheet is improved.
Description
Technical field
The present invention relates to areas of information technology, relate in particular to a kind of method and terminal of in electrical form, pointing out relative ranks value.
Background technology
In electronic form file, function be the most frequently used also be the most useful instrument, can help the user portable return the result of calculation that needs.The kind of function is more, and needs to determine that the function of ranks positional information is also many in electronic form file, for example, Vlookup, Hlookup, Offset, Index, Dget, DSum, DAverage, DMin, DMax, DStdev, functions such as Dvar need the user to provide the relative ranks value of information in use.
Have some functions the time need provide the appointed area positional information in input, and the row column headers on this moment worksheet can not provide such facility.Come for example with the Vlookup function.The Vlookup function is used for searching the numerical value of appointment at first of form or numerical value array, and returns the numerical value at specify columns place in form or the array current line thus.Vlookup has 4 parameters, is respectively the value of searching (lookup_value), tables of data (table_array), row ordinal number (col_index_num) and matching condition (range_lookup).When using this function, be unable to do without this parameter c of row ordinal number ol_index_num.This parameter must be the concrete column position information in the constituency of tables of data parameter correspondence, namely be a relative column position information, but not the ranks positional information in the whole table, be column position information absolute in the electrical form, be example with excel, absolute column position information is A, B, the row labels such as C, D of mark excel top on, and absolute line position information is the line labels such as 1,2,3,4 that excel upward marks.In this time, the row column headers on the gauge outfit does not have effect.When particularly current constituency was bigger, just there was certain difficulty in user oneself when the parameter of the relative ranks of input position, need ceaselessly to proofread and correct.And do not provide how to point out relative ranks value as yet for this kind situation in present spreadsheet application or the software, and also just can't determine fast relative ranks value to cause the electrical form very flexible according to prompting, editorial efficiency is low.
Summary of the invention
The objective of the invention is to overcome weak point of the prior art, a kind of method and terminal of determining relative ranks value in electrical form is provided, the problem that can't provide the relative ranks value of prompting to cause the electrical form very flexible in the prior art has been provided, strengthen the dirigibility of electrical form, improved the editorial efficiency of electrical form.
The embodiment of the invention provides a kind of method of pointing out relative ranks value in electrical form, comprising:
Terminal monitors the input instruction, obtains table area parameter and the relative position information parameter of input, and described relative position information parameter is relative line label value, or relative row index value, or relative line label value and relative row index value;
Described terminal reads the constituency scope of described table area parameter correspondence, determine relative position information in the scope of described constituency and the absolute location information of described relative position information correspondence, described absolute location information comprises absolute row index value, or absolute row index value, or absolute line label value and absolute row index value;
The relative position information parameter of described terminal judges input;
When described relative position information parameter is relative line label value, described terminal is according to the absolute location information of the relative position information in the scope of described constituency and described relative position information correspondence, described relative line label value is converted to absolute capable table number value, and described absolute line label value is shown as information;
When described relative position information parameter is relative row index value, described terminal is according to the absolute location information of the relative position information in the scope of described constituency and described relative position information correspondence, described relative row index value is converted to absolute tabulation number value, and described absolute row index value is shown as information;
When described relative position information parameter is relative line label value and relative row index value, described terminal is according to the absolute location information of the relative position information in the scope of described constituency and described relative position information correspondence, described relative line label value is converted to absolute capable table number value, simultaneously described relative row index value is converted to absolute tabulation number value, and described absolute line label value and described absolute row index value are shown as information.
The embodiment of the invention also provides a kind of terminal of determining relative ranks value in electrical form, comprising:
Acquiring unit is used for monitoring the input instruction, obtains table area parameter and the relative position information parameter of input, and described relative position information parameter is relative line label value, or relative row index value, or relative line label value and relative row index value;
Determining unit, be used for reading the constituency scope of described table area parameter correspondence, determine relative position information in the scope of described constituency and the absolute location information of described relative position information correspondence, described absolute location information comprises absolute row index value, or absolute row index value, or absolute line label value and absolute row index value;
Judging unit is used for judging the relative position information parameter of importing;
When described relative position information parameter is relative line label value, described terminal comprises converting unit, be used for the absolute location information according to the relative position information in the scope of described constituency and described relative position information correspondence, described relative line label value is converted to absolute capable table number value; Display unit is used for described absolute line label value is shown as information;
When described relative position information parameter is relative row index value, described terminal comprises converting unit, be used for the absolute location information according to the relative position information in the scope of described constituency and described relative position information correspondence, described relative row index value is converted to absolute tabulation number value; Display unit is used for described absolute row index value is shown as information;
When described relative position information parameter is relative line label value and relative row index value, described terminal comprises converting unit, be used for the absolute location information according to the relative position information in the scope of described constituency and described relative position information correspondence, described relative line label value is converted to absolute capable table number value, simultaneously described relative row index value is converted to absolute tabulation number value; Display unit is used for described absolute line label value and described absolute row index value are shown as information.
The method and the terminal that provide by the embodiment of the invention, terminal is obtained relative position information parameter and the table area parameter of input, determine relative position information in the scope of constituency and the absolute location information of described relative position information correspondence, relative position information is converted to absolute location information and absolute location information is shown as information, the problem that can't provide the relative ranks value of prompting to cause the electrical form very flexible in the prior art has been provided, strengthen the dirigibility of electrical form, improved the editorial efficiency of electrical form.
Description of drawings
In order to be illustrated more clearly in the technical scheme of the embodiment of the invention, the accompanying drawing of required use is done an introduction simply in will describing embodiment below, apparently, accompanying drawing in describing below is some embodiments of the present invention, for those of ordinary skills, under the prerequisite of not paying creative work, can also obtain other accompanying drawing according to these accompanying drawings.
Fig. 1 is the method flow diagram of the embodiment of the invention one;
Fig. 2 is the design sketch of the embodiment of the invention one;
Fig. 3 is the terminal composition diagram of the embodiment of the invention two.
Embodiment
For the purpose, technical scheme and the advantage that make the embodiment of the invention clearer, below in conjunction with the accompanying drawing in the embodiment of the invention, technical scheme in the embodiment of the invention is clearly and completely described, obviously, described embodiment is the present invention's part embodiment, rather than whole embodiment.Based on the embodiment among the present invention, the every other embodiment that those of ordinary skills obtain under the prerequisite of not making creative work belongs to the scope of protection of the invention.
Embodiment one
Fig. 1 is the method flow diagram of the embodiment of the invention one, and as shown in Figure 1, this method comprises:
S101, terminal monitor the input instruction, obtain table area parameter and the relative position information parameter of input, and described relative position information parameter is relative line label value, or relative row index value, or relative line label value and relative row index value;
Terminal monitors user's input instruction, obtains table area parameter and the relative position information parameter of user's input.Wherein, the table area parameter is represented user-defined table area, and table area is made up of a plurality of cells, and each cell has its specific ranks index value.The table area parameter is set form, for example: " D5:O14 ", represent in this table area, its positional information of cell in the upper left corner is " D5 ", be that line label is 5, the row label is " D ", and its positional information of the cell of last cell is " O14 ", be that line label is 14, the row label is " O ".In the electrical form, the upper left corner with do the lower right corner two dot position informations in case determine, just can determine the concrete scope of this table area.
The relative position information parameter can be the relative position information parameter at a certain cell in the table area, it also can be the relative position information parameter of a certain appointed area in the table area, this appointed area comprises a plurality of cells, and the scope of this appointed area is smaller or equal to table area.If the relative position information parameter is the relative position information parameter of a certain appointed area in the table area, then terminal also will be obtained the appointed area parameter of user's input, described appointed area parameter is appointed area height and width value, at this moment, terminal calculates relative ranks value according to described appointed area height value and width value, and described positional information is shown as information.
S102, described terminal read the constituency scope of described table area parameter correspondence, determine relative position information in the scope of described constituency and the absolute location information of described relative position information correspondence, described absolute location information comprises absolute row index value, or absolute row index value, or absolute line label value and absolute row index value;
Relative position information is namely with respect to the skew of the coordinate (coordinate is line label and row index value) in the upper left corner in the table area, absolute location information is namely gone up line label and the row index value of mark by top in the electrical form, be example with excel, absolute column position information is A, B, the row labels such as C, D of mark excel top on, and absolute line position information is the line labels such as 1,2,3,4 that excel upward marks.
The relative position information parameter of S103, the input of described terminal judges;
If the relative position information parameter is the relative position information parameter of a certain appointed area in the table area, then described terminal also needs to judge the validity of described relative line label value, if described relative line label value is more than or equal to 1 and less than the region height value of the form parameter correspondence of described input, described relative line label value is effective, otherwise it is invalid to import, flow process finishes, or, the validity of the described relative row index value of described terminal judges, if described relative row index value is more than or equal to 1 and less than the peak width value of the form parameter correspondence of described input, described relative row index value is effective, otherwise imports invalidly, and flow process finishes.
S104a, when described relative position information parameter is relative line label value, described terminal is according to the absolute location information of the relative position information in the scope of described constituency and described relative position information correspondence, described relative line label value is converted to absolute capable table number value, and described absolute line label value is shown as information;
Terminal is converted to absolute capable table number value with described relative line label value, is specially: calculate absolute row table number value, described absolute line label value be described form parameter correspondence upper left corner cell line label value and described input relative line label value with subtract 1.
S104b, when described relative position information parameter is relative row index value, described terminal is according to the absolute location information of the relative position information in the scope of described constituency and described relative position information correspondence, described relative row index value is converted to absolute tabulation number value, and described absolute row index value is shown as information;
Terminal is converted to absolute tabulation number value with described relative row index value, is specially: calculate absolute tabulation number value, described absolute tabulation number value be described form parameter correspondence upper left corner cell row index value and described input relative row index value with subtract 1.
S104c, when described relative position information parameter is relative line label value and relative row index value, described terminal is according to the absolute location information of the relative position information in the scope of described constituency and described relative position information correspondence, described relative line label value is converted to absolute capable table number value, simultaneously described relative row index value is converted to absolute tabulation number value, and described absolute line label value and described absolute row index value are shown as information.
If described appointed area height value is 1, and described appointed area width value is electrical form full line width, then described terminal is according to the absolute location information of the relative position information in the scope of described constituency and described relative position information correspondence, described relative line label value is converted to absolute capable table number value, and described absolute line label value shown as information, or
If described appointed area width value is 1, and described appointed area height value is electrical form permutation height, then described terminal is according to the absolute location information of the relative position information in the scope of described constituency and described relative position information correspondence, described relative row index value is converted to absolute tabulation number value, and described absolute row index value shown as information, or
If described appointed area height value and appointed area width value are 1, then described terminal is according to the absolute location information of the relative position information in the scope of described constituency and described relative position information correspondence, described relative line label value is converted to absolute capable table number value, simultaneously described relative row index value is converted to absolute tabulation number value, and described absolute line label value and described absolute row index value shown as information, or
If described appointed area width value is greater than 1 and less than electrical form full line width value, and described appointed area height value is greater than 1 and less than electrical form permutation height value, described terminal is obtained the positional information in the upper left corner, and the positional information in the calculating lower right corner, appointed area, and the positional information in the described upper left corner and the lower right corner is converted to relative ranks value, described relative ranks value is shown as information; Wherein, the positional information in the lower right corner, described calculating appointed area, comprise: described terminal is calculated line label value and the row index value in the described regional lower right corner, the line label value in the described regional lower right corner be upper left corner line label value and appointed area height value and subtract 1, the row index value in the described regional lower right corner be upper left corner row index value and target area width value with subtract 1;
Terminal is converted to relative ranks value with the positional information in the described upper left corner and the lower right corner, comprising:
According to letter and the corresponding relation of row-coordinate value, be alphabetical with upper left corner row-coordinate number and lower right corner row coordinate conversion, upper left corner row index value and lower right corner line label value are added 1 respectively; The described upper left corner and the lower right corner are respectively upper left corner cell and the last cell cell of described appointed area.
The effect of one of them of the embodiment of the invention can be as shown in Figure 2, table area is " D6:O14 ", during user's input function, can be according to input sequence from left to right, when being input to the 3rd parameter, namely need the relative row information inserted, when the user imports 8, then can eject prompting " Column K ".
The method that provides with regard to above-described embodiment below, introduce respectively different function inputs is shown different output prompting examples:
Function one: Vlookup
Input: second parameter of function, i.e. table area, for example B1:D4;
The 3rd parameter of function, digital parameters, expression row relative position, for example 2;
Output: user prompt information.
Flow process:
S201, get table area upper left corner row coordinate, the zone width.For example, " B1:D4 " upper left corner column label is ' B ', and namely the row coordinate is 1, and width is 3(column label A, B, C, D ... corresponding to row coordinate 0,1,2,3 ...);
The validity of the 3rd parameter of function of S202, judgement user input.Namely this parameter is more than or equal to 1, and is then effective smaller or equal to peak width, otherwise namely invalid.If the user imports invalid, then flow process finishes.For example, in the top example 1＜=2＜=3, input effectively;
S203, calculating absolute row coordinate figure, i.e. row coordinate figure=the 3rd parameter-1 of upper left corner row coordinate+function.For example, 1+2-1=2 in the top example;
S204, be column label with the row coordinate conversion of calculating in the previous step and point out the user.For example row coordinate 2 then leans out prompting " Column C " corresponding to column label ' C ' in electrical form.
Function two: Hlookup
Input: second parameter of function, i.e. table area, for example B1:D4
The 3rd parameter of function, digital parameters, expression row relative position, for example 3
Output: user prompt information
Flow process:
S301, get table area upper left corner row-coordinate, the zone height.For example, B1:D4 upper left corner row-coordinate is 0, highly is 4;
The validity of the 3rd parameter of function of S302, judgement user input.Namely this parameter is more than or equal to 1, and is then effective smaller or equal to region height, otherwise namely invalid.If the user imports invalid, then flow process finishes.For example, in the top example 1＜=3＜=4, input effectively;
S303, calculate absolute row-coordinate, row-coordinate=the 3rd parameter-1 of upper left corner row-coordinate+function.For example, 0+3-1=2 in the top example;
After adding 1, S304, the row-coordinate value that the previous step random encounter is calculated be converted to that rower is signed and the prompting user.For example 2+1=3, and prompting user " Row3 ".
Function three: Index
Input: first parameter of function, i.e. table area, for example B1:D4
Second parameter of function, digital parameters, expression row relative position, for example 3
The 3rd parameter of function (this parameter is optional parameter), digital parameters, expression row relative position, for example 2
Output: user prompt
Flow process:
S401. obtain the upper left corner ranks coordinate of table area, the height-width in zone.For example, B1:D4 upper left corner rower is signed to ' 1 ', and namely row-coordinate is 0, highly is 4, and width is 3;
S402. judge the validity of second parameter of function that the user imports.Namely this parameter is more than or equal to 1, and is then effective smaller or equal to region height, otherwise namely invalid.If the user imports invalid, then flow process finishes.For example, in the top example 1＜=3＜=4, input effectively;
S403. calculate absolute row-coordinate, i.e. row-coordinate=second parameter-1 of upper left corner row-coordinate+function.For example, 0+3-1=2 in the top example;
If S404. the user does not have the 3rd parameter of input function, then the row-coordinate that calculates in the previous step is added 1 and be rower label and prompting user, flow process finishes.2-for example〉' 3 ', and prompting user " Row3 ";
S405. judge the validity of the 3rd parameter of function that the user imports.Namely this parameter is more than or equal to 1, and is then effective smaller or equal to peak width, otherwise namely invalid.If the user imports invalid, then flow process finishes.For example, in the top example 1＜=2＜=3, input effectively;
S406. calculated column coordinate, i.e. row coordinate=the 3rd parameter-1 of upper left corner row coordinate+function.For example, 1+2-1=2 in the top example;
S407. be the table cell label with the ranks coordinate conversion.2-for example〉' 3 ' 2-〉' C ', and prompting user " Cell C3 ".
Function four: Dget, Dsum, Daverage, Dmin, Dmax, Dstdev, Dstdevp, Dvar
Input: first parameter of function, i.e. table area, for example B1:D4
Second parameter of function, digital parameters, for example 3
Output: user prompt information
Flow process:
S501. get the width in table area upper left corner row coordinate, zone.For example row coordinate in the B1:D4 upper left corner is ' B '-1, and width is 3;
S502. judge the validity of second parameter of function that the user imports.Namely this parameter is more than or equal to 1, and is then effective smaller or equal to peak width, otherwise invalid.If the user imports invalid, then flow process finishes.For example, in the top example 1＜=3＜=3, input effectively;
S503. calculated column coordinate, i.e. row coordinate=second parameter-1 of upper left corner row coordinate+function.For example, 1+3-1=3 in the top example;
S504. the row coordinate standard of calculating in the previous step is changed to column label and points out the user.3-for example〉' D ', and prompting user " Column D ".
Function five: Offset
Input: first parameter of function, i.e. table area, for example B1:D4
Second parameter of function, digital parameters, expression row relative position, for example 2
The 3rd parameter of function, digital parameters, expression row relative position, for example-1
The 4th parameter of function (this parameter is optional parameter), digital parameters, expression appointed area height, for example 3
The 5th parameter of function (this parameter is optional parameter), digital parameters, expression appointed area width, for example 1
Output: user prompt information
Flow process:
S601. get upper left corner ranks coordinate, region height, the width of table area.For example, B1:D4 upper left corner row-coordinate is ' B '-1, highly is 4, and width is 3;
S602. calculate the row-coordinate value, i.e. row-coordinate=second parameter of upper left corner row-coordinate+function.For example, 0+2=2 in the top example;
S603. calculated column coordinate, i.e. row coordinate=the 3rd parameter of upper left corner row coordinate+function.For example, 1+ (1)=0 in the top example;
If S604. the 4th parameter of function exists, then as the appointed area height.Otherwise with the region height of first parameter as the appointed area height;
If S605. the 5th parameter of function exists, then as the width of appointed area.Otherwise with the peak width of first parameter appointed area width the most;
If S606. appointed area height and width all are 1, then the appointed area is the individual unit lattice, calculates target upper left corner location tags and points out the user, process ends.For example, prompting user " Cell D1 ";
If S607. the appointed area height be 1 and width be full line width (corresponding excel2003 is 256, and corresponding excel2007 is 16384), then the appointed area is full line, calculates target upper left corner rower and signs also prompting user, process ends.For example, prompting user " Row2 ";
If S608. the appointed area width is 1 and highly is permutation height (corresponding excel2003 is 65535, and corresponding excel2007 is 1048576), then the appointed area is permutation, calculates target upper left corner column label and points out the user, process ends.For example, prompting user " Column M ";
S609. the lower right corner, zoning coordinate.Row-coordinate=upper left corner row-coordinate+appointed area height-1, row coordinate=upper left corner row coordinate+appointed area width-1.For example, lower right corner row-coordinate=2+3-1=4 in the top example, lower right corner row coordinate=0+1-1=0;
S610. the upper left corner, lower right corner ranks coordinate transfer regional label to and point out the user.For example, upper left corner rower is signed 2-in the top example〉' 3 ', upper left corner column label 0-〉' A ', and lower right corner rower is signed 4-〉' 5 ', lower right corner column label 0-〉' A ', so prompting user " Area A3:A5 ".
The method that the embodiment of the invention provides, terminal is obtained relative position information parameter and the table area parameter of input, determine relative position information in the scope of constituency and the absolute location information of described relative position information correspondence, relative position information is converted to absolute location information and absolute location information is shown as information, the problem that can't provide the relative ranks value of prompting to cause the electrical form very flexible in the prior art has been provided, strengthen the dirigibility of electrical form, improved the editorial efficiency of electrical form.
Embodiment two
Fig. 3 is the terminal composition diagram of the embodiment of the invention two, and as shown in Figure 3, this terminal comprises:
Acquiring unit 701 is used for monitoring the input instruction, obtains table area parameter and the relative position information parameter of input, and described relative position information parameter is relative line label value, or relative row index value, or relative line label value and relative row index value;
Determining unit 702, be used for reading the constituency scope of described table area parameter correspondence, determine relative position information in the scope of described constituency and the absolute location information of described relative position information correspondence, described absolute location information comprises absolute row index value, or absolute row index value, or absolute line label value and absolute row index value;
Judging unit 703 is used for judging the relative position information parameter of importing;
When described relative position information parameter is relative line label value, described terminal comprises converting unit 704, be used for the absolute location information according to the relative position information in the scope of described constituency and described relative position information correspondence, described relative line label value is converted to absolute capable table number value; Display unit 705 is used for described absolute line label value is shown as information;
When described relative position information parameter is relative row index value, described terminal comprises converting unit 704, be used for the absolute location information according to the relative position information in the scope of described constituency and described relative position information correspondence, described relative row index value is converted to absolute tabulation number value; Display unit 705 is used for described absolute row index value is shown as information;
When described relative position information parameter is relative line label value and relative row index value, described terminal comprises converting unit 704, be used for the absolute location information according to the relative position information in the scope of described constituency and described relative position information correspondence, described relative line label value is converted to absolute capable table number value, simultaneously described relative row index value is converted to absolute tabulation number value; Display unit 705 is used for described absolute line label value and described absolute row index value are shown as information.
When described relative position information parameter was relative line label value and relative row index value, described terminal also comprised:
Described acquiring unit 701 also is used for obtaining the appointed area parameter of input, and described appointed area parameter is appointed area height and width value;
Computing unit 706 is used for calculating relative ranks value according to described appointed area height value and width value, and described positional information is shown as information.
Described computing unit 706 calculates relative ranks value according to described appointed area height value and width value, comprising:
If described appointed area height value is 1, and described appointed area width value is electrical form full line width, then described computing unit 706 is according to the absolute location information of the relative position information in the scope of described constituency and described relative position information correspondence, described relative line label value is converted to absolute capable table number value, described display unit 705 shows described absolute line label value as information, or
If described appointed area width value is 1, and described appointed area height value is electrical form permutation height, then described computing unit 706 is according to the absolute location information of the relative position information in the scope of described constituency and described relative position information correspondence, described relative row index value is converted to absolute tabulation number value, described display unit 705 shows described absolute row index value as information, or
If described appointed area height value and appointed area width value are 1, then described computing unit 706 is according to the absolute location information of the relative position information in the scope of described constituency and described relative position information correspondence, described relative line label value is converted to absolute capable table number value, simultaneously described relative row index value is converted to absolute tabulation number value, described display unit 705 shows described absolute line label value and described absolute row index value as information, or
If described appointed area width value is greater than 1 and less than electrical form full line width value, and described appointed area height value is greater than 1 and less than electrical form permutation height value, described computing unit 706 obtains the positional information in the upper left corner, and the positional information in the calculating lower right corner, appointed area, and the positional information in the described upper left corner and the lower right corner is converted to relative ranks value, described display unit 705 shows described relative ranks value as information; Wherein, described computing unit 706 calculates the positional information in the lower right corner, appointed area, comprise: line label value and the row index value of calculating the described regional lower right corner, the line label value in the described regional lower right corner be upper left corner line label value and appointed area height value and subtract 1, the row index value in the described regional lower right corner be upper left corner row index value and target area width value with subtract 1;
Described computing unit 706 is converted to relative ranks value with the positional information in the described upper left corner and the lower right corner, comprising:
According to letter and the corresponding relation of row-coordinate value, be alphabetical with upper left corner row-coordinate number and lower right corner row coordinate conversion, upper left corner row index value and lower right corner line label value are added 1 respectively; The described upper left corner and the lower right corner are respectively upper left corner cell and the last cell cell of described appointed area.
One of ordinary skill in the art will appreciate that: accompanying drawing is the synoptic diagram of an embodiment, and the unit in the accompanying drawing or flow process might not be that enforcement the present invention is necessary.
In several embodiment that the application provides, should be understood that, disclosed system, equipment and method can realize by other mode.For example, apparatus embodiments described above only is schematic, for example, the division of described unit, only be that a kind of logic function is divided, during actual the realization other dividing mode can be arranged, for example a plurality of unit or assembly can in conjunction with or can be integrated into another system, or some features can ignore, or do not carry out.Another point, the shown or coupling each other discussed or directly to be coupled or to communicate to connect can be by some interfaces, the indirect coupling of equipment or unit or communicate to connect can be electrically, machinery or other form.
Described unit as separating component explanation can or can not be physically to separate also, and the parts that show as the unit can be or can not be physical locations also, namely can be positioned at a place, perhaps also can be distributed on a plurality of network element.Can select wherein some or all of unit to realize the purpose of present embodiment scheme according to the actual needs.
In addition, each functional unit in each embodiment of the present invention can be integrated in the processing unit, also can be that the independent physics in each unit exists, and also can be integrated in the unit two or more unit.Above-mentioned integrated unit both can adopt the form of hardware to realize, the form that also can adopt hardware to add SFU software functional unit realizes.
The above-mentioned integrated unit of realizing with the form of SFU software functional unit can be stored in the computer read/write memory medium.Above-mentioned SFU software functional unit is stored in the storage medium, comprise some instructions with so that computer equipment (can be personal computer, server, the perhaps network equipment etc.) carry out the part steps of the described method of each embodiment of the present invention.And aforesaid storage medium comprises: USB flash disk, portable hard drive, ROM (read-only memory) (Read-Only Memory, abbreviation ROM), various media that can be program code stored such as random access memory (Random Access Memory is called for short RAM), magnetic disc or CD.It should be noted that at last: above embodiment only in order to technical scheme of the present invention to be described, is not intended to limit; Although with reference to previous embodiment the present invention is had been described in detail, those of ordinary skill in the art is to be understood that: it still can be made amendment to the technical scheme that aforementioned each embodiment puts down in writing, and perhaps part technical characterictic wherein is equal to replacement; And these modifications or replacement do not make the essence of appropriate technical solution break away from the spirit and scope of various embodiments of the present invention technical scheme.
Claims (8)
1. the method for the relative ranks value of prompting in electrical form is characterized in that, comprising:
Terminal monitors the input instruction, obtains table area parameter and the relative position information parameter of input, and described relative position information parameter is capable relatively label value, or relative column label value, or capable relatively label value and relative column label value;
Described terminal reads the constituency scope of described table area parameter correspondence, determine relative position information in the scope of described constituency and the absolute location information of described relative position information correspondence, described absolute location information comprises absolute column label value, or absolute column label value, or definitely capable label value and absolute column label value;
The relative position information parameter of described terminal judges input;
When described relative position information parameter when going label value relatively, described terminal is according to the absolute location information of the relative position information in the scope of described constituency and described relative position information correspondence, the described label value of going relatively is converted to absolute capable label value, and described absolute capable label value is shown as information;
When described relative position information parameter is relative column label value, described terminal is according to the absolute location information of the relative position information in the scope of described constituency and described relative position information correspondence, described relative column label value is converted to absolute column label value, and described absolute column label value is shown as information;
When described relative position information parameter when going label value and relative column label value relatively, described terminal is according to the absolute location information of the relative position information in the scope of described constituency and described relative position information correspondence, the described label value of going relatively is converted to absolute capable label value, simultaneously described relative column label value is converted to absolute column label value, and described absolute capable label value and described absolute column label value are shown as information.
2. method according to claim 1 is characterized in that, when described relative position information parameter when going label value and relative column label value relatively, described method further comprises:
Described terminal is obtained the appointed area parameter of input, and described appointed area parameter is appointed area height and width value;
Described terminal calculates relative ranks value according to described appointed area height value and width value, and described positional information is shown as information.
3. method according to claim 2 is characterized in that, described terminal calculates relative ranks value according to described appointed area height value and width value, comprising:
If described appointed area height value is 1, and described appointed area width value is electrical form full line width, then described terminal is according to the absolute location information of the relative position information in the scope of described constituency and described relative position information correspondence, the described label value of going relatively is converted to absolute capable label value, and described absolute capable label value shown as information, or
If described appointed area width value is 1, and described appointed area height value is electrical form permutation height, then described terminal is according to the absolute location information of the relative position information in the scope of described constituency and described relative position information correspondence, described relative column label value is converted to absolute column label value, and described absolute column label value shown as information, or
If described appointed area height value and appointed area width value are 1, then described terminal is according to the absolute location information of the relative position information in the scope of described constituency and described relative position information correspondence, the described label value of going relatively is converted to absolute capable label value, simultaneously described relative column label value is converted to absolute column label value, and described absolute capable label value and described absolute column label value shown as information, or
If described appointed area width value is greater than 1 and less than electrical form full line width value, and described appointed area height value is greater than 1 and less than electrical form permutation height value, described terminal is obtained the positional information in the upper left corner, and the positional information in the calculating lower right corner, appointed area, and the positional information in the described upper left corner and the lower right corner is converted to relative ranks value, described relative ranks value is shown as information; Wherein, the positional information in the lower right corner, described calculating appointed area, comprise: described terminal is calculated capable label value and the column label value in the described regional lower right corner, the capable label value in the described regional lower right corner be upper left corner row label value and appointed area height value and subtract 1, the column label value in the described regional lower right corner be upper left corner column label value and target area width value with subtract 1;
Described positional information with the described upper left corner and the lower right corner is converted to relative ranks value, comprising:
According to the corresponding relation of letter with the row-coordinate value, be letter with upper left corner row-coordinate and lower right corner row coordinate conversion, upper left corner row coordinate figure and lower right corner row-coordinate value are added 1 respectively; The described upper left corner and the lower right corner are respectively upper left corner cell and the last cell cell of described appointed area.
4. according to each described method of claim 1-3, it is characterized in that, described the described label value of going relatively is converted to absolute capable label value, comprise: calculate absolute row label value, described absolute capable label value be described form parameter correspondence upper left corner cell capable label value and described input relative capable label value with subtract 1; Or,
Described described relative column label value is converted to absolute column label value, comprises: calculate absolute column label value, described absolute column label value be described form parameter correspondence upper left corner cell column label value and described input relative column label value and subtract 1.
5. method according to claim 4 is characterized in that, before described terminal is converted to absolute capable label value with described capable relatively label value, or before described terminal is converted to absolute column label value with described relative column label value, also comprises:
Described terminal judges is described goes the validity of label value relatively, if describedly go label value relatively more than or equal to 1 and less than the peak width value of the form parameter correspondence of described input, the described label value of going relatively is effective, otherwise import invalid, or,
The validity of the described relative column label value of described terminal judges, if described relative column label value is more than or equal to 1 and less than the region height value of the form parameter correspondence of described input, described relative column label value is effective, otherwise import invalid.
6. the terminal of the relative ranks value of prompting appointment in electrical form is characterized in that, comprising:
Acquiring unit for monitoring the input instruction, obtains table area parameter and the relative position information parameter of input, and described relative position information parameter is capable relatively label value, or relative column label value, or capable relatively label value and relative column label value;
Determining unit, be used for reading the constituency scope of described table area parameter correspondence, determine relative position information in the scope of described constituency and the absolute location information of described relative position information correspondence, described absolute location information comprises absolute column label value, or absolute column label value, or definitely capable label value and absolute column label value;
Judging unit is used for judging the relative position information parameter of importing;
When described relative position information parameter when going label value relatively, described terminal comprises converting unit, be used for the absolute location information according to the relative position information in the scope of described constituency and described relative position information correspondence, the described label value of going relatively is converted to absolute capable label value; Display unit is used for described absolute capable label value is shown as information;
When described relative position information parameter is relative column label value, described terminal comprises converting unit, be used for the absolute location information according to the relative position information in the scope of described constituency and described relative position information correspondence, described relative column label value is converted to absolute column label value; Display unit is used for described absolute column label value is shown as information;
When described relative position information parameter when going label value and relative column label value relatively, described terminal comprises converting unit, be used for the absolute location information according to the relative position information in the scope of described constituency and described relative position information correspondence, the described label value of going relatively is converted to absolute capable label value, simultaneously described relative column label value is converted to absolute column label value; Display unit is used for described absolute capable label value and described absolute column label value are shown as information.
7. terminal according to claim 6 is characterized in that, when described relative position information parameter when going label value and relative column label value relatively, described terminal also comprises:
Described acquiring unit also is used for obtaining the appointed area parameter of input, and described appointed area parameter is appointed area height and width value;
Computing unit is used for calculating relative ranks value according to described appointed area height value and width value, and described positional information is shown as information.
8. terminal according to claim 7 is characterized in that, described computing unit calculates relative ranks value according to described appointed area height value and width value, comprising:
If described appointed area height value is 1, and described appointed area width value is electrical form full line width, then described computing unit is according to the absolute location information of the relative position information in the scope of described constituency and described relative position information correspondence, the described label value of going relatively is converted to absolute capable label value, described display unit shows described absolute capable label value as information, or
If described appointed area width value is 1, and described appointed area height value is electrical form permutation height, then described computing unit is according to the absolute location information of the relative position information in the scope of described constituency and described relative position information correspondence, described relative column label value is converted to absolute column label value, described display unit shows described absolute column label value as information, or
If described appointed area height value and appointed area width value are 1, then described computing unit is according to the absolute location information of the relative position information in the scope of described constituency and described relative position information correspondence, the described label value of going relatively is converted to absolute capable label value, simultaneously described relative column label value is converted to absolute column label value, described display unit shows described absolute capable label value and described absolute column label value as information, or
If described appointed area width value is greater than 1 and less than electrical form full line width value, and described appointed area height value is greater than 1 and less than electrical form permutation height value, described computing unit obtains the positional information in the upper left corner, and the positional information in the calculating lower right corner, appointed area, and the positional information in the described upper left corner and the lower right corner is converted to relative ranks value, described display unit shows described relative ranks value as information; Wherein, described computing unit calculates the positional information in the lower right corner, appointed area, comprise: capable label value and the column label value of calculating the described regional lower right corner, the capable label value in the described regional lower right corner be upper left corner row label value and appointed area height value and subtract 1, the column label value in the described regional lower right corner be upper left corner column label value and target area width value with subtract 1;
Described computing unit is converted to relative ranks value with the positional information in the described upper left corner and the lower right corner, comprising:
According to the corresponding relation of letter with the row-coordinate value, be letter with upper left corner row seat coordinate and lower right corner row coordinate conversion, upper left corner row coordinate figure and lower right corner row-coordinate value are added 1 respectively; The described upper left corner and the lower right corner are respectively upper left corner cell and the last cell cell of described appointed area.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310294127.4A CN103336762B (en) | 2013-07-12 | 2013-07-12 | A kind of method and terminal pointing out relative ranks value in electrical form |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310294127.4A CN103336762B (en) | 2013-07-12 | 2013-07-12 | A kind of method and terminal pointing out relative ranks value in electrical form |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103336762A true CN103336762A (en) | 2013-10-02 |
| CN103336762B CN103336762B (en) | 2016-06-08 |
Family
ID=49244931
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310294127.4A Active CN103336762B (en) | 2013-07-12 | 2013-07-12 | A kind of method and terminal pointing out relative ranks value in electrical form |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103336762B (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106959941A (en) * | 2016-01-11 | 2017-07-18 | 北京国双科技有限公司 | Web page form delet method and device |
| CN109002427A (en) * | 2017-06-06 | 2018-12-14 | 珠海金山办公软件有限公司 | The method, apparatus and electronic equipment of refresh function parameter in electrical form |
| CN109558578A (en) * | 2018-11-26 | 2019-04-02 | 成都四方伟业软件股份有限公司 | Report conversion method and device |
| CN110147565A (en) * | 2019-03-29 | 2019-08-20 | 西安建筑科技大学 | A kind of spring unit modeling method of the SRC component finite element model based on Excel |
| CN111832270A (en) * | 2019-03-27 | 2020-10-27 | 珠海金山办公软件有限公司 | Method and device for displaying row number and column label of table and electronic equipment |
| CN113590619A (en) * | 2021-07-22 | 2021-11-02 | 中共四川省委组织部 | Information protection and data management method based on label |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108268193B (en) * | 2017-01-04 | 2021-03-02 | 珠海金山办公软件有限公司 | Method and device for displaying prompt information corresponding to functions in spreadsheet |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5987481A (en) * | 1997-07-01 | 1999-11-16 | Microsoft Corporation | Method and apparatus for using label references in spreadsheet formulas |
| CN101211334A (en) * | 2006-12-28 | 2008-07-02 | 珠海金山软件股份有限公司 | Device and method for positioning unit grid position in electronic form designated area |
| US20120079363A1 (en) * | 2005-09-09 | 2012-03-29 | Microsoft Corporation | Filtering User Interface for a Data Summary Table |
| CN102799576A (en) * | 2012-07-05 | 2012-11-28 | 珠海金山办公软件有限公司 | Method and device for giving different line-row operation prompts in electronic form |
-
2013
- 2013-07-12 CN CN201310294127.4A patent/CN103336762B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5987481A (en) * | 1997-07-01 | 1999-11-16 | Microsoft Corporation | Method and apparatus for using label references in spreadsheet formulas |
| US20120079363A1 (en) * | 2005-09-09 | 2012-03-29 | Microsoft Corporation | Filtering User Interface for a Data Summary Table |
| CN101211334A (en) * | 2006-12-28 | 2008-07-02 | 珠海金山软件股份有限公司 | Device and method for positioning unit grid position in electronic form designated area |
| CN102799576A (en) * | 2012-07-05 | 2012-11-28 | 珠海金山办公软件有限公司 | Method and device for giving different line-row operation prompts in electronic form |
Non-Patent Citations (2)
| Title |
|---|
| HUST_XIAOWEI: "《http://blog.csdn.net/qq1987924/article/details/7927829》", 31 August 2012, article "excel VLOOKUP函数的使用方法" * |
| MICROSOFT: "《Microsoft Excel 2003》", 31 December 2003, article "Vlookup函数操作" * |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106959941A (en) * | 2016-01-11 | 2017-07-18 | 北京国双科技有限公司 | Web page form delet method and device |
| CN109002427A (en) * | 2017-06-06 | 2018-12-14 | 珠海金山办公软件有限公司 | The method, apparatus and electronic equipment of refresh function parameter in electrical form |
| US11238213B2 (en) | 2017-06-06 | 2022-02-01 | Beijing Kingsoft Office Software, Inc. | Method and apparatus for displaying function parameter in spreadsheet, and electronic device |
| CN109558578A (en) * | 2018-11-26 | 2019-04-02 | 成都四方伟业软件股份有限公司 | Report conversion method and device |
| CN111832270A (en) * | 2019-03-27 | 2020-10-27 | 珠海金山办公软件有限公司 | Method and device for displaying row number and column label of table and electronic equipment |
| CN111832270B (en) * | 2019-03-27 | 2024-03-19 | 珠海金山办公软件有限公司 | Method and device for displaying line numbers and column labels of tables in non-table document and electronic equipment |
| CN110147565A (en) * | 2019-03-29 | 2019-08-20 | 西安建筑科技大学 | A kind of spring unit modeling method of the SRC component finite element model based on Excel |
| CN110147565B (en) * | 2019-03-29 | 2022-09-13 | 西安建筑科技大学 | Excel-based spring unit modeling method for SRC member finite element model |
| CN113590619A (en) * | 2021-07-22 | 2021-11-02 | 中共四川省委组织部 | Information protection and data management method based on label |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103336762B (en) | 2016-06-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103336762A (en) | Method and terminal for pointing out relative rank and column values in spreadsheet | |
| CN108984499B (en) | Report data processing method and device, electronic equipment and readable storage medium | |
| CN101719100A (en) | Compression based wear leveling for non-volatile memory | |
| US20210232561A1 (en) | Data processing method and apparatus, and computer-readable storage medium | |
| CN105045775A (en) | Method and apparatus for generating Excel document in designated format | |
| US9613005B2 (en) | Method and apparatus for bidirectional typesetting | |
| CN107943542A (en) | A kind of configuration information management method, device, computer-readable recording medium and storage control | |
| CN104199977A (en) | Method for creating information search based on data in database | |
| CN105632270A (en) | Data processing method and data processing device based on exam | |
| CN102117266A (en) | Method and device for processing character pitch | |
| CN104375814A (en) | Generation method and device of an interface document | |
| CN104636717A (en) | Method and device for identifying diagram | |
| CN101655835A (en) | Method for text message processing, text message output and character retrieval in electronic document and device thereof | |
| CN104978169A (en) | SDK processing method and SDK processing device for periodical reading application | |
| CN101303742B (en) | Microminiature Hanxin code and method for generating symbol thereof | |
| CN102479072B (en) | Multi-header report generating method, device and terminal | |
| CN105630506A (en) | Bill generation method, bill template generation method and related devices | |
| WO2023024959A1 (en) | Image labeling method and system, and device and storage medium | |
| CN102855115A (en) | Method and system for displaying character label based on splicing wall | |
| CN101436177B (en) | Method and apparatus for importing data film to form | |
| RU2640294C1 (en) | Method of recording and recording apparatus for memory device | |
| CN104572655A (en) | Data processing method, device and system | |
| CN105677629A (en) | Information processing method and electronic device | |
| CN103065337A (en) | Two-dimensional graphic file parsing drawing system and two-dimensional graphic file parsing drawing method | |
| CN109144624A (en) | Method, storage medium, equipment and the system of not contour list are shown in IOS |
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 | ||
| C56 | Change in the name or address of the patentee | ||
| 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. |