Summary of the invention
The invention provides a kind of method and system of utilizing the computer drawing form, it manipulates more convenient, flexibly the row or column of additions and deletions form.
Technical scheme of the present invention is: a kind of method of utilizing the computer drawing form comprises step:
Obtain the instruction of the drafting form of input;
Computing mouse drags the length of the rectangle that forms and the ratio of predetermined col width, with the columns of this ratio as form;
Computing mouse drags the high ratio of wide and predetermined row of the rectangle that forms, with the line number of this ratio as described form;
When mouse drag finishes, draw this form in the precalculated position according to the line number that calculates, columns and predetermined col width and predetermined row height;
If receive the additions and deletions instruction of user by the keyboard shortcut input, corresponding relation according to predefined described keyboard shortcut and additions and deletions line number or columns, judge the corresponding additions and deletions information of this additions and deletions instruction, the row or column that increases or delete described form according to this additions and deletions information.
A kind of system that utilizes the computer drawing form comprises:
Receiver module is used to obtain the instruction of the drafting form of input;
Computing module is used for computing mouse and drags the length of the rectangle that forms and the ratio of predetermined col width, with the columns of this ratio as form; Reach the high ratio of wide and predetermined row that computing mouse drags the rectangle that forms, with the line number of this ratio as described form;
Draw the form module, be used for when mouse drag finishes, draw this form in the precalculated position according to the line number that calculates, columns and predetermined col width and predetermined row height;
Processing module, if be used for receiving the additions and deletions instruction of user by the keyboard shortcut input, corresponding relation according to predefined described keyboard shortcut and additions and deletions line number or columns, judge the corresponding additions and deletions information of this additions and deletions instruction, the row or column that increases or delete described form according to this additions and deletions information.
The method and system of utilizing the computer drawing form of the present invention, it can be with the ratio of the length of rectangle that mouse drag forms and the predetermined col width columns as form, and the high ratio of the wide and predetermined row of rectangle that mouse drag forms is as the line number of described form; Drawing the effect that realizes for the first time promptly is the form of real meaning, rather than cell, does not need to add ranks on this basis, and the user is easy for operation, improves operating efficiency; And can increase or delete row or column by the additions and deletions instruction control flexibly of shortcut input according to the user, swift to operate, the simplicity of increase operation.
Embodiment
The method and system of utilizing the computer drawing form of the present invention, it can be with the ratio of the length of rectangle that mouse drag forms and the predetermined col width columns as form, and the high ratio of the wide and predetermined row of rectangle that mouse drag forms is as the line number of described form; Drawing the effect that realizes for the first time promptly is the form of real meaning, rather than cell, does not need to add ranks on this basis, and the user is easy for operation, improves operating efficiency; And can increase or delete row or column by the additions and deletions instruction control flexibly of shortcut input according to the user, swift to operate, the simplicity of increase operation.
Below in conjunction with accompanying drawing specific embodiments of the invention are done a detailed elaboration.
The method of utilizing the computer drawing form of the present invention as Fig. 1, comprises step:
S101, the instruction of obtaining the drafting form of input; In one embodiment, on the page, can show the icon of drawing form,, will import the instruction of drawing form as user during by this icon of click.
S102, computing mouse drag the length of the rectangle that forms and the ratio of predetermined col width, with the columns of this ratio as form; Draw the instruction of form in input after, the user can drag mouse and form a rectangle, and predetermined col width is the width that will draw every row of form, and it can be provided with as required.
S103, computing mouse drag the wide of the rectangle that forms and ratio that predetermined row is high, with the line number of this ratio as described form; This predetermined row is high to be the height that will draw every row of form, and it can be provided with as required.
S104, when mouse drag finishes, draw this form in the precalculated position according to the line number that calculates, columns and predetermined col width and predetermined row height; After mouse drag finishes, line number that step S102 and S103 are calculated and columns are as the line number that will draw form and columns, predetermined col width and predetermined row is high high as the col width that will draw form and row, this form can be drawn in precalculated position (position that pre-sets, the position of perhaps drawing form) at the page.
If S105 receives the additions and deletions instruction of user by the keyboard shortcut input, corresponding relation according to predefined described keyboard shortcut and additions and deletions line number or columns, judge the corresponding additions and deletions information of this additions and deletions instruction, the row or column that increases or delete described form according to this additions and deletions information.The row or column that the user can the input keyboard shortcut increases or delete the form of drawing out, concrete line number that increases or delete and columns can be provided with the corresponding relation with keyboard shortcut as required, this keyboard shortcut can be the letter or number key on the keyboard, user-friendly like this use improves operating efficiency.
In addition, the user also can come the additions and deletions ranks by mouse drag, and detailed process is as follows: detect the drag area of mouse, instruct the row or column that increases or delete the regional place of mouse drag according to the additions and deletions of input.
This shows that the effect that the present invention draws realization for the first time promptly is the form of real meaning, rather than cell, does not need to add ranks on this basis, the user is easy for operation, improves operating efficiency; And can increase or delete row or column by the additions and deletions instruction control flexibly of shortcut input according to the user, swift to operate, the simplicity of increase operation.
In a preferred embodiment, the user's columns and line number of checking the form of drafting for convenience drags the ratio of the wide and predetermined col width of the rectangle that forms at computing mouse, behind the columns of this ratio as form, also comprises step: the columns that shows this form;
Drag the height and the high ratio of predetermined row of the rectangle that forms at computing mouse, after the line number of this ratio, also comprise step: the line number that shows this form as described form;
After increasing according to this additions and deletions information or deleting the row or column of described form, also comprise step: the line number of this form of update displayed or columns.Can allow the user get information about the line number and the columns of the form of drafting like this.
In a preferred embodiment, after this form is drawn in the precalculated position,, then judge whether that according to the attribute information that sets in advance the frame of the frame of the form that this is new and described cell is overlapping if in the cell of this form of drawing, draw new form.This step is the self-adaptation adjustment process, the user can draw in cell before the new form, corresponding attribute information is set, can judges whether new form support with this drafting greatly to cell according to this attribute information, promptly whether that the frame of the frame of new form and cell is overlapping.Can further make things convenient for the user in cell, to draw new form like this, improve operating efficiency.
In a preferred embodiment, after this form is drawn in the precalculated position,, can drag the drafting straight line with mouse if the starting point that drags drafting on this form sideline, is then judged the slope size of the straight line that drags starting point and terminal point place; If this slope smaller or equal to first predetermined value, is then drawn the horizontal line that passes starting point or terminal point more than or equal to zero; If this slope less than second predetermined value, is then drawn the oblique line that passes starting point and terminal point greater than first predetermined value; If this slope more than or equal to second predetermined value, is then drawn the perpendicular line that passes starting point or terminal point.Wherein first predetermined value is less than second predetermined value, and it can be provided with according to actual needs, and this is provided with further to make things convenient for draws straight line in cell, further made things convenient for the user to draw straight line.
The present invention has also disclosed a kind of system that utilizes the computer drawing form, and as Fig. 2, it comprises:
Receiver module is used to receive the instruction of the drafting form of input; The user can import the instruction of drawing form by this receiver module of click; In one embodiment, this receiver module can be realized by the icon of the drafting form that shows on the page.
Computing module is connected with receiver module, is used for the ratio that computing mouse drags the wide and predetermined col width of the rectangle that forms, with the columns of this ratio as form; Reach height and the high ratio of predetermined row that computing mouse drags the rectangle that forms, with the line number of this ratio as described form; Draw the instruction of form in input after, the user can drag mouse and form a rectangle, and predetermined col width is the width that will draw every row of form, and it can be provided with as required; This predetermined row is high to be the height that will draw every row of form, and it can be provided with as required;
Draw the form module, be connected, be used for when mouse drag finishes, draw this form in the precalculated position according to the line number that calculates, columns and predetermined col width and predetermined row height with computing module; After mouse drag finishes, line number that computing module is calculated and columns are as the line number that will draw form and columns, predetermined col width and predetermined row is high high as the col width that will draw form and row, this form can be drawn in precalculated position (position that pre-sets, the position of perhaps drawing form) at the page;
Processing module, be connected with drafting form module, if be used for receiving the additions and deletions instruction of user by the keyboard shortcut input, corresponding relation according to predefined described keyboard shortcut and additions and deletions line number or columns, judge the corresponding additions and deletions information of this additions and deletions instruction, the row or column that increases or delete described form according to this additions and deletions information.The row or column that the user can the input keyboard shortcut increases or delete the form of drawing out, concrete increase or deletion line number and columns can be provided with the corresponding relation with keyboard shortcut as required, this keyboard shortcut can be the letter or number key on the keyboard, user-friendly like this use improves operating efficiency.
In a preferred embodiment, the user's columns and line number of checking the form of drafting for convenience, as Fig. 3, the present invention utilizes the system of computer drawing form also to comprise display module, be connected with processing module with computing module, be used for dragging the ratio of the wide and predetermined col width of the rectangle that forms, behind the columns of this ratio, show the columns of this form as form at computing mouse;
Drag the height and the high ratio of predetermined row of the rectangle that forms at computing mouse, after the line number of this ratio, show the line number of this form as described form;
After increasing according to this additions and deletions information or deleting the row or column of described form, the line number of this form of update displayed or columns.Can allow the user get information about the line number and the columns of the form of drafting like this.
In a preferred embodiment, as Fig. 3, the present invention utilizes the system of computer drawing form also to comprise the self-adaptation adjusting module, be connected with described drafting form module, be used for after this form is drawn in the precalculated position, if in the cell of this form of drawing, draw new form, then judge whether that according to the attribute information that sets in advance the frame of the frame of the form that this is new and described cell is overlapping.The user draws in cell before the new form, can be provided with corresponding attribute information, can judge whether the new form of this drafting is supportted greatly to cell according to this attribute information.Can further make things convenient for the user in cell, to draw new form like this, improve operating efficiency.
In a preferred embodiment, as Fig. 3, the present invention utilizes the system of computer drawing form also to comprise the drafting linear module, be connected with drafting form module, be used for after this form is drawn in the precalculated position, if the starting point that drags drafting on this form sideline, is then judged the slope size of the straight line that drags starting point and terminal point place, can drag the drafting straight line with mouse; If this slope smaller or equal to first predetermined value, is then drawn the horizontal line that passes starting point or terminal point more than or equal to zero; If this slope less than second predetermined value, is then drawn the oblique line that passes starting point and terminal point greater than first predetermined value; If this slope more than or equal to second predetermined value, is then drawn the perpendicular line that passes starting point or terminal point.Wherein first predetermined value is less than second predetermined value, and it can be provided with according to actual needs, and this is provided with further to make things convenient for draws straight line in cell, further made things convenient for the user to draw straight line.
Above-described embodiment of the present invention does not constitute the qualification to protection domain of the present invention.Any modification of being done 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.