CN102103577B - Method and system for compiling tables by using computer - Google Patents
Method and system for compiling tables by using computer Download PDFInfo
- Publication number
- CN102103577B CN102103577B CN 200910213923 CN200910213923A CN102103577B CN 102103577 B CN102103577 B CN 102103577B CN 200910213923 CN200910213923 CN 200910213923 CN 200910213923 A CN200910213923 A CN 200910213923A CN 102103577 B CN102103577 B CN 102103577B
- Authority
- CN
- China
- Prior art keywords
- oblique line
- cell
- end points
- module
- distance
- 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
Images
Landscapes
- Processing Or Creating Images (AREA)
Abstract
The invention provides a method for compiling tables by using a computer. The method comprises the following steps of: receiving an instruction of a user and drawing an oblique line in a table cell; computing the distances between intersection points and the end point of the oblique line, wherein the intersection points are formed between a straight line on which the oblique line is positioned and table cell side lines; and judging whether the distance is less than a first threshold value or not, if the distance is less than the first threshold value, absorbing an intersection point closest to the end point to the end point, and adding the absorbed oblique line into the table cell. A system for compiling the tables by using the computer provided by the invention comprises a drawing module, a computation module and a receiving module. The invention also provides a technical scheme for deleting an added oblique line header and changing the position of the added oblique line header. In the technical scheme, a table cell oblique line is one part of the table cell but not an additional attached object; and the oblique line can be automatically absorbed in the compiling process, so that the misoperation of the user is avoided to the maximum extent and the working efficiency of the user is improved.
Description
Technical field
The invention belongs to the office software field, be specifically related to a kind of method and apparatus that utilizes the Computerized Editing form.
Background technology
In school and some other enterprises and institutions, often need to make monthly form.Form is to carry out report data to distinguish and the common mode of showing.Wherein, the cell that comprises oblique line is very helpful to the form of producing simple and clear.
In the existing office software, the Office software of Microsoft for example only is at the simply additional compound object of the cell at place, as shown in Figure 1 for the interpolation of oblique line gauge outfit.In Fig. 1, can see that except the text box object of mark the straight line object of interpolation only belongs to additional compound object as cell oblique line and cell and concerns.This compound object does not possess the editability in later stage after user add.The user is easy to it is carried out maloperation, causes occurring a strange oblique line cell, as shown in Figure 2.
So this office software is only realized the simple interpolation to the cell internal oblique line, if when the user needs the later stage that the oblique line in the cell is edited adjustment, then can have larger difficulty.
Summary of the invention
The object of the invention is to, a kind of method and apparatus that utilizes the Computerized Editing form is provided, can in cell, add oblique line, can also edit adjustment to the oblique line in the cell in the later stage equally, meet consumers' demand.
The method of utilizing the Computerized Editing form that the present invention proposes comprises: the instruction Oblique line drawing in described cell that receives the user; Calculate the intersection point in this oblique line place straight line and described cell sideline and the distance of this oblique line end points, judge that whether this distance is less than first threshold, if less than described first threshold, then will be adsorbed to described end points with the nearest intersection point of described end-point distances, the oblique line after the absorption will be added into described cell.
The present invention also proposes a kind of system that utilizes the Computerized Editing form simultaneously, comprise drafting module for the Oblique line drawing gauge outfit, be used for the computing module that data calculate and be used for receiving user instruction, and according to the receiver module of the user instruction sending controling instruction that receives to other modules;
Described receiver module receives user's instruction, and according to the user instruction sending controling instruction that receives to drafting module, described drafting module begins Oblique line drawing according to described steering order in described cell; Described computing module calculates the intersection point in this oblique line place straight line and described cell sideline and the distance of this oblique line end points, and result of calculation is sent to described drafting module;
Whether described drafting module judges described distance less than first threshold according to described result of calculation, if then will be adsorbed to described end points with the nearest intersection point of described end-point distances less than described first threshold, the oblique line after then will adsorbing is added into described cell.
The technical scheme that the present invention proposes, the cell oblique line is the part of cell, but not extra attached object, oblique line is the meeting automatic absorbing in drafting or change process, at utmost avoids user misoperation, improves user's office efficiency.
Description of drawings
Fig. 1 is the synoptic diagram that the Office of Microsoft software adds the oblique line gauge outfit;
Fig. 2 is to the result schematic diagram after the oblique line maloperation of adding in the Office of the Microsoft software;
Fig. 3 is the method synoptic diagram that utilizes the Computerized Editing form.
Embodiment
Embodiment 1:
The method of utilizing the Computerized Editing form that the present invention proposes, as shown in Figure 3.
Receive user instruction and in cell, begin Oblique line drawing.Whole drawing process judges that by the Origin And Destination of drawing the line of drawing is horizontal line, perpendicular line or oblique line.
According to the oblique line Origin And Destination of drawing, determine the straight line at this oblique line place.Represent the straight line at this oblique line place with straight line AB, the intersection point that intersect in straight line AB and cell sideline represents with alphabetical S and E respectively, represents certain end points of oblique line with P.
Calculate the distance of point of intersection S or E and end points P, suppose that point of intersection S and end points P are nearest apart, whether judge this distance less than first threshold, if less than first threshold, then will be adsorbed to end points P with the nearest point of intersection S of end points P, the oblique line after adsorbing is added into cell.The process of absorption is for moving to the coordinate of point of intersection S on the coordinate of end points P.The new oblique line that adds is namely as the oblique line gauge outfit in the cell.
Further improvement as above-described embodiment, oblique line after the absorption is added in the process of cell, judge after the absorption oblique line whether with cell in existing oblique line intersect, when existing oblique line is non-intersect in the oblique line after absorption and the cell, the oblique line after adsorbing is added into cell.Judge whether to intersect to increase the process of oblique line gauge outfit in the cell more intelligent, in situation about not intersecting with existing oblique line, the oblique line of the drafting after the absorption is added into the oblique line gauge outfit of this cell; If intersect with existing oblique line, then do not preserve the oblique line of new drafting, and withdraw from the drawing process of oblique line gauge outfit.Like this, guarantee to greatest extent the user to oblique line gauge outfit editor's accuracy, improve user's work efficiency.
As the further improvement of embodiment 1, if in the time of need to deleting the oblique line gauge outfit of having added, can carry out following steps: receive user instruction and choose oblique line, and the oblique line that deletion is chosen when receiving the triggering command of keyboard delete key.
As the further improvement of embodiment 1, if need to when all oblique lines are deleted in the cell, can carry out following steps: receive user instruction and choose whole cell, and when receiving the triggering command of keyboard delete key all oblique lines in the Delete Cells.
The mode that changes the oblique line gauge outfit comprises and moves horizontally oblique line or certain endpoint location of mobile oblique line, as the further improvement of embodiment 1, can carry out following steps:
Receive user instruction and choose oblique line to pull, and calculate respectively the distance that pulls starting point and oblique line end points, oblique line.Because changing the mode of oblique line gauge outfit can be to move horizontally this oblique line, also can be the position of mobile certain end points of oblique line, so determine according to pulling starting point.
Mobile oblique line single endpoint position: if the distance of the starting point of pulling and oblique line end points is less than first threshold, then adjust the distance and pull the nearest oblique line end points of starting point and pull, another does not draw new oblique line in the needs end points that pulls and the position that pulls terminal point according to oblique line, by the plane geometry knowledge of 2 definite straight lines, this new oblique line is the straight line that passes the motionless end points of oblique line and pull terminal point.The end points of new oblique line is adsorbed to oblique line end points nearest in the cell, the new oblique line after the absorption is added into cell.
Move horizontally this oblique line: if the distance of the starting point of pulling and oblique line is less than Second Threshold, then oblique line is pulled, according to the oblique line slope with pull the final position and draw new oblique line, new oblique line is to pass to pull terminal point and the slope straight line identical with choosing the oblique line slope.The end points of new oblique line is adsorbed to oblique line end points nearest in the cell, the new oblique line after the absorption is added into cell.
The mode that changes the oblique line gauge outfit also comprises: receives user instruction and chooses oblique line or oblique line end points, and when receiving the triggering command that keyboard direction is pressed, vertical or move horizontally oblique line or oblique line end points according to triggering command.For example, choose after certain bar oblique line, can also be according to the instruction of keyboard direction, for example the right key is pressed, and then this oblique line is turned right and is moved horizontally.
Process by above deletion or change oblique line gauge outfit further satisfies the user to editor's demand of oblique line gauge outfit.
In instructions of the present invention, first threshold and Second Threshold can preset.Marking different threshold values with " first, second ", only is the convenience for describing, and does not consist of restriction.
Embodiment 2:
Present embodiment also proposes a kind of system that utilizes the Computerized Editing form simultaneously, comprise: carry out the oblique line gauge outfit and draw the drafting module of operation, be used for the computing module that distance is calculated in the cell and be used for receiving user instruction, and send control command to the receiver module of other modules according to described instruction.
Receiver module receives user's instruction, and sends control command to drafting module according to described instruction.Drafting module begins Oblique line drawing according to steering order in cell; Computing module calculates the distance of intersection point and this oblique line end points in this oblique line place straight line and cell sideline, and result of calculation is sent to drafting module.
Drafting module judges that according to result of calculation whether the distance of calculating is less than first threshold, if then intersection point is adsorbed to corresponding end points less than first threshold, represent two intersection points with S and E, P represents certain oblique line end points, in the situation less than first threshold, if S point and P point are nearest among S and the E, then this S point is adsorbed to the P point.Then the oblique line after will adsorbing is added into cell.
As the further improvement of embodiment 2, utilize the system of Computerized Editing form also to comprise: to be used for the removing module of deletion oblique line gauge outfit and to intercept the module of intercepting of KeyEvent.In the time need to carrying out deletion action to the oblique line gauge outfit of having added, can and intercept module and realize by removing module.Receiver module receives user instruction, and according to the user instruction sending controling instruction that receives to removing module; Removing module is chosen oblique line according to steering order; Intercept module and intercept current KeyEvent, when listening to delete key and press, send triggering command that the keyboard delete key is pressed to removing module, the removing module oblique line that deletion is chosen according to triggering command.
If cell is the cell that does not comprise any literal, then can delete all oblique lines in the cell.Detailed process comprises: receiver module receives user instruction, and according to the user instruction sending controling instruction that receives to removing module; Removing module is chosen whole cell according to steering order; Intercept module and intercept current KeyEvent, when listening to delete key and press, send triggering command that the keyboard delete key is pressed to removing module, removing module is according to all oblique lines in the triggering command Delete Cells.
As the further improvement of embodiment 2, utilize the system of Computerized Editing form also to comprise: the mobile module that is used for mobile oblique line or oblique line endpoint location.
At first receiver module receives user instruction, according to the user instruction sending controling instruction that receives to mobile module.Mobile module chooses oblique line to pull according to steering order, and computing module calculates respectively the distance that pulls starting point and oblique line, oblique line end points, and result of calculation is sent to mobile module.
If the distance of the starting point of pulling and oblique line end points is less than first threshold, then mobile module is adjusted the distance and is pulled the nearest oblique line end points of starting point and pull, and will comprise another information that does not need the endpoint location that pulls and pull the final position of oblique line and be sent to drafting module.According to the plane geometry knowledge of 2 definite straight lines, drafting module is drawn new oblique line according to the information that receives, and new oblique line is to pass to pull terminal point and oblique line another does not need the straight line of mobile end points.Drafting module is adsorbed to oblique line end points nearest in the cell with the end points of new oblique line again, and the new oblique line after will adsorbing is added into cell.
If the distance of the starting point of pulling and oblique line is less than Second Threshold, then mobile module pulls oblique line, and the information that will comprise the oblique line slope and pull the final position is sent to drafting module, drafting module is drawn new oblique line according to the information that receives, by plane geometry knowledge as can be known this new oblique line be to pass to pull terminal point and the slope straight line identical with choosing the oblique line slope.Drafting module is adsorbed to oblique line end points nearest in the cell with the end points of new oblique line again, and the new oblique line after will adsorbing is added into cell.
Further improvement as above-described embodiment, in the process of Oblique line drawing gauge outfit, computing module can also judge after the absorption oblique line whether with cell in existing oblique line intersect, when existing oblique line is non-intersect in the oblique line after absorption and the cell, judged result is sent to drafting module.Drafting module is added into cell according to the judged result that receives with the oblique line after the absorption.By this crossing judge module, guarantee to greatest extent the user to oblique line gauge outfit editor's accuracy, improve user's work efficiency.
Above-described embodiment of the present invention does not consist of the restriction to protection domain of the present invention.Any modification of doing within the spirit and principles in the present invention, be equal to and replace and improvement etc., all should be included within the claim protection domain of the present invention.
Claims (9)
1. a method of utilizing the Computerized Editing form is characterized in that, comprising: the instruction Oblique line drawing in cell that receives the user; Obtain two intersection points in this oblique line place straight line and described cell sideline, calculate described two intersection points to the distance of the arbitrary end points of this oblique line, select wherein short this distance of Distance Judgment whether less than first threshold, if less than described first threshold, then will be adsorbed to described end points with the nearest intersection point of described end-point distances, the oblique line after the absorption will be added into described cell.
2. the described method of utilizing the Computerized Editing form according to claim 1 is characterized in that, also comprises step after adding the oblique line gauge outfit: receive user instruction and choose oblique line, and the oblique line that deletion is chosen when receiving the triggering command that the keyboard delete key is pressed.
3. the described method of utilizing the Computerized Editing form according to claim 1, it is characterized in that, after adding the oblique line gauge outfit, also comprise step: receive user instruction and choose described cell, and when receiving the triggering command that the keyboard delete key is pressed all oblique lines in the Delete Cells; Wherein, described cell is not for comprising the cell of any literal.
4. the described method of utilizing the Computerized Editing form according to claim 1 is characterized in that, also comprises following steps after adding the oblique line gauge outfit:
Receive user instruction and choose oblique line to pull, and calculate respectively pull initial and press a little distance with the oblique line end points, and the described initial distance of pressing a little with oblique line;
If describedly initially press a little distance with the oblique line end points less than described first threshold, then adjust the distance and describedly initially press a little nearest oblique line end points and pull, according to pull lift the final position and another endpoint location that need not pull of described oblique line is drawn new oblique line; And the described end points of described new oblique line is adsorbed to nearest oblique line end points in the cell, the new oblique line after will adsorbing again is added into cell;
If describedly initially press a little distance with oblique line less than Second Threshold, then described oblique line is pulled, draw new oblique line according to described oblique line slope and the described final position of lifting; And two end points of described new oblique line are adsorbed to nearest oblique line end points in the cell, the new oblique line after will adsorbing again is added into cell.
5. the described method of utilizing the Computerized Editing form according to claim 1 is characterized in that, also comprises following steps after adding the oblique line gauge outfit:
Receive user instruction and choose oblique line or oblique line end points, when receiving the triggering command that keyboard direction is pressed, vertical or move horizontally described oblique line or described oblique line end points according to described triggering command.
6. the method for utilizing the Computerized Editing form according to claim 1, it is characterized in that, oblique line after the absorption is added described cell specifically to be comprised as the process of oblique line gauge outfit: judge after the absorption oblique line whether with cell in existing oblique line intersect, if non-intersect oblique line after then will adsorbing is added into described cell.
7. a system that utilizes the Computerized Editing form is characterized in that, comprising:
Drafting module is used for the drafting of oblique line gauge outfit;
Computing module is used for data and calculates;
Receiver module be used for to receive user instruction, and according to the user instruction sending controling instruction that receives to other modules;
Described receiver module receives user's instruction, and according to the user instruction sending controling instruction that receives to drafting module, described drafting module begins Oblique line drawing according to described steering order in cell; Described computing module obtains two intersection points in this oblique line place straight line and described cell sideline, calculates described two intersection points to the distance of the arbitrary end points of this oblique line, and result of calculation is sent to described drafting module;
Described drafting module is according to described result of calculation, select the wherein short described distance of Distance Judgment whether less than first threshold, if then will be adsorbed to described end points with the nearest intersection point of described end-point distances less than described first threshold, the oblique line after then will adsorbing is added into described cell.
8. the described system that utilizes the Computerized Editing form according to claim 7 is characterized in that the described system of Computerized Editing form that utilizes also comprises: be used for the removing module of deletion oblique line gauge outfit and intercept the module of intercepting of KeyEvent.
9. the described system that utilizes the Computerized Editing form according to claim 7 is characterized in that the described system of Computerized Editing form that utilizes also comprises: the mobile module that is used for mobile oblique line or oblique line endpoint location;
Described receiver module receives user instruction, and according to described user instruction sending controling instruction to described mobile module, described mobile module chooses oblique line to pull according to described steering order;
Described computing module calculates respectively pull initial and presses a little distance with the oblique line end points, and the described initial distance of pressing a little with oblique line, and result of calculation is sent to described mobile module;
If describedly initially press a little distance with the oblique line end points less than described first threshold, then adjust the distance and describedly initially press a little nearest oblique line end points and pull, according to pull lift the final position and another endpoint location that need not pull of described oblique line is drawn new oblique line; And the described end points of described new oblique line is adsorbed to nearest oblique line end points in the cell, the new oblique line after will adsorbing again is added into cell;
If describedly initially press a little distance with oblique line less than Second Threshold, then described oblique line is pulled, draw new oblique line according to described oblique line slope and the described final position of lifting; And two end points of described new oblique line are adsorbed to nearest oblique line end points in the cell, the new oblique line after will adsorbing again is added into cell.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200910213923 CN102103577B (en) | 2009-12-17 | 2009-12-17 | Method and system for compiling tables by using computer |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200910213923 CN102103577B (en) | 2009-12-17 | 2009-12-17 | Method and system for compiling tables by using computer |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102103577A CN102103577A (en) | 2011-06-22 |
| CN102103577B true CN102103577B (en) | 2013-04-17 |
Family
ID=44156355
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 200910213923 Active CN102103577B (en) | 2009-12-17 | 2009-12-17 | Method and system for compiling tables by using computer |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102103577B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103473001B (en) * | 2013-09-25 | 2017-01-11 | 珠海金山办公软件有限公司 | cell adjusting method and device |
| US10191895B2 (en) * | 2014-11-03 | 2019-01-29 | Adobe Systems Incorporated | Adaptive modification of content presented in electronic forms |
| CN115496050B (en) * | 2022-11-17 | 2023-05-19 | 宇动源(北京)信息技术有限公司 | Method and device for drawing configuration of head-of-table oblique line, electronic equipment and storage medium |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101436178A (en) * | 2008-12-03 | 2009-05-20 | 北大方正集团有限公司 | Method and system for typesetting oblique line unit lattice |
-
2009
- 2009-12-17 CN CN 200910213923 patent/CN102103577B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101436178A (en) * | 2008-12-03 | 2009-05-20 | 北大方正集团有限公司 | Method and system for typesetting oblique line unit lattice |
Non-Patent Citations (2)
| Title |
|---|
| 水晶宝贝.文档斜线表头轻松绘制.《电脑爱好者》.2006,(第3期),第62页. * |
| 王道才.给表格加斜线表头.《Computer Fan》.2007,第19页. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102103577A (en) | 2011-06-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102799358B (en) | The determination method and device of display position of cursor | |
| CN102073706B (en) | Combined application method of distributed file storage system and relation database | |
| CN102103577B (en) | Method and system for compiling tables by using computer | |
| CN104741718B (en) | Quick wire cutting control system | |
| CN103309988A (en) | Method for automatically generating rail traffic line database | |
| CN101498923B (en) | System and method for automatically generating electrode processing program | |
| CN105479747A (en) | 3d printing method | |
| CN103853867A (en) | Hydropower engineering full information MBD (model based definition) and mold building method thereof | |
| CN105279275A (en) | Point list configuration method of dispatch master station end | |
| CN104298419A (en) | Mobile terminal and method for arranging icons of mobile terminal | |
| CN104239589A (en) | Method for implementing intelligent analysis system of distribution network business expansions | |
| CN105718495A (en) | Exporting method and system of database hierarchical HTML (Hypertext Markup Language) statement | |
| CN204229415U (en) | A kind of numerically-controlled machine Product processing automatic information recorder based on Quick Response Code | |
| Cai et al. | Adaptive traffic signal control using wireless communications | |
| CN104343457A (en) | Control system of full face rock tunnel boring machine | |
| CN103259932B (en) | Editing method and system of touch screen mobile terminal multimedia messages | |
| CN102528250A (en) | Automatic changing three-dimensional groove cutting system | |
| CN103135891A (en) | Method and device for processing user interface | |
| CN201633080U (en) | Electronic saw with saw blade lifting control mechanisms | |
| CN103488844A (en) | Power grid net rack graph automatic wiring method based on power station geographic information | |
| CN101394300A (en) | Automatically chart forming method for communication system chart | |
| CN101764708A (en) | Method and device for scene-based rapid data configuration in telecom network management system | |
| CN110851934B (en) | Substation SSD file generation method | |
| CN111583302B (en) | Coal cutting roof plate line extraction method based on three-dimensional laser point cloud | |
| CN202656233U (en) | Stock cutter with dust collection function |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| C41 | Transfer of patent application or patent right or utility model | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20151217 Address after: Kingsoft No. 33 building, 100085 Beijing city Haidian District Xiaoying Road Patentee after: Beijing Kingsoft WPS Office Co., Ltd. Patentee after: GUANGZHOU JINSHAN JINSHAN MOBILE TECHNOLOGY CO., LTD. Address before: Jinshan computer Building No. 8 Jingshan Hill Road, Lane 519015 Lianshan Jida Zhuhai city in Guangdong Province Patentee before: Zhuhai Kingsoft Software Co., Ltd. |
|
| C56 | Change in the name or address of the patentee | ||
| CP01 | Change in the name or title of a patent holder |
Address after: Kingsoft No. 33 building, 100085 Beijing city Haidian District Xiaoying Road Patentee after: Beijing Kingsoft office software Limited by Share Ltd Patentee after: GUANGZHOU JINSHAN JINSHAN MOBILE TECHNOLOGY CO., LTD. Address before: Kingsoft No. 33 building, 100085 Beijing city Haidian District Xiaoying Road Patentee before: Beijing Kingsoft WPS Office Co., Ltd. Patentee before: GUANGZHOU JINSHAN JINSHAN MOBILE TECHNOLOGY CO., LTD. |