CN105022558B - The method and system of frozen region in a kind of adjustment electrical form - Google Patents
The method and system of frozen region in a kind of adjustment electrical form Download PDFInfo
- Publication number
- CN105022558B CN105022558B CN201410153436.4A CN201410153436A CN105022558B CN 105022558 B CN105022558 B CN 105022558B CN 201410153436 A CN201410153436 A CN 201410153436A CN 105022558 B CN105022558 B CN 105022558B
- Authority
- CN
- China
- Prior art keywords
- line
- control point
- state
- freezing
- mobile
- 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
- 238000000034 method Methods 0.000 title claims abstract description 25
- 230000008014 freezing Effects 0.000 claims description 83
- 238000007710 freezing Methods 0.000 claims description 83
- 235000015110 jellies Nutrition 0.000 claims description 7
- 239000008274 jelly Substances 0.000 claims description 7
- 238000006073 displacement reaction Methods 0.000 claims description 5
- 238000012423 maintenance Methods 0.000 claims description 3
- 230000005611 electricity Effects 0.000 claims description 2
- 238000010257 thawing Methods 0.000 abstract description 10
- 230000004044 response Effects 0.000 abstract description 4
- 238000010586 diagram Methods 0.000 description 6
- 108010001267 Protein Subunits Proteins 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 230000008859 change Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
Landscapes
- Telephone Function (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
A kind of method and system for adjusting frozen region in electrical form provided in an embodiment of the present invention, it can be instructed directly in response to the dragging of user, it will freeze line and be switched to removable state, line is freezed in the dragging instruction movement followed by user, and current frozen region is adjusted according to the line that freezes after movement.Therefore, the present invention carries out pane freeze operation again after thawing without user, and operation is more convenient, realizes the quick adjustment of frozen region, user's use feeling is good.
Description
Technical field
The present invention relates to spreadsheet technology field, more particularly to a kind of method for adjusting frozen region in electrical form
And system.
Background technology
With the development of science and technology, the office softwares such as electrical form become critical software indispensable in people's work.
By pane freezing function, user can freeze the block of certain in electrical form region, so as to carry out table
Lattice content remains to see institute frozen region when switching.In order to which user is helped to see frozen region clearly, electrical form is using freezing line
Represent the boundary of frozen region.User can easily freeze certain row, certain row or certain block region.
But it when user needs to adjust frozen region, needs to cancel existing frozen region first, then carry out again
Freeze operation simultaneously selects the region oneself to be freezed that can be just adjusted to frozen region, and operation is relatively complicated, is unfavorable for
The quick adjustment of frozen region.
Invention content
The embodiment of the present invention is designed to provide a kind of method and system for adjusting frozen region in electrical form, with reality
The quick adjustment of existing frozen region.
In order to achieve the above objectives, the embodiment of the invention discloses a kind of method for adjusting frozen region in electrical form, packets
It includes：
It receives user to instruct the dragging for freezing line of frozen region current in electrical form, be moved according to the dragging instruction
Freeze line described in dynamic；
Freeze line according to after movement and adjust the current frozen region.
Preferably, the line that freezes according to after movement adjusts the current frozen region, including：
Freeze described in mobile according to the dragging instruction line extremely can be outside frozen region after, can be in frozen region described in judgement
Whether there remains and freezed line, if it is, adjusting current frozen region according to the remaining line that freezes, otherwise, cancelled to institute
State freezing for current frozen region.
Preferably, the dragging for the freezing line instruction for receiving user to frozen region current in electrical form, according to institute
It states and freezes line described in dragging instruction movement, including：
Obtain the position of the control point of user；
According to the position of the control point, the line that freezes of the control point and frozen region current in electrical form is determined
Distance；
When the distance is less than pre-determined distance threshold value, the pre-determined distance threshold value will be less than with the distance of the control point
The state for freezing line removable state is switched to by stationary state；
Follow the mobile removable state of variation of the control point freezes line.
Preferably, the dragging for the freezing line instruction for receiving user to frozen region current in electrical form, according to institute
It states and freezes line described in dragging instruction movement, including：
Obtain the position of the control point of user；
It obtains the control point and maintains the constant duration in position, according to the position of the control point, determine the control point
With the distance for freezing line of frozen region current in electrical form；
It is less than pre-determined distance threshold value in the distance and the duration for maintaining position constant is not less than preset duration threshold value
When, it is removable by being switched to the state of freezing line of the distance of the control point less than the pre-determined distance threshold value by stationary state
Dynamic state；
Follow the mobile removable state of variation of the control point freezes line.
Preferably, the mobile removable state of variation for following the control point freezes line, including：
Determine the line number being spaced between the control point after variation and the control point before variation and columns；
Determine the frozen property for freezing line of the removable state, the frozen property includes going freezing and row freeze；
When the frozen property for freezing line of the removable state freezes for row, to the jelly of the vertical removable state
The direction movement removable state of tie lines freezes line, distance of the distance moved corresponding to the line number；Institute
When the frozen property for freezing line for stating removable state is that row freeze, moved to the direction for freezing line of the vertical removable state
That moves the removable state freezes line, distance of the distance moved corresponding to the columns.
The system of frozen region in a kind of adjustment electrical form, including：Freeze line mobile unit and frozen region adjustment is single
Member；
It is described to freeze line mobile unit, for receiving the dragging of freezing line of the user to frozen region current in electrical form
Instruction freezes line according to the dragging instruction is mobile；
The frozen region adjustment unit adjusts the current frozen region for freezing line according to after movement.
Preferably, the frozen region adjustment unit, including：Judgment sub-unit, adjustment subelement and defrosting subelement,
The judgment sub-unit, for freezing line according to the dragging instruction is mobile in the line mobile unit of freezing
Whether can there remains in frozen region after extremely can be outside frozen region, described in judgement and freeze line, if it is, triggering the adjustment
Otherwise subelement triggers the defrosting subelement；
The adjustment subelement is used to adjust current frozen region according to the remaining line that freezes；
The defrosting subelement freezes the current frozen region for cancelling.
Preferably, it is described to freeze line mobile unit, including：Position obtains subelement, apart from determination subelement, first state
Switching subelement and mobile subelement,
The position obtains subelement, for obtaining the position of the control point of user；
It is described apart from determination subelement, for the position according to the control point, determine the control point and electrical form
In current frozen region the distance for freezing line；
The first state switching subelement, for the distance be less than pre-determined distance threshold value when, will be with the manipulation
The state for freezing line that the distance of point is less than the pre-determined distance threshold value is switched to removable state by stationary state；
The mobile subelement freezes line for follow the mobile removable state of the variation of the control point.
Preferably, it is described to freeze line mobile unit, including：Position obtains subelement, is determined apart from determination subelement, duration
Subelement, the second state switching subelement and mobile subelement,
The position obtains subelement, for obtaining the position of the control point of user；
The duration determination subelement maintains the constant duration in position for obtaining the control point；
It is described apart from determination subelement, for the position according to the control point, determine the control point and electrical form
In current frozen region the distance for freezing line；
The second state switching subelement, for being less than pre-determined distance threshold value and the maintenance position in the distance
When constant duration is not less than preset duration threshold value, freezing for the pre-determined distance threshold value will be less than with the distance of the control point
The state of line is switched to removable state by stationary state；
The mobile subelement freezes line for follow the mobile removable state of the variation of the control point.
Preferably, the mobile subelement, including：Mobile interval determination unit, frozen property determination unit and orientation are moved
Moving cell,
The mobile interval determination unit, for determining what is be spaced between the control point after variation and the control point before variation
Line number and columns；
The frozen property determination unit, for determining the frozen property for freezing line of the removable state, the jelly
Knot attribute includes going freezing and row freeze；
The displacement unit, for the frozen property for freezing line of the removable state for row freeze when, to
The direction for the freezing line movement removable state of the vertical removable state freezes line, and the distance moved is described
Distance corresponding to line number；When the frozen property for freezing line of the removable state freezes for row, to vertical described removable
The direction for the freezing line movement removable state of dynamic state freezes line, and the distance moved is corresponding to the columns
Distance.
A kind of method and system for adjusting frozen region in electrical form provided in an embodiment of the present invention, can be directly in response to
The dragging instruction of user, will freeze line and is switched to removable state, and line is freezed in the dragging instruction movement followed by user, according to
The line that freezes after movement adjusts current frozen region.Therefore, without user, progress pane freezes to grasp the present invention again after thawing
Make, operation is more convenient, realizes the quick adjustment of frozen region, user's use feeling is good.
Description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, to embodiment or will show below
There is attached drawing needed in technology 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
Other attached drawings are obtained according to these attached drawings.
Fig. 1 is a kind of flow chart for adjusting the method for frozen region in electrical form provided in an embodiment of the present invention；
Fig. 2 is a kind of frozen region schematic diagram provided in an embodiment of the present invention；
Fig. 3 is another frozen region schematic diagram provided in an embodiment of the present invention；
Fig. 4 is another frozen region schematic diagram provided in an embodiment of the present invention；
Fig. 5 is another frozen region schematic diagram provided in an embodiment of the present invention；
Fig. 6 is another frozen region schematic diagram provided in an embodiment of the present invention；
Fig. 7 is another flow chart for adjusting the method for frozen region in electrical form provided in an embodiment of the present invention；
Fig. 8 is a kind of structure diagram for adjusting the system of frozen region in electrical form provided in an embodiment of the present invention.
Specific embodiment
Below in conjunction with the attached drawing in the embodiment of the present invention, the technical solution in the embodiment of the present invention is carried out clear, complete
Site preparation describes, it is clear that described embodiment is only part of the embodiment of the present invention, instead of all the embodiments.It is based on
Embodiment in the present invention, those of ordinary skill in the art are obtained every other without making creative work
Embodiment shall fall within the protection scope of the present invention.
As shown in Figure 1, a kind of method for adjusting frozen region in electrical form provided in an embodiment of the present invention, can wrap
It includes：
S100, the dragging of freezing line instruction of the user to frozen region current in electrical form is received, according to the dragging
Freeze line described in instruction is mobile；
Wherein, freeze the boundary marking line that line is frozen region.When the cell to a line or multirow freezes, freeze
Tie lines will be overlapped with horizontal row cut-off rule.When the cell to one or more columns per page freezes, freeze line by with it is vertical
Column split line overlaps.It is of course also possible to the cell of the cell to certain line number and certain columns freezes simultaneously, this
When, there will be two in electrical form to freeze line, and one overlaps with horizontal row cut-off rule, one with vertical column split line weight
It closes.As shown in Fig. 2, when the cell to row 1, row 2, row 3, row 4 freezes, occur freezing line 001 in electrical form, it should
The region for freezing 001 top of line is current frozen region.As shown in figure 3, when freezing to the cell for arranging A, electronics
Occur freezing line 002 in table, which is current frozen region.As shown in figure 4, when to row 1,
It row 2, row 3, row 4 and arranges the cell of A and is carried out at the same time when freezing, occur freezing line 001 simultaneously in electrical form and freeze line
002, the union refion freezed the region of 001 top of line and freeze the region in 002 left side of line is current frozen region.
Wherein, S100 can be there are two types of specific embodiment：
Mode one, S100 can include：
Obtain the position of the control point of user；
According to the position of the control point, the line that freezes of the control point and frozen region current in electrical form is determined
Distance；
When the distance is less than pre-determined distance threshold value, the jelly of pre-determined distance threshold value will be less than with the distance of the control point
The state of tie lines is switched to removable state by stationary state；
Follow the mobile removable state of variation of the control point freezes line.
Wherein, control point can be touch point or cursor point.When control point distance freeze line it is nearer when, it is possible to will
Freeze line and be switched to removable state, user to be facilitated to be moved.
Mode two, S100 can include：
Obtain the position of the control point of user；
It obtains the control point and maintains the constant duration in position, according to the position of the control point, determine the control point
With the distance for freezing line of frozen region current in electrical form；
It is less than pre-determined distance threshold value in the distance and the duration for maintaining position constant is not less than preset duration threshold value
When, the state for freezing line that pre-determined distance threshold value is less than with the distance of the control point is switched to removable shape by stationary state
State；
Follow the mobile removable state of variation of the control point freezes line.
Difference lies in freeze line in mode two needs to maintain position whithin a period of time in control point mode two with mode one
Just become removable state when putting constant.Such as：For touch panel device, after user's long-press freezes line, freeze line change
To move state.
Specifically, in mode one and mode two, freeze line after removable state is switched to, difference can be had by freezing line
Display effect can be moved with prompting user that should freeze line.
In above two mode, the mobile removable state of variation of the control point is followed to freeze line and can wrap
It includes：
Determine the line number being spaced between the control point after variation and the control point before variation and columns；
Determine the frozen property for freezing line of the removable state, the frozen property includes going freezing and row freeze；
When the frozen property for freezing line of the removable state freezes for row, to the jelly of the vertical removable state
The direction movement removable state of tie lines freezes line, distance of the distance moved corresponding to the line number；Institute
When the frozen property for freezing line for stating removable state is that row freeze, moved to the direction for freezing line of the vertical removable state
That moves the removable state freezes line, distance of the distance moved corresponding to the columns.
Wherein, row freeze freeze line with level row cut-off rule overlap, arrange freeze freeze line and vertical column split
Line overlaps.The dragging distance that user drags instruction can be any distance, but freeze line when moving, need according to row or column come into
Therefore row movement, freezes the distance necessarily integral multiple of line space or column pitch, and moving direction is necessarily level of line movement
It is or vertical.
S200, freeze the line adjustment current frozen region according to after movement.
As shown in figure 5, occurring freezing line 001 simultaneously in electrical form and freezing line 002, freeze the area of 001 top of line
Domain and the union refion for freezing the region on the left of line 002 are current frozen region.Freeze line positioned at two in the control point of user
Focus, two are freezed line and are switched to removable state at this time.Subsequent user sends out the instruction of drag down, at this time due to only
The movement of vertical direction, therefore freeze line 002 and can not be moved horizontally, only freeze line 001 and move down.
As shown in fig. 6, after the finger of user stops dragging, the cut-off rule for freezing line 001 with row 10, row 11 overlaps, according to
Freeze line after movement, can adjust current frozen region is：Freeze the region of 001 top of line and freeze the area in 002 left side of line
The union refion in domain.
A kind of method for adjusting frozen region in electrical form provided in an embodiment of the present invention, can be directly in response to user's
Dragging instruction, will freeze line and is switched to removable state, and line is freezed in the dragging instruction movement followed by user, after movement
The line that freezes adjust current frozen region.Therefore, the present invention carries out pane freeze operation, operation again after thawing without user
It is more convenient, the quick adjustment of frozen region is realized, user's use feeling is good.
As shown in fig. 7, in another adjustment electrical form provided in an embodiment of the present invention in the method for frozen region, Fig. 1
S200 in illustrated embodiment can include：
S210, freeze described in mobile according to the dragging instruction line extremely can be outside frozen region after, can freeze described in judgement
Whether there remains in region and freezed line, if it is, performing S211, otherwise performed S212；
S211, current frozen region is adjusted according to the remaining line that freezes；
The current frozen region is freezed in S212, cancellation.
Wherein, can frozen region be editable table area, the editable table area include line number Mark Column where
Row and column.When user's dragging freeze line to can be outside frozen region when, then it is ineffective to freeze line, can cancel the jelly at this time
Tie lines.When existing simultaneously two in electrical form and freezing line, cancel wherein one freeze line after, another is freezed line and is formed
Frozen region be current frozen region.If there is only one in electrical form to freeze line, cancel after this freezes line, electricity
It there would not be in sub-table and freeze line, therefore can cancel and current frozen region is freezed.
Relative to above method embodiment, the present invention also provides a kind of systems for adjusting frozen region in electrical form.
As shown in figure 8, a kind of system for adjusting frozen region in electrical form provided in an embodiment of the present invention, can wrap
It includes：Freeze line mobile unit 100 and frozen region adjustment unit 200；
It is described to freeze line mobile unit 100, for receiving freeze line of the user to frozen region current in electrical form
Dragging instruction freezes line according to the dragging instruction is mobile；
Wherein, the line mobile unit 100 of freezing can be there are two types of building form：
Mode one is freezed line mobile unit 100 and can be included：Position obtains subelement, apart from determination subelement, the first shape
State switching subelement and mobile subelement,
The position obtains subelement, for obtaining the position of the control point of user；
It is described apart from determination subelement, for the position according to the control point, determine the control point and electrical form
In current frozen region the distance for freezing line；
The first state switching subelement, for the distance be less than pre-determined distance threshold value when, will be with the manipulation
The state for freezing line that the distance of point is less than pre-determined distance threshold value is switched to removable state by stationary state；
The mobile subelement freezes line for follow the mobile removable state of the variation of the control point.
Mode two is freezed line mobile unit 100 and can be included：Position obtains subelement, true apart from determination subelement, duration
Stator unit, the second state switching subelement and mobile subelement,
The position obtains subelement, for obtaining the position of the control point of user；
The duration determination subelement maintains the constant duration in position for obtaining the control point；
It is described apart from determination subelement, for the position according to the control point, determine the control point and electrical form
In current frozen region the distance for freezing line；
The second state switching subelement, for being less than pre-determined distance threshold value and the maintenance position in the distance
When constant duration is not less than preset duration threshold value, the line that freezes of pre-determined distance threshold value will be less than with the distance of the control point
State is switched to removable state by stationary state；
The mobile subelement freezes line for follow the mobile removable state of the variation of the control point.
Mobile subelement in above two mode, can include：Mobile interval determination unit, frozen property determination unit
With displacement unit,
The mobile interval determination unit, for determining what is be spaced between the control point after variation and the control point before variation
Line number and columns；
The frozen property determination unit, for determining the frozen property for freezing line of the removable state, the jelly
Knot attribute includes going freezing and row freeze；
The displacement unit, for the frozen property for freezing line of the removable state for row freeze when, to
The direction for the freezing line movement removable state of the vertical removable state freezes line, and the distance moved is described
Distance corresponding to line number；When the frozen property for freezing line of the removable state freezes for row, to vertical described removable
The direction for the freezing line movement removable state of dynamic state freezes line, and the distance moved is corresponding to the columns
Distance.
The frozen region adjustment unit 200 adjusts the current freezing zone for freezing line according to after movement
Domain.
In other embodiments of the present invention, frozen region adjustment unit 200 shown in Fig. 8, can include：Judge that son is single
Member, adjustment subelement and defrosting subelement,
The judgment sub-unit, for freezing line according to the dragging instruction is mobile in the line mobile unit of freezing
Whether can there remains in frozen region after extremely can be outside frozen region, described in judgement and freeze line, if it is, triggering the adjustment
Otherwise subelement triggers the defrosting subelement；
The adjustment subelement is used to adjust current frozen region according to the remaining line that freezes；
The defrosting subelement freezes the current frozen region for cancelling.
A kind of system for adjusting frozen region in electrical form provided in an embodiment of the present invention, can be directly in response to user's
Dragging instruction, will freeze line and is switched to removable state, and line is freezed in the dragging instruction movement followed by user, after movement
The line that freezes adjust current frozen region.Therefore, the present invention carries out pane freeze operation, operation again after thawing without user
It is more convenient, the quick adjustment of frozen region is realized, user's use feeling is good.
It should be noted that herein, 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 this practical relationship or sequence.Moreover, term " comprising ", "comprising" or its any other variant are intended to
Non-exclusive inclusion, so that process, method, article or equipment including a series of elements not only will including those
Element, but also including other elements that are not explicitly listed or further include as 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
Also there are other identical elements in process, method, article or equipment including the element.
Each embodiment in this specification is described using relevant mode, identical similar portion between each embodiment
Point just to refer each other, and the highlights of each of the examples are difference from other examples.Especially for system reality
For applying example, since it is substantially similar to embodiment of the method, so description is fairly simple, related part is referring to embodiment of the method
Part explanation.
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 (8)
- A kind of 1. method for adjusting frozen region in electrical form, which is characterized in that including：It receives user to instruct the dragging for freezing line of frozen region current in electrical form, according to the mobile institute of dragging instruction It states and freezes line；Freeze line according to after movement and adjust the current frozen region.
- 2. according to the method described in claim 1, it is characterized in that, the reception user is to frozen region current in electrical form The dragging for freezing line instruction, freeze line according to the dragging instruction is mobile, including：Obtain the position of the control point of user；According to the position of the control point, determine the control point and frozen region current in electrical form freeze line away from From；When the distance is less than pre-determined distance threshold value, the jelly of the pre-determined distance threshold value will be less than with the distance of the control point The state of tie lines is switched to removable state by stationary state；Follow the mobile removable state of variation of the control point freezes line.
- 3. according to the method described in claim 1, it is characterized in that, the reception user is to frozen region current in electrical form The dragging for freezing line instruction, freeze line according to the dragging instruction is mobile, including：Obtain the position of the control point of user；It obtains the control point and maintains the constant duration in position, according to the position of the control point, determine the control point and electricity The distance for freezing line of current frozen region in sub-table；When the distance is less than pre-determined distance threshold value and the duration for maintaining position constant is not less than preset duration threshold value, It is removable by being switched to the state of freezing line of the distance of the control point less than the pre-determined distance threshold value by stationary state State；Follow the mobile removable state of variation of the control point freezes line.
- 4. according to the method in claim 2 or 3, which is characterized in that described to follow described in the variation movement of the control point Removable state freezes line, including：Determine the line number being spaced between the control point after variation and the control point before variation and columns；Determine the frozen property for freezing line of the removable state, the frozen property includes going freezing and row freeze；When the frozen property for freezing line of the removable state freezes for row, freeze line to the vertical removable state Direction move the removable state freeze line, distance of the distance moved corresponding to the line number；It is described can When the frozen property for freezing line of mobile status freezes for row, institute is moved to the direction for freezing line of the vertical removable state That states removable state freezes line, distance of the distance moved corresponding to the columns.
- 5. a kind of system for adjusting frozen region in electrical form, which is characterized in that including：Freeze line mobile unit and freezing zone Domain adjustment unit；It is described to freeze line mobile unit, the dragging for freezing line of frozen region current in electrical form is referred to for receiving user It enables, freezes line according to the dragging instruction is mobile；The frozen region adjustment unit adjusts the current frozen region for freezing line according to after movement.
- 6. system according to claim 5, which is characterized in that it is described to freeze line mobile unit, including：It is single that position obtains son Member, apart from determination subelement, first state switching subelement and mobile subelement,The position obtains subelement, for obtaining the position of the control point of user；It is described apart from determination subelement, for the position according to the control point, determine the control point in electrical form when The distance for freezing line of preceding frozen region；The first state switching subelement, for the distance be less than pre-determined distance threshold value when, by with the control point The state for freezing line that distance is less than the pre-determined distance threshold value is switched to removable state by stationary state；The mobile subelement freezes line for follow the mobile removable state of the variation of the control point.
- 7. system according to claim 5, which is characterized in that it is described to freeze line mobile unit, including：It is single that position obtains son Member, apart from determination subelement, duration determination subelement, the second state switching subelement and mobile subelement,The position obtains subelement, for obtaining the position of the control point of user；The duration determination subelement maintains the constant duration in position for obtaining the control point；It is described apart from determination subelement, for the position according to the control point, determine the control point in electrical form when The distance for freezing line of preceding frozen region；The second state switching subelement, for the distance be less than pre-determined distance threshold value and it is described maintenance position it is constant Duration when being not less than preset duration threshold value, the line that freezes of the pre-determined distance threshold value will be less than with the distance of the control point State is switched to removable state by stationary state；The mobile subelement freezes line for follow the mobile removable state of the variation of the control point.
- 8. the system described according to claim 6 or 7, which is characterized in that the mobile subelement, including：Mobile interval determines Unit, frozen property determination unit and displacement unit,The mobile interval determination unit, for determining the line number being spaced between the control point after variation and the control point before variation And columns；The frozen property determination unit, it is described to freeze to belong to for determining the frozen property for freezing line of the removable state Property include row and freeze and row freeze；The displacement unit, for when the frozen property for freezing line of the removable state freezes for row, to vertical The direction for the freezing line movement removable state of the removable state freezes line, and the distance moved is the line number Corresponding distance；When the frozen property for freezing line of the removable state freezes for row, to the vertical removable shape What the removable state was moved in the direction for freezing line of state freezes line, the distance moved corresponding to the columns away from From.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410153436.4A CN105022558B (en) | 2014-04-16 | 2014-04-16 | The method and system of frozen region in a kind of adjustment electrical form |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410153436.4A CN105022558B (en) | 2014-04-16 | 2014-04-16 | The method and system of frozen region in a kind of adjustment electrical form |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105022558A CN105022558A (en) | 2015-11-04 |
| CN105022558B true CN105022558B (en) | 2018-07-10 |
Family
ID=54412559
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410153436.4A Active CN105022558B (en) | 2014-04-16 | 2014-04-16 | The method and system of frozen region in a kind of adjustment electrical form |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105022558B (en) |
Families Citing this family (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20190095056A1 (en) * | 2016-04-15 | 2019-03-28 | Huawei Technologies Co., Ltd. | Method and Apparatus for Locking Object in List, and Terminal Device |
| CN107515706A (en) * | 2017-08-23 | 2017-12-26 | 合肥龙图腾信息技术有限公司 | Multiple ranks Window-freezing system and its application method in a kind of same EXCEL file |
| CN110968241B (en) * | 2018-09-30 | 2022-03-01 | 腾讯科技（深圳）有限公司 | Processing method and device of electronic form, computer readable storage medium and computer equipment |
| CN110968987B (en) * | 2018-09-30 | 2022-05-20 | 腾讯科技（深圳）有限公司 | Table display method and device, storage medium and electronic device |
| CN110609993A (en) * | 2019-09-18 | 2019-12-24 | 北京字节跳动网络技术有限公司 | Table adjusting method and equipment |
| CN113625917B (en) * | 2021-07-29 | 2024-06-11 | 北京达佳互联信息技术有限公司 | Data display method, device, electronic equipment, storage medium and product |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101751223A (en) * | 2009-12-22 | 2010-06-23 | 深圳市五巨科技有限公司 | Method and device for displaying dynamic data of webpage form |
| CN101777063A (en) * | 2009-01-07 | 2010-07-14 | 陈敏广 | Method for realizing rapid classified access and utilization of literature by using electronic form as platform |
| US8533585B2 (en) * | 2006-10-03 | 2013-09-10 | Blackberry Limited | System and method for freezing columns and rows in a UI table |
-
2014
- 2014-04-16 CN CN201410153436.4A patent/CN105022558B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8533585B2 (en) * | 2006-10-03 | 2013-09-10 | Blackberry Limited | System and method for freezing columns and rows in a UI table |
| CN101777063A (en) * | 2009-01-07 | 2010-07-14 | 陈敏广 | Method for realizing rapid classified access and utilization of literature by using electronic form as platform |
| CN101751223A (en) * | 2009-12-22 | 2010-06-23 | 深圳市五巨科技有限公司 | Method and device for displaying dynamic data of webpage form |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105022558A (en) | 2015-11-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105022558B (en) | The method and system of frozen region in a kind of adjustment electrical form | |
| JP2015518221A5 (en) | ||
| EP2838009A3 (en) | Terminal and method for controlling the same | |
| WO2016191364A8 (en) | Methods and systems for controlling a concentric tube probe | |
| CN103941875B (en) | A kind of page turning method, device and terminal | |
| DE602006002873D1 (en) | A user interface method and apparatus for controlling the visual display of maps with selectable map elements in mobile communication devices | |
| WO2012135478A3 (en) | Area selection for hand held devices with display | |
| RU2016130682A (en) | USE OF THE SECOND SCREEN AS A PERSONAL PROJECTIVE DISPLAY ON GLASSES | |
| MY181167A (en) | Operation and control method based on touch screen, and terminal | |
| EP2543972A3 (en) | Device, method and graphical user interface for mapping directions between search results | |
| JP2016505188A5 (en) | ||
| CN102681774A (en) | Method, device and mobile terminal for controlling application interface by gesture | |
| WO2008115361A3 (en) | Non-linear navigation in discussion forums | |
| JP2013539091A5 (en) | ||
| CN104468331B (en) | A kind of method and apparatus for building group for instant messaging | |
| WO2015095875A3 (en) | Mobile platform functionalities employing proximal variants and advanced personalization methods to control dynamic icon display | |
| EP2921939A3 (en) | Method and mobile terminal for text editing and correction | |
| JP2016509724A5 (en) | ||
| TWI456484B (en) | Electronic apparatus and method for controlling the same | |
| CN105511782B (en) | A kind of game command processing method and processing device | |
| CN104536650B (en) | A kind of parallax page turning man-machine interaction method based on IOS systems | |
| GB2532859A (en) | Navigating within a graphical depiction of a process control plant | |
| CN103543996A (en) | Browser window management method and device | |
| CN103970471B (en) | A kind of method for sending information, equipment and terminal | |
| CN105807965A (en) | False trigger prevention method and apparatus |
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 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. |
|
| COR | Change of bibliographic data | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |