CN117057323A

CN117057323A - Information input method and device

Info

Publication number: CN117057323A
Application number: CN202310814521.XA
Authority: CN
Inventors: 陈波; 晁云曈; 霍秋桦; 王婷; 朱军行
Original assignee: Beijing Kingsoft Office Software Inc; Zhuhai Kingsoft Office Software Co Ltd
Current assignee: Beijing Kingsoft Office Software Inc; Zhuhai Kingsoft Office Software Co Ltd
Priority date: 2020-03-11
Filing date: 2020-03-11
Publication date: 2023-11-14
Also published as: CN112784550B; CN112784550A

Abstract

The embodiment of the application provides an information input method and device, and relates to the technical field of computers, wherein the method comprises the following steps: an edit instruction for a first cell in the electronic form may be obtained and a target data type of content in a second cell in a preset direction of the first cell may be determined. And then, according to the corresponding relation between the pre-stored data type and the input mode, determining a target input mode corresponding to the target data type, acquiring target data input in the target input mode, and writing the target data into the first cell. Based on the method, when information is input into the electronic form, the input modes corresponding to different data types can be determined based on the corresponding relation between the pre-stored data types and the input modes, the user does not need to manually switch the input modes, and the information input efficiency is improved.

Description

Information input method and device

The application discloses a division application of Chinese patent application with the name of 'an information input method and device' which is filed by Chinese patent office at 3 months and 11 days in 2020, the application number of which is 202010166542.1.

Technical Field

The present application relates to the field of computer technologies, and in particular, to an information input method and apparatus.

Background

At present, people often use electronic forms to manage data such as material details, personnel lists, transaction records, and the like. When people use the electronic form to input data, no matter what information is input, the people can only input characters one by one through a keyboard.

But the manner of input required may be different when different information is entered. For example, it is necessary to enter Chinese characters, letters, etc. using an alphabetic keyboard, and it is necessary to enter numerals, dates, etc. using a numeric keyboard. In this case, if different information is continuously input into the electronic form, the input mode may need to be continuously switched, especially on a mobile terminal such as a mobile phone, the complexity further increases, which results in lower efficiency of inputting information into the electronic form.

Disclosure of Invention

The embodiment of the application aims to provide an information input method and device so as to improve the information input efficiency. The specific technical scheme is as follows:

in a first aspect, there is provided an information entry method, the method comprising:

acquiring an editing instruction aiming at a first cell in the electronic table;

determining a target data type of data in a second cell, wherein the second cell is a cell in a preset direction of the first cell;

Determining a target input mode corresponding to the target data type according to the corresponding relation between the pre-stored data type and the input mode;

and acquiring target data input in the target input mode, and writing the target data into the first cell.

Optionally, the step of determining the target data type of the data in the second cell includes:

determining the data type of the content of each second cell;

counting the proportion of the second cells corresponding to each data type in all the second cells;

and taking the data type corresponding to the second cell with the largest proportion as the target data type of the data in the second cell.

determining the data type of the cell digital format of each second cell;

Acquiring title contents in a preset direction of the first cell;

determining a data type of the title content;

and taking the determined data type of the title content as a target data type of the data in the second cell.

Optionally, after acquiring the editing instruction for the first cell in the electronic table, the method further includes:

determining the number of weight-removing items in the second cell, and determining the total number of the second cell, wherein the contents of all weight-removing items are different;

calculating the ratio of the number of the weight removing items to the total number;

if the calculated ratio is smaller than a preset threshold, displaying the content of all the weight removing items;

the step of obtaining the target data input in the target input mode comprises the following steps:

acquiring a selection instruction for the content of the displayed first heavy item;

and determining the content of the first duplicate entry as target data input in the target input mode.

Optionally, after determining the target data type of the data in the second cell, the method further includes:

and the data type recorded in the preset direction of the first cell is the target data type.

Optionally, after determining the target input mode corresponding to the target data type, the method further includes:

Acquiring an input mode switching instruction;

and switching the target input mode into a preset input mode according to the input mode switching instruction.

In a second aspect, there is provided an information entry apparatus, the apparatus comprising:

the first acquisition module is used for acquiring an editing instruction aiming at a first cell in the electronic form;

