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

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 method and system for adjusting frozen areas in a spreadsheet

technical field

The invention relates to the technical field of electronic forms, in particular to a method and system for adjusting frozen areas in electronic forms.

Background technique

With the development of science and technology, office software such as spreadsheets has become an indispensable and important software in people's work.

Through the pane freezing function, users can freeze a certain area in the spreadsheet, so that they can still see the frozen area when switching the content of the table. To help users see frozen areas, spreadsheets use frozen lines to denote the boundaries of frozen areas. Users can conveniently freeze a certain row, column or area.

However, when the user needs to adjust the frozen area, he needs to cancel the existing frozen area first, and then perform the freezing operation again and select the area he wants to freeze to adjust the frozen area. The operation is cumbersome and is not conducive to the quick adjustment of the frozen area. .

Contents of the invention

The purpose of the embodiments of the present invention is to provide a method and system for adjusting frozen areas in an electronic form, so as to realize rapid adjustment of frozen areas.

In order to achieve the above purpose, the embodiment of the present invention discloses a method for adjusting the frozen area in the spreadsheet, including:

receiving a user's drag instruction to the frozen line of the current frozen area in the spreadsheet, and moving the frozen line according to the drag instruction;

The current freezing area is adjusted according to the moving freezing line.

Preferably, the adjusting the current freezing area according to the moving freezing line includes:

After moving the freezing line out of the freezable area according to the dragging instruction, it is judged whether there is any remaining frozen line in the freezable area, if so, adjusting the current frozen area according to the remaining frozen line, otherwise, Unfreeze the currently frozen region.

Preferably, the receiving a user's drag instruction to the frozen line of the current frozen area in the spreadsheet, and moving the frozen line according to the drag instruction includes:

Obtain the position of the user's manipulation point;

determining the distance between the manipulation point and the freezing line of the current freezing area in the spreadsheet according to the position of the manipulation point;

When the distance is less than a preset distance threshold, switching the state of the freezing line whose distance from the control point is less than the preset distance threshold from a fixed state to a movable state;

The freeze line of the movable state is moved following the change of the manipulation point.

Preferably, the receiving a user's drag instruction to the frozen line of the current frozen area in the spreadsheet, and moving the frozen line according to the drag instruction includes:

Obtain the position of the user's manipulation point;

Obtaining the duration for which the control point maintains a constant position, and determining the distance between the control point and the freezing line of the current freezing area in the spreadsheet according to the position of the control point;

When the distance is less than a preset distance threshold and the duration of maintaining the position is not less than a preset duration threshold, the state of the freezing line whose distance from the control point is smaller than the preset distance threshold is changed from a fixed state switch to a movable state;

The freeze line of the movable state is moved following the change of the manipulation point.

Preferably, the moving the frozen line in the movable state following the change of the control point includes:

Determine the number of rows and columns between the manipulated point after the change and the manipulated point before the change;

determining a freeze attribute of the freeze line in the movable state, where the freeze attribute includes row freeze and column freeze;

When the freezing attribute of the frozen line in the movable state is line freezing, move the frozen line in the movable state in a direction perpendicular to the frozen line in the movable state, and the distance moved is the corresponding number of rows distance; when the freezing attribute of the frozen line in the movable state is column freezing, move the frozen line in the movable state in a direction perpendicular to the frozen line in the movable state, and the distance moved is the column The distance corresponding to the number.

A system for adjusting frozen areas in an electronic form, comprising: a freezing line moving unit and a freezing area adjusting unit;

The frozen line moving unit is configured to receive a user's drag instruction for the frozen line in the current frozen area in the spreadsheet, and move the frozen line according to the drag instruction;

The freezing area adjusting unit is configured to adjust the current freezing area according to the moved freezing line.

Preferably, the freezing area adjustment unit includes: a judging subunit, an adjusting subunit and an unfreezing subunit,

The judging subunit is configured to judge whether there are still frozen lines remaining in the freezable area after the frozen line moving unit moves the frozen line out of the freezable area according to the drag instruction, and if so, then trigger the adjusting subunit, otherwise trigger the unfreezing subunit;

The adjustment subunit is used to adjust the current freezing area according to the remaining freezing line;

The unfreezing subunit is configured to unfreeze the currently frozen area.

Preferably, the freezing line moving unit includes: a position obtaining subunit, a distance determining subunit, a first state switching subunit and a moving subunit,

The position obtaining subunit is used to obtain the position of the user's manipulation point;

The distance determination subunit is configured to determine the distance between the manipulation point and the freezing line of the current freezing area in the spreadsheet according to the position of the manipulation point;

The first state switching subunit is configured to switch the state of the freezing line whose distance from the control point is less than the preset distance threshold from a fixed state to a movable state when the distance is less than a preset distance threshold ;

The moving subunit is configured to move the movable freezing line following the change of the manipulation point.

Preferably, the freezing line moving unit includes: a position obtaining subunit, a distance determining subunit, a duration determining subunit, a second state switching subunit and a moving subunit,

The position obtaining subunit is used to obtain the position of the user's manipulation point;

The duration determination subunit is configured to obtain the duration for which the control point maintains its position;

The distance determination subunit is configured to determine the distance between the manipulation point and the freezing line of the current freezing area in the spreadsheet according to the position of the manipulation point;

The second state switching subunit is configured to set the distance to the control point to be less than the preset distance threshold when the distance is less than the preset distance threshold and the time for maintaining the position is not less than the preset time length threshold. The state of the frozen line at the distance threshold is switched from a fixed state to a movable state;

The moving subunit is configured to move the movable freezing line following the change of the manipulation point.

Preferably, the moving subunit includes: a moving interval determining unit, a freezing attribute determining unit, and a directional moving unit,

The movement interval determining unit is used to determine the number of rows and columns between the changed control point and the control point before the change;

The freezing attribute determining unit is configured to determine the freezing attribute of the movable freezing line, the freezing attribute includes row freezing and column freezing;

The directional moving unit is configured to move the frozen line in the movable state in a direction perpendicular to the frozen line in the movable state when the freezing attribute of the frozen line in the movable state is row freezing, and the moved The distance is the distance corresponding to the number of rows; when the freezing attribute of the movable freezing line is column freezing, moving the movable freezing line in a direction perpendicular to the movable freezing line, The moved distance is the distance corresponding to the column number.

The embodiment of the present invention provides a method and system for adjusting the frozen area in a spreadsheet, which can directly respond to the user's drag command, switch the frozen line to a movable state, and then follow the user's drag command to move the frozen line. After the freeze line adjusts the current freeze area. Therefore, the present invention does not require the user to perform pane freezing operation again after unfreezing, the operation is more convenient, quick adjustment of the frozen area is realized, and the user experience is good.

Description of drawings

In order to more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the following will briefly introduce the drawings that need to be used in the description of the embodiments or the prior art. Obviously, the accompanying drawings in the following description are only These are some embodiments of the present invention. Those skilled in the art can also obtain other drawings based on these drawings without creative work.

FIG. 1 is a flow chart of a method for adjusting frozen regions in an electronic form provided by an embodiment of the present invention;

FIG. 2 is a schematic diagram of a frozen region provided by an embodiment of the present invention;

FIG. 3 is a schematic diagram of another frozen region provided by an embodiment of the present invention;

FIG. 4 is a schematic diagram of another frozen region provided by an embodiment of the present invention;

FIG. 5 is a schematic diagram of another frozen region provided by an embodiment of the present invention;

FIG. 6 is a schematic diagram of another frozen region provided by an embodiment of the present invention;

FIG. 7 is a flowchart of another method for adjusting frozen regions in an electronic form provided by an embodiment of the present invention;

FIG. 8 is a schematic structural diagram of a system for adjusting frozen regions in a spreadsheet according to an embodiment of the present invention.

Detailed ways

The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some of the embodiments of the present invention, not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

As shown in FIG. 1, a method for adjusting a frozen area in a spreadsheet provided by an embodiment of the present invention may include:

S100. Receive a user's drag instruction for the frozen line of the current frozen area in the spreadsheet, and move the frozen line according to the drag instruction;

Wherein, the freezing line is a boundary identification line of the freezing area. When freezing one or more rows of cells, the freezing line will coincide with the horizontal row dividing line. When freezing one or more columns of cells, the freezing line will coincide with the vertical column dividing line. Of course, cells with a certain number of rows and cells with a certain number of columns can also be frozen at the same time. At this time, there will be two freezing lines in the spreadsheet, one coincides with the horizontal row dividing line, and the other coincides with the vertical column dividing line Lines coincide. As shown in FIG. 2 , when the cells in row 1, row 2, row 3, and row 4 are frozen, a freezing line 001 appears in the spreadsheet, and the area above the freezing line 001 is the current freezing area. As shown in FIG. 3 , when the cells in column A are frozen, a frozen line 002 appears in the spreadsheet, and the area to the left of the frozen line 002 is the current frozen area. As shown in Figure 4, when the cells in row 1, row 2, row 3, row 4, and column A are frozen at the same time, the frozen line 001 and the frozen line 002 appear in the spreadsheet at the same time, and the area above the frozen line 001 and The union area of the areas on the left side of the freezing line 002 is the current freezing area.

Among them, S100 can have two specific implementation modes:

Method 1. S100 may include:

Obtain the position of the user's manipulation point;

determining the distance between the manipulation point and the freezing line of the current freezing area in the spreadsheet according to the position of the manipulation point;

When the distance is less than a preset distance threshold, switching the state of the freezing line whose distance from the control point is less than the preset distance threshold from a fixed state to a movable state;

The freeze line of the movable state is moved following the change of the manipulation point.

Wherein, the manipulation point may be a touch point or a point where a cursor is located. When the control point is close to the frozen line, the frozen line can be switched to a movable state to facilitate the user to move.

Method 2. S100 may include:

Obtain the position of the user's manipulation point;

Obtaining the duration for which the control point maintains a constant position, and determining the distance between the control point and the freezing line of the current freezing area in the spreadsheet according to the position of the control point;

When the distance is less than a preset distance threshold and the duration of maintaining the position is not less than a preset duration threshold, the state of the freezing line whose distance from the control point is less than the preset distance threshold is switched from a fixed state to a Movable state;

The freeze line of the movable state is moved following the change of the manipulation point.

The difference between method 2 and method 1 is that in method 2, the frozen line becomes movable only when the position of the control point remains unchanged for a period of time. For example: For a touch screen device, when the user presses and holds the frozen line, the frozen line becomes movable.

Specifically, in mode 1 and mode 2, after the frozen line is switched to a movable state, the frozen line may have different display effects to remind the user that the frozen line can be moved.

In the above two manners, moving the frozen line in the movable state following the change of the control point may include:

Determine the number of rows and columns between the manipulated point after the change and the manipulated point before the change;

determining a freeze attribute of the freeze line in the movable state, where the freeze attribute includes row freeze and column freeze;

When the freezing attribute of the frozen line in the movable state is line freezing, move the frozen line in the movable state in a direction perpendicular to the frozen line in the movable state, and the distance moved is the corresponding number of rows distance; when the freezing attribute of the frozen line in the movable state is column freezing, move the frozen line in the movable state in a direction perpendicular to the frozen line in the movable state, and the distance moved is the column The distance corresponding to the number.

Wherein, the freezing line of row freezing coincides with the horizontal row dividing line, and the freezing line of column freezing coincides with the vertical column dividing line. The dragging distance of the user's drag command can be any distance, but when the frozen line moves, it needs to move according to the row or column. Therefore, the moving distance of the frozen line must be an integer multiple of the row spacing or column spacing, and the moving direction Must be horizontal or vertical.

S200. Adjust the current freezing area according to the moved freezing line.

As shown in FIG. 5 , the frozen line 001 and the frozen line 002 appear simultaneously in the spreadsheet, and the union area of the area above the frozen line 001 and the area to the left of the frozen line 002 is the current frozen area. The user's handle point is at the focus of the two frozen lines, and both frozen lines switch to a movable state. Then the user issues an instruction to drag downwards. At this time, since there is only movement in the vertical direction, the frozen line 002 cannot move horizontally, and only the frozen line 001 moves downward.

As shown in Figure 6, after the user's finger stops dragging, the frozen line 001 coincides with the dividing line of line 10 and line 11. According to the moved frozen line, the current frozen area can be adjusted to: the area above the frozen line 001 and the frozen area. The union region of the region to the left of line 002.

The embodiment of the present invention provides a method for adjusting the frozen area in the electronic form, which can directly respond to the user's drag command, switch the frozen line to a movable state, and then follow the user's drag command to move the frozen line, according to the moved Freeze Line adjusts the current frozen area. Therefore, the present invention does not require the user to perform pane freezing operation again after unfreezing, the operation is more convenient, quick adjustment of the frozen area is realized, and the user experience is good.

As shown in FIG. 7, in another method for adjusting the frozen area in a spreadsheet provided by an embodiment of the present invention, S200 in the embodiment shown in FIG. 1 may include:

S210. After moving the freezing line out of the freezable area according to the dragging instruction, judge whether there is still a frozen line in the freezable area, if yes, execute S211, otherwise execute S212;

S211. Adjust the current freezing area according to the remaining freezing line;

S212. Unfreeze the current frozen area.

Wherein, the freezeable area is the editable table area, and the editable table area does not include the row and column where the row number label bar is located. When the user drags the frozen line out of the freezable area, the frozen line has lost its effect, and the frozen line can be canceled at this time. When there are two frozen lines in the spreadsheet, after one of the frozen lines is canceled, the frozen area formed by the other frozen line is the current frozen area. If there is only one frozen line in the spreadsheet, unfreezing the frozen line will no longer exist in the spreadsheet, so the current frozen area can be unfrozen.

Compared with the above method embodiment, the present invention also provides a system for adjusting the frozen area in the spreadsheet.

As shown in FIG. 8 , a system for adjusting frozen areas in an electronic form provided by an embodiment of the present invention may include: a frozen line moving unit 100 and a frozen area adjusting unit 200;

The frozen line moving unit 100 is configured to receive a user's drag instruction for the frozen line in the current frozen area in the spreadsheet, and move the frozen line according to the drag instruction;

Wherein, the freezing line moving unit 100 can be composed in two ways:

Mode 1, the freezing line moving unit 100 may include: a position obtaining subunit, a distance determining subunit, a first state switching subunit, and a moving subunit,

The position obtaining subunit is used to obtain the position of the user's manipulation point;

The distance determination subunit is configured to determine the distance between the manipulation point and the freezing line of the current freezing area in the spreadsheet according to the position of the manipulation point;

The first state switching subunit is configured to switch the state of the freezing line whose distance from the control point is less than a preset distance threshold from a fixed state to a movable state when the distance is less than a preset distance threshold;

The moving subunit is configured to move the movable freezing line following the change of the manipulation point.

Mode 2, the freezing line moving unit 100 may include: a position obtaining subunit, a distance determining subunit, a duration determining subunit, a second state switching subunit and a moving subunit,

The position obtaining subunit is used to obtain the position of the user's manipulation point;

The duration determination subunit is configured to obtain the duration for which the control point maintains its position;

The distance determination subunit is configured to determine the distance between the manipulation point and the freezing line of the current freezing area in the spreadsheet according to the position of the manipulation point;

The second state switching subunit is configured to reduce the distance to the control point to less than a preset distance when the distance is less than a preset distance threshold and the time for maintaining the position is not less than a preset time threshold The state of the frozen line of the threshold is switched from a fixed state to a movable state;

The moving subunit is configured to move the movable freezing line following the change of the manipulation point.

The moving sub-units in the above two ways may include: a moving interval determining unit, a freezing attribute determining unit and a directional moving unit,

The movement interval determining unit is used to determine the number of rows and columns between the changed control point and the control point before the change;

The freezing attribute determining unit is configured to determine the freezing attribute of the movable freezing line, the freezing attribute includes row freezing and column freezing;

The directional moving unit is configured to move the frozen line in the movable state in a direction perpendicular to the frozen line in the movable state when the freezing attribute of the frozen line in the movable state is row freezing, and the moved The distance is the distance corresponding to the number of rows; when the freezing attribute of the movable freezing line is column freezing, moving the movable freezing line in a direction perpendicular to the movable freezing line, The moved distance is the distance corresponding to the column number.

The freezing area adjusting unit 200 is configured to adjust the current freezing area according to the moved freezing line.

In other embodiments of the present invention, the freezing area adjusting unit 200 shown in FIG. 8 may include: a judging subunit, an adjusting subunit, and an unfreezing subunit,

The judging subunit is configured to judge whether there are still frozen lines remaining in the freezable area after the frozen line moving unit moves the frozen line out of the freezable area according to the drag instruction, and if so, then trigger the adjusting subunit, otherwise trigger the unfreezing subunit;

The adjustment subunit is used to adjust the current freezing area according to the remaining freezing line;

The unfreezing subunit is configured to unfreeze the currently frozen area.

The embodiment of the present invention provides a system for adjusting the frozen area in the electronic form, which can directly respond to the user's drag command, switch the frozen line to a movable state, and then follow the user's drag command to move the frozen line, according to the moved Freeze Line adjusts the current frozen area. Therefore, the present invention does not require the user to perform pane freezing operation again after unfreezing, the operation is more convenient, quick adjustment of the frozen area is realized, and the user experience is good.

It should be noted that in this article, relational terms such as first and second are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply that there is a relationship between these entities or operations. There is no such actual relationship or order between them. Furthermore, the term "comprises", "comprises" or any other variation thereof is intended to cover a non-exclusive inclusion such that a process, method, article or apparatus comprising a set of elements includes not only those elements, but also includes elements not expressly listed. other elements of or also include elements inherent in such a process, method, article, or apparatus. Without further limitations, an element defined by the phrase "comprising a ..." does not exclude the presence of additional identical elements in the process, method, article or apparatus comprising said element.

Each embodiment in this specification is described in a related manner, the same and similar parts of each embodiment can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the system embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and for relevant parts, refer to part of the description of the method embodiment.

The above descriptions are only preferred embodiments of the present invention, and are not intended to limit the protection scope of the present invention. Any modification, equivalent replacement, improvement, etc. made within the spirit and principles of the present invention are included in the protection scope of the present invention.

Claims (10)

1. A method for adjusting frozen regions in a spreadsheet, comprising: receiving a user's drag instruction to the frozen line of the current frozen area in the spreadsheet, and moving the frozen line according to the drag instruction; The current freezing area is adjusted according to the moving freezing line. 2. The method according to claim 1, wherein the adjusting the current frozen region according to the moved frozen line comprises: After moving the freezing line out of the freezable area according to the dragging instruction, it is judged whether there is any remaining frozen line in the freezable area, if so, adjusting the current frozen area according to the remaining frozen line, otherwise, Unfreeze the currently frozen region. 3. The method according to claim 1, wherein the receiving a user's drag instruction to the frozen line of the current frozen area in the spreadsheet, and moving the frozen line according to the drag instruction comprises: Obtain the position of the user's manipulation point; determining the distance between the manipulation point and the freezing line of the current freezing area in the spreadsheet according to the position of the manipulation point; When the distance is less than a preset distance threshold, switching the state of the freezing line whose distance from the control point is less than the preset distance threshold from a fixed state to a movable state; The freeze line of the movable state is moved following the change of the manipulation point. 4. The method according to claim 1, wherein the receiving a user's drag instruction to the frozen line of the current frozen area in the spreadsheet, and moving the frozen line according to the drag instruction comprises: Obtain the position of the user's manipulation point; Obtaining the duration for which the control point maintains a constant position, and determining the distance between the control point and the freezing line of the current freezing area in the spreadsheet according to the position of the control point; When the distance is less than a preset distance threshold and the duration of maintaining the position is not less than a preset duration threshold, the state of the freezing line whose distance from the control point is smaller than the preset distance threshold is changed from a fixed state switch to a movable state; The freeze line of the movable state is moved following the change of the manipulation point. 5. The method according to claim 3 or 4, wherein the moving the frozen line in the movable state following the change of the manipulation point comprises: Determine the number of rows and columns between the manipulated point after the change and the manipulated point before the change; determining a freeze attribute of the freeze line in the movable state, where the freeze attribute includes row freeze and column freeze; When the freezing attribute of the frozen line in the movable state is line freezing, move the frozen line in the movable state in a direction perpendicular to the frozen line in the movable state, and the distance moved is the corresponding number of rows distance; when the freezing attribute of the frozen line in the movable state is column freezing, move the frozen line in the movable state in a direction perpendicular to the frozen line in the movable state, and the distance moved is the column The distance corresponding to the number. 6. A system for adjusting frozen areas in an electronic form, comprising: a frozen line moving unit and a frozen area adjustment unit; The frozen line moving unit is configured to receive a user's drag instruction for the frozen line in the current frozen area in the spreadsheet, and move the frozen line according to the drag instruction; The freezing area adjusting unit is configured to adjust the current freezing area according to the moved freezing line. 7. The system according to claim 6, wherein the freezing area adjusting unit comprises: a judging subunit, an adjusting subunit and an unfreezing subunit, The judging subunit is configured to judge whether there are still frozen lines remaining in the freezable area after the frozen line moving unit moves the frozen line out of the freezable area according to the drag instruction, and if so, then trigger the adjusting subunit, otherwise trigger the unfreezing subunit; The adjustment subunit is used to adjust the current freezing area according to the remaining freezing line; The unfreezing subunit is configured to unfreeze the currently frozen area. 8. The system according to claim 6, wherein the freezing line moving unit comprises: a position obtaining subunit, a distance determining subunit, a first state switching subunit and a moving subunit, The position obtaining subunit is used to obtain the position of the user's manipulation point; The distance determination subunit is configured to determine the distance between the manipulation point and the freezing line of the current freezing area in the spreadsheet according to the position of the manipulation point; The first state switching subunit is configured to switch the state of the freezing line whose distance from the control point is less than the preset distance threshold from a fixed state to a movable state when the distance is less than a preset distance threshold ; The moving subunit is configured to move the movable freezing line following the change of the manipulation point. 9. The system according to claim 6, wherein the freezing line moving unit comprises: a position obtaining subunit, a distance determining subunit, a duration determining subunit, a second state switching subunit and a moving subunit, The position obtaining subunit is used to obtain the position of the user's manipulation point; The duration determination subunit is configured to obtain the duration for which the control point maintains its position; The distance determination subunit is configured to determine the distance between the manipulation point and the freezing line of the current freezing area in the spreadsheet according to the position of the manipulation point; The second state switching subunit is configured to set the distance to the control point to be less than the preset distance threshold when the distance is less than the preset distance threshold and the time for maintaining the position is not less than the preset time length threshold. The state of the frozen line at the distance threshold is switched from a fixed state to a movable state; The moving subunit is configured to move the movable freezing line following the change of the manipulation point. 10. The system according to claim 8 or 9, wherein the moving subunit comprises: a moving interval determining unit, a freezing attribute determining unit and a directional moving unit, The movement interval determining unit is used to determine the number of rows and columns between the changed control point and the control point before the change; The freezing attribute determining unit is configured to determine the freezing attribute of the movable freezing line, the freezing attribute includes row freezing and column freezing; The directional moving unit is configured to move the frozen line in the movable state in a direction perpendicular to the frozen line in the movable state when the freezing attribute of the frozen line in the movable state is row freezing, and the moved The distance is the distance corresponding to the number of rows; when the freezing attribute of the movable freezing line is column freezing, moving the movable freezing line in a direction perpendicular to the movable freezing line, The moved distance is the distance corresponding to the column number.