CN103473001A - Cell adjusting method and device - Google Patents
Cell adjusting method and device Download PDFInfo
- Publication number
- CN103473001A CN103473001A CN2013104415589A CN201310441558A CN103473001A CN 103473001 A CN103473001 A CN 103473001A CN 2013104415589 A CN2013104415589 A CN 2013104415589A CN 201310441558 A CN201310441558 A CN 201310441558A CN 103473001 A CN103473001 A CN 103473001A
- Authority
- CN
- China
- Prior art keywords
- cell
- rule
- adjusted
- adjustable cut
- data content
- 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
Links
Images
Abstract
The embodiment of the invention discloses a cell adjusting method and device. The cell adjusting method comprises the following steps: when dragging operation of an adjustable partition line is detected, determining an adjustable cell which corresponds to the dragged adjustable partition line as a cell to be adjusted; determining a reference position which corresponds to the cell to be adjusted according to the data content of the cell to be adjusted; and when the current position of the adjustable partition line is a preset distance away from the reference position according to detection, automatically controlling the adjustable partition line to be positioned at a position matched with the data contents in the cell to be adjusted. According to the scheme, repeated manual adjustment due to inaccurate visual inspection of a user is avoided, the adjusting complexity of the cell is lowered, and the user experience is improved.
Description
Technical field
The present invention relates to the data edition field, particularly a kind of cell method of adjustment and device.
Background technology
Along with science and technology development at full speed, various electronic equipments constantly enrich and have facilitated popular life.Owing to utilizing the electronic equipment deal with data to there is the advantages such as convenient and swift, saving resource, make electronic equipment become an indispensable part in people's life or work.And be installed on the data processing work that the electrical form software in electronic equipment is the user, bring great convenience, wherein, existing electrical form software comprises: the Excel in the office office software, Kingsoft WPS etc.
Wherein, while utilizing the electrical form software data processing, after input data content in cell content, need the high and/or col width of the row of adjustment unit lattice, so that the size of cell and the data content inputted coupling, there is not larger white space in the data content inputted in complete demonstration and this cell in this cell.
In prior art, when the row of adjustment unit lattice is high and/or during col width, the user need to estimate and weigh the position that adjustable cut-off rule need to reach, and then drags adjustable cut-off rule to determined position, thereby realizes the adjustment of cell.But the mode of this adjustment unit lattice, need ownership goal to weigh the position that adjustable cut-off rule need to reach, and the user estimates measurement may be not accurate enough, make once and adjust and can't mate fully, need to repeatedly adjust, these make adjustment process comparatively loaded down with trivial details undoubtedly; And if cell to be adjusted comprises that, when a plurality of cells of having data content or needs are adjusted many divisible lines, triviality is more obvious, causes the user to experience bad.
Summary of the invention
Based on the problems referred to above, the embodiment of the invention discloses a kind of cell method of adjustment and device, to reduce the triviality of cell adjustment process, thereby improve the user, experience.Technical scheme is as follows:
First aspect, the embodiment of the present invention provides a kind of cell method of adjustment, comprising:
When the trailing operation of adjustable cut-off rule being detected, determine that the corresponding adjustable cell of trailing adjustable cut-off rule is cell to be adjusted;
According to the data content of described cell to be adjusted, determine reference position corresponding to described cell to be adjusted;
When the current position of described adjustable cut-off rule and described reference position being detected when the predeterminable range value, automatically control described adjustable cut-off rule be positioned to described cell to be adjusted in the position that is complementary of data content.
Preferably, according to the data content of described cell to be adjusted, determine reference position corresponding to described cell to be adjusted, comprising:
Determine the extreme position of data content on the trailing direction of described adjustable cut-off rule in described cell to be adjusted;
Using the extreme position in the required extreme position reached of described adjustable cut-off rule as reference position corresponding to described cell to be adjusted.
Preferably, when the trailing operation of adjustable cut-off rule shows that described adjustable cut-off rule is dragged by left/right, described extreme position is the extreme position of data content on Width in described cell to be adjusted.
Preferably, when the trailing operation of adjustable cut-off rule shows that described adjustable cut-off rule is dragged by up/down, described extreme position is the extreme position of data content on short transverse in described cell to be adjusted.
Preferably, described predeterminable range value is set according to the screen pixels of electronic equipment.
Second aspect, the embodiment of the present invention provides a kind of cell adjusting gear, comprising:
Cell determination module to be adjusted, for when the trailing operation of adjustable cut-off rule being detected, determine that the corresponding adjustable cell of trailing adjustable cut-off rule is cell to be adjusted;
The reference position determination module, for the data content according to described cell to be adjusted, determine reference position corresponding to described cell to be adjusted;
Adjustable cut-off rule locating module, for when the current position of described adjustable cut-off rule and described reference position being detected apart during the predeterminable range value, automatically control described adjustable cut-off rule be positioned to described cell to be adjusted in the position that is complementary of data content.
Preferably, described reference position determination module comprises:
The extreme position determining unit, for determining the extreme position of data content on the trailing direction of described adjustable cut-off rule in described cell to be adjusted;
The reference position determining unit, for the extreme position using the required extreme position reached of described adjustable cut-off rule as reference position corresponding to described cell to be adjusted.
Preferably, the extreme position determining unit comprises:
The first extreme position is determined subelement, for when the trailing operation of adjustable cut-off rule shows that described adjustable cut-off rule is dragged by left/right, determines the extreme position of data content on Width in described cell to be adjusted.
Preferably, the extreme position determining unit comprises:
The second extreme position is determined subelement, for when the trailing operation of adjustable cut-off rule shows that described adjustable cut-off rule is dragged by up/down, determines the extreme position of data content on short transverse in described cell to be adjusted.
In the embodiment of the present invention, when the trailing operation of adjustable cut-off rule being detected, determine that the corresponding adjustable cell of trailing adjustable cut-off rule is cell to be adjusted; According to the data content of cell to be adjusted, determine the reference position that cell to be adjusted is corresponding; When Yu Gai reference position, the current position of this adjustable cut-off rule being detected when the predeterminable range value, automatically control this adjustable cut-off rule be positioned to this cell to be adjusted in the position that is complementary of data content.Compared with prior art, in this programme, in adjustment unit lattice process, the user drags adjustable cut-off rule, and electronic equipment is detecting the current position of adjustable cut-off rule with the reference position determined during at a distance of the predeterminable range value, automatically locate adjustable cut-off rule to the position be complementary with data content, with this, avoided the user to estimate weighing and the inaccurate repeatedly manual adjustments of being brought is weighed in range estimation, reduce the triviality of cell adjustment process, thereby improved user's experience.
The accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, below will the accompanying drawing of required use in embodiment or description of the Prior Art be briefly described, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skills, under the prerequisite of not paying creative work, can also obtain according to these accompanying drawings other accompanying drawing.
The first process flow diagram of a kind of cell method of adjustment that Fig. 1 provides for the embodiment of the present invention;
The second process flow diagram of a kind of cell method of adjustment that Fig. 2 provides for the embodiment of the present invention;
The first schematic diagram of a kind of cell method of adjustment that Fig. 3 provides for the embodiment of the present invention;
The third process flow diagram of a kind of cell method of adjustment that Fig. 4 provides for the embodiment of the present invention;
The second schematic diagram of a kind of cell method of adjustment that Fig. 5 provides for the embodiment of the present invention;
The structural representation of a kind of cell adjusting gear that Fig. 6 provides for the embodiment of the present invention.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is clearly and completely described, obviously, described embodiment is only the present invention's part embodiment, rather than whole embodiment.Embodiment based in the present invention, those of ordinary skills, not making under the creative work prerequisite the every other embodiment obtained, belong to the scope of protection of the invention.
In order to reduce the triviality of cell adjustment process, thereby improve the user, to experience, the embodiment of the present invention provides a kind of cell method of adjustment and device.
A kind of cell the method for adjustment below at first embodiment of the present invention provided is introduced.
It should be noted that, a kind of cell method of adjustment that the embodiment of the present invention provides is applicable to electronic equipment, and electrical form software is installed in this electronic equipment.Wherein, in actual applications, this electronic equipment can be: touch-screen type mobile phone, notebook computer, panel computer etc., and this electrical form software can be: the Excel in the office office software, Kingsoft WPS etc.
As shown in Figure 1, a kind of cell method of adjustment can comprise:
S101, when the trailing operation of adjustable cut-off rule being detected, determine that the corresponding adjustable cell of trailing adjustable cut-off rule is cell to be adjusted;
In electrical form software, after the user inputs data content in cell, if the size of the data content of inputting and cell is not mated, the data content inputted can not be in respective cells complete demonstration or can complete demonstration but the cell white space is larger, need col width and/or the row of adjustment unit lattice high, now, the user will drag corresponding adjustable cut-off rule; And electronic equipment can determine that the corresponding adjustable cell of trailing adjustable cut-off rule is cell to be adjusted when the trailing operation of adjustable cut-off rule being detected, and then carry out follow-up processing.
It should be noted that, the corresponding adjustable cell of adjustable cut-off rule is a plurality of, and for example: full line cell or permutation cell, therefore, cell to be adjusted is also a plurality of.
S102, according to the data content of cell to be adjusted, determine the reference position that cell to be adjusted is corresponding;
After determining the corresponding adjustable cell of trailing adjustable cut-off rule and being cell to be adjusted, can determine the reference position that cell to be adjusted is corresponding according to the data content of cell to be adjusted, and then carry out follow-up processing.
Concrete, according to the data content of cell to be adjusted, determining the reference position that cell to be adjusted is corresponding, can comprise:
Determine the extreme position of data content on the trailing direction of this adjustable cut-off rule in cell to be adjusted;
Using the extreme position reference position corresponding as this cell to be adjusted in the required extreme position reached of this adjustable cut-off rule.
It should be noted that, when the trailing operation of adjustable cut-off rule shows that this adjustable cut-off rule is dragged by left/right, this extreme position can be the extreme position of data content on Width in this cell to be adjusted; And, when the trailing operation of adjustable cut-off rule shows that this adjustable cut-off rule is dragged by up/down, this extreme position can be the extreme position of data content on short transverse in this cell to be adjusted.Wherein, it will be appreciated by persons skilled in the art that the end position made progress the party that the extreme position of data content on a direction is data content; Concrete, the extreme position of data content on Width is the end position of data content on Width, the extreme position of data content on short transverse is the end position of data content on short transverse.
And, in a plurality of cells to be adjusted, only have in a cell to be adjusted while having data content, the corresponding extreme position of this data content, be that the interior extreme position of data content on the trailing direction of this adjustable cut-off rule of cell to be adjusted is one, now, the extreme position of determining being defined as to reference position gets final product; And while in a plurality of cells to be adjusted, at least two cells to be adjusted, having data content, each data content is by extreme position of correspondence, be that the interior extreme position of data content on the trailing direction of this adjustable cut-off rule of cell to be adjusted is at least two, now, can be using the extreme position reference position corresponding as this cell to be adjusted in the required extreme position reached of this adjustable cut-off rule.
Further, it should be noted that, the data content of above-mentioned foundation cell to be adjusted determines that the mode of the reference position that cell to be adjusted is corresponding is as just example, should not form the restriction to the embodiment of the present invention, for example: in the situation that guarantee that reference position is the position that adjustable cut-off rule need to be dragged to, the extreme position of the partial content of the data content of cell to be adjusted can be defined as to the reference position that cell to be adjusted is corresponding, this is also rational.
S103, when Yu Gai reference position, the current position of this adjustable cut-off rule being detected when the predeterminable range value, automatically control this adjustable cut-off rule be positioned to this cell to be adjusted in the position that is complementary of data content.
After determining this reference position, in the trailing process of adjustable cut-off rule, when Yu Gai reference position, the current position of this adjustable cut-off rule being detected at a distance of the predeterminable range value, can automatically control this adjustable cut-off rule be positioned to this cell to be adjusted in the position that is complementary of data content, so that data content can completely be presented in cell to be adjusted, or make data content complete be presented in cell to be adjusted and the white space of cell to be adjusted less.Wherein, automatically control this adjustable cut-off rule be positioned to this cell to be adjusted in the process of the position that is complementary of data content can be defined as the automatic absorbing process.
It should be noted that, while for cell to be adjusted, comprising a plurality of unit to be adjusted that has a data content, this adjustable cut-off rule be positioned to this cell to be adjusted in the position that is complementary of data content be: the position of the data content in can each cell to be adjusted of complete demonstration; And, because data content is not identical, may cause after coupling completes, some exists the white space in the cell to be adjusted of data content larger, and this is also rational; And when only comprising a unit to be adjusted that has a data content in unit to be adjusted, this adjustable cut-off rule be positioned to this cell to be adjusted in the position that is complementary of data content be: the data content in can this cell to be adjusted of complete demonstration and have the position of white space in allowed band of this cell to be adjusted of data content.
Be understandable that, this predeterminable range value can be set according to the screen pixels of electronic equipment, such as: this predeterminable range value can, for 5px, 3px etc., be not limited to this certainly; And the corresponding predeterminable range value of different electronic equipments can be different, and, under different application scenarioss, can set different predeterminable range values in same electronic equipment, this is all rational.
In the embodiment of the present invention, when the trailing operation of adjustable cut-off rule being detected, determine that the corresponding adjustable cell of trailing adjustable cut-off rule is cell to be adjusted; According to the data content of cell to be adjusted, determine the reference position that cell to be adjusted is corresponding; When Yu Gai reference position, the current position of this adjustable cut-off rule being detected when the predeterminable range value, automatically control this adjustable cut-off rule be positioned to this cell to be adjusted in the position that is complementary of data content.Compared with prior art, in this programme, in adjustment unit lattice process, the user drags adjustable cut-off rule, and electronic equipment is detecting the current position of adjustable cut-off rule with the reference position determined during at a distance of the predeterminable range value, automatically locate adjustable cut-off rule to the position be complementary with data content, with this, avoided the user to estimate weighing and the inaccurate repeatedly manual adjustments of being brought is weighed in range estimation, reduce the triviality of cell adjustment process, thereby improved user's experience.
Below in conjunction with Fig. 2 and Fig. 3, the col width of adjustment unit lattice of take is example, and a kind of cell method of adjustment that the embodiment of the present invention is provided is introduced.
As shown in Figures 2 and 3, a kind of cell method of adjustment can comprise:
S201, when the trailing operation of adjustable cut-off rule being detected, determine that the corresponding adjustable cell of the trailing first adjustable cut-off rule (A column unit lattice) is cell to be adjusted;
Because the width of cell A1 is shorter, make the data content " when the cut-off rule content is longer " can't complete demonstration in this cell A1, therefore, need the col width of adjustment unit lattice A1, now, the user drags the first adjustable cut-off rule to the right; And electronic equipment can determine that the corresponding adjustable cell of the trailing first adjustable cut-off rule (A column unit lattice) is cell to be adjusted when the trailing operation of adjustable cut-off rule being detected, and then carry out follow-up processing.
S202, determine the extreme position of data content on Width in the cell A1 in cell to be adjusted;
S203, first reference position corresponding as this cell to be adjusted using this extreme position;
Because the cell to be adjusted that has data content in cell to be adjusted is only cell A1, and, the trailing operation of detected adjustable cut-off rule shows that this first adjustable cut-off rule is dragged to the right, therefore, determine the extreme position of data content on Width in the cell A1 in cell to be adjusted, be the end position on Width, and, first reference position corresponding as this cell to be adjusted using this extreme position.
S204, when this current position of the first adjustable cut-off rule and this first reference position being detected when the first distance value, automatically control this first adjustable cut-off rule be positioned to this cell to be adjusted in the position that is complementary of data content.
After determining this first reference position, in the trailing process of the first adjustable cut-off rule, when this current position of the first adjustable cut-off rule and this first reference position being detected at a distance of the first distance value, can automatically control this first adjustable cut-off rule be positioned to this cell to be adjusted in the position that is complementary of data content so that data content can completely be presented in cell A1 and the white space of cell A1 in allowed band.Wherein, automatically control this first adjustable cut-off rule be positioned to this cell to be adjusted in the process of the position that is complementary of data content can be defined as the automatic absorbing process.
It should be noted that, this first distance value can be set according to the screen pixels of electronic equipment, such as: this first distance value can, for 5px, 3px etc., be not specifically limited at this.
Compared with prior art, in this programme, in adjustment unit lattice process, the user drags the first adjustable cut-off rule, and electronic equipment is detecting the first current position of adjustable cut-off rule with the first reference position of determining during at a distance of the first distance value, automatically location the first adjustable cut-off rule is to the position be complementary with data content, with this, having avoided the user to estimate weighs and the inaccurate repeatedly manual adjustments of being brought of range estimation measurement, reduce the triviality of cell adjustment process, thereby improved user's experience.
Below in conjunction with Fig. 4 and Fig. 5, the col width of adjustment unit lattice of still take is example, and a kind of cell method of adjustment that the embodiment of the present invention is provided is introduced.
As shown in Figure 4 and Figure 5, a kind of cell method of adjustment can comprise:
S401, when the trailing operation of adjustable cut-off rule being detected, determine that the corresponding adjustable cell of the trailing second adjustable cut-off rule (A column unit lattice) is cell to be adjusted;
Because the width of cell A1 is longer, the white space existed in this cell A1 after making data content " the cut-off rule content more in short-term " show in cell A1 is larger, therefore, needs the col width of adjustment unit lattice A1, now, the user drags the second adjustable cut-off rule left; And electronic equipment can determine that the corresponding adjustable cell of the trailing second adjustable cut-off rule (A column unit lattice) is cell to be adjusted when the trailing operation of adjustable cut-off rule being detected, and then carry out follow-up processing.
S402, determine the extreme position of data content on Width in the cell A1 in cell to be adjusted;
S403, second reference position corresponding as this cell to be adjusted using this extreme position;
Because the cell that has data content in cell to be adjusted is only cell A1, and, the trailing operation of detected adjustable cut-off rule shows that this second adjustable cut-off rule is dragged left, therefore, determine the extreme position of data content on Width in the cell A1 in cell to be adjusted, be the end position on Width, and, second reference position corresponding as this cell to be adjusted using this extreme position.
S404, when this current position of the second adjustable cut-off rule and this second reference position being detected when the second distance value, automatically control this second adjustable cut-off rule be positioned to this cell to be adjusted in the position that is complementary of data content.
After determining this second reference position, in the trailing process of the second adjustable cut-off rule, when this current position of the second adjustable cut-off rule and this second reference position being detected at a distance of the second distance value, can automatically control this second adjustable cut-off rule be positioned to this cell to be adjusted in the position that is complementary of data content so that the complete demonstration of data content and the existing white space of cell A1 are in allowed band.Wherein, automatically control this second adjustable cut-off rule be positioned to this cell to be adjusted in the process of the position that is complementary of data content can be defined as the automatic absorbing process.
It should be noted that, this second distance value can be set according to the screen pixels of electronic equipment, such as: this second distance value can, for 5px, 3px etc., be not specifically limited at this.
Compared with prior art, in this programme, in adjustment unit lattice process, the user drags the second adjustable cut-off rule, and electronic equipment is detecting the second current position of adjustable cut-off rule with the second reference position of determining during at a distance of the second distance value, automatically location the second adjustable cut-off rule is to the position be complementary with data content, with this, having avoided the user to estimate weighs and the inaccurate repeatedly manual adjustments of being brought of range estimation measurement, reduce the triviality of cell adjustment process, thereby improved user's experience.
Corresponding to said method embodiment, the embodiment of the present invention also provides a kind of cell adjusting gear, as shown in Figure 6, can comprise:
Reference position determination module 620, for the data content according to described cell to be adjusted, determine reference position corresponding to described cell to be adjusted;
Adjustable cut-off rule locating module 630, for when the current position of described adjustable cut-off rule and described reference position being detected apart during the predeterminable range value, automatically control described adjustable cut-off rule be positioned to described cell to be adjusted in the position that is complementary of data content.
In the embodiment of the present invention, when the trailing operation of adjustable cut-off rule being detected, determine that the corresponding adjustable cell of trailing adjustable cut-off rule is cell to be adjusted; According to the data content of cell to be adjusted, determine the reference position that cell to be adjusted is corresponding; When Yu Gai reference position, the current position of this adjustable cut-off rule being detected when the predeterminable range value, automatically control this adjustable cut-off rule be positioned to this cell to be adjusted in the position that is complementary of data content.Compared with prior art, in this programme, in adjustment unit lattice process, the user drags adjustable cut-off rule, and electronic equipment is detecting the current position of adjustable cut-off rule with the reference position determined during at a distance of the predeterminable range value, automatically locate adjustable cut-off rule to the position be complementary with data content, with this, avoided the user to estimate weighing and the inaccurate repeatedly manual adjustments of being brought is weighed in range estimation, reduce the triviality of cell adjustment process, thereby improved user's experience.
Wherein, described reference position determination module 620 can comprise:
The extreme position determining unit, for determining the extreme position of data content on the trailing direction of described adjustable cut-off rule in described cell to be adjusted;
The reference position determining unit, for the extreme position using the required extreme position reached of described adjustable cut-off rule as reference position corresponding to described cell to be adjusted.
Wherein, the extreme position determining unit can comprise:
The first extreme position is determined subelement, for when the trailing operation of adjustable cut-off rule shows that described adjustable cut-off rule is dragged by left/right, determines the extreme position of data content on Width in described cell to be adjusted.
Wherein, the extreme position determining unit can comprise:
The second extreme position is determined subelement, for when the trailing operation of adjustable cut-off rule shows that described adjustable cut-off rule is dragged by up/down, determines the extreme position of data content on short transverse in described cell to be adjusted.
For device embodiment, due to it, substantially similar in appearance to embodiment of the method, so description is fairly simple, relevant part gets final product referring to the part explanation of embodiment of the method.
It should be noted that, in this article, relational terms such as the first and second grades only is used for an entity or operation are separated with another entity or operational zone, and not necessarily requires or imply between these entities or operation the relation of any this reality or sequentially of existing.And, term " comprises ", " comprising " or its any other variant are intended to contain comprising of nonexcludability, thereby make the process, method, article or the equipment that comprise a series of key elements not only comprise those key elements, but also comprise other key elements of clearly not listing, or also be included as the intrinsic key element of this process, method, article or equipment.In the situation that not more restrictions, the key element limited by statement " comprising ... ", and be not precluded within process, method, article or the equipment that comprises described key element and also have other identical element.
One of ordinary skill in the art will appreciate that all or part of step realized in the said method embodiment is to come the hardware that instruction is relevant to complete by program, described program can be stored in computer read/write memory medium, here alleged storage medium, as: ROM/RAM, magnetic disc, CD etc.
The foregoing is only preferred embodiment of the present invention, be not intended to limit protection scope of the present invention.All any modifications of doing within the spirit and principles in the present invention, be equal to replacement, improvement etc., all be included in protection scope of the present invention.
Claims (9)
1. a cell method of adjustment, is characterized in that, comprising:
When the trailing operation of adjustable cut-off rule being detected, determine that the corresponding adjustable cell of trailing adjustable cut-off rule is cell to be adjusted;
According to the data content of described cell to be adjusted, determine reference position corresponding to described cell to be adjusted;
When the current position of described adjustable cut-off rule and described reference position being detected when the predeterminable range value, automatically control described adjustable cut-off rule be positioned to described cell to be adjusted in the position that is complementary of data content.
2. method according to claim 1, is characterized in that, according to the data content of described cell to be adjusted, determines reference position corresponding to described cell to be adjusted, comprising:
Determine the extreme position of data content on the trailing direction of described adjustable cut-off rule in described cell to be adjusted;
Using the extreme position in the required extreme position reached of described adjustable cut-off rule as reference position corresponding to described cell to be adjusted.
3. method according to claim 2, is characterized in that, when the trailing operation of adjustable cut-off rule shows that described adjustable cut-off rule is dragged by left/right, described extreme position is the extreme position of data content on Width in described cell to be adjusted.
4. method according to claim 2, is characterized in that, when the trailing operation of adjustable cut-off rule shows that described adjustable cut-off rule is dragged by up/down, described extreme position is the extreme position of data content on short transverse in described cell to be adjusted.
5. method according to claim 1, is characterized in that, described predeterminable range value is set according to the screen pixels of electronic equipment.
6. a cell adjusting gear, is characterized in that, comprising:
Cell determination module to be adjusted, for when the trailing operation of adjustable cut-off rule being detected, determine that the corresponding adjustable cell of trailing adjustable cut-off rule is cell to be adjusted;
The reference position determination module, for the data content according to described cell to be adjusted, determine reference position corresponding to described cell to be adjusted;
Adjustable cut-off rule locating module, for when the current position of described adjustable cut-off rule and described reference position being detected apart during the predeterminable range value, automatically control described adjustable cut-off rule be positioned to described cell to be adjusted in the position that is complementary of data content.
7. device according to claim 6, is characterized in that, described reference position determination module comprises:
The extreme position determining unit, for determining the extreme position of data content on the trailing direction of described adjustable cut-off rule in described cell to be adjusted;
The reference position determining unit, for the extreme position using the required extreme position reached of described adjustable cut-off rule as reference position corresponding to described cell to be adjusted.
8. device according to claim 7, is characterized in that, the extreme position determining unit comprises:
The first extreme position is determined subelement, for when the trailing operation of adjustable cut-off rule shows that described adjustable cut-off rule is dragged by left/right, determines the extreme position of data content on Width in described cell to be adjusted.
9. device according to claim 7, is characterized in that, the extreme position determining unit comprises:
The second extreme position is determined subelement, for when the trailing operation of adjustable cut-off rule shows that described adjustable cut-off rule is dragged by up/down, determines the extreme position of data content on short transverse in described cell to be adjusted.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310441558.9A CN103473001B (en) | 2013-09-25 | 2013-09-25 | cell adjusting method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310441558.9A CN103473001B (en) | 2013-09-25 | 2013-09-25 | cell adjusting method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103473001A true CN103473001A (en) | 2013-12-25 |
| CN103473001B CN103473001B (en) | 2017-01-11 |
Family
ID=49797880
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310441558.9A Active CN103473001B (en) | 2013-09-25 | 2013-09-25 | cell adjusting method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103473001B (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104123270A (en) * | 2014-07-29 | 2014-10-29 | 广东能龙教育股份有限公司 | Reverse table arrangement method based on content |
| CN105094622A (en) * | 2015-09-08 | 2015-11-25 | 上海上讯信息技术股份有限公司 | Method and equipment for regulating column width of table |
| CN105159570A (en) * | 2014-06-13 | 2015-12-16 | 珠海金山办公软件有限公司 | Determining method and determining device for slidable display area of spreadsheet document |
| CN108241608A (en) * | 2016-12-26 | 2018-07-03 | 北京国双科技有限公司 | The processing method of chart data, apparatus and system |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2001281835A (en) * | 2000-02-12 | 2001-10-10 | Adobe Syst Inc | Layout edition system, method and layout edition program as well as recording medium recording the same |
| US6549878B1 (en) * | 1998-12-31 | 2003-04-15 | Microsoft Corporation | System and method for editing a spreadsheet via an improved editing and cell selection model |
| CN102103578A (en) * | 2009-12-17 | 2011-06-22 | 珠海金山软件有限公司 | Method and system for performing fine adjustment on tables by using computer |
| CN102103577A (en) * | 2009-12-17 | 2011-06-22 | 珠海金山软件有限公司 | Method and system for compiling tables by using computer |
| US20110276868A1 (en) * | 2010-05-05 | 2011-11-10 | Microsoft Corporation | Multi-Threaded Adjustment of Column Widths or Row Heights |
-
2013
- 2013-09-25 CN CN201310441558.9A patent/CN103473001B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6549878B1 (en) * | 1998-12-31 | 2003-04-15 | Microsoft Corporation | System and method for editing a spreadsheet via an improved editing and cell selection model |
| JP2001281835A (en) * | 2000-02-12 | 2001-10-10 | Adobe Syst Inc | Layout edition system, method and layout edition program as well as recording medium recording the same |
| CN102103578A (en) * | 2009-12-17 | 2011-06-22 | 珠海金山软件有限公司 | Method and system for performing fine adjustment on tables by using computer |
| CN102103577A (en) * | 2009-12-17 | 2011-06-22 | 珠海金山软件有限公司 | Method and system for compiling tables by using computer |
| US20110276868A1 (en) * | 2010-05-05 | 2011-11-10 | Microsoft Corporation | Multi-Threaded Adjustment of Column Widths or Row Heights |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105159570A (en) * | 2014-06-13 | 2015-12-16 | 珠海金山办公软件有限公司 | Determining method and determining device for slidable display area of spreadsheet document |
| CN104123270A (en) * | 2014-07-29 | 2014-10-29 | 广东能龙教育股份有限公司 | Reverse table arrangement method based on content |
| CN105094622A (en) * | 2015-09-08 | 2015-11-25 | 上海上讯信息技术股份有限公司 | Method and equipment for regulating column width of table |
| CN105094622B (en) * | 2015-09-08 | 2018-05-22 | 上海上讯信息技术股份有限公司 | Adjust the method and apparatus of form col width |
| CN108241608A (en) * | 2016-12-26 | 2018-07-03 | 北京国双科技有限公司 | The processing method of chart data, apparatus and system |
| CN108241608B (en) * | 2016-12-26 | 2021-06-22 | 北京国双科技有限公司 | Method, device and system for processing chart data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103473001B (en) | 2017-01-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9152618B2 (en) | Cell view mode for outsized cells | |
| US20120192108A1 (en) | Gesture-based menu controls | |
| CN103680471B (en) | A kind of method and electronic equipment showing image | |
| CN103473001A (en) | Cell adjusting method and device | |
| JP2017517055A (en) | Command user interface for displaying and scaling selectable controls and commands | |
| CA2922060C (en) | Swipe toolbar to switch tabs | |
| CN103616982A (en) | Touch screen device and method of creating new folders on touch screen device | |
| CN104615332A (en) | Mobile terminal and application icon arrangement method | |
| KR20110044204A (en) | Presenting dynamic grids | |
| CN107290674A (en) | A kind of calibration method and terminal for showing charge value | |
| TW201523422A (en) | Techniques to present a dynamic formula bar in a spreadsheet | |
| CN103729109A (en) | Interface display method and interface display terminal | |
| CN103593180A (en) | Method and device for adding files in application programs | |
| CN103809886A (en) | Cursor positioning method and mobile terminal | |
| CN103135911B (en) | A kind of information processing method and electric terminal | |
| CN104915131A (en) | Method and apparatus for turning pages of electronic document | |
| CN103902580A (en) | Method and device for dragging multiple elements in webpage | |
| WO2021090323A1 (en) | Gap-aware mitigation of gradient staleness | |
| CN104978731A (en) | Information processing method and electronic equipment | |
| CN105335040A (en) | Date switching method and device, and mobile terminal | |
| CN108197074B (en) | Fast Fourier Transform (FFT) data processing method and device | |
| CN110083851B (en) | Method and device for determining bottom hole pressure of gas well and storage medium | |
| CN105426071A (en) | Electronic Device And Method Of Controlling Display Of Screen Thereof | |
| CN103455246B (en) | Method for managing object in touch page and terminal | |
| CN104216818A (en) | Display control method and device of computer processing progress |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| C56 | Change in the name or address of the patentee | ||
| CP01 | Change in the name or title of a patent holder |
Address after: Jinshan software building No. 8 Jingshan Hill Road, Lane 519015 Lianshan Jida Zhuhai city in Guangdong Province Patentee after: Zhuhai Kingsoft Office Software Co., Ltd. Patentee 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 Patentee before: Zhuhai Kingsoft Office Software Co., Ltd. Patentee before: Beijing Kingsoft WPS Office Co., Ltd. |