CN105988655B - A kind of spreadsheet line column region method of adjustment and device - Google Patents
A kind of spreadsheet line column region method of adjustment and device Download PDFInfo
- Publication number
- CN105988655B CN105988655B CN201510067163.6A CN201510067163A CN105988655B CN 105988655 B CN105988655 B CN 105988655B CN 201510067163 A CN201510067163 A CN 201510067163A CN 105988655 B CN105988655 B CN 105988655B
- Authority
- CN
- China
- Prior art keywords
- adjustment
- user
- action
- type
- column
- 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)
Abstract
The embodiment of the invention discloses a kind of spreadsheet line column region method of adjustment and devices, a kind of spreadsheet line column region method of adjustment, for realizing the increase or deletion to electrical form ranks, comprising the following steps: receive the adjustment trigger action that user is directed to current spreadsheet ranks region；Determine regulating object type, adjustment type of action and adjustment quantity；According to definitive result, current spreadsheet ranks region is adjusted；It currently needs to be adjusted line number amount or needs to be adjusted number of columns wherein it is determined that regulating object type comprises determining that；It determines that adjustment type of action comprises determining that currently to need to carry out increase operation or need to carry out delete operation；Determine that adjustment quantity includes: to show adjustment quantity inquiry interface；According to the user in the numerical value of the adjustment quantity inquiry interface input or selection, adjustment quantity is determined.It is user-friendly using technical solution provided by the embodiment of the present invention, it is able to ascend user experience.
Description
Technical field
The present invention relates to technical field of office software, in particular to a kind of spreadsheet line column region method of adjustment and dress
It sets.
Background technique
Spreadsheet software is one of common office software, and user can be used spreadsheet software and make various formats
Electrical form, to carry out information record, data statistics etc..It is needed when the line number or columns of electrical form are unsatisfactory for user currently
When asking, user needs to be adjusted spreadsheet line column region, increases or delete the row or column of respective numbers, such as in electronic watch
Lattice in the ranks or row end increases or deletes corresponding row, or between the column of electrical form or column end increases or deletes corresponding
Column.
A kind of existing ranks region method of adjustment is that operation button, such as Fig. 1 is arranged at the row, column end of electrical form
Shown in button 110 and button 120, drag operation button downward by user, upward, leftward or rightward completes corresponding increase
The operation for adding or deleting both, increased line number or columns carry out true according to the multiple proportion of dragging distance and a reference value of setting
It is fixed.
This method has some disadvantages, firstly, user is easily lost during drag operation button to operation
The control of button；Secondly, in drag operation button procedure, being unable to judge accurately out current when user needs to increase row, column
Dragging distance and setting a reference value multiple proportion, also can not just determine whether current dragging distance can meet oneself
Want the requirement of increased line number or columns.Therefore, additions and deletions electrical form ranks in this way, it may be necessary to which user carries out
Repeatedly adjustment could be completed to accordingly increase, delete row, column operation repeatedly, it has not been convenient to which user uses, and user experience is poor.
Summary of the invention
The embodiment of the present invention is designed to provide a kind of spreadsheet line column region method of adjustment and device, to facilitate use
Family uses, and promotes user experience.Technical solution is as follows:
A kind of spreadsheet line column region method of adjustment, it is described for realizing the increase or deletion to electrical form ranks
Method includes:
Receive the adjustment trigger action that user is directed to current spreadsheet ranks region；
Determine regulating object type, adjustment type of action and adjustment quantity；
According to definitive result, current spreadsheet ranks region is adjusted；
Wherein,
The determining regulating object type, which comprises determining that, currently to be needed to be adjusted line number amount or need to number of columns
It is adjusted；
The determining adjustment type of action, which comprises determining that, currently to need to carry out increase operation or needs to carry out delete operation；
The determining adjustment quantity includes: to show adjustment quantity inquiry interface；According to the user in the adjustment quantity
The numerical value for inquiring interface input or selection determines adjustment quantity.
In a kind of specific embodiment of the invention,
The adjustment trigger action for receiving user and being directed to current spreadsheet ranks region, comprising:
User is received for the clicking operation of the first kind adjustment button in current spreadsheet ranks region, Current electronic table
The different row, column of lattice respectively corresponds different first kind adjustment buttons；
Correspondingly, determining regulating object type by following steps:
According to the corresponding relationship of the first kind adjustment button and current spreadsheet ranks that the user clicks, adjustment is determined
Object type.
In a kind of specific embodiment of the invention, adjustment type of action is determined by following steps:
Show adjustment type of action option corresponding with the first kind adjustment button that the user clicks；
According to selection of the user in the adjustment type of action option, adjustment type of action is determined.
In a kind of specific embodiment of the invention,
The adjustment trigger action for receiving user and being directed to current spreadsheet ranks region, comprising:
User is received for the clicking operation of the second class adjustment button in current spreadsheet ranks region, Current electronic table
The different row, column of lattice respectively corresponds different the second class adjustment buttons；
Correspondingly, determining regulating object type by following steps and determining adjustment type of action:
According to the corresponding relationship of the second class adjustment button and current spreadsheet ranks that the user clicks, adjustment is determined
Object type；
According to the clicking operation of the user, determine the user to the number of clicks of second class adjustment button；
According to the relationship of preset number of clicks and adjustment type of action, adjustment type of action is determined.
In a kind of specific embodiment of the invention, adjustment type of action is determined by following steps and determines adjustment number
Amount:
It shows adjustment quantity selection interface, includes at least one option, each option in the adjustment quantity selection interface
Respectively user provides the combination of a kind of adjustment quantity and adjustment type of action；
According to the user in the selection of the adjustment quantity selection interface, determines adjustment type of action and determine adjustment number
Amount.
In a kind of specific embodiment of the invention, in the case where determining adjustment type of action is to increase operation,
It is described according to definitive result, current spreadsheet ranks region is adjusted, comprising:
According to determining regulating object type and adjustment quantity, increases the row of respective numbers or increase the column of respective numbers；
Wherein, the format of new line increment determines that the new line increment closes on row root according to the row format that closes on of the new line increment
Determine that the row that closes on of the new line increment includes: a line on the downside of new line increment according to preset first rule, or one on the upside of new line increment
Row；
The format newly added determines according to the column format of closing on newly added, it is described newly add close on column according to pre-
If Second Rule determine, it is described newly add close on column include: newly add left side a column, or newly add right side a column.
A kind of spreadsheet line column region adjustment device, it is described for realizing the increase or deletion to electrical form ranks
Device includes:
Receiving module, the adjustment trigger action for being directed to current spreadsheet ranks region for receiving user；
Determining module, for determining regulating object type, adjustment type of action and adjustment quantity；
Module is adjusted, for the determination according to the determining module as a result, adjusting to current spreadsheet ranks region
It is whole；
Wherein,
The determining module is specifically used for: determining and currently needs to be adjusted line number amount or need to carry out number of columns
Adjustment；
The determining module is specifically used for: determination currently needs to carry out increase operation or needs to carry out delete operation；
The determining module is specifically used for: showing that adjustment quantity inquires interface；According to the user in the adjustment quantity
The numerical value for inquiring interface input or selection determines adjustment quantity.
In a kind of specific embodiment of the invention,
The receiving module is specifically used for:
User is received for the clicking operation of the first kind adjustment button in current spreadsheet ranks region, Current electronic table
The different row, column of lattice respectively corresponds different first kind adjustment buttons；
Correspondingly, the determining module is specifically used for:
According to the corresponding relationship of the first kind adjustment button and current spreadsheet ranks that the user clicks, adjustment is determined
Object type.
In a kind of specific embodiment of the invention, the determining module is specifically used for:
Show adjustment type of action option corresponding with the first kind adjustment button that the user clicks；
According to selection of the user in the adjustment type of action option, adjustment type of action is determined.
In a kind of specific embodiment of the invention,
The receiving module is specifically used for:
User is received for the clicking operation of the second class adjustment button in current spreadsheet ranks region, Current electronic table
The different row, column of lattice respectively corresponds different the second class adjustment buttons；
Correspondingly, the determining module is specifically used for:
According to the corresponding relationship of the second class adjustment button and current spreadsheet ranks that the user clicks, adjustment is determined
Object type；
According to the clicking operation of the user, determine the user to the number of clicks of second class adjustment button；
According to the relationship of preset number of clicks and adjustment type of action, adjustment type of action is determined.
In a kind of specific embodiment of the invention, the determining module is specifically used for:
It shows adjustment quantity selection interface, includes at least one option, each option in the adjustment quantity selection interface
Respectively user provides the combination of a kind of adjustment quantity and adjustment type of action；
According to the user in the selection of the adjustment quantity selection interface, determines adjustment type of action and determine adjustment number
Amount.
In a kind of specific embodiment of the invention, the adjustment module is specifically used for:
In the case where determining adjustment type of action is to increase operation, according to determining regulating object type and adjustment number
Amount increases the row of respective numbers or increases the column of respective numbers；
Wherein, the format of new line increment determines that the new line increment closes on row root according to the row format that closes on of the new line increment
Determine that the row that closes on of the new line increment includes: a line on the downside of new line increment according to preset first rule, or one on the upside of new line increment
Row；
The format newly added determines according to the column format of closing on newly added, it is described newly add close on column according to pre-
If Second Rule determine, it is described newly add close on column include: newly add left side a column, or newly add right side a column.
Using technical solution provided by the embodiment of the present invention, when user needs to be adjusted spreadsheet line column region
When, it is corresponding in adjustment quantity inquiry interface input or selection by user by showing that adjustment quantity inquires interface to user
Numerical value adjusts quantity to determine, identified adjustment quantity matches with the actual demand of user, do not need user and adjust repeatedly
Can be completed accordingly increase, delete operation, it is user-friendly, be able to ascend user experience.
Detailed description of the invention
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, to embodiment or will show below
There is attached drawing needed in technical description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
Some embodiments of invention for those of ordinary skill in the art without creative efforts, can be with
It obtains other drawings based on these drawings.
Fig. 1 show a kind of schematic diagram of electrical form in background technique；
Fig. 2 show the implementation flow chart of spreadsheet line column region method of adjustment provided in an embodiment of the present invention；
Fig. 3 a show a kind of schematic diagram of electrical form adjustment button provided in an embodiment of the present invention；
Fig. 3 b show another schematic diagram of electrical form adjustment button provided in an embodiment of the present invention；
Fig. 4 show adjustment quantity selection interface schematic diagram provided in an embodiment of the present invention；
Fig. 5 show another schematic diagram of electrical form adjustment button provided in an embodiment of the present invention；
Fig. 6 show the structural schematic diagram of spreadsheet line column region adjustment device provided in an embodiment of the present invention.
Specific embodiment
In order to make those skilled in the art more fully understand the technical solution in the embodiment of the present invention, below in conjunction with this hair
Attached drawing in bright embodiment, technical scheme in the embodiment of the invention is clearly and completely described, it is clear that described
Embodiment is only a part of the embodiment of the present invention, instead of all the embodiments.Based on the embodiments of the present invention, this field
Those of ordinary skill's every other embodiment obtained without making creative work, belongs to protection of the present invention
Range.
It is shown in Figure 2, it is a kind of implementation stream of spreadsheet line column region method of adjustment provided in an embodiment of the present invention
Cheng Tu, this method may comprise steps of:
S210: the adjustment trigger action that user is directed to current spreadsheet ranks region is received；
In practical applications, it in the case where the line number of current spreadsheet or columns are unsatisfactory for user's current demand, needs
Will the ranks region to current spreadsheet be adjusted, the row for such as increasing certain line number, deletes one at the column for increasing certain columns
Determine the row of line number or deletes the column of certain columns.When user has this adjustment demand, need to issue corresponding adjustment instruction,
To trigger the trigger action to current spreadsheet ranks region.In practical applications, can be arranged in electrical form corresponding
Adjustment button or adjustment option be supplied to user, with by user to adjustment button or adjustment option operate, trigger to electricity
The adjustment in sub-table ranks region operates.Button is adjusted or in electronic watch for example, can be arranged in spreadsheet line column region
Setting adjustment option in the menu of lattice software, user clicks adjustment button or the corresponding adjustment option of selection can be considered sending
Adjustment instruction.
After receiving adjustment trigger action of the user for current spreadsheet ranks region, step can be continued to execute
Rapid S220.
S220: regulating object type, adjustment type of action and adjustment quantity are determined；
Wherein, the determining regulating object type, which comprises determining that, currently needs to be adjusted line number amount or need to column
Quantity is adjusted；
The determining adjustment type of action, which comprises determining that, currently to need to carry out increase operation or needs to carry out delete operation；
The determining adjustment quantity includes: to show adjustment quantity inquiry interface；According to the user in the adjustment quantity
The numerical value for inquiring interface input or selection determines adjustment quantity.
It is understood that before being adjusted to spreadsheet line column region, it is thus necessary to determine that regulating object type is adjusted
Whole type of action and adjustment quantity determine and need to increase how many row or increase how many column or delete how many row or delete more
Few column.
Determining that specific value option, root can be provided by inquiring in interface in the adjustment quantity shown when adjusting quantity
Adjustment quantity is determined according to the numerical value of user's selection；Adjustment quantity input frame can also be provided, user inputs phase according to actual needs
The numerical value answered determines adjustment quantity according to the numerical value of user's input.Exhibition for specific value option and adjustment quantity input frame
Existing form can be designed according to the characteristics of terminal operating system, such as in an intelligent terminal, can pass through each option of user's stroke
To select to meet the numerical value of actual demand, in computer terminal, each option can be rolled to select by user by setting scroll bar
Meet the numerical value of actual demand.The present invention is without limitation.
It is understood that regulating object type, adjustment type of action, adjustment quantity, can be determined respectively, may be used also
To be determined simultaneously.
In a kind of specific embodiment of the invention, step S210 receives user and is directed to current spreadsheet ranks region
Adjustment trigger action, may comprise steps of:
User is received for the clicking operation of the first kind adjustment button in current spreadsheet ranks region, Current electronic table
The different row, column of lattice respectively corresponds different first kind adjustment buttons；
Correspondingly, can determine regulating object type by following steps:
According to the corresponding relationship of the first kind adjustment button and current spreadsheet ranks that the user clicks, adjustment is determined
Object type.
In practical applications, first kind adjustment button can have multiple, and the row, column different from electrical form is opposite respectively
It answers.Position of each first kind adjustment button in electrical form can be preset, the axis of the every row of electrical form is such as in
It on upper, each column axis, or is between spreadsheet line and row, between the column and the column, specifically may refer to Fig. 3 a and Fig. 3 b
Shown in position, button 310 and button 330 respectively correspond the 1st column, and button 320 and button 340 respectively correspond the 3rd row, other are pressed
Button is similar.
It is understood which kind of position that first kind adjustment button is in electrical form no matter is preset, it is different
It is corresponding that the first kind adjusts button row, column different from electrical form.When the user clicks when some first kind adjustment button, i.e.,
It can be considered and have issued adjustment instruction, the first kind adjustment button clicked according to user is corresponding with current spreadsheet ranks to close
System can determine regulating object type, that is, determine that user wants to be adjusted line number amount to be also intended to adjust number of columns
It is whole.For example, user clicks button 310 shown in Fig. 3 a, then it can determine and currently need to be adjusted number of columns.
In another specific embodiment of the invention, adjustment type of action can be determined by following steps:
Step 1: adjustment type of action option corresponding with the first kind adjustment button that the user clicks is shown；
Step 2: according to selection of the user in the adjustment type of action option, adjustment type of action is determined.
It is understood that first kind adjustment button can be provided simultaneously with increase, delete operation function, when user is to some
When first kind adjustment button is clicked, the corresponding adjustment type of action option of first kind adjustment button is shown, specifically, can
Increase operation button and delete operation button to expand on the basis of the first kind adjusts button, so that user further selects
Adjust type of action option.When the actual demand of user is to increase row or column, increase option of operation can be clicked, alternatively, working as
The actual demand of user is that when deleting row or column, can click delete operation option.According to user to adjustment type of action option
Selection, determine adjustment type of action.
In a kind of specific embodiment of the invention, step S210 receives user and is directed to current spreadsheet ranks region
Adjustment trigger action, may comprise steps of:
User is received for the clicking operation of the second class adjustment button in current spreadsheet ranks region, Current electronic table
The different row, column of lattice respectively corresponds different the second class adjustment buttons；
Correspondingly, can determine regulating object type by following steps and determine adjustment type of action:
First step: the second class adjustment button clicked according to the user is corresponding with current spreadsheet ranks to close
System, determines regulating object type；
Second step: according to the clicking operation of the user, determine the user to second class adjustment button
Number of clicks；
Third step: according to the relationship of preset number of clicks and adjustment type of action, adjustment type of action is determined.
To the first kind adjustment button it is similar, the second class adjustment button can have it is multiple, respectively the row different from electrical form,
It arranges corresponding.Position of each second class adjustment button in electrical form can be preset, the every row of electrical form is such as in
Axis on, on the axis of each column, or between spreadsheet line and row, between the column and the column, specifically may refer to Fig. 3 a
With position shown in Fig. 3 b, button 310 and button 330 respectively correspond the 1st column, and button 320 and button 340 respectively correspond the 3rd row,
Other buttons are similar.
It is understood which kind of position that the second class adjustment button is in electrical form no matter is preset, it is different
It is corresponding that second class adjusts button row, column different from electrical form.When the user clicks when some second class adjustment button, i.e.,
It can be considered and have issued adjustment instruction, the second class adjustment button clicked according to user is corresponding with current spreadsheet ranks to close
System can determine regulating object type, that is, determine that user wants to be adjusted line number amount to be also intended to adjust number of columns
It is whole.For example, user clicks button 310 shown in Fig. 3 a, then it can determine and currently need to be adjusted number of columns.
Second class adjustment button can be provided simultaneously with increase, delete operation function, according to the clicking operation of user, determine and use
Family determines adjustment according to the relationship of preset number of clicks and adjustment type of action to the number of clicks of the second class adjustment button
Type of action.It should be noted that the relationship of preset number of clicks and adjustment type of action, can be and set by system default
It sets, can also be configured by user according to personal habits.The present invention is without limitation.For example, setting are as follows: user clicks the
Two classes adjust button, corresponding to increase operation when clicking one time, when clicking twice, corresponding delete operation.
It should be noted that second step, third step need sequence to execute, but first step and the two steps
It is not carried out the limitation of sequence.
In another specific embodiment of the invention, adjustment type of action and determination can be determined by following steps
Adjust quantity:
Step 1: showing adjustment quantity selection interface, includes at least one option in the adjustment quantity selection interface, often
A option is respectively that user provides the combination of a kind of adjustment quantity and adjustment type of action；
Step 2: according to the user it is described adjustment quantity selection interface selection, determine adjustment type of action and really
It sets the tone integer number.
After step S210 receives adjustment trigger action of the user for current spreadsheet ranks region, it can show
Quantity selection interface is adjusted, includes at least one option in the interface, each option is respectively that user provides a kind of adjustment quantity
With the combination of adjustment type of action.It is shown in Figure 4, after user clicks button 330 shown in Fig. 3 b, show adjustment quantity selection
Interface 410 after user selects according to actual needs, that is, can determine adjustment type of action and determining adjustment quantity, for example, with
Family selects option "+2 ", indicates that user's adjustment type of action to be carried out is to increase operation, adjustment quantity is 2, because of button 330
Corresponding 1st column, it is possible to determine that regulating object type is number of columns, i.e., increase by 2 column on the column of current spreadsheet.
S230: according to definitive result, current spreadsheet ranks region is adjusted.
Step S220 respectively determine or simultaneously determined regulating object type, adjustment type of action and adjustment quantity it
Afterwards, according to identified as a result, being adjusted to current spreadsheet ranks region.
As can be seen from the above description, different first kind adjustment buttons or the second class adjustment button is different from electrical form
Row, column it is corresponding, for convenience of description, in the description of the step, by the first kind adjust button and the second class adjustment button system
Button is referred to as adjusted, the different adjustment buttons row, column different from electrical form is corresponding.Some adjustment button when the user clicks
When, that is, it can be mapped to certain specific row or certain column.It in practical applications, can be with row corresponding to the adjustment button of user's click
Or it is classified as benchmark, increase or delete row, column.New line increment is newly added, and deletes row, the position of deletion column can be set in advance by system
It sets, setting option can also be provided and be configured by user according to personal habits.Such as, the button according to shown in Fig. 3 a that user clicks
320, it can determine and currently need to be adjusted line number amount, and further determine that adjustment type of action to increase operation, adjustment
Quantity is 3, then can increase by 3 rows on the upside of the 3rd row, or increase on the downside of the 3rd row with corresponding 3rd standard of behaviour of button 320
Add 3 rows；If the adjustment type of action further determined that is delete operation, adjustment quantity is 2, then can be corresponding with button 320
The 3rd standard of behaviour, delete the 2nd row and the 3rd row, or delete the 1st row and the 2nd row.
It should be noted that adjustment button present position is different, different adjustment location rules can be set.
In practical applications, user increases at electrical form row, column end or the frequency of delete operation is higher, this
In the case of, the position setting adjustment button at can only be expert at end or column end is shown in Figure 5, when user has for current
When the adjustment demand of spreadsheet line column region, end of being directly expert at increases the row of respective numbers or increases phase at column end
It answers the column of quantity or end of being expert at deletes the row of respective numbers or deletes the column of respective numbers at column end.
In a kind of specific embodiment of the invention, in the case where determining adjustment type of action is to increase operation,
Step S230 may comprise steps of:
According to determining regulating object type and adjustment quantity, increases the row of respective numbers or increase the column of respective numbers；
Wherein, the format of new line increment determines that the new line increment closes on row root according to the row format that closes on of the new line increment
Determine that the row that closes on of the new line increment includes: a line on the downside of new line increment according to preset first rule, or one on the upside of new line increment
Row；
The format newly added determines according to the column format of closing on newly added, it is described newly add close on column according to pre-
If Second Rule determine, it is described newly add close on column include: newly add left side a column, or newly add right side a column.
It is understood that the electrical form that user uses spreadsheet software to make, it can be each according to actual demand setting
Kind format, may want to new line increment or the format newly added and the format of the original row or column of electrical form is consistent, in this way
Progress format editor can be added to new line increment or newly to avoid user, save the time.The format of new line increment can be according to new line increment
Close on row format determine, the format newly added can according to newly add close on column format determine.
Such as, according to step S220 to adjustment object type, adjustment type of action, adjustment determination of amount as a result, new line increment
Between the 2nd row of current spreadsheet and the 3rd row, then the format of new line increment can be identical as the format of the 2nd row, or with
The format of 3 rows is identical.It can be specifically determined according to default rule.
Using technical solution provided by the embodiment of the present invention, when user needs to be adjusted spreadsheet line column region
When, it is corresponding in adjustment quantity inquiry interface input or selection by user by showing that adjustment quantity inquires interface to user
Numerical value adjusts quantity to determine, identified adjustment quantity matches with the actual demand of user, do not need user and adjust repeatedly
Can be completed accordingly increase, delete operation, it is user-friendly, be able to ascend user experience.
Corresponding to above method embodiment, the embodiment of the invention also provides a kind of adjustment of spreadsheet line column region to fill
It sets, shown in Figure 6, which, for realizing increase or deletion to electrical form ranks, may include with lower module:
Receiving module 510, the adjustment trigger action for being directed to current spreadsheet ranks region for receiving user；
Determining module 520, for determining regulating object type, adjustment type of action and adjustment quantity；
Module 530 is adjusted, for the determination according to the determining module as a result, carrying out to current spreadsheet ranks region
Adjustment；
Wherein,
The determining module 520 is specifically used for: determine currently need to be adjusted line number amount or need to number of columns into
Row adjustment；
The determining module 520 is specifically used for: determination currently needs to carry out increase operation or needs to carry out delete operation；
The determining module 520 is specifically used for: showing that adjustment quantity inquires interface；According to the user in the adjustment number
The numerical value of amount inquiry interface input or selection, determines adjustment quantity.
In a kind of specific embodiment of the invention, the receiving module 510 is specifically used for:
User is received for the clicking operation of the first kind adjustment button in current spreadsheet ranks region, Current electronic table
The different row, column of lattice respectively corresponds different first kind adjustment buttons；
Correspondingly, the determining module 520 is specifically used for:
According to the corresponding relationship of the first kind adjustment button and current spreadsheet ranks that the user clicks, adjustment is determined
Object type.
In a kind of specific embodiment of the invention, the determining module 520 is specifically used for:
Show adjustment type of action option corresponding with the first kind adjustment button that the user clicks；
According to selection of the user in the adjustment type of action option, adjustment type of action is determined.
In a kind of specific embodiment of the invention, the receiving module 510 is specifically used for:
User is received for the clicking operation of the second class adjustment button in current spreadsheet ranks region, Current electronic table
The different row, column of lattice respectively corresponds different the second class adjustment buttons；
Correspondingly, the determining module 520 is specifically used for:
According to the corresponding relationship of the second class adjustment button and current spreadsheet ranks that the user clicks, adjustment is determined
Object type；
According to the clicking operation of the user, determine the user to the number of clicks of second class adjustment button；
According to the relationship of preset number of clicks and adjustment type of action, adjustment type of action is determined.
In a kind of specific embodiment of the invention, the determining module 520 is specifically used for:
It shows adjustment quantity selection interface, includes at least one option, each option in the adjustment quantity selection interface
Respectively user provides the combination of a kind of adjustment quantity and adjustment type of action；
According to the user in the selection of the adjustment quantity selection interface, determines adjustment type of action and determine adjustment number
Amount.
In a kind of specific embodiment of the invention, the adjustment module 530 is specifically used for:
In the case where determining adjustment type of action is to increase operation, according to determining regulating object type and adjustment number
Amount increases the row of respective numbers or increases the column of respective numbers；
Wherein, the format of new line increment determines that the new line increment closes on row root according to the row format that closes on of the new line increment
Determine that the row that closes on of the new line increment includes: a line on the downside of new line increment according to preset first rule, or one on the upside of new line increment
Row；
The format newly added determines according to the column format of closing on newly added, it is described newly add close on column according to pre-
If Second Rule determine, it is described newly add close on column include: newly add left side a column, or newly add right side a column.
Using device provided by the embodiment of the present invention, when user needs to be adjusted spreadsheet line column region,
By showing that adjustment quantity inquires interface to user, by user in adjustment quantity inquiry interface input or the corresponding number of selection
Value adjusts quantity to determine, identified adjustment quantity matches with the actual demand of user, do not need user and adjust repeatedly i.e.
It is achievable accordingly increase, delete operation, it is user-friendly, be able to ascend user experience.
It should be noted that, in this document, relational terms such as first and second and the like are used merely to a reality
Body or operation are distinguished with another entity or operation, are deposited without necessarily requiring or implying between these entities or operation
In any actual relationship or order or sequence.Moreover, the terms "include", "comprise" or its any other variant are intended to
Non-exclusive inclusion, so that the process, method, article or equipment including a series of elements is not only wanted including those
Element, but also including other elements that are not explicitly listed, or further include for this process, method, article or equipment
Intrinsic element.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that
There is also other identical elements in process, method, article or equipment including the element.
Each embodiment in this specification is all made of relevant mode and describes, same and similar portion between each embodiment
Dividing may refer to each other, and each embodiment focuses on the differences from other embodiments.Especially for device reality
For applying example, since it is substantially similar to the method embodiment, so being described relatively simple, related place is referring to embodiment of the method
Part explanation.
Those of ordinary skill in the art will appreciate that all or part of the steps in realization above method embodiment is can
It is completed with instructing relevant hardware by program, the program can store in computer-readable storage medium,
The storage medium designated herein obtained, such as: ROM/RAM, magnetic disk, CD.
The foregoing is merely illustrative of the preferred embodiments of the present invention, is not intended to limit the scope of the present invention.It is all
Any modification, equivalent replacement, improvement and so within the spirit and principles in the present invention, are all contained in protection scope of the present invention
It is interior.
Claims (10)
1. a kind of spreadsheet line column region method of adjustment, for realizing the increase or deletion to electrical form ranks, feature
It is, which comprises
Receive the adjustment trigger action that user is directed to current spreadsheet ranks region；
Determine regulating object type, adjustment type of action and adjustment quantity；
According to definitive result, current spreadsheet ranks region is adjusted；
Wherein,
The determining regulating object type, which comprises determining that, currently to be needed to be adjusted line number amount or need to carry out number of columns
Adjustment；
The determining adjustment type of action, which comprises determining that, currently to need to carry out increase operation or needs to carry out delete operation；
The determining adjustment quantity includes: to show adjustment quantity inquiry interface；It is inquired according to the user in the adjustment quantity
The numerical value of interface input or selection determines adjustment quantity；
The adjustment trigger action for receiving user and being directed to current spreadsheet ranks region, comprising:
User is received for the clicking operation of the second class adjustment button in current spreadsheet ranks region, current spreadsheet is not
Same row, column respectively corresponds different the second class adjustment buttons；
Correspondingly, determining regulating object type by following steps and determining adjustment type of action:
According to the corresponding relationship of the second class adjustment button and current spreadsheet ranks that the user clicks, regulating object is determined
Type；
According to the clicking operation of the user, determine the user to the number of clicks of second class adjustment button；
According to the relationship of preset number of clicks and adjustment type of action, adjustment type of action is determined.
2. the method according to claim 1, wherein
The adjustment trigger action for receiving user and being directed to current spreadsheet ranks region, comprising:
User is received for the clicking operation of the first kind adjustment button in current spreadsheet ranks region, current spreadsheet is not
Same row, column respectively corresponds different first kind adjustment buttons；
Correspondingly, determining regulating object type by following steps:
According to the corresponding relationship of the first kind adjustment button and current spreadsheet ranks that the user clicks, regulating object is determined
Type.
3. according to the method described in claim 2, it is characterized in that, determining adjustment type of action by following steps:
Show adjustment type of action option corresponding with the first kind adjustment button that the user clicks；
According to selection of the user in the adjustment type of action option, adjustment type of action is determined.
4. method according to claim 1 or 2, which is characterized in that by the determining adjustment type of action of following steps and really
It sets the tone integer number:
It shows adjustment quantity selection interface, includes at least one option in the adjustment quantity selection interface, each option difference
The combination of a kind of adjustment quantity and adjustment type of action is provided for user；
According to the user in the selection of the adjustment quantity selection interface, determines adjustment type of action and determine adjustment quantity.
5. the method according to claim 1, wherein the case where determining adjustment type of action is to increase operation
Under, it is described according to definitive result, current spreadsheet ranks region is adjusted, comprising:
According to determining regulating object type and adjustment quantity, increases the row of respective numbers or increase the column of respective numbers；
Wherein, the format of new line increment determines that the new line increment closes on row according to pre- according to the row format that closes on of the new line increment
If the first rule determine that the row that closes on of the new line increment includes: a line on the downside of new line increment, or newly a line on the upside of line increment；
The format newly added, according to it is described newly add close on column format determine, it is described newly add close on column according to preset
Second Rule determines that the column that close on newly added include: the column for newly adding left side, or newly add a column on right side.
6. a kind of spreadsheet line column region adjusts device, for realizing the increase or deletion to electrical form ranks, feature
It is, described device includes:
Receiving module, the adjustment trigger action for being directed to current spreadsheet ranks region for receiving user；
Determining module, for determining regulating object type, adjustment type of action and adjustment quantity；
Module is adjusted, for the determination according to the determining module as a result, being adjusted to current spreadsheet ranks region；
Wherein,
The determining module is specifically used for: determination currently needs to be adjusted line number amount or needs to be adjusted number of columns；
The determining module is specifically used for: determination currently needs to carry out increase operation or needs to carry out delete operation；
The determining module is specifically used for: showing that adjustment quantity inquires interface；It is inquired according to the user in the adjustment quantity
The numerical value of interface input or selection determines adjustment quantity；
The receiving module is specifically used for:
User is received for the clicking operation of the second class adjustment button in current spreadsheet ranks region, current spreadsheet is not
Same row, column respectively corresponds different the second class adjustment buttons；
Correspondingly, the determining module is specifically used for:
According to the corresponding relationship of the second class adjustment button and current spreadsheet ranks that the user clicks, regulating object is determined
Type；
According to the clicking operation of the user, determine the user to the number of clicks of second class adjustment button；
According to the relationship of preset number of clicks and adjustment type of action, adjustment type of action is determined.
7. device according to claim 6, which is characterized in that
The receiving module is specifically used for:
User is received for the clicking operation of the first kind adjustment button in current spreadsheet ranks region, current spreadsheet is not
Same row, column respectively corresponds different first kind adjustment buttons；
Correspondingly, the determining module is specifically used for:
According to the corresponding relationship of the first kind adjustment button and current spreadsheet ranks that the user clicks, regulating object is determined
Type.
8. device according to claim 7, which is characterized in that the determining module is specifically used for:
Show adjustment type of action option corresponding with the first kind adjustment button that the user clicks；
According to selection of the user in the adjustment type of action option, adjustment type of action is determined.
9. device according to claim 6 or 7, which is characterized in that the determining module is specifically used for:
It shows adjustment quantity selection interface, includes at least one option in the adjustment quantity selection interface, each option difference
The combination of a kind of adjustment quantity and adjustment type of action is provided for user；
According to the user in the selection of the adjustment quantity selection interface, determines adjustment type of action and determine adjustment quantity.
10. device according to claim 6, which is characterized in that the adjustment module is specifically used for:
In the case where determining adjustment type of action is to increase operation, according to determining regulating object type and quantity is adjusted,
Increase the row of respective numbers or increases the column of respective numbers；
Wherein, the format of new line increment determines that the new line increment closes on row according to pre- according to the row format that closes on of the new line increment
If the first rule determine that the row that closes on of the new line increment includes: a line on the downside of new line increment, or newly a line on the upside of line increment；
The format newly added, according to it is described newly add close on column format determine, it is described newly add close on column according to preset
Second Rule determines that the column that close on newly added include: the column for newly adding left side, or newly add a column on right side.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510067163.6A CN105988655B (en) | 2015-02-09 | 2015-02-09 | A kind of spreadsheet line column region method of adjustment and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510067163.6A CN105988655B (en) | 2015-02-09 | 2015-02-09 | A kind of spreadsheet line column region method of adjustment and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105988655A CN105988655A (en) | 2016-10-05 |
| CN105988655B true CN105988655B (en) | 2018-12-21 |
Family
ID=57040937
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510067163.6A Active CN105988655B (en) | 2015-02-09 | 2015-02-09 | A kind of spreadsheet line column region method of adjustment and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105988655B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109508450A (en) * | 2018-09-20 | 2019-03-22 | 天津字节跳动科技有限公司 | The operating method of table, device, storage medium and electronic equipment in online document |
| CN109858000B (en) * | 2019-01-10 | 2021-09-07 | 广州视源电子科技股份有限公司 | Form processing method, device and system, storage medium and interactive intelligent panel |
| CN112817974B (en) * | 2021-01-25 | 2021-10-15 | 杭州新中大科技股份有限公司 | Multi-layer list head control method for list control |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102629180A (en) * | 2011-01-07 | 2012-08-08 | 微软公司 | Natural input for spreadsheet actions |
| CN102637118A (en) * | 2012-05-04 | 2012-08-15 | 珠海金山办公软件有限公司 | Method and device for inserting or deleting cells or rows and lines in spreadsheet |
| CN103257959A (en) * | 2012-02-15 | 2013-08-21 | 深圳市金蝶友商电子商务服务有限公司 | Method and device for generating spreadsheet report |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7702619B2 (en) * | 2005-09-23 | 2010-04-20 | Alan El-Sabbagh | Methods and systems for joining database tables using indexing data structures |
-
2015
- 2015-02-09 CN CN201510067163.6A patent/CN105988655B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102629180A (en) * | 2011-01-07 | 2012-08-08 | 微软公司 | Natural input for spreadsheet actions |
| CN103257959A (en) * | 2012-02-15 | 2013-08-21 | 深圳市金蝶友商电子商务服务有限公司 | Method and device for generating spreadsheet report |
| CN102637118A (en) * | 2012-05-04 | 2012-08-15 | 珠海金山办公软件有限公司 | Method and device for inserting or deleting cells or rows and lines in spreadsheet |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105988655A (en) | 2016-10-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10877639B2 (en) | Page shortcut display method, apparatus, terminal, and server, and storage medium | |
| CN105260109B (en) | A kind of playing speed adjusting method and terminal | |
| CN105683894A (en) | Application execution method by display device and display device thereof | |
| CN110442293A (en) | Split screen application switching method, device and computer readable storage medium | |
| KR20090107638A (en) | Mobile terminal able to control widget type wallpaper and method for wallpaper control using the same | |
| CN109447248A (en) | Deep learning platform and method | |
| CN105988655B (en) | A kind of spreadsheet line column region method of adjustment and device | |
| WO2017128849A1 (en) | Method and device for customizing keyboard layout | |
| CN104243710A (en) | Method for intelligently switching mobile phone under multiple contextual modes | |
| CN104536768A (en) | Method for improving user-friendly operation of software user interface | |
| CN107332762B (en) | File/information sharing method, mobile terminal and device with storage function | |
| CN109189301A (en) | A kind of method and device of screenshot capture | |
| CN106909358A (en) | The methods of exhibiting and device of application controls | |
| CN103402008A (en) | Method and device for rapidly mass texting message | |
| CN114741079A (en) | Software development method, platform, electronic device and computer-readable storage medium | |
| CN106503062A (en) | A kind of social dynamic dissemination method and device, user terminal | |
| CN109508450A (en) | The operating method of table, device, storage medium and electronic equipment in online document | |
| CN105487769B (en) | Media file display method and device and electronic equipment | |
| CN105677870A (en) | Side classified index setting method | |
| CN104598023A (en) | Method and device for selecting files through gesture recognition | |
| CN104978334A (en) | Processing method and device of spatiotemporal behavior data | |
| CN108399037A (en) | A kind of schedule creates, edit methods and intelligent meter | |
| CN115270737B (en) | Method and device for modifying format of target object | |
| CN103914466A (en) | Tab management method and system | |
| CN105871583A (en) | User data obtaining method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information |
Address after: Jinshan software building No. 8 Jingshan Hill Road, Lane 519015 Lianshan Jida Zhuhai city in Guangdong Province Applicant after: Zhuhai Kingsoft Office Software Co., Ltd. Applicant after: Beijing Kingsoft office software Limited by Share Ltd Applicant after: GUANGZHOU JINSHAN JINSHAN MOBILE TECHNOLOGY CO., LTD. Address before: Jinshan software building No. 8 Jingshan Hill Road, Lane 519015 Lianshan Jida Zhuhai city in Guangdong Province Applicant before: Zhuhai Kingsoft Office Software Co., Ltd. Applicant before: Beijing Kingsoft WPS Office Co., Ltd. Applicant before: GUANGZHOU JINSHAN JINSHAN MOBILE TECHNOLOGY CO., LTD. |
|
| COR | Change of bibliographic data | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |