[go: up one dir, main page]

CN105022558A - Method and system for adjusting frozen region in spreadsheet - Google Patents

Method and system for adjusting frozen region in spreadsheet Download PDF

Info

Publication number
CN105022558A
CN105022558A CN201410153436.4A CN201410153436A CN105022558A CN 105022558 A CN105022558 A CN 105022558A CN 201410153436 A CN201410153436 A CN 201410153436A CN 105022558 A CN105022558 A CN 105022558A
Authority
CN
China
Prior art keywords
frost line
control point
distance
frozen
frozen region
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN201410153436.4A
Other languages
Chinese (zh)
Other versions
CN105022558B (en
Inventor
王晖
张伶俐
曾思洁
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Kingsoft Office Software Inc
Zhuhai Kingsoft Office Software Co Ltd
Original Assignee
Beijing Kingsoft Office Software Inc
Zhuhai Kingsoft Office Software Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Beijing Kingsoft Office Software Inc, Zhuhai Kingsoft Office Software Co Ltd filed Critical Beijing Kingsoft Office Software Inc
Priority to CN201410153436.4A priority Critical patent/CN105022558B/en
Publication of CN105022558A publication Critical patent/CN105022558A/en
Application granted granted Critical
Publication of CN105022558B publication Critical patent/CN105022558B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Landscapes

  • Telephone Function (AREA)
  • User Interface Of Digital Computer (AREA)

Abstract

Embodiments of the invention provide a method and a system for adjusting a frozen region in a spreadsheet. A dragging instruction of a user can be directly responded, a frost line is switched to a movable state, and then, the frost line is moved following the dragging instruction of the user, and a present frozen region is adjusted according to the frost line after movement. Therefore, a user does not need to perform a pane frosting operation after defrosting. The method and the system are more convenient in operation, rapid adjustment of the frozen region is realized, and usage feeling of a user is good.

Description

A kind of method and system adjusting frozen region in electrical form
Technical field
The present invention relates to spreadsheet technology field, particularly relate to a kind of method and system adjusting frozen region in electrical form.
Background technology
Along 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, certain the block region in electrical form can be freezed by user, thus still can see institute frozen region when carrying out table content and switching.In order to help user to see frozen region clearly, electrical form uses frost line to represent the border of frozen region.User can freeze certain row, certain row or certain block region easily.
But, when user needs adjustment frozen region, need first to cancel existing frozen region, and then carry out freeze operation and select the region oneself will freezed just can adjust frozen region, operate comparatively loaded down with trivial details, be unfavorable for the rapid adjustment of frozen region.
Summary of the invention
The object of the embodiment of the present invention is to provide a kind of method and system adjusting frozen region in electrical form, to realize the rapid adjustment of frozen region.
For achieving the above object, the embodiment of the invention discloses a kind of method adjusting frozen region in electrical form, comprising:
Receive user to the dragging instruction of the frost line of frozen region current in electrical form, move described frost line according to described dragging instruction;
According to the described current frozen region of described frost line adjustment after movement.
Preferably, described according to the described current frozen region of described frost line adjustment after movement, comprising:
Move according to described dragging instruction described frost line to can outside frozen region after, judge described can in frozen region whether also residue have frost line, if so, then adjust current frozen region according to remaining frost line, otherwise, cancel freezing described current frozen region.
Preferably, described reception user, to the dragging instruction of the frost line of frozen region current in electrical form, moves described frost line according to described dragging instruction, comprising:
Obtain the position of the control point of user;
According to the position of described control point, determine the distance of the frost line of current frozen region in described control point and electrical form;
When described distance is less than predeterminable range threshold value, the state distance with described control point being less than the frost line of described predeterminable range threshold value switches to removable state by stationary state;
The frost line of described removable state is moved in the change of following described control point.
Preferably, described reception user, to the dragging instruction of the frost line of frozen region current in electrical form, moves described frost line according to described dragging instruction, comprising:
Obtain the position of the control point of user;
Obtain the duration that described control point maintains invariant position, according to the position of described control point, determine the distance of the frost line of current frozen region in described control point and electrical form;
When described distance is less than predeterminable range threshold value and the duration of described maintenance invariant position is not less than preset duration threshold value, the state distance with described control point being less than the frost line of described predeterminable range threshold value switches to removable state by stationary state;
The frost line of described removable state is moved in the change of following described control point.
Preferably, described in follow described control point change move the frost line of described removable state, comprising:
Determine line number and the columns at interval between the control point before the control point after changing and change;
Determine the frozen property of the frost line of described removable state, described frozen property comprises row to be freezed and row freeze;
When the frozen property of the frost line of described removable state freezes for row, the frost line of described removable state is moved in the direction to the frost line of vertical described removable state, the distance of distance corresponding to described line number of movement; The frozen property of the frost line of described removable state be row freeze time, the frost line of described removable state is moved in the direction to the frost line of vertical described removable state, the distance of distance corresponding to described columns of movement.
Adjust a system for frozen region in electrical form, comprising: frost line mobile unit and frozen region adjustment unit;
Described frost line mobile unit, for receiving the dragging instruction of user to the frost line of frozen region current in electrical form, moves described frost line according to described dragging instruction;
Described frozen region adjustment unit, for adjusting described current frozen region according to the described frost line after movement.
Preferably, described frozen region adjustment unit, comprising: judgment sub-unit, adjust subelement and the subelement that thaws,
Described judgment sub-unit, for to move according to described dragging instruction at described frost line mobile unit described frost line to can frozen region outer after, judge that described whether also can residue in frozen region has frost line, if, then trigger described adjustment subelement, otherwise the subelement that thaws described in triggering;
Described adjustment subelement is used for adjusting current frozen region according to remaining frost line;
The described subelement that thaws, for cancelling freezing described current frozen region.
Preferably, described frost line mobile unit, comprising: position obtains subelement, distance determines subelement, the first state switches subelement and mover unit,
Described position obtains subelement, for obtaining the position of the control point of user;
Described distance determines subelement, for the position according to described control point, determines the distance of the frost line of current frozen region in described control point and electrical form;
Described first state switches subelement, and for when described distance is less than predeterminable range threshold value, the state distance with described control point being less than the frost line of described predeterminable range threshold value switches to removable state by stationary state;
Described mover unit, the frost line of described removable state is moved in the change for following described control point.
Preferably, described frost line mobile unit, comprising: position obtains subelement, distance determines subelement, duration determination subelement, the second state switches subelement and mover unit,
Described position obtains subelement, for obtaining the position of the control point of user;
Described duration determination subelement, maintains the duration of invariant position for obtaining described control point;
Described distance determines subelement, for the position according to described control point, determines the distance of the frost line of current frozen region in described control point and electrical form;
Described second state switches subelement, for be less than predeterminable range threshold value in described distance and the duration of described maintenance invariant position is not less than preset duration threshold value time, the state distance with described control point being less than the frost line of described predeterminable range threshold value switches to removable state by stationary state;
Described mover unit, the frost line of described removable state is moved in the change for following described control point.
Preferably, described mover unit, comprising: mobile interval determining unit, frozen property determining unit and displacement unit,
Described mobile interval determining unit, for determining line number and the columns at interval between the control point before the control point after changing and change;
Described frozen property determining unit, for determining the frozen property of the frost line of described removable state, described frozen property comprises row to be freezed and row freeze;
Described displacement unit, when frozen property for the frost line in described removable state freezes for going, the frost line of described removable state is moved in direction to the frost line of vertical described removable state, the distance of distance corresponding to described line number of movement; The frozen property of the frost line of described removable state be row freeze time, the frost line of described removable state is moved in the direction to the frost line of vertical described removable state, the distance of distance corresponding to described columns of movement.
A kind of method and system adjusting frozen region in electrical form that the embodiment of the present invention provides, directly can respond the dragging instruction of user, frost line is switched to removable state, and frost line is moved in the dragging instruction of then following user, adjusts current frozen region according to the frost line after movement.Therefore, the present invention carries out pane freeze operation after thawing again without the need to user, more convenient to operate, achieves the rapid adjustment of frozen region, and user's use sense is by good.
Accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, be briefly described to the accompanying drawing used required in embodiment or description of the prior art below, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skill in the art, under the prerequisite not paying creative work, other accompanying drawing can also be obtained according to these accompanying drawings.
A kind of process flow diagram adjusting the method for frozen region in electrical form that Fig. 1 provides for the embodiment of the present invention;
A kind of frozen region schematic diagram that Fig. 2 provides for the embodiment of the present invention;
The another kind of frozen region schematic diagram that Fig. 3 provides for the embodiment of the present invention;
The another kind of frozen region schematic diagram that Fig. 4 provides for the embodiment of the present invention;
The another kind of frozen region schematic diagram that Fig. 5 provides for the embodiment of the present invention;
The another kind of frozen region schematic diagram that Fig. 6 provides for the embodiment of the present invention;
The process flow diagram of the method for frozen region in the another kind adjustment electrical form that Fig. 7 provides for the embodiment of the present invention;
A kind of structural representation adjusting the system of frozen region in electrical form that Fig. 8 provides for the embodiment of the present invention.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, be clearly and completely described the technical scheme in the embodiment of the present invention, obviously, described embodiment is only the present invention's part embodiment, instead of whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art, not making the every other embodiment obtained under creative work prerequisite, belong to the scope of protection of the invention.
As shown in Figure 1, a kind of method adjusting frozen region in electrical form that the embodiment of the present invention provides, can comprise:
S100, reception user, to the dragging instruction of the frost line of frozen region current in electrical form, move described frost line according to described dragging instruction;
Wherein, frost line is the boundary marking line of frozen region.When freezing the cell of a line or multirow, frost line overlaps with the row cut-off rule of level.When freezing the cell of row or multiple row, frost line overlaps with vertical column split line.Certainly, also can freeze the cell of certain line number and the cell of certain columns, at this moment, by existence two frost lines in electrical form, one overlaps with the row cut-off rule of level, and one overlaps with vertical column split line simultaneously.As shown in Figure 2, when freezing the cell of row 1, row 2, row 3, row 4, occur frost line 001 in electrical form, the region above this frost line 001 is current frozen region.As shown in Figure 3, when freezing the cell of row A, occur frost line 002 in electrical form, the region on the left of this frost line 002 is current frozen region.As shown in Figure 4, when freezing the cell of row 1, row 2, row 3, row 4 and row A simultaneously, occur frost line 001 and frost line 002 in electrical form, the union region in the region on the left of the region above frost line 001 and frost line 002 is current frozen region simultaneously.
Wherein, S100 can have two kinds of embodiments:
Mode one, S100 can comprise:
Obtain the position of the control point of user;
According to the position of described control point, determine the distance of the frost line of current frozen region in described control point and electrical form;
When described distance is less than predeterminable range threshold value, the state distance with described control point being less than the frost line of predeterminable range threshold value switches to removable state by stationary state;
The frost line of described removable state is moved in the change of following described control point.
Wherein, control point can be touch point or cursor point.When control point distance frost line is nearer, just frost line can be switched to removable state, move to facilitate user.
Mode two, S100 can comprise:
Obtain the position of the control point of user;
Obtain the duration that described control point maintains invariant position, according to the position of described control point, determine the distance of the frost line of current frozen region in described control point and electrical form;
When described distance is less than predeterminable range threshold value and the duration of described maintenance invariant position is not less than preset duration threshold value, the state distance with described control point being less than the frost line of predeterminable range threshold value switches to removable state by stationary state;
The frost line of described removable state is moved in the change of following described control point.
Mode two is with the difference of mode one, and in mode two, frost line needs just to become removable state when maintaining invariant position within a period of time in control point.Such as: for touch panel device, after pressing frost line with the head of a household, frost line becomes removable state.
Concrete, in mode one and mode two, frost line is after switching to removable state, and frost line can have different display effects and can move to point out this frost line of user.
In above-mentioned two kinds of modes, the frost line that described removable state is moved in the change of following described control point can comprise:
Determine line number and the columns at interval between the control point before the control point after changing and change;
Determine the frozen property of the frost line of described removable state, described frozen property comprises row to be freezed and row freeze;
When the frozen property of the frost line of described removable state freezes for row, the frost line of described removable state is moved in the direction to the frost line of vertical described removable state, the distance of distance corresponding to described line number of movement; The frozen property of the frost line of described removable state be row freeze time, the frost line of described removable state is moved in the direction to the frost line of vertical described removable state, the distance of distance corresponding to described columns of movement.
Wherein, the frost line that row freezes overlaps with the row cut-off rule of level, arranges the frost line freezed and overlaps with vertical column split line.The dragging distance that user drags instruction can be any distance, but frost line is when mobile, needs to move according to row or column, therefore, and the integral multiple of the distance of frost line movement necessarily line space or column pitch, and moving direction must be level or vertically.
S200, according to the described current frozen region of described frost line adjustment after movement.
As shown in Figure 5, occur frost line 001 and frost line 002 in electrical form, the union region in the region on the left of the region above frost line 001 and frost line 002 is current frozen region simultaneously.The control point of user is positioned at the focus of two frost lines, and now two frost lines all switch to removable state.User sends the instruction of drag down subsequently, and now owing to only there being the movement of vertical direction, therefore frost line 002 cannot move horizontally, and only has frost line 001 to move down.
As shown in Figure 6, after the finger stopping dragging of user, frost line 001 overlaps with the cut-off rule of row 10, row 11, and according to the frost line after movement, can adjust current frozen region is: the union region in the region on the left of the region above frost line 001 and frost line 002.
A kind of method adjusting frozen region in electrical form that the embodiment of the present invention provides, directly can respond the dragging instruction of user, frost line is switched to removable state, and frost line is moved in the dragging instruction of then following user, adjusts current frozen region according to the frost line after movement.Therefore, the present invention carries out pane freeze operation after thawing again without the need to user, more convenient to operate, achieves the rapid adjustment of frozen region, and user's use sense is by good.
As shown in Figure 7, the another kind that the embodiment of the present invention provides adjusts in the method for frozen region in electrical form, and the S200 in embodiment illustrated in fig. 1 can comprise:
S210, move according to described dragging instruction described frost line to can frozen region outer after, judge described can in frozen region whether also residue have frost line, if so, then perform S211, otherwise execution S212;
S211, adjust current frozen region according to remaining frost line;
S212, cancel freezing described current frozen region.
Wherein, can be and can edit form district in frozen region, this can edit the row and column that form district does not comprise line number Mark Column place.When user drag frost line to can outside frozen region time, then frost line is ineffective, now can cancel this frost line.When there is two frost lines in electrical form simultaneously, cancel wherein after a frost line, the frozen region that another frost line is formed is current frozen region.If only there is a frost line in electrical form, then after cancelling this frost line, in electrical form, no longer will there is frost line, therefore can cancel freezing current frozen region.
Relative to said method embodiment, present invention also offers a kind of system adjusting frozen region in electrical form.
As shown in Figure 8, a kind of system adjusting frozen region in electrical form that the embodiment of the present invention provides, can comprise: frost line mobile unit 100 and frozen region adjustment unit 200;
Described frost line mobile unit 100, for receiving the dragging instruction of user to the frost line of frozen region current in electrical form, moves described frost line according to described dragging instruction;
Wherein, described frost line mobile unit 100 can have two kinds of building forms:
Mode one, frost line mobile unit 100 can comprise: position obtains subelement, distance determines subelement, the first state switches subelement and mover unit,
Described position obtains subelement, for obtaining the position of the control point of user;
Described distance determines subelement, for the position according to described control point, determines the distance of the frost line of current frozen region in described control point and electrical form;
Described first state switches subelement, and for when described distance is less than predeterminable range threshold value, the state distance with described control point being less than the frost line of predeterminable range threshold value switches to removable state by stationary state;
Described mover unit, the frost line of described removable state is moved in the change for following described control point.
Mode two, frost line mobile unit 100 can comprise: position obtains subelement, distance determines subelement, duration determination subelement, the second state switches subelement and mover unit,
Described position obtains subelement, for obtaining the position of the control point of user;
Described duration determination subelement, maintains the duration of invariant position for obtaining described control point;
Described distance determines subelement, for the position according to described control point, determines the distance of the frost line of current frozen region in described control point and electrical form;
Described second state switches subelement, for be less than predeterminable range threshold value in described distance and the duration of described maintenance invariant position is not less than preset duration threshold value time, the state distance with described control point being less than the frost line of predeterminable range threshold value switches to removable state by stationary state;
Described mover unit, the frost line of described removable state is moved in the change for following described control point.
Mover unit in above-mentioned two kinds of modes, can comprise: mobile interval determining unit, frozen property determining unit and displacement unit,
Described mobile interval determining unit, for determining line number and the columns at interval between the control point before the control point after changing and change;
Described frozen property determining unit, for determining the frozen property of the frost line of described removable state, described frozen property comprises row to be freezed and row freeze;
Described displacement unit, when frozen property for the frost line in described removable state freezes for going, the frost line of described removable state is moved in direction to the frost line of vertical described removable state, the distance of distance corresponding to described line number of movement; The frozen property of the frost line of described removable state be row freeze time, the frost line of described removable state is moved in the direction to the frost line of vertical described removable state, the distance of distance corresponding to described columns of movement.
Described frozen region adjustment unit 200, for adjusting described current frozen region according to the described frost line after movement.
In other embodiments of the present invention, the frozen region adjustment unit 200 shown in Fig. 8, can comprise: judgment sub-unit, adjust subelement and the subelement that thaws,
Described judgment sub-unit, for to move according to described dragging instruction at described frost line mobile unit described frost line to can frozen region outer after, judge that described whether also can residue in frozen region has frost line, if, then trigger described adjustment subelement, otherwise the subelement that thaws described in triggering;
Described adjustment subelement is used for adjusting current frozen region according to remaining frost line;
The described subelement that thaws, for cancelling freezing described current frozen region.
A kind of system adjusting frozen region in electrical form that the embodiment of the present invention provides, directly can respond the dragging instruction of user, frost line is switched to removable state, and frost line is moved in the dragging instruction of then following user, adjusts current frozen region according to the frost line after movement.Therefore, the present invention carries out pane freeze operation after thawing again without the need to user, more convenient to operate, achieves the rapid adjustment of frozen region, and user's use sense is by good.
It should be noted that, in this article, the such as relational terms of first and second grades and so on is only used for an entity or operation to separate with another entity or operational zone, and not necessarily requires or imply the relation that there is any this reality between these entities or operation or sequentially.And, term " comprises ", " comprising " or its any other variant are intended to contain comprising of nonexcludability, thus make to comprise the process of a series of key element, method, article or equipment and not only comprise those key elements, but also comprise other key elements clearly do not listed, or also comprise by the intrinsic key element of this process, method, article or equipment.When not more restrictions, the key element limited by statement " comprising ... ", and be not precluded within process, method, article or the equipment comprising described key element and also there is other identical element.
Each embodiment in this instructions all adopts relevant mode to describe, between each embodiment identical similar part mutually see, what each embodiment stressed is the difference with other embodiments.Especially, for system embodiment, because it is substantially similar to embodiment of the method, so description is fairly simple, relevant part illustrates see the part of embodiment of the method.
The foregoing is only preferred embodiment of the present invention, be not intended to limit protection scope of the present invention.All any amendments done within the spirit and principles in the present invention, equivalent replacement, improvement etc., be all included in protection scope of the present invention.

Claims (10)

1. adjust a method for frozen region in electrical form, it is characterized in that, comprising:
Receive user to the dragging instruction of the frost line of frozen region current in electrical form, move described frost line according to described dragging instruction;
According to the described current frozen region of described frost line adjustment after movement.
2. method according to claim 1, is characterized in that, described according to the described current frozen region of described frost line adjustment after movement, comprising:
Move according to described dragging instruction described frost line to can outside frozen region after, judge described can in frozen region whether also residue have frost line, if so, then adjust current frozen region according to remaining frost line, otherwise, cancel freezing described current frozen region.
3. method according to claim 1, is characterized in that, described reception user, to the dragging instruction of the frost line of frozen region current in electrical form, moves described frost line according to described dragging instruction, comprising:
Obtain the position of the control point of user;
According to the position of described control point, determine the distance of the frost line of current frozen region in described control point and electrical form;
When described distance is less than predeterminable range threshold value, the state distance with described control point being less than the frost line of described predeterminable range threshold value switches to removable state by stationary state;
The frost line of described removable state is moved in the change of following described control point.
4. method according to claim 1, is characterized in that, described reception user, to the dragging instruction of the frost line of frozen region current in electrical form, moves described frost line according to described dragging instruction, comprising:
Obtain the position of the control point of user;
Obtain the duration that described control point maintains invariant position, according to the position of described control point, determine the distance of the frost line of current frozen region in described control point and electrical form;
When described distance is less than predeterminable range threshold value and the duration of described maintenance invariant position is not less than preset duration threshold value, the state distance with described control point being less than the frost line of described predeterminable range threshold value switches to removable state by stationary state;
The frost line of described removable state is moved in the change of following described control point.
5. the method according to claim 3 or 4, is characterized in that, described in follow described control point change move the frost line of described removable state, comprising:
Determine line number and the columns at interval between the control point before the control point after changing and change;
Determine the frozen property of the frost line of described removable state, described frozen property comprises row to be freezed and row freeze;
When the frozen property of the frost line of described removable state freezes for row, the frost line of described removable state is moved in the direction to the frost line of vertical described removable state, the distance of distance corresponding to described line number of movement; The frozen property of the frost line of described removable state be row freeze time, the frost line of described removable state is moved in the direction to the frost line of vertical described removable state, the distance of distance corresponding to described columns of movement.
6. adjust a system for frozen region in electrical form, it is characterized in that, comprising: frost line mobile unit and frozen region adjustment unit;
Described frost line mobile unit, for receiving the dragging instruction of user to the frost line of frozen region current in electrical form, moves described frost line according to described dragging instruction;
Described frozen region adjustment unit, for adjusting described current frozen region according to the described frost line after movement.
7. system according to claim 6, is characterized in that, described frozen region adjustment unit, comprising: judgment sub-unit, adjust subelement and the subelement that thaws,
Described judgment sub-unit, for to move according to described dragging instruction at described frost line mobile unit described frost line to can frozen region outer after, judge that described whether also can residue in frozen region has frost line, if, then trigger described adjustment subelement, otherwise the subelement that thaws described in triggering;
Described adjustment subelement is used for adjusting current frozen region according to remaining frost line;
The described subelement that thaws, for cancelling freezing described current frozen region.
8. system according to claim 6, is characterized in that, described frost line mobile unit, comprising: position obtains subelement, distance determines subelement, the first state switches subelement and mover unit,
Described position obtains subelement, for obtaining the position of the control point of user;
Described distance determines subelement, for the position according to described control point, determines the distance of the frost line of current frozen region in described control point and electrical form;
Described first state switches subelement, and for when described distance is less than predeterminable range threshold value, the state distance with described control point being less than the frost line of described predeterminable range threshold value switches to removable state by stationary state;
Described mover unit, the frost line of described removable state is moved in the change for following described control point.
9. system according to claim 6, is characterized in that, described frost line mobile unit, comprising: position obtains subelement, distance determines subelement, duration determination subelement, the second state switches subelement and mover unit,
Described position obtains subelement, for obtaining the position of the control point of user;
Described duration determination subelement, maintains the duration of invariant position for obtaining described control point;
Described distance determines subelement, for the position according to described control point, determines the distance of the frost line of current frozen region in described control point and electrical form;
Described second state switches subelement, for be less than predeterminable range threshold value in described distance and the duration of described maintenance invariant position is not less than preset duration threshold value time, the state distance with described control point being less than the frost line of described predeterminable range threshold value switches to removable state by stationary state;
Described mover unit, the frost line of described removable state is moved in the change for following described control point.
10. system according to claim 8 or claim 9, it is characterized in that, described mover unit, comprising: mobile interval determining unit, frozen property determining unit and displacement unit,
Described mobile interval determining unit, for determining line number and the columns at interval between the control point before the control point after changing and change;
Described frozen property determining unit, for determining the frozen property of the frost line of described removable state, described frozen property comprises row to be freezed and row freeze;
Described displacement unit, when frozen property for the frost line in described removable state freezes for going, the frost line of described removable state is moved in direction to the frost line of vertical described removable state, the distance of distance corresponding to described line number of movement; The frozen property of the frost line of described removable state be row freeze time, the frost line of described removable state is moved in the direction to the frost line of vertical described removable state, the distance of distance corresponding to described columns of movement.
CN201410153436.4A 2014-04-16 2014-04-16 The method and system of frozen region in a kind of adjustment electrical form Active CN105022558B (en)

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 true CN105022558A (en) 2015-11-04
CN105022558B 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)