the first determining module is used for determining a target data type of data in a second cell, wherein the second cell is a cell in a preset direction of the first cell;

the second determining module is used for determining a target input mode corresponding to the target data type according to the corresponding relation between the pre-stored data type and the input mode;

and the second acquisition module is used for acquiring target data input in the target input mode and writing the target data into the first cell.

Optionally, the first determining module includes:

a first determining sub-module for determining a data type of the content of each second cell;

the first statistics sub-module is used for counting the proportion of the second cells corresponding to each data type in all the second cells;

and the second determining submodule is used for taking the data type corresponding to the second cell with the largest proportion as the target data type of the data in the second cell.

Optionally, the first determining module includes:

a third determining sub-module for determining the data type of the cell digital format of each second cell;

the second statistics sub-module is used for counting the proportion of the second cells corresponding to each data type in all the second cells;

and the fourth determining submodule is used for taking the data type corresponding to the second cell with the largest proportion as the target data type of the data in the second cell.

Optionally, the first determining module includes:

the first acquisition sub-module is used for acquiring the title content in the preset direction of the first cell;

a fifth determining submodule for determining a data type of the title content;

and a sixth determining sub-module, configured to take the determined data type of the title content as a target data type of the data in the second cell.

Optionally, the apparatus further includes:

the third determining module is used for determining the number of the weight-removing items in the second cell after the editing instruction for the first cell in the electronic table is acquired, and determining the total number of the second cell, wherein the contents of all the weight-removing items are different;

The calculating module is used for calculating the ratio of the number of the weight removing items to the total number;

the display module is used for displaying the contents of all the weight-removing items if the calculated ratio is smaller than a preset threshold value;

the second acquisition module includes:

a second obtaining sub-module, configured to obtain a selection instruction for the content of the displayed first heavy item;

and a seventh determining submodule, configured to determine that the content of the first heavy item is target data input in the target input mode.

Optionally, the apparatus further includes:

and the recording module is used for recording the data type in the preset direction of the first cell as the target data type after determining the target data type of the data in the second cell.

Optionally, the apparatus further includes:

the third acquisition module is used for acquiring an input mode switching instruction after determining a target input mode corresponding to the target data type;

and the switching module is used for switching the target input mode into a preset input mode according to the input mode switching instruction.

In a third aspect, an electronic device is provided, including a processor, a communication interface, a memory, and a communication bus, where the processor, the communication interface, and the memory complete communication with each other through the communication bus;

A memory for storing a computer program;

and a processor, configured to implement the method steps described in the first aspect when executing the program stored in the memory.

In a fourth aspect, a computer-readable storage medium is provided, in which a computer program is stored which, when being executed by a processor, carries out the method steps according to the first aspect.

In a fifth aspect, there is provided a computer program product comprising instructions which, when run on a computer, cause the computer to perform the method of the first aspect described above.

The information input method and the information input device provided by the embodiment of the application can acquire the editing instruction aiming at the first cell in the electronic form and determine the target data type of the content in the second cell in the preset direction of the first cell. And then, according to the corresponding relation between the pre-stored data type and the input mode, determining a target input mode corresponding to the target data type, acquiring target data input in the target input mode, and writing the target data into the first cell. Based on the method, when information is input into the electronic form, the input modes corresponding to different data types can be determined based on the corresponding relation between the pre-stored data types and the input modes, the user does not need to manually switch the input modes, and the information input efficiency is improved.

Of course, it is not necessary for any one product or method of practicing the application to achieve all of the advantages set forth above at the same time.

Drawings

In order to more clearly illustrate the embodiments of the application or the technical solutions in the prior art, the drawings that are required in the embodiments or the description of the prior art will be briefly described, it being obvious that the drawings in the following description are only some embodiments of the application, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.

Fig. 1 is a flow chart of a first information input method according to an embodiment of the present application;

FIG. 2 is a schematic diagram of a date selector input method according to an embodiment of the present application;

fig. 3 is a schematic diagram of a nine-grid input mode according to an embodiment of the present application;

FIG. 4 is a schematic diagram of acquiring target data according to an embodiment of the present application;

fig. 5 is a flow chart of a second information input method according to an embodiment of the present application;

fig. 6 is a flow chart of a third information input method according to an embodiment of the present application;

fig. 7 is a flowchart of a fourth information input method according to an embodiment of the present application;

Fig. 8 is a flowchart of a fifth information input method according to an embodiment of the present application;

fig. 9 is a schematic structural diagram of an information input device according to an embodiment of the present application;

fig. 10 is a schematic structural diagram of an electronic device according to an embodiment of the present application.

Detailed Description

The following description of the embodiments of the present application will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present application, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to be within the scope of the application.

In the prior art, no matter what information is recorded, people can only record characters one by one through a keyboard when using the electronic form to record data. However, when different information is entered, the required input mode may be different. For example, it is necessary to enter Chinese characters, letters, etc. using an alphabetic keyboard, and it is necessary to enter numerals, dates, etc. using a numeric keyboard. In this case, if different information is continuously input into the electronic form, the input mode may need to be continuously switched, especially on a mobile terminal such as a mobile phone, the complexity further increases, which results in lower efficiency of inputting information into the electronic form.

In order to solve the problems, the embodiment of the application provides an information input method. Referring to fig. 1, fig. 1 is a flowchart of a first information input method according to an embodiment of the present application. The method can be applied to electronic equipment such as smart phones, personal computers, notebooks and the like, and the embodiment of the application is not particularly limited. For the sake of understanding, the following explanation of the information input method provided in the embodiment of the present application using the electronic device as an execution body is not limited. The method comprises the following steps.

Step 101, obtaining an editing instruction for a first cell in the electronic table.

In the embodiment of the present application, the first cell is any cell needing to enter information. The user can select to open the electronic form needing to be input with information and select the first cell needing to be input with information in the electronic form, and at the moment, the electronic equipment can acquire an editing instruction aiming at the first cell in the electronic form. Wherein each row in the spreadsheet may represent a complete piece of data and each column may represent a type of information. Alternatively, each row in the spreadsheet represents a type of information and each column represents a complete piece of information. The category of the information includes, but is not limited to, category, date, number, name, etc., and the specific information category may be determined according to the actually recorded information, which is not particularly limited in the embodiment of the present application.

Step 102, determining a target data type of the data in the second cell. The second cells are all cells in the preset direction of the first cells.

In the embodiment of the application, after the electronic device acquires the editing instruction for the first cell in the electronic table, the electronic device can determine the target data type of the data in the second cell.

The predetermined direction may be a vertical direction, i.e., a column direction. For example, if each column of the electronic table represents a type of information, the predetermined direction may be a vertical direction, i.e., a column direction. At this time, the second cell is the cell in the column where the first cell is located. The predetermined direction may be a horizontal direction, that is, a row direction. If each row of the electronic form represents a type of information, the predetermined direction may be a horizontal direction, i.e., a row direction. At this time, the second cell is the cell in which the first cell is located.

In an alternative embodiment, after determining the target data type of the data in the second cell, the data type recorded in the preset direction of the first cell may be the target data type. Based on the above, when new information is recorded in the electronic form, if the record of the data type exists, the target data type of the data in the second cell does not need to be determined again, so that the efficiency of information recording is further improved.

Step 103, determining a target input mode corresponding to the target data type according to the corresponding relation between the pre-stored data type and the input mode.

In the embodiment of the application, the user can prestore the established corresponding relation between the data type and the input mode into the electronic equipment, and the electronic equipment finds the target input mode corresponding to the target data type according to the prestored corresponding relation between the data type and the input mode. The input modes include, but are not limited to, a selection list, a date selector, a code scanner, a picture selector, a member selector, a map address, a numeric keyboard, a text keyboard and the like.

For example, the correspondence between the data types stored in advance in the electronic device and the input modes is shown in table 1.

TABLE 1

Data type	Input mode
		Options	Selection list
Date and time	Date selector
		Bar code	Code scanner
Picture picture	Picture selector
		Mailbox	Member selector
Address of	Map location selection
		Numerical value (quantity, amount)	Digital keyboard
Plain text	Text keyboard

If the target data type is an option, based on table 1, it can be determined that the target input mode is a selection list; if the target data type is date, based on table 1, it can be determined that the target input mode is a date selector, etc. When determining the input modes corresponding to other data types, specific corresponding relations may refer to table 1, and embodiments of the present application will not be described in detail herein.

In an alternative embodiment, after determining the target input mode corresponding to the target data type, the electronic device may further obtain an input mode switching instruction, and switch the target input mode to the preset input mode according to the input mode switching instruction. For example, when it is determined that the target input mode is a date selector, as shown in fig. 2, fig. 2 is a schematic diagram of the input mode of the date selector provided in the embodiment of the present application, if it is detected that the user clicks the switch button, as shown by a black circle in the upper right corner of fig. 2, the date selector is switched to a nine-grid input mode as shown in fig. 3, and fig. 3 is a schematic diagram of the input mode of the nine-grid embodiment of the present application. If the current output mode is a nine-grid input mode as shown in fig. 3, when it is detected that the user clicks the switch button, a portion circled with a black circle in the upper left corner of fig. 3 is used, the nine-grid input mode is switched back to the date selector as shown in fig. 2.

Step 104, obtaining target data input in a target input mode, and writing the target data into the first cell.

In the embodiment of the application, after determining the target input mode corresponding to the target data type, the electronic device may acquire the target data input in the target input mode and write the target data into the first cell. For example, as shown in fig. 4, fig. 4 is a schematic diagram of acquiring target data according to an embodiment of the present application, when the type of the target data is determined to be a date, the input mode of the date selector is skipped, and the user can click to select a corresponding year, month and date and input the selected year, month and date into the first cell.

According to the information input method provided by the embodiment of the application, the electronic equipment can acquire the editing instruction aiming at the first cell in the electronic table and determine the target data type of the content in the second cell in the preset direction of the first cell. And then, according to the corresponding relation between the pre-stored data type and the input mode, determining a target input mode corresponding to the target data type, acquiring target data input in the target input mode, and writing the target data into the first cell. Based on the method, when information is input into the electronic form, the input modes corresponding to different data types can be determined based on the corresponding relation between the pre-stored data types and the input modes, the user does not need to manually switch the input modes, and the information input efficiency is improved.

In one embodiment of the present application, the electronic device may determine the target data type of the data in the second cells according to the data type of the content of each second cell. Referring specifically to fig. 5, fig. 5 is a flow chart of a second information input method according to an embodiment of the present application, where the method includes the following steps:

step 501, an edit instruction for a first cell in a spreadsheet is obtained. Step 501 corresponds to step 101.

Step 502, determining the data type of the content of each second cell.

In the embodiment of the application, the electronic equipment can acquire the content of each second cell and determine the data type of the content of each second cell. The data types of the contents of the second cells may be the same or different.

Step 503, counting the proportion of the second cells corresponding to each data type in all the second cells.

In the embodiment of the application, after determining the data types of the content of each second cell, the electronic device may count the proportion of the second cells corresponding to each data type in all the second cells. For example, the data type includes a date and time, a numerical value, and a text, the total number of the second cells is 10, where the number of the second cells corresponding to the data type of the date and time is 6, the number of the second cells corresponding to the data type of the text is 2, and the number of the second cells corresponding to the data type of the numerical value is 2, and the statistical result can be obtained: the proportion of the second cells corresponding to the data type of the date and time in all the second cells is 6/10=0.6, the proportion of the second cells corresponding to the data type of the text in all the second cells is 2/10=0.2, and the proportion of the second cells corresponding to the data type of the numerical value in all the second cells is 2/10=0.2.

And 504, taking the data type corresponding to the second cell with the largest proportion as the target data type of the data in the second cell.

In the embodiment of the application, after counting the proportion of the second cells corresponding to each data type in all the second cells, the electronic device can take the data type corresponding to the second cell with the largest proportion as the target data type of the data in the second cell.

The description will be given with an example in step 503. For example, the statistics shows that the proportion of the second cells corresponding to the data type of the date and time in all the second cells is 0.6, the proportion of the second cells corresponding to the data type of the text in all the second cells is 0.2, and the proportion of the second cells corresponding to the data type of the numerical value in all the second cells is also 0.2. At this time, the maximum ratio is 0.6, and the corresponding data type is the date and time, and the data type of the date and time is used as the target data type of the data in the second cell.

In step 505, a target input mode corresponding to the target data type is determined according to the correspondence between the pre-stored data type and the input mode. Step 505 corresponds to step 103.

Step 506, obtaining the target data input in the target input mode, and writing the target data into the first cell. Step 506 corresponds to step 104.

According to the information input method provided by the embodiment of the application, when information is input into the electronic form, based on the corresponding relation between the pre-stored data types and the input modes, the input modes corresponding to different data types can be determined according to the data types of the contents of each second cell and the proportion of the second cells corresponding to the data types in all the second cells, so that the user does not need to manually switch the input modes, and the information input efficiency is improved.

In another embodiment, the electronic device may further determine the target data type of the data within the second cells according to the cell number format of each second cell. Referring specifically to fig. 6, fig. 6 is a flow chart of a third information input method according to an embodiment of the present application, where the method includes the following steps:

step 601, an edit instruction for a first cell in a spreadsheet is obtained. Step 601 corresponds to step 101.

Step 602, determining a data type of a cell digital format of each second cell.

In the embodiment of the application, the electronic equipment can acquire the cell digital format of each second cell and determine the data type of the cell digital format of each second cell. The cell number formats of the second cells may be the same or different. For example, the cell number format of the second cell may be numerical, monetary, regular, percentage, text, time, or the like. The data type corresponding to the second cells with the cell format of numerical value, currency and percentage can be the data type of numerical value, the data type corresponding to the second cells with the cell numerical format of regular text can be the data type of text, and the data type corresponding to the second cells with the cell numerical format of time can be the data type of date. Of course, the correspondence between the cell number format and the data type may be other correspondence, which is not limited herein.

Step 603, counting the proportion of the second cells corresponding to each data type in all the second cells.

In the embodiment of the application, after determining the data types of the cell digital formats of the second cells, the electronic device may count the proportion of the second cells corresponding to each data type in all the second cells. For example, the data type of the cell digital format has date, numerical value and text, the total number of the second cells is 10, wherein the number of the second cells corresponding to the data type of the date is 6, the number of the second cells corresponding to the data type of the text is 2, the number of the second cells corresponding to the data type of the numerical value is 2, the proportion of the second cells corresponding to the data type of the date in all the second cells is 6/10=0.6, the proportion of the second cells corresponding to the data type of the text in all the second cells is 2/10=0.2, and the proportion of the second cells corresponding to the data type of the numerical value in all the second cells is 2/10=0.2.

And step 604, taking the data type corresponding to the second cell with the largest proportion as the target data type of the data in the second cell.

The description will be given with an example in step 603. For example, the proportion of the second cells corresponding to the data type of the date in all the second cells is 0.6, the proportion of the second cells corresponding to the data type of the text in all the second cells is 0.2, and the proportion of the second cells corresponding to the data type of the numerical value in all the second cells is also 0.2. At this time, the maximum value of the ratio is 0.6, and the corresponding data type is the date, and the date data type is used as the target data type of the data in the second cell.

Step 605, determining a target input mode corresponding to the target data type according to the corresponding relation between the pre-stored data type and the input mode. Step 605 corresponds to step 103.

Step 606, obtain the target data input in the target input mode, and write the target data into the first cell. Step 606 corresponds to step 104.

According to the information input method provided by the embodiment of the application, when information is input into the electronic form, based on the corresponding relation between the prestored data types and the input modes, the input modes corresponding to different data types can be determined according to the data types of the cell digital formats of the second cells and the proportion of the second cells corresponding to the data types in all the second cells, the user does not need to manually switch the input modes, and the information input efficiency is improved.

In one embodiment of the present application, the electronic device may further determine the target data type of the data in the second cell according to the data type of the title content in the preset direction of the first cell. Referring specifically to fig. 7, fig. 7 is a flowchart of a fourth information input method according to an embodiment of the present application, where the method includes the following steps:

step 701, obtaining an editing instruction for a first cell in a spreadsheet. Step 701 corresponds to step 101.

In step 702, the title content in the preset direction of the first cell is obtained.

In the embodiment of the application, the electronic device can acquire the title content in the preset direction of the first cell, wherein the preset direction can be the horizontal direction or the vertical direction.

In step 703, the data type of the title content is determined.

In the embodiment of the application, after the electronic equipment acquires the title content, the data type of the title content can be determined. For example, when the title content is an entrance time, it is determined that the data type of the title is a date.

Step 704, the determined data type of the title content is used as the target data type of the data in the second cell.

In the embodiment of the application, the electronic device can use the data type of the title content as the target data type of the data in the second cell. For example, when it is determined that the data type of the title content is a date, the date is taken as the target data type of the data in the second cell.

Step 705, determining a target input mode corresponding to the target data type according to the corresponding relation between the pre-stored data type and the input mode. Step 705 corresponds to step 103.

Step 706, obtaining target data input in a target input mode, and writing the target data into the first cell. Step 706 corresponds to step 104.

According to the information input method provided by the embodiment of the application, when information is input into the electronic form, based on the corresponding relation between the pre-stored data types and the input modes, the input modes corresponding to different data types can be determined according to the data types of the title contents in the preset direction of the first cell, the user does not need to manually switch the input modes, and the information input efficiency is improved.

In addition, the embodiment of the application also provides an information input method, and specifically referring to fig. 8, fig. 8 is a flow chart of a fifth information input method provided by the embodiment of the application, and the method comprises the following steps:

step 801, an edit instruction for a first cell in a spreadsheet is obtained. Step 801 corresponds to step 101.

Step 802, determining the number of weight-removing items in the second cell, and determining the total number of the second cells.

In the embodiment of the application, the electronic equipment can determine the number of the weight-removing items in the second cell and determine the total number of the second cell. Wherein the contents of all the weight items are different. For example, the total number of the second cells is 10, where the number of the second cells with the content of a is 6, the number of the second cells with the content of B is 3, and the number of the second cells with the content of C is 1, the number of the weight-ranking items in the second cells is determined to be 3, and the contents in the three weight-ranking items are A, B, C.

Step 803, calculating the ratio of the number of weight-removing items to the total number.

In the embodiment of the application, after the electronic equipment determines the number of the weight-removing items in the second cell and the total number of the second cell, the ratio of the number of the weight-removing items to the total number can be calculated. For example, when the number of the weight-removing items in the second cell is determined to be 3 and the total number is 10, the calculated ratio is 0.3.

Step 804, if the calculated ratio is smaller than the preset threshold, displaying the content of all the weight-removing items.

In the embodiment of the application, when the calculated ratio is smaller than the preset threshold, displaying the content of all the weight-removing items. For example, when the preset threshold is 0.5 and the calculated ratio is 0.3, and at this time, the calculated ratio is smaller than the preset threshold, then the contents of all the weight-removing items are displayed at the first cell.

In an optional embodiment, if the calculated ratio is greater than or equal to a preset threshold, the electronic device may determine a data type corresponding to the second cell, determine input modes corresponding to different data types based on a correspondence between prestored data types and input modes, acquire target data input based on the input modes, and then write the acquired target data into the first cell; the electronic device may also acquire the target data using the preset input manner, and write the target data into the first cell.

Step 805, a selection instruction for the displayed first row of heavy items is acquired.

In the embodiment of the application, after displaying the contents of all the weight-removing items, the electronic device can acquire the selection instruction of the user for the first weight-removing item in the displayed contents of all the weight-removing items.

In step 806, the content of the first duplicate entry is determined to be the target data input in the target input mode, and the target data is written into the first cell.

In the embodiment of the application, after the electronic device acquires the selection instruction for the content of the first row of heavy items, the electronic device can take the content of the first row of heavy items as the target data input in the target input mode and write the target data into the first unit cell. For example, when the content of the first row of heavy items is a, a is written as target data into the first cell.

Step 807 determines a target data type for the data within the second cell. The second cells are all cells in the preset direction of the first cells. Step 807 corresponds to step 102.

Step 808, determining a target input mode corresponding to the target data type according to the corresponding relation between the pre-stored data type and the input mode. Step 808 corresponds to step 103.

Step 809, obtaining target data input in the target input mode, and writing the target data into the first cell. Step 809 corresponds to step 104.

In the information input method provided by the embodiment of the application, when information is input into the electronic form, the content of all the repeated items can be displayed according to the ratio of the number of the repeated items of the second cell to the total number of the second cell, the content of the first repeated item selected by a user can be directly used as target data to be written into the first cell, and the input modes corresponding to different data types can be determined based on the corresponding relation between the pre-stored data types and the input modes, so that the user does not need to manually switch the input modes, and the information input efficiency is improved.

