CN102103581A - Method and system for adding columns and rows to form by computer - Google Patents
Method and system for adding columns and rows to form by computer Download PDFInfo
- Publication number
- CN102103581A CN102103581A CN 200910213927 CN200910213927A CN102103581A CN 102103581 A CN102103581 A CN 102103581A CN 200910213927 CN200910213927 CN 200910213927 CN 200910213927 A CN200910213927 A CN 200910213927A CN 102103581 A CN102103581 A CN 102103581A
- Authority
- CN
- China
- Prior art keywords
- row
- ranks
- columns
- instruction
- ratio
- 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
Landscapes
- User Interface Of Digital Computer (AREA)
Abstract
The invention discloses a method and a system for adding columns and rows to a form by a computer, wherein the method comprises the following steps: receiving a column and row adding instruction inputted by a user; computing the ratio of a horizontal mouse-drag distance and a scheduled column width, and taking the ratio as the number of added column; computing the ratio of a vertical mouse-drag distance and a scheduled row height, and taking the ratio as the number of added row; and after the dragging of mouse is completed, adding columns and rows to corresponding areas of a form according to the computed numbers of columns and rows. The method and system disclosed by the invention have the advantages that because the numbers of added columns and rows can be determined according to the horizontal mouse-drag distance and the vertical mouse-drag distance, the number determination is simple and convenient, and because the columns and rows can be added just by inputting a column and row adding instruction and then dragging the mouse by the user, the operation process is simple and high in efficiency; and because a plurality of rows and columns can be added at a time without repeatedly entering the menu function, the user experience is good.
Description
Technical field
The present invention relates to the office software field, relate in particular to a kind of method and system of utilizing computing machine in form, to append ranks.
Background technology
In the literal table operation, appending ranks is common form adjustment operations, and the user is after the insertion form is finished, because the actual demand that content is write often needs to append ranks for form temporarily.
In the prior art, the method that Microsoft increases the form ranks may further comprise the steps:
1, cursor is placed form delegation or a certain row or choose full line or permutation;
2, click menu;
3, select to insert the position of row or column.
This method once can only increase delegation or row, and need select by menu, the complete operation complex steps, and operating efficiency is lower; Increase multirow or multiple row if desired, then need to select the multirow or the multiple row of form, enter menu function again, user experience is poor.
Summary of the invention
The invention provides a kind of method and system of utilizing computing machine in form, to append ranks, its efficient height simple to operate, user experience is good.
Technical scheme of the present invention is:
A kind of method of utilizing computing machine to append ranks in form comprises step:
Receive the instruction of appending ranks of user's input;
The horizontal range that computing mouse drags and the ratio of predetermined col width, with this ratio as the columns that appends; The ratio that vertical range that computing mouse drags and predetermined row are high, with this ratio as the line number of appending;
After mouse drag finishes, increase row or column at the respective regions of form according to the described line number that calculates, columns.
A kind of system that utilizes computing machine to append ranks in form comprises:
Receiver module is used to receive the instruction of appending ranks of user's input;
Computing module is used for after receiver module receives described instruction, the horizontal range that computing mouse drags and the ratio of predetermined col width, with this ratio as the columns that appends; The ratio that vertical range that computing mouse drags and predetermined row are high, with this ratio as the line number of appending;
Drafting module is used for after mouse drag finishes, and the line number, the columns that calculate according to described computing module increase row or column at the respective regions of form.
The method and system of utilizing computing machine in form, to append ranks of the present invention, it can determine the line number and the columns that append according to the horizontal range of mouse drag and vertical range, simple and convenient, the user drags mouse and can append ranks after only need importing the instruction of appending ranks, and operation steps is simple, efficient is high; And once can increase multirow or multiple row, not need repeatedly to enter repeatedly menu function, user experience is relatively good.
Description of drawings
Fig. 1 is that the present invention utilizes computing machine to increase the method process flow diagram in one embodiment of ranks in form;
Fig. 2 is that the present invention utilizes computing machine to increase system's structured flowchart in one embodiment of ranks in form;
Fig. 3 is that the present invention utilizes computing machine to increase system's structured flowchart in another embodiment of ranks in form.
Embodiment
The method and system of utilizing computing machine in form, to append ranks of the present invention, it can determine the line number and the columns that append according to the horizontal range of mouse drag and vertical range, simple and convenient, the user drags mouse and can append ranks after only need importing the instruction of appending ranks, and operation steps is simple, efficient is high; And once can increase multirow or multiple row, not need repeatedly to enter repeatedly menu function, user experience is relatively good.
Below in conjunction with accompanying drawing specific embodiments of the invention are done a detailed elaboration.
The method that the present invention utilizes computing machine to append ranks in form, as Fig. 1, it comprises step:
The instruction of appending ranks of S101, reception user input; When the user operates, can show the icon that appends row or column in the precalculated position of the drafting form of the page, when the user wants to use the function of appending ranks, can import the instruction of appending row or column by clicking this icon.
The horizontal range that S102, computing mouse drag and the ratio of predetermined col width, with this ratio as the columns that appends; The ratio that vertical range that computing mouse drags and predetermined row are high, with this ratio as the line number of appending; Predetermined col width and predetermined row height can be provided with according to user's actual needs.
S103, after mouse drag finishes, increase row or column according to the described line number that calculates, columns at the respective regions of form.The capable height that increases row can be high with the row of former form consistent, and the col width that increases row can be consistent with the col width of former form.
In a preferred embodiment, also can before this step S101, also comprise step: detect mouse and whether enter the presumptive area of the page,, show that then being used to receive user's input appends the unsteady label of row or column instruction if enter; This moment, step S101 was specially: receive the instruction of appending ranks of user's input by described unsteady label.Can save the space of the page like this, just show unsteady label when the user need append the function of row or column, can click use for the user easily, operating process is simplified greatly, reach to settle at one go, and the process that the form ranks append is very directly perceived.
In a preferred embodiment, before finishing, mouse drag also comprises step: show the line number and the columns that append.Can allow the user get information about current increase line number and columns like this, the distance that the user can adjust mouse drag at any time according to the line number that shows and columns is more convenient quick.
In a preferred embodiment, after the respective regions increase of form is listed as, also comprise step: whether detection increases the width of the form behind the row greater than pagewidth, if greater than, then press the form after the increase of predetermined ratio convergent-divergent is listed as.This step can be set according to user's actual needs, and the form that can prevent from like this to increase behind the row exceeds pagewidth, and form can be presented in the page by convergent-divergent.Described predetermined ratio can be calculated as follows when concrete calculating:
In addition, in a preferred embodiment, after according to the described line number that calculates, the respective regions increase row or column of columns, can also comprise step at form:
If receive the additions and deletions instruction of user by click or keyboard shortcut input, corresponding relation according to predefined described click or 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.Can make things convenient for user's row or column of additions and deletions form efficiently like this, improve operating efficiency, step simplifies the operation.
During concrete enforcement, the user can import the additions and deletions instruction by the unsteady label of click, the additions and deletions instruction that can set the click input is for increasing delegation or row, and the user can increase delegation or row by click like this, and is further convenient for users.
The present invention has also disclosed a kind of system that utilizes computing machine to append ranks in form, and as Fig. 2, it comprises:
Receiver module is used to receive the instruction of appending ranks of user's input; When the user operated, this receiver module can show in the precalculated position of the drafting form of the page, when the user wants to use the function of appending ranks, can import the instruction of appending row or column by clicking this receiver module.
Computing module is connected with receiver module, be used for after receiver module receives described instruction, the horizontal range that computing mouse drags and the ratio of predetermined col width, with this ratio as the columns that appends; The ratio that vertical range that computing mouse drags and predetermined row are high, with this ratio as the line number of appending; Predetermined col width and predetermined row height can be provided with according to user's actual needs.
Drafting module is used for after mouse drag finishes, and the line number, the columns that calculate according to described computing module increase row or column at the respective regions of form.The capable height that increases row can be high with the row of former form consistent, and the col width that increases row can be consistent with the col width of former form, and the row col widths high and row that increase row certainly also can be pre-set.
In a preferred embodiment, as Fig. 3, the present invention utilizes computing machine to append the system of ranks in form, can also comprise processing module, be connected with described receiver module, be used for before the instruction of appending row or column that receives input, detecting the presumptive area whether mouse enters the page, if enter, show that then described receiver module appends the instruction of row or column for user's input.
In a preferred embodiment, as Fig. 3, the system that the present invention utilizes computing machine to append ranks in form also comprises display module, is connected with computing module, is used for showing before mouse drag finishes line number and the columns that appends.Can allow the user get information about current increase line number and columns like this, the distance that the user can adjust mouse drag at any time according to the line number that shows and columns is more convenient quick.
In a preferred embodiment, as Fig. 3, the present invention utilizes computing machine to append the system of ranks in form, also comprise Zoom module, be connected with described drafting module, be used for after the respective regions of form increases row, whether the width that detects the form after increase is listed as is greater than pagewidth, if greater than, then by the form behind the predetermined ratio convergent-divergent increase row.
The form that can prevent from like this to increase behind the row exceeds pagewidth, and form can be presented in the page by convergent-divergent.Described predetermined ratio can be calculated as follows when concrete calculating:
In addition, in a preferred embodiment, described receiver module also is used to receive the additions and deletions instruction of user by click or keyboard shortcut input, corresponding relation according to predefined described click or 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.Can make things convenient for user's row or column of additions and deletions form efficiently like this, improve operating efficiency, step simplifies the operation.
During concrete enforcement, the user can import the additions and deletions instruction by the click receiver module, the additions and deletions instruction that can set the click input is for increasing delegation or row, and the user can increase delegation or row by click like this, and is further convenient for users.
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.
Claims (10)
1. a method of utilizing computing machine to append ranks in form is characterized in that, comprises step:
Receive the instruction of appending ranks of user's input;
The horizontal range that computing mouse drags and the ratio of predetermined col width, with this ratio as the columns that appends; The ratio that vertical range that computing mouse drags and predetermined row are high, with this ratio as the line number of appending;
After mouse drag finishes, increase row or column at the respective regions of form according to the described line number that calculates, columns.
2. the method for utilizing computing machine to append ranks in form according to claim 1 is characterized in that: before the instruction of appending row or column that receives input, also comprise step:
Detect mouse and whether enter the presumptive area of the page,, show that then being used to receive user's input appends the unsteady label of ranks instruction if enter;
Step receives the instruction of appending ranks of user's input, is specially: receive the instruction of appending ranks of user's input by described unsteady label.
3. the method for utilizing computing machine to append ranks in form according to claim 1 and 2 is characterized in that: before mouse drag finishes, also comprise step: show the line number and the columns that append.
4. the method for utilizing computing machine in form, to append ranks according to claim 1 and 2, it is characterized in that: after the respective regions of form increases row, also comprise step: whether the width that detects the form after increase is listed as is greater than pagewidth, if greater than, then by the form behind the predetermined ratio convergent-divergent increase row.
5. the method for utilizing computing machine to append ranks in form according to claim 1 is characterized in that: after according to the described line number that calculates, the respective regions increase row or column of columns at form, also comprise step:
If receive the additions and deletions instruction of user by click or keyboard shortcut input, corresponding relation according to predefined described click or 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.
6. a system that utilizes computing machine to append ranks in form is characterized in that, comprising:
Receiver module is used to receive the instruction of appending ranks of user's input;
Computing module is used for after receiver module receives described instruction, the horizontal range that computing mouse drags and the ratio of predetermined col width, with this ratio as the columns that appends; The ratio that vertical range that computing mouse drags and predetermined row are high, with this ratio as the line number of appending;
Drafting module is used for after mouse drag finishes, and the line number, the columns that calculate according to described computing module increase row or column at the respective regions of form.
7. the system that utilizes computing machine in form, to append ranks according to claim 6, it is characterized in that: also comprise processing module, be used for before the instruction of appending row or column that receives input, detect the presumptive area whether mouse enters the page, if enter, then show the instruction that described receiver module appends ranks for user's input.
8. according to claim 6 or the 7 described systems that utilize computing machine in form, to append ranks, it is characterized in that: also comprise display module, be used for before mouse drag finishes, showing line number and the columns that appends.
9. according to claim 6 or the 7 described systems that utilize computing machine in form, to append ranks, it is characterized in that: also comprise Zoom module, be used for after the respective regions of form increases row, whether the width that detects the form after increase is listed as is greater than pagewidth, if greater than, then by the form behind the predetermined ratio convergent-divergent increase row.
10. the system that utilizes computing machine in form, to append ranks according to claim 6, it is characterized in that: described receiver module also is used to receive the additions and deletions instruction of user by click or keyboard shortcut input, corresponding relation according to predefined described click or keyboard shortcut and additions and deletions line number or columns, judge the corresponding additions and deletions information of this additions and deletions instruction, increase or delete the row or column of the form after the described increase row or column according to this additions and deletions information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200910213927 CN102103581B (en) | 2009-12-17 | 2009-12-17 | Method and system for adding columns and rows to form by computer |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200910213927 CN102103581B (en) | 2009-12-17 | 2009-12-17 | Method and system for adding columns and rows to form by computer |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102103581A true CN102103581A (en) | 2011-06-22 |
| CN102103581B CN102103581B (en) | 2013-07-24 |
Family
ID=44156359
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 200910213927 Active CN102103581B (en) | 2009-12-17 | 2009-12-17 | Method and system for adding columns and rows to form by computer |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102103581B (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105183325A (en) * | 2015-10-27 | 2015-12-23 | 上海斐讯数据通信技术有限公司 | User-defined input method and system |
| CN106681972A (en) * | 2015-11-11 | 2017-05-17 | 北京国双科技有限公司 | Method and device for displaying table |
| CN109508450A (en) * | 2018-09-20 | 2019-03-22 | 天津字节跳动科技有限公司 | The operating method of table, device, storage medium and electronic equipment in online document |
| CN109858000A (en) * | 2019-01-10 | 2019-06-07 | 广州视源电子科技股份有限公司 | Form processing method, device and system, storage medium and interactive intelligent panel |
| CN111984170A (en) * | 2020-07-14 | 2020-11-24 | 维沃移动通信有限公司 | Table output method and device and electronic equipment |
| CN116341506A (en) * | 2023-05-25 | 2023-06-27 | 广东杰纳医药科技有限公司 | Method for iteratively calculating column width of table |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1936882A (en) * | 2006-10-13 | 2007-03-28 | 北京北大方正电子有限公司 | Paging form data-processing method and system |
-
2009
- 2009-12-17 CN CN 200910213927 patent/CN102103581B/en active Active
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105183325A (en) * | 2015-10-27 | 2015-12-23 | 上海斐讯数据通信技术有限公司 | User-defined input method and system |
| CN106681972A (en) * | 2015-11-11 | 2017-05-17 | 北京国双科技有限公司 | Method and device for displaying table |
| CN109508450A (en) * | 2018-09-20 | 2019-03-22 | 天津字节跳动科技有限公司 | The operating method of table, device, storage medium and electronic equipment in online document |
| CN109858000A (en) * | 2019-01-10 | 2019-06-07 | 广州视源电子科技股份有限公司 | Form processing method, device and system, storage medium and interactive intelligent panel |
| WO2020143387A1 (en) * | 2019-01-10 | 2020-07-16 | 广州视源电子科技股份有限公司 | Table processing method, device and system, and storage medium and intelligent interactive tablet |
| CN109858000B (en) * | 2019-01-10 | 2021-09-07 | 广州视源电子科技股份有限公司 | Form processing method, device and system, storage medium and interactive intelligent panel |
| CN111984170A (en) * | 2020-07-14 | 2020-11-24 | 维沃移动通信有限公司 | Table output method and device and electronic equipment |
| CN111984170B (en) * | 2020-07-14 | 2022-06-10 | 维沃移动通信有限公司 | Table output method and device and electronic equipment |
| CN116341506A (en) * | 2023-05-25 | 2023-06-27 | 广东杰纳医药科技有限公司 | Method for iteratively calculating column width of table |
| CN116341506B (en) * | 2023-05-25 | 2023-08-25 | 广东杰纳医药科技有限公司 | Method for iteratively calculating column width of table |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102103581B (en) | 2013-07-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11487426B2 (en) | Apparatus and method for cursor control and text selection and editing based on gesture-based touch inputs received in a virtual keyboard display area | |
| CN101388041B (en) | Browsers page navigation method and system for handhold terminal | |
| CN102103581B (en) | Method and system for adding columns and rows to form by computer | |
| CN103019508B (en) | Mobile terminal and icon arrangement display packing | |
| AU2012309121B2 (en) | Formula entry for limited display devices | |
| CN101661375B (en) | Touch control method, system and display terminal | |
| CN102306080A (en) | Touch electronic device and icon moving method | |
| CN102110148B (en) | Folder content showing method and terminal | |
| CN101763218A (en) | Input method for handheld equipment | |
| US20120036435A1 (en) | Apparatuses and Methods for Rearranging Menu Items | |
| EP2869173A1 (en) | Handheld electronic device and touchscreen-based list item editing method | |
| CN106325663B (en) | Mobile terminal and its screenshotss method | |
| CN101452354B (en) | Input method of electronic device, content display method and use thereof | |
| KR20120095430A (en) | Method and apparatus for displaying information in an electronic device | |
| CN102436335A (en) | Widget addition system and method | |
| CN103677603A (en) | Zonal touch method and device | |
| CN105824520A (en) | Desktop icon batch processing method and mobile terminal | |
| CN102103582B (en) | Method and system for drawing table utilizing computer | |
| CN102968270A (en) | Data deleting method and terminal equipment thereof | |
| CN103365524A (en) | Application synergy method based on status bar icon and communication terminal | |
| CN112269501A (en) | Icon moving method and device and electronic equipment | |
| CN104238933B (en) | For editing the method for the page based on frame and the electronic installation using methods described | |
| CN106201270A (en) | A kind of processing method and processing device of destination object | |
| CN102103580A (en) | Method and system of selection of some areas in table utilizing computer | |
| CN106503061B (en) | Group message display method and mobile terminal |
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. |
|
| CP03 | Change of name, title or address |
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: Jinshan software building No. 33 Xiaoying Road Patentee before: Beijing Kingsoft WPS Office Co., Ltd. Patentee before: GUANGZHOU JINSHAN JINSHAN MOBILE TECHNOLOGY CO., LTD. |
|
| CP03 | Change of name, title or address |