Cited By (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2017177436A1 (en) * 2016-04-15 2017-10-19 华为技术有限公司 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
CN110609993A (en) * 2019-09-18 2019-12-24 北京字节跳动网络技术有限公司 Table adjusting method and equipment
CN110968987A (en) * 2018-09-30 2020-04-07 腾讯科技(深圳)有限公司 Table display method and device, storage medium and electronic device
CN110968241A (en) * 2018-09-30 2020-04-07 腾讯科技(深圳)有限公司 Processing method and device of electronic form, computer readable storage medium and computer equipment
CN113625917A (en) * 2021-07-29 2021-11-09 北京达佳互联信息技术有限公司 Data display method and device, electronic equipment, storage medium and product

Citations (3)

* Cited by examiner, † Cited by third party
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

Patent Citations (3)

* Cited by examiner, † Cited by third party
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

Cited By (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2017177436A1 (en) * 2016-04-15 2017-10-19 华为技术有限公司 Method and apparatus for locking object in list, and terminal device
CN108604161A (en) * 2016-04-15 2018-09-28 华为技术有限公司 A kind of method, apparatus and terminal device of locking list object
CN108604161B (en) * 2016-04-15 2021-08-31 华为技术有限公司 A method, device and terminal device for locking list objects
CN107515706A (en) * 2017-08-23 2017-12-26 合肥龙图腾信息技术有限公司 Multiple ranks Window-freezing system and its application method in a kind of same EXCEL file
CN110968987A (en) * 2018-09-30 2020-04-07 腾讯科技(深圳)有限公司 Table display method and device, storage medium and electronic device
CN110968241A (en) * 2018-09-30 2020-04-07 腾讯科技(深圳)有限公司 Processing method and device of electronic form, computer readable storage medium and computer equipment
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
CN113625917A (en) * 2021-07-29 2021-11-09 北京达佳互联信息技术有限公司 Data display method and device, electronic equipment, storage medium and product
CN113625917B (en) * 2021-07-29 2024-06-11 北京达佳互联信息技术有限公司 Data display method, device, electronic equipment, storage medium and product

Also Published As

Publication number Publication date
CN105022558B (en) 2018-07-10

Similar Documents

Publication Publication Date Title
CN105022558A (en) Method and system for adjusting frozen region in spreadsheet
CN103092494A (en) Application switching method and device for touch screen terminals
CN103809853A (en) Information processing method and electronic device
CN103500057A (en) Mobile terminal and control method and device thereof
KR20150012290A (en) User interface interaction method and apparatus applied in touchscreen device, and touchscreen device
CN104142792B (en) A kind of application interface changing method and device
CN107977148A (en) method and device for moving cursor
CN103699289A (en) Method and device for responding to sliding operation
CN105511782B (en) A kind of game command processing method and processing device
CN105094567A (en) Intelligent terminal operation implementation method and system based on gravity sensor
CN103955329A (en) Intelligent terminal, mobile terminal and operating method thereof
CN103092496B (en) A kind of method, device and mobile device controlling browser
CN103870128A (en) Control method of electronic equipment, control device and electronic equipment
CN105700763A (en) Terminal interface window moving method and terminal interface window moving device
CN103096157A (en) Method for controlling moving focal point on television application interface by mobile phone
CN103530035A (en) Touch control terminal and area operating method of touch control terminal
CN104571872A (en) Mobile terminal split screen management method and device
CN103473014A (en) Multitask switching method and terminal
MX361221B (en) Application icon management method and device.
CN103473013B (en) The method of a kind of application interface regulation and mobile terminal
TWI456484B (en) Electronic apparatus and method for controlling the same
CN103837148A (en) Navigation map switching method and device and electronic equipment
CN105468133A (en) Touch processing method and device
CN103793132A (en) Desktop switching method and system for touch screen mobile terminals
CN104750361B (en) The processing method of icon, the processing system of icon and terminal

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