Based on the same technical concept, the embodiment of the application further provides an information input device, as shown in fig. 9, fig. 9 is a schematic structural diagram of the information input device provided by the embodiment of the application, where the device includes:

a first obtaining module 901, configured to obtain an editing instruction for a first cell in the electronic form;

a first determining module 902, configured to determine a target data type of data in a second cell, where the second cell is a cell in a preset direction of the first cell;

A second determining module 903, configured to determine a target input mode corresponding to the target data type according to a correspondence between a pre-stored data type and an input mode;

the second obtaining module 904 is configured to obtain target data input in a target input manner, and write the target data into the first cell.

Optionally, the first determining module 902 includes:

a fifth determining sub-module for determining a data type of the title content;

Optionally, the apparatus further comprises:

the display module is used for displaying the content of all the weight removing items if the calculated ratio is smaller than a preset threshold value;

a second acquisition module 904, comprising:

and a seventh determining submodule, configured to determine that the content of the first heavy item is target data input in a target input manner.

Optionally, the apparatus further comprises:

In the information input device provided by the embodiment of the application, the electronic equipment can acquire the editing instruction aiming at the first cell in the electronic table and determine the target data type of the content in the second cell in the preset direction of the first cell. And then, according to the corresponding relation between the pre-stored data type and the input mode, determining a target input mode corresponding to the target data type, acquiring target data input in the target input mode, and writing the target data into the first cell. Based on the method, when information is input into the electronic form, the input modes corresponding to different data types can be determined based on the corresponding relation between the pre-stored data types and the input modes, the user does not need to manually switch the input modes, and the information input efficiency is improved.

The embodiment of the application also provides an electronic device, as shown in fig. 10, which comprises a processor 1001, a communication interface 1002, a memory 1003 and a communication bus 1004, wherein the processor 1001, the communication interface 1002 and the memory 1003 complete communication with each other through the communication bus 1004,

A memory 1003 for storing a computer program;

the processor 1001 is configured to implement the method steps in any of the above-described information entry method embodiments when executing the program stored in the memory 1003.

In the electronic device provided by the embodiment of the application, the electronic device can acquire the editing instruction aiming at the first cell in the electronic table and determine the target data type of the content in the second cell in the preset direction of the first cell. And then, according to the corresponding relation between the pre-stored data type and the input mode, determining a target input mode corresponding to the target data type, acquiring target data input in the target input mode, and writing the target data into the first cell. Based on the method, when information is input into the electronic form, the input modes corresponding to different data types can be determined based on the corresponding relation between the pre-stored data types and the input modes, the user does not need to manually switch the input modes, and the information input efficiency is improved.

The communication bus mentioned by the network device may be a peripheral component interconnect standard (english: peripheral Component Interconnect, abbreviated: PCI) bus or an extended industry standard architecture (english: extended Industry Standard Architecture, abbreviated: EISA) bus, etc. The communication bus may be classified as an address bus, a data bus, a control bus, or the like. For ease of illustration, the figures are shown with only one bold line, but not with only one bus or one type of bus.

The communication interface is used for communication between the network device and other devices.

The Memory may include random access Memory (Random Access Memory, abbreviated as RAM) or nonvolatile Memory (NVM), such as at least one disk Memory. Optionally, the memory may also be at least one memory device located remotely from the aforementioned processor.

The processor may be a general-purpose processor, including a central processing unit (Central Processing Unit, CPU for short), a network processor (Network Processor, NP for short), etc.; it may also be a digital signal processor (English: digital Signal Processing; DSP; for short), an application specific integrated circuit (English: application Specific Integrated Circuit; ASIC; for short), a Field programmable gate array (English: field-Programmable Gate Array; FPGA; for short), or other programmable logic device, discrete gate or transistor logic device, discrete hardware components.

Based on the same technical concept, the embodiment of the application also provides a computer readable storage medium, wherein a computer program is stored in the computer readable storage medium, and the computer program realizes the steps of the information input method when being executed by a processor.

Based on the same technical idea, an embodiment of the present application also provides a computer program product containing instructions, which when run on a computer, cause the computer to perform the above-mentioned information entry method steps.

In the above embodiments, it may be implemented in whole or in part by software, hardware, firmware, or any combination thereof. When implemented in software, may be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer instructions. When loaded and executed on a computer, produces a flow or function in accordance with embodiments of the present application, in whole or in part. The computer may be a general purpose computer, a special purpose computer, a computer network, or other programmable apparatus. The computer instructions may be stored in or transmitted from one computer-readable storage medium to another, for example, by wired (e.g., coaxial cable, optical fiber, digital Subscriber Line (DSL)), or wireless (e.g., infrared, wireless, microwave, etc.). The computer readable storage medium may be any available medium that can be accessed by a computer or a data storage device such as a server, data center, etc. that contains an integration of one or more available media. The usable medium may be a magnetic medium (e.g., floppy Disk, hard Disk, magnetic tape), an optical medium (e.g., DVD), or a semiconductor medium (e.g., solid State Disk (SSD)), etc.

It is noted that relational terms such as first and second, and the like are used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Moreover, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.

In this specification, each embodiment is described in a related manner, and identical and similar parts of each embodiment are all referred to each other, and each embodiment mainly describes differences from other embodiments. In particular, for apparatus, electronic devices, computer readable storage medium embodiments, since they are substantially similar to method embodiments, the description is relatively simple, and relevant references are made to the partial description of method embodiments.

The foregoing description is only of the preferred embodiments of the present application and is not intended to limit the scope of the present application. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application are included in the protection scope of the present application.

Claims

1. An information entry method, the method comprising:

acquiring target data input in the target input mode, and writing the target data into the first cell;

wherein the step of determining the target data type of the data in the second cell includes:

determining the data type of the content of each second cell; counting the proportion of the second cells corresponding to each data type in all the second cells; taking the data type corresponding to the second cell with the largest proportion as the target data type of the data in the second cell;

Alternatively, the step of determining the target data type of the data in the second cell includes:

determining the data type of the cell digital format of each second cell; counting the proportion of the second cells corresponding to each data type in all the second cells; taking the data type corresponding to the second cell with the largest proportion as the target data type of the data in the second cell;

acquiring title contents in a preset direction of the first cell; determining a data type of the title content; and taking the determined data type of the title content as a target data type of the data in the second cell.

2. The method of claim 1, further comprising, after obtaining the edit instruction for the first cell in the spreadsheet:

3. The method of claim 1, further comprising, after determining the target data type for the data within the second cell:

4. The method of claim 1, further comprising, after determining the target input pattern corresponding to the target data type:

acquiring an input mode switching instruction;

5. An information entry device, the device comprising:

the second acquisition module is used for acquiring target data input in the target input mode and writing the target data into the first cell;

wherein the first determining module includes:

a first determining sub-module for determining a data type of the content of each second cell; the first statistics sub-module is used for counting the proportion of the second cells corresponding to each data type in all the second cells; the second determining submodule is used for taking the data type corresponding to the second cell with the largest proportion as the target data type of the data in the second cell;

alternatively, the first determining module includes:

a third determining sub-module for determining the data type of the cell digital format of each second cell; the second statistics sub-module is used for counting the proportion of the second cells corresponding to each data type in all the second cells; a fourth determining submodule, configured to use a data type corresponding to the second cell with the largest proportion as a target data type of data in the second cell;

Alternatively, the first determining module includes:

the first acquisition sub-module is used for acquiring the title content in the preset direction of the first cell; a fifth determining submodule for determining a data type of the title content; and a sixth determining sub-module, configured to take the determined data type of the title content as a target data type of the data in the second cell.

6. The apparatus of claim 5, wherein the apparatus further comprises:

the second acquisition module includes:

7. The apparatus of claim 5, wherein the apparatus further comprises:

8. The apparatus of claim 5, wherein the apparatus further comprises:

9. The electronic equipment is characterized by comprising a processor, a communication interface, a memory and a communication bus, wherein the processor, the communication interface and the memory are communicated with each other through the communication bus;

a memory for storing a computer program;

a processor for carrying out the method steps of any one of claims 1-4 when executing a program stored on a memory.

10. A computer-readable storage medium, characterized in that the computer-readable storage medium has stored therein a computer program which, when executed by a processor, implements the method steps of any of claims 1-4.