CN105022722B - A kind of electrical form ranks freezing method and device - Google Patents
A kind of electrical form ranks freezing method and device Download PDFInfo
- Publication number
- CN105022722B CN105022722B CN201410158411.3A CN201410158411A CN105022722B CN 105022722 B CN105022722 B CN 105022722B CN 201410158411 A CN201410158411 A CN 201410158411A CN 105022722 B CN105022722 B CN 105022722B
- Authority
- CN
- China
- Prior art keywords
- row
- freeze
- cell
- content
- waiting
- 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
Abstract
The embodiment of the invention discloses a kind of electrical form ranks freezing method and device, a kind of electrical form ranks freezing method comprises the following steps:Receive that user sends to target spreadsheet freezes to instruct, described to freeze instruction and include:Freeze to instruct or row are freezed to instruct to capable;Freeze to instruct according to described, in the target spreadsheet, content is not defined as waiting to freeze to go for the minimum row of empty and line number, or content is not defined as waiting to freeze to arrange for the minimum row of empty and column number;Wait to freeze to go or row to be freezed freeze to identified.The technical scheme provided according to embodiments of the present invention, when user is using freezing to go or freezing the shortcut of row, first scanning electron form, to be freezed go or row to be freezed is determined in the region of physical record information, corresponding freeze operation is carried out again, more meet the actual expectation of user, it is user-friendly.
Description
Technical field
The present invention relates to technical field of office software, more particularly to a kind of electrical form ranks freezing method and device.
Background technology
In daily life, work, the use of electrical form is more and more frequent, and user can be made respectively using electrical form
The simple or complicated form document of kind, for information record, statistics etc..Effective line number, columns when electrical form is more
When, electrical form is rolled, all row or column all can be rolled and then, it is difficult to corresponding to the data for distinguishing each row or each column unit lattice
Title.For convenience of editing electronic form, the row or column specified can be locked, when rolling electrical form other parts, quilt
The row or column of locking remains stationary as, and is constantly in visible state, and here it is use One function conventional during electrical form ---
Freeze pane.
According to a kind of implementation of prior art, two kinds of shortcuts are provided to " freezing pane " function:Freeze first trip,
Freeze first.Both shortcuts are able to realize to the first trip in electrical form viewing area, first freezes.
However, in actual applications, first trip in electrical form viewing area or first not necessarily desired by user
The row or column freezed.For example, in some cases, the first trip in electrical form viewing area is probably blank line, and user it is expected
The line position freezed is in the second row of viewing area;Or the row that user it is expected to freeze is not in viewing area.Such case
Under, directly the desired row of user can not be freezed using prior art, user needs manually to move the row for it is expected to freeze
Moving to the first trip position of viewing area, can utilize the shortcut of " freezing first trip " to realize desired operation, use be present
The problem of inconvenient.
The content of the invention
To solve the above problems, the embodiment of the invention discloses a kind of electrical form ranks freezing method and device.Technology
Scheme is as follows:
A kind of electrical form ranks freezing method, including:
Receive that user sends to target spreadsheet freezes to instruct, described to freeze instruction and include:Capable is freezed to instruct
Or row are freezed to instruct;
Freeze to instruct according to described, it is in the target spreadsheet, content is true not for the minimum row of empty and line number
It is set to and waits to freeze to go, or content is not defined as waiting to freeze to arrange for the minimum row of empty and column number;
Wait to freeze to go or row to be freezed freeze to identified.
In a kind of embodiment of the present invention, freeze to instruct described in the basis, in the target spreadsheet
In, content is not defined as waiting to freeze to go for the minimum row of empty and line number, or content is minimum not for empty and column number
Row are defined as waiting to freeze to arrange, including:
In the target spreadsheet, single-frame scanned since the first row first row cell, when scanning is arrived in first
When holding the cell not for sky, the cell region is labeled as the currently active region, the effective coverage is a rectangle
Region;
Scan to i-th of content for empty cell when, judge i-th of content not for empty cell and currently
The relative position relation of effective coverage, wherein i=2,3,4 ...;
If i-th of content be not adjacent with the currently active region for empty cell, the currently active region is extended,
The peripheral cell lattice of the effective coverage after extension are made to include the cell that i-th of content is not sky;
If i-th of content be not non-conterminous for empty cell and the currently active region, by the currently active region
Labeled as an independent effective coverage, i-th of content is not labeled as new the currently active area for empty cell region
Domain, carry out the extension in new the currently active region;
After scanning through all cells of the target spreadsheet, freeze to instruct according to described, independently have what is marked
Imitate in region, the minimum row of line number is defined as waiting to freeze to go, or the minimum row of column number are defined as waiting to freeze to arrange.
In a kind of embodiment of the present invention, freeze to instruct described in the basis, in the target spreadsheet
In, content is not defined as waiting to freeze to go for the minimum row of empty and line number, or content is minimum not for empty and column number
Row are defined as waiting to freeze to arrange, including:
In the target spreadsheet, single-frame scanned since the first row first row cell, when it is determined that a cell
Content be not space-time, the cell is labeled as effective cell;
After scanning through all cells of the target spreadsheet, freeze to instruct according to described, in the effective list marked
In first lattice, the minimum cell of line number is expert at and is defined as waiting to freeze to go, or the cell column by column number minimum
It is defined as waiting to freeze to arrange.
It is described to freeze instruction and be in a kind of embodiment of the present invention:Capable is freezed to instruct;
It is described not to be defined as waiting to freeze to go for the minimum row of empty and line number by content in the target spreadsheet,
Including:
In the target spreadsheet, progressively scanned since the first row, when first scan has content not to certain row
For sky cell when, the row is defined as waiting to freeze to go.
It is described to freeze instruction and be in a kind of embodiment of the present invention:Row are freezed to instruct;
It is described not to be defined as waiting to freeze to arrange for the minimum row of empty and column number by content in the target spreadsheet,
Including:
In the target spreadsheet, scanned by column since first row, when first scan has content not to certain row
For sky cell when, the row are defined as waiting to freeze to arrange.
A kind of electrical form ranks freezing plant, including:
Freeze command reception module, what is target spreadsheet sent for receiving user freezes to instruct, described to freeze to refer to
Order includes:Freeze to instruct or row are freezed to instruct to capable;
Frozen contents determining module is treated, for freezing to instruct according to, in the target spreadsheet, by content not
It is defined as waiting to freeze to go for the minimum row of empty and line number, or content is not defined as waiting to freeze for the minimum row of empty and column number
Knot row;
Freeze processing module, for waiting to freeze to go or row to be freezed freeze to identified.
It is described to treat frozen contents determining module in a kind of embodiment of the present invention, including:
Effective coverage marks submodule, in the target spreadsheet, since the first row first row cell
Progressive scan, when scanning to first content is not empty cell, the cell region is labeled as the currently active area
Domain, the effective coverage are a rectangular areas;
Position relationship judging submodule, when not being empty cell for scanning to i-th of content, judge described i-th
Content is not empty cell and the relative position relation in the currently active region, wherein i=2,3,4 ...;
Effective coverage extends submodule, for being not empty cell and the currently active region phase in i-th of content
When adjacent, the currently active region is extended, the peripheral cell lattice of the effective coverage after extension is included i-th of content not to be empty
Cell;
Loop control submodule, for non-conterminous not for empty cell and the currently active region in i-th of content
When, the effective coverage mark submodule is triggered, is an independent effective coverage by the currently active zone marker, with i-th
It not is empty cell region as the currently active region newly to hold, and carries out the extension in new the currently active region;
Frozen contents determination sub-module is treated, for after all cells of the target spreadsheet are scanned through, according to institute
State and freeze to instruct, in the independent effective coverage marked, minimum being expert at of line number is defined as waiting to freeze to go, or row are compiled
Number minimum row are defined as waiting to freeze to arrange.
It is described to treat frozen contents determining module in a kind of embodiment of the present invention, including:
Effective unit case marking submodule, in the target spreadsheet, being opened from the first row first row cell
Beginning is single-frame scanned, when it is determined that the content of a cell is not space-time, the cell is labeled as into effective cell;
Frozen contents determination sub-module is treated, for after all cells of the target spreadsheet are scanned through, according to institute
State and freeze to instruct, in the effective cell marked, the minimum cell of line number is expert at and is defined as waiting to freeze to go, or
The minimum cell column of line number is defined as waiting to freeze to arrange.
The present invention a kind of embodiment in, it is described freeze command reception module reception instruction of freezing be:It is right
Capable freezes to instruct;
It is described to treat frozen contents determining module, it is specifically used for:In the target spreadsheet, since the first row line by line
Scanning, when it is not empty cell that first scan to certain row, which has content, the row is defined as waiting to freeze to go.
It is described to freeze the instruction of freezing that command reception module receives and be in a kind of embodiment of the present invention:
Row are freezed to instruct;
It is described to treat frozen contents determining module, it is specifically used for:In the target spreadsheet, since first row by column
Scanning, when first scan to certain row is not empty cell with content, the row are defined as waiting to freeze to arrange.
The technical scheme that the embodiment of the present invention is provided, when user is using freezing to go or freezing the shortcut of row, first
Scanning electron form, determined in the region of physical record information it is to be freezed go or row to be freezed, then frozen accordingly
Knot operation, compared with prior art, more meets the actual expectation of user, user-friendly.
Brief description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
There is the required accompanying drawing used in technology description to be briefly described, it should be apparent that, drawings in the following description are only this
Some embodiments of invention, for those of ordinary skill in the art, on the premise of not paying creative work, can be with
Other accompanying drawings are obtained according to these accompanying drawings.
Fig. 1 is a kind of flow chart of electrical form ranks freezing method in the embodiment of the present invention;
Fig. 2 is a kind of schematic diagram of electrical form in the embodiment of the present invention;
Fig. 3 is a kind of flow chart that ranks method to be freezed is determined in the embodiment of the present invention;
Fig. 4 is another flow chart that ranks method to be freezed is determined in the embodiment of the present invention;
Fig. 5 is the structural representation of electrical form ranks freezing plant in the embodiment of the present invention;
Fig. 6 is a kind of structural representation that frozen contents determining module is treated in the embodiment of the present invention;
Fig. 7 is another structural representation that frozen contents determining module is treated in the embodiment of the present invention.
Embodiment
Fig. 2 is that a kind of schematic diagram of electrical form, electrical form are mainly used in information record, numeral in the embodiment of the present invention
Statistics etc., in real life, work, the use of electrical form is more and more frequent.Common spreadsheet software includes Microsoft
Electrical form in spreadsheet component EXCEL and Kingsoft WPS in OFFICE etc..
In electrical form, line number 1,2,3,4 ..., column number A, B, C, D ..., herein with " unit
The such descriptions of lattice B1 " refer to the first row secondary series cell, it can be seen in fig. 2 that the electrical form includes student information and achievement
Table 101 and remarks cell 102, it is easy to find out, the first behavior null, first is classified as empty row, and the B-H of the second row is classified as the table
The header line of lattice, the B-H row of the third line to the 6th row correspond to the title content in header line respectively, and B is classified as name row, per a line
The corresponding student of C-H row information and achievement.In actual applications, if user scrolls down through electrical form, header line
Can and then it roll, it is difficult to corresponding title is corresponded to according to the content of each row record, the achievement portion such as represented in digital form
Point, once header line is rolled to invisible area, listed numeral can not judge be Chinese Achievement Test, mathematics achievement, English into
Achievement or average achievement.Equally, scroll right electrical form when, name row also can and then roll, once the row be rolled to it is invisible
Region, it is difficult to which the sex row after the row, class's row, achievement row are corresponded on the name of specific student.In this case, use
Family wishes to freeze header line, if freezed using the shortcut for freezing first trip of prior art, what is freezed will be first
OK, the first behavior null, it is not the header line freezed desired by user;Or user wishes to freeze name row, if made
Freezed with the shortcut for freezing first of prior art, what is freezed will be first row, and first is classified as empty row, is not
The name row freezed desired by user.
In view of the above-mentioned problems, the embodiments of the invention provide a kind of electrical form ranks freezing method, including:
Receive that user sends to target spreadsheet freezes to instruct, described to freeze instruction and include:Capable is freezed to instruct
Or row are freezed to instruct;
Freeze to instruct according to described, it is in the target spreadsheet, content is true not for the minimum row of empty and line number
It is set to and waits to freeze to go, or content is not defined as waiting to freeze to arrange for the minimum row of empty and column number;
Wait to freeze to go or row to be freezed freeze to identified.
Target spreadsheet mentioned here is user's form to be dealt with, and its content recorded can be word letter
Breath or data message.It can be that user sets the quick botton for freezing instruction in the menu of electrical form, such as " freeze
Have effect content first trip ", " freeze effective content first ", effective content is exactly the information of user's physical record.
When user, which will use, freezes capable function, quick botton " row for freezing effective content " is clicked directly on, you can complete
Paired content is not the freeze operation of the minimum row of empty and line number;When user will use the function of freezing row, click directly on
Quick botton " row for freezing effective content ", you can complete to be not the freeze operation of the minimum row of empty and column number to content.
The technical scheme that the embodiment of the present invention is provided, when user is using freezing to go or freezing the shortcut of row, first
Scanning electron form, determined in the region of physical record information it is to be freezed go or row to be freezed, then frozen accordingly
Knot operation, compared with prior art, more meets the actual expectation of user, user-friendly.
In order that those skilled in the art more fully understand the technical scheme in the embodiment of the present invention, below in conjunction with this hair
Accompanying drawing in bright embodiment, the technical scheme in the embodiment of the present invention is described in detail, it is clear that described embodiment
Only part of the embodiment of the present invention, rather than whole embodiments.Based on the embodiment in the present invention, the common skill in this area
The every other embodiment that art personnel are obtained, should all belong to the scope of protection of the invention.
As shown in figure 1, a kind of electrical form ranks freezing method provided in an embodiment of the present invention, can include:
S100, what reception user sent to target spreadsheet freezes to instruct;
Convenient for editor for the more electrical form of effective line number, columns, user can be used freezing function, send jelly
Knot instruction, freezing instruction includes, and freezes to instruct or row are freezed to instruct to capable.
For freezing to capable, user is that the desired row freezed can be kept when it is expected to roll other rows of electrical form
It is motionless, it is constantly in visible state;
For freezing to row, user is that the desired row freezed can be kept when it is expected to roll other row of electrical form
It is motionless, it is constantly in visible state.
For form as shown in Figure 2, what user wished to freeze is header line or name row.
S200, freeze to instruct according to described, it is in the target spreadsheet, content is minimum not for empty and line number
Row be defined as waiting to freeze to go, or content is not defined as waiting to freeze to arrange for the minimum row of empty and column number;
, will in target spreadsheet when receiving that user sends to target spreadsheet to capable when freezing instruction
Content is not defined as waiting to freeze to go for the minimum row of empty and line number;
, will in target spreadsheet when receiving that user sends to target spreadsheet to row when freezing instruction
Content is not defined as waiting to freeze to arrange for the minimum row of empty and column number.
S300, wait to freeze to go or row to be freezed freeze to identified.
It is determined that wait freezing to go or after row are freezed, freezed accordingly.
For step S200, can there are a variety of methods to determine to wait to freeze to go or wait to freeze to arrange, enumerate here it is several, certainly really
Fixed method be not limited to be enumerated this is several.
The first determination provided in an embodiment of the present invention is waited to freeze to go or waits that the method for freezing row is as shown in Figure 3:
S210, in the target spreadsheet, single-frame scanned since the first row first row cell, when scanning to head
When individual content is not empty cell, the cell region is labeled as the currently active region;
The currently active region mentioned here is a variable, as the content scanned does not increase gradually for empty cell
More, the currently active region constantly extends, and is presented with rectangular mode.Scanning when laterally can single-frame scan, can also longitudinally by
Lattice scan.
S220, i-th of content is judged not for the cell and the relative position relation in the currently active region of sky;
Scan to i-th of content for empty cell when, judge i-th of content not for empty cell with it is the currently active
The relative position relation in region, i=2,3,4 ....
Such as scan to the 2nd content for empty cell when, judge the 2nd content for empty cell and ought
The relative position relation of preceding effective coverage, the currently active region are not marked with the 1st content for empty cell region
Obtain;
Scan to the 3rd content for empty cell when, judge the 3rd content not for empty cell with it is the currently active
The relative position relation in region, the currently active region are not mark to obtain for empty cell region with the 1st, 2 content
's;
By that analogy, scan to the 4th, 5 ... individual content for empty cell when, do phase with the currently active region
To position judgment.
S230, the currently active region is extended, the peripheral cell lattice of the effective coverage after extension is included i-th of content
It is not mentioned null cell;
By step S220 judgement, if i-th of content for empty cell it is adjacent with the currently active region,
The currently active region is extended, and the peripheral cell lattice of the effective coverage after extension is included the list that i-th of content is not sky
First lattice.
Position is adjacent several situations, and respectively i-th of content is not located under the currently active region for empty cell
Side, lower left, right or lower right:
When i-th of content is not located at the lower section in the currently active region for empty cell, the currently active region is expanded downwards
A line is opened up, and columns is constant;
When i-th of content is not located at the lower left in the currently active region for empty cell, the currently active region is downward
Extend a line, and the row of extension one to the left;
When i-th of content is not located at the right in the currently active region for empty cell, the currently active region is expanded to the right
Zhan Yilie, and line number is constant;
When i-th of content is not located at the lower right in the currently active region for empty cell, the currently active region is downward
Extend a line, and the row of extension one to the right.
S240, it is an independent effective coverage by the currently active zone marker, is not the cell institute of sky by i-th of content
It is new the currently active region in zone marker, carries out the extension in new the currently active region;
By step S220 judgement, if i-th of content for empty cell and non-conterminous the currently active region,
It is then an independent effective coverage by the currently active zone marker, i-th of content is not marked for empty cell region
For new the currently active region, step S210 is back to, carries out the extension in new the currently active region.
S250, after scanning through all cells of the target spreadsheet, freeze to instruct according to described, it is only what is marked
In vertical effective coverage, the minimum row of line number is defined as waiting to freeze to go, or the minimum row of column number are defined as waiting to freeze to arrange;
After above step circulation is carried out, all cells of target spreadsheet are scanned through, arrange marked independence
Effective coverage, the minimum row of line number is defined as waiting to freeze to go, or the minimum row of column number are defined as waiting to freeze to arrange.
Below by taking the electrical form shown in Fig. 2 as an example, this method is described in detail.
Laterally single-frame scanned since the first row first row cell A1, the content scanned to the cell of the first row is
It is empty;
Then the content for scanning the first row secondary series cell B1, B1 is sky, is scanned to the second row secondary series cell B2,
The content for determining B2 is not sky, and cell B2 regions are labeled as into the currently active region;
Continue to scan on, scan the content to the column unit lattice C2 of the second row the 3rd not to be empty, cell C2 is in the currently active
The right in region, then the currently active region is extended into the right a row, line number is constant, that is, the currently active region is by cell
B2, C2 are formed;
Equally, it is not empty cell D2, E2, F2, G2, H2, the extended method of effective coverage to scan to the second row content
It is similar, that is, the peripheral cell lattice in the currently active region are B2 and H2;
The third line first row cell A3 is scanned, content is sky, and scanning arrives the third line secondary series cell B3, determines B3
Content for sky, cell B3 be located at by peripheral cell lattice B2 and the H2 the currently active region formed lower section, will currently have
Effect region extends downwards a line, and columns is constant, and the peripheral cell lattice of the effective coverage after extension are cell B2, H2, B3 and H3;
The first six row is scanned through after the same method, the peripheral cell lattice of the effective coverage after extension are cell B2, H2,
B6、H6;
Scan to the 7th row first row cell A7, the 7th all cell contents of row are sky;
The effective coverage being now made up of peripheral cell lattice B2, H2, B6, H6 is labeled as an independent effective coverage.
It is sky to scan to the 8th row first row cell A8, content, and cell B8 is arrived in scanning, and the content for determining B8 is not
Sky, by cell B8 labeled as new the currently active region, carry out the extension in new the currently active region;
All cells of whole electrical form are scanned through, independent effective coverage has two altogether, and one is by peripheral cell
The rectangular area of lattice B2, H2, B6, H6 composition, one is cell B8;
Independent effective coverage is arranged, it is not the minimum row of behavior second of empty and line number to determine content;
Determine content and be not classified as secondary series for empty and column number minimum.
Determine to wait to freeze to go for second provided in an embodiment of the present invention or wait that the method for freezing row is as shown in Figure 4:
S201, in the target spreadsheet, single-frame scanned since the first row first row cell, when it is determined that one is single
The content of first lattice is not space-time, and the cell is labeled as into effective cell;
Here single-frame scanning laterally can be scanned single-frame, longitudinally can also single-frame be scanned.As long as determine the interior of a cell
Appearance is not space-time, and the cell just is labeled as into effective cell.
S202, after scanning through all cells of the target spreadsheet, freeze to instruct according to described, have what is marked
Imitate in cell, the minimum cell of line number is expert at and is defined as waiting to freeze to go, or the cell institute by column number minimum
It is defined as waiting to freeze to arrange in row;
After scanning through all cells of target spreadsheet, all effective cells can be obtained;
If the instruction of freezing of user is that capable is freezed, the minimum cell of line number is expert at and is defined as waiting to freeze
Knot row;
If the instruction of freezing of user is to freeze row, the minimum cell column of column number is defined as waiting to freeze
Knot row.
Still this method is specifically described by taking the electrical form shown in Fig. 2 as an example.
Single-frame scanned since the first row first row cell A1, final determining unit lattice B2-H2, B3-H3, B4-H4,
B5-H5, B6-H6, B8 content are not sky, and be labeled as effective cell, determine that the minimum cell of line number is B2-H2,
The row of place behavior second;It is B2, B3, B4, B5, B6, B8 to determine the minimum cell of column number, and place is classified as secondary series i.e. B row.
The third determination provided in an embodiment of the present invention is waited to freeze to go or waits to freeze the method for row, is implemented as follows:
If it is that capable is freezed to freeze instruction, in target spreadsheet, progressively scanned since the first row, when first
When scanning certain row has the cell that content is not sky, the row is defined as waiting to freeze to go.
If it is that row are freezed to freeze instruction, in target spreadsheet, scanned by column since first row, when first
When scanning certain row has the cell that content is not sky, the row are defined as waiting to freeze to arrange.
Exemplified by electrical form as shown in Figure 2, if it is that capable is freezed to freeze instruction, swept line by line since the first row
Retouch, it is not empty cell to scan into the second row with content, then is defined as waiting to freeze to go by the row;If freezing instruction is
Row are freezed, scanned by column since first row, it is not empty cell that scanning in secondary series, which has content, then arranges this
It is defined as waiting to freeze to arrange.
Using the technical scheme of the present embodiment, when user is using freezing to go or freezing the shortcut of row, first scanning is electric
Sub-table, determined in the region of physical record information it is to be freezed go or row to be freezed, then carry out corresponding freeze operation,
Compared with prior art, the actual expectation of user is more met, it is user-friendly.
Corresponding to above method embodiment, the embodiment of the present invention also provides a kind of electrical form ranks freezing plant, such as
Shown in Fig. 5, the device can include:
Freeze command reception module 100, what is target spreadsheet sent for receiving user freezes to instruct, described to freeze
Instruction includes:Freeze to instruct or row are freezed to instruct to capable;
Frozen contents determining module 200 is treated, for freezing to instruct according to, in the target spreadsheet, by
Hold and be not defined as waiting to freeze to go for the minimum row of empty and line number, or content is not defined as the minimum row of empty and column number
Wait to freeze to arrange;
Freeze processing module 300, for waiting to freeze to go or row to be freezed freeze to identified.
It is shown in Figure 6, in a kind of embodiment of the present invention, treat that frozen contents determining module 200 can wrap
Include:
Effective coverage marks submodule 210, in the target spreadsheet, being opened from the first row first row cell
Beginning is single-frame scanned, when scanning to first content is not empty cell, by the cell region labeled as the currently active
Region, the effective coverage are a rectangular areas;
Position relationship judging submodule 220, when not being empty cell for scanning to i-th of content, judge described i-th
Individual content is not empty cell and the relative position relation in the currently active region, wherein i=2,3,4 ...;
Effective coverage extends submodule 230, for being not empty cell and the currently active region in i-th of content
When adjacent, the currently active region is extended, the peripheral cell lattice of the effective coverage after extension is included i-th of content not to be empty
Cell;
Loop control submodule 240, for being not empty cell and the currently active region not phase in i-th of content
When adjacent, the effective coverage mark submodule is triggered, is an independent effective coverage by the currently active zone marker, with i-th
Content is not empty cell region as the currently active region newly, carries out the extension in new the currently active region;
Frozen contents determination sub-module 250 is treated, for after all cells of the target spreadsheet are scanned through, according to
It is described to freeze to instruct, in the independent effective coverage marked, the minimum cell of line number is expert at and is defined as waiting to freeze
OK, or by the minimum cell column of column number it is defined as waiting to freeze to arrange.
It is shown in Figure 7, in another embodiment of the present invention, treat that frozen contents determining module 200 can be with
Including:
Effective unit case marking submodule 201, in the target spreadsheet, from the first row first row cell
Start single-frame to scan, when it is determined that the content of a cell is not space-time, the cell is labeled as into effective cell;
Frozen contents determination sub-module 202 is treated, for after all cells of the target spreadsheet are scanned through, according to
It is described to freeze to instruct, in the effective cell marked, the minimum cell of line number is expert at and is defined as waiting to freeze to go,
Or the minimum cell column of line number is defined as waiting to freeze to arrange.
The present invention another embodiment in, if freeze command reception module 100 reception freeze instruct
For:Capable is freezed to instruct, then treats that frozen contents determining module 200 specifically can be used for:
In the target spreadsheet, progressively scanned since the first row, when first scan has content not to certain row
For sky cell when, the row is defined as waiting to freeze to go.
It is if freezing the instruction of freezing that command reception module 100 receives:Row are freezed to instruct, then treat frozen contents
Determining module 200 specifically can be used for:
In the target spreadsheet, scanned by column since first row, when first scan has content not to certain row
For sky cell when, the row are defined as waiting to freeze to arrange.
The electrical form ranks freezing plant that the embodiment of the present invention is provided, used in user and freeze to go or freeze the fast of row
During prompt mode, first scanning electron form, determined in the region of physical record information it is to be freezed go or row to be freezed, then enter
The corresponding freeze operation of row, compared with prior art, more meets the actual expectation of user, user-friendly.
It should be noted that herein, such as first and second or the like relational terms are used merely to a reality
Body or operation make a distinction with another entity or operation, and not necessarily require or imply and deposited between these entities or operation
In any this actual relation or order.Moreover, term " comprising ", "comprising" or its any other variant are intended to
Nonexcludability includes, so that process, method, article or equipment including a series of elements not only will including those
Element, but also the other element including being not expressly set out, or it is this process, method, article or equipment also to include
Intrinsic key element.In the absence of more restrictions, the key element limited by sentence "including a ...", it is not excluded that
Other identical element also be present in process, method, article or equipment including the key element.
Each embodiment in this specification is described by the way of related, identical similar portion between each embodiment
Divide mutually referring to what each embodiment stressed is the difference with other embodiment.It is real especially for device
For applying example, because 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.
Can one of ordinary skill in the art will appreciate that realizing that all or part of step in above method embodiment is
To instruct the hardware of correlation to complete by program, described program can be stored in computer read/write memory medium,
The storage medium designated herein obtained, such as:ROM/RAM, magnetic disc, CD etc..
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 substitution and improvements made within the spirit and principles in the present invention etc., are all contained in protection scope of the present invention
It is interior.
Claims (10)
- A kind of 1. electrical form ranks freezing method, it is characterised in that including:Receive that user sends to target spreadsheet freezes to instruct, described to freeze instruction and include:Instruction or right is freezed to capable Row freeze to instruct;Freeze to instruct according to described, in the target spreadsheet, content is not defined as the minimum row of empty and line number Wait to freeze to go, or content is not defined as waiting to freeze to arrange for the minimum row of empty and column number;Wait to freeze to go or row to be freezed freeze to identified.
- 2. according to the method for claim 1, it is characterised in that freeze to instruct described in the basis, in the target electronic In form, content is not defined as waiting to freeze to go for the minimum row of empty and line number, or by content for empty and column number most Small row are defined as waiting to freeze to arrange, including:In the target spreadsheet, single-frame scanned since the first row first row cell, when scanning arrives first content not For sky cell when, the cell region is labeled as the currently active region, the effective coverage is a rectangular area;Scan to i-th of content for empty cell when, judge i-th of content not for empty cell with it is the currently active The relative position relation in region, wherein i=2,3,4 ...;If i-th of content be not adjacent with the currently active region for empty cell, the currently active region is extended, makes expansion It is not empty cell that the peripheral cell lattice of effective coverage after exhibition, which include i-th of content,;If i-th of content be not non-conterminous for empty cell and the currently active region, by the currently active zone marker For an independent effective coverage, i-th of content is not labeled as new the currently active region for empty cell region, entered The extension in the new the currently active region of row;After scanning through all cells of the target spreadsheet, freeze to instruct according to described, in the independent effective district marked In domain, compare to obtain the row or column for numbering minimum in all independent effective coverages, the minimum row of line number is defined as waiting to freeze Knot row, or the minimum row of column number are defined as waiting to freeze to arrange.
- 3. according to the method for claim 1, it is characterised in that freeze to instruct described in the basis, in the target electronic In form, content is not defined as waiting to freeze to go for the minimum row of empty and line number, or by content for empty and column number most Small row are defined as waiting to freeze to arrange, including:In the target spreadsheet, single-frame scanned since the first row first row cell, when it is determined that in a cell Appearance is not space-time, and the cell is labeled as into effective cell;After scanning through all cells of the target spreadsheet, freeze to instruct according to described, in the effective cell marked In, the minimum cell of line number is expert at and is defined as waiting to freeze to go, or the minimum cell column of column number is determined To wait to freeze to arrange.
- 4. according to the method for claim 1, it is characterised in thatIt is described to freeze instruction and be:Capable is freezed to instruct;Described is not that the minimum row of empty and line number is defined as waiting to freeze to go by content in the target spreadsheet, bag Include:In the target spreadsheet, progressively scanned since the first row, be not sky when first scan to certain row has content Cell when, the row is defined as waiting to freeze to go.
- 5. according to the method for claim 1, it is characterised in thatIt is described to freeze instruction and be:Row are freezed to instruct;Described is not that the minimum row of empty and column number are defined as waiting to freeze to arrange by content in the target spreadsheet, bag Include:In the target spreadsheet, scanned by column since first row, be not sky when first scan to certain row has content Cell when, the row are defined as waiting to freeze to arrange.
- A kind of 6. electrical form ranks freezing plant, it is characterised in that including:Freeze command reception module, what is target spreadsheet sent for receiving user freezes to instruct, described to freeze instruction bag Include:Freeze to instruct or row are freezed to instruct to capable;Frozen contents determining module is treated, for freezing to instruct according to, in the target spreadsheet, is not by content The minimum row of empty and line number is defined as waiting to freeze to go, or content is not defined as waiting to freeze for the minimum row of empty and column number Row;Freeze processing module, for waiting to freeze to go or row to be freezed freeze to identified.
- 7. device according to claim 6, it is characterised in that it is described to treat frozen contents determining module, including:Effective coverage marks submodule, in the target spreadsheet, since the first row first row cell line by line Scanning, when scanning to first content is not empty cell, the cell region is labeled as the currently active region, institute It is a rectangular area to state effective coverage;Position relationship judging submodule, when not being empty cell for scanning to i-th of content, judge i-th of content It is not empty cell and the relative position relation in the currently active region, wherein i=2,3,4 ...;Effective coverage extends submodule, for when i-th of content be not adjacent with the currently active region for empty cell, The currently active region is extended, the peripheral cell lattice of the effective coverage after extension is included the unit that i-th of content is not sky Lattice;Loop control submodule, for when i-th of content be not non-conterminous with the currently active region for empty cell, touching Mark submodule of sending out effective coverage described, is an independent effective coverage by the currently active zone marker, is not with i-th of content Empty cell region carries out the extension in new the currently active region as new the currently active region;Frozen contents determination sub-module is treated, for after all cells of the target spreadsheet are scanned through, according to the jelly Knot instruction, in the independent effective coverage marked, compare to obtain the row or column for numbering minimum in all independent effective coverages, The minimum row of line number is defined as waiting to freeze to go, or the minimum row of column number are defined as waiting to freeze to arrange.
- 8. device according to claim 6, it is characterised in that it is described to treat frozen contents determining module, including:Effective unit case marking submodule, in the target spreadsheet, since the first row first row cell by Lattice scan, when it is determined that the content of a cell is not space-time, the cell is labeled as into effective cell;Frozen contents determination sub-module is treated, for after all cells of the target spreadsheet are scanned through, according to the jelly Knot instruction, in the effective cell marked, the minimum cell of line number is expert at and is defined as waiting to freeze to go, or will row The minimum cell column of numbering is defined as waiting to freeze to arrange.
- 9. device according to claim 6, it is characterised in thatIt is described freeze command reception module reception instruction of freezing be:Capable is freezed to instruct;It is described to treat frozen contents determining module, it is specifically used for:In the target spreadsheet, swept line by line since the first row Retouch, when it is not empty cell that first scan to certain row, which has content, the row is defined as waiting to freeze to go.
- 10. device according to claim 6, it is characterised in thatIt is described to freeze the instruction of freezing that command reception module receives and be:Row are freezed to instruct;It is described to treat frozen contents determining module, it is specifically used for:In the target spreadsheet, swept by column since first row Retouch, when first scan to certain row is not empty cell with content, the row are defined as waiting to freeze to arrange.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410158411.3A CN105022722B (en) | 2014-04-18 | 2014-04-18 | A kind of electrical form ranks freezing method and device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410158411.3A CN105022722B (en) | 2014-04-18 | 2014-04-18 | A kind of electrical form ranks freezing method and device |
Publications (2)
Publication Number | Publication Date |
---|---|
CN105022722A CN105022722A (en) | 2015-11-04 |
CN105022722B true CN105022722B (en) | 2017-12-29 |
Family
ID=54412706
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201410158411.3A Active CN105022722B (en) | 2014-04-18 | 2014-04-18 | A kind of electrical form ranks freezing method and device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN105022722B (en) |
Families Citing this family (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109726380A (en) * | 2018-12-29 | 2019-05-07 | 天津字节跳动科技有限公司 | Table edit method and device |
CN113625917A (en) * | 2021-07-29 | 2021-11-09 | 北京达佳互联信息技术有限公司 | Data display method and device, electronic equipment, storage medium and product |
Family Cites Families (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20090313537A1 (en) * | 2008-06-17 | 2009-12-17 | Microsoft Corporation | Micro browser spreadsheet viewer |
CN101751223B (en) * | 2009-12-22 | 2012-11-07 | 深圳市五巨科技有限公司 | Method and device for displaying dynamic data of webpage form |
CN101894133B (en) * | 2010-06-08 | 2011-12-07 | 用友软件股份有限公司 | Method and device for modifying form data in batches |
CN101876971A (en) * | 2010-06-22 | 2010-11-03 | 北京伟库电子商务科技有限公司 | Report form showing method and device |
-
2014
- 2014-04-18 CN CN201410158411.3A patent/CN105022722B/en active Active
Also Published As
Publication number | Publication date |
---|---|
CN105022722A (en) | 2015-11-04 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN104115218B (en) | For providing and the method interacting of multiple ranks of program, device and equipment | |
US9432322B2 (en) | Electronic sticky note system, information processing terminal, method for processing electronic sticky note, medium storing program, and data structure of electronic sticky note | |
CN103430140B (en) | Method and apparatus of managing items on clipboard of portable terminal | |
US7358960B2 (en) | System and method for displaying two-dimensional data on small screen devices | |
CN105867728B (en) | A kind of man-machine interface display system and method | |
CN102184072B (en) | Method and terminal for opening folder | |
CN105955587A (en) | Hidden application icon display method and device | |
DE202007018413U1 (en) | Touch screen device and graphical user interface for specifying commands by applying heuristics | |
CN103703437A (en) | Application for viewing images | |
CN102609399B (en) | Method and apparatus for providing an electronic book service in a mobile device | |
CN106055197A (en) | Display method and terminal for application icons | |
CN112947923A (en) | Object editing method and device and electronic equipment | |
CN107786432A (en) | Information displaying method, device, computer installation and calculating readable storage medium storing program for executing | |
CN104601603B (en) | A kind of game resource processing method and equipment | |
CN105867746A (en) | Touch operation method and mobile terminal | |
CN113518026A (en) | Message processing method and device and electronic equipment | |
KR20130086621A (en) | System and method for recording and querying original handwriting and electronic device | |
CN106095367A (en) | Multi-screen interaction method and system | |
CN106445900A (en) | Table style processing method and device | |
CN105022722B (en) | A kind of electrical form ranks freezing method and device | |
CN103136301A (en) | File management method and electronic device executing the same | |
WO2020046451A1 (en) | Selectively controlling modification states for user-defined subsets of objects within a digital document | |
CN106371694A (en) | Intelligent image capture method and apparatus used for optional global or local image capture, and terminal device | |
CN107766517A (en) | A kind of acquisition methods of view data, device and mobile terminal | |
CN109656435A (en) | Display control unit and recording medium |
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 |