CN112749533A - Data input control method and device, electronic equipment and storage medium - Google Patents

Data input control method and device, electronic equipment and storage medium Download PDF

Info

Publication number
CN112749533A
CN112749533A CN201911048115.7A CN201911048115A CN112749533A CN 112749533 A CN112749533 A CN 112749533A CN 201911048115 A CN201911048115 A CN 201911048115A CN 112749533 A CN112749533 A CN 112749533A
Authority
CN
China
Prior art keywords
domain
ordinal
data
ordered
data input
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
Application number
CN201911048115.7A
Other languages
Chinese (zh)
Other versions
CN112749533B (en
Inventor
徐杨
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Tencent Technology Shenzhen Co Ltd
Original Assignee
Tencent Technology Shenzhen Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Tencent Technology Shenzhen Co Ltd filed Critical Tencent Technology Shenzhen Co Ltd
Priority to CN201911048115.7A priority Critical patent/CN112749533B/en
Publication of CN112749533A publication Critical patent/CN112749533A/en
Application granted granted Critical
Publication of CN112749533B publication Critical patent/CN112749533B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Abstract

The application relates to the technical field of computers, and discloses a data input control method, a data input control device, electronic equipment and a storage medium, wherein the method comprises the following steps: responding to a data input operation for a target ordered domain of at least two ordered domains, wherein the at least two ordered domains are arranged in sequence, each ordered domain comprises an order display sub-domain for displaying order indication data and at least one data input sub-domain for displaying input data; and when the data input operation is an input operation in the data input sub-domain, displaying the ordinal indicator data generated for the target ordered domain in advance into the ordinal display sub-domain of the target ordered domain. The data input control method, the data input control device, the electronic equipment and the storage medium can improve the data input efficiency, particularly enable the data collection process to be more orderly under an online cooperation scene, and reduce the risk of data disorder easily caused by multi-user operation.

Description

Data input control method and device, electronic equipment and storage medium
Technical Field
The present application relates to the field of computer technologies, and in particular, to a data input control method and apparatus, an electronic device, and a storage medium.
Background
In the process of editing the document, some data meeting the sorting rule, such as the sequence number of the data, time information and the like, often need to be edited, and various document editing software provides some convenient operations to assist users in quickly processing the data meeting the sorting rule. Taking Excel software as an example, as shown in fig. 1, a user can select a cell containing a sequence number, click the lower right corner of the selected cell and manually drag the selected cell, and then the sequence numbers can be automatically generated in batches in subsequent cells.
However, the online collaboration document supports multiple users to edit the same document at the same time, in such a scenario, multiple users are required to manually fill data in the online collaboration document one by one, which is prone to causing data confusion, and particularly for data with a sorting rule, a document creator needs to manually adjust or complete the data for multiple times, which is cumbersome to operate and prone to error.
Disclosure of Invention
The embodiment of the application provides a data input control method and device, electronic equipment and a storage medium, which can improve the data input efficiency, particularly enable the data collection process to be more orderly under an online cooperation scene, and reduce the risk of data disorder easily caused by multi-user operation.
In one aspect, an embodiment of the present application provides a data input control method, including:
responding to a data input operation for a target ordered domain of at least two ordered domains, wherein the at least two ordered domains are arranged in sequence, each ordered domain comprises an order display sub-domain for displaying order indication data and at least one data input sub-domain for displaying input data;
and when the data input operation is an input operation in the data input sub-domain, displaying the ordinal indicator data generated for the target ordered domain in advance into the ordinal display sub-domain of the target ordered domain.
In one aspect, an embodiment of the present application provides a data input control method applied to an online collaboration table, where each row or column in the online collaboration table is an ordered domain, a cell in the online collaboration table for displaying order indication data is an order display sub-domain, and other cells in the online collaboration table except the order display sub-domain are data input sub-domains;
the method comprises the following steps: according to any one of the above methods, data input into the online collaboration form is controlled.
In one aspect, an embodiment of the present application provides a data input control device, including:
a response module for responding to a data input operation for a target ordered domain of at least two ordered domains, wherein the at least two ordered domains are arranged in sequence, each ordered domain comprises an order display sub-domain for displaying order indication data and at least one data input sub-domain for displaying input data;
and the ordinal display module is used for displaying ordinal indication data which is generated for the target ordered domain in advance into an ordinal display subdomain of the target ordered domain when the data input operation is an input operation in a data input subdomain.
Optionally, the data input control device further includes a deletion module, configured to update the ordinal level indication data in the ordinal level display sub-domain of the subsequent ordinal level domain according to a set sorting rule and a position order of the subsequent ordinal level domain after the deletion operation in response to the deletion operation for the ordinal level indication data-containing ordinal level domain, where the subsequent ordinal level domain is the ordinal level indication data-containing ordinal level domain arranged after the deleted ordinal level domain.
Optionally, the data input control device further comprises a moving module for:
responding to the moving operation of the ordered domain containing the ordered domain indicating data, and judging whether the data in the ordered domain display sub-domain adjacent to the moved ordered domain after the moving operation is executed is the ordered domain indicating data;
if so, updating the sequence indication data in the sequence display sub-domain of each sequence domain according to the set sequencing rule and the position sequence of each sequence domain after the moving operation is carried out;
and if not, updating the ordinal indicator data in ordinal display sub-domains of other ordinal domains according to the set ordering rule and the position sequence of other ordinal domains except the moved ordinal domain after the moving operation.
In one aspect, an embodiment of the present application provides an electronic device, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of any one of the methods when executing the computer program.
In one aspect, an embodiment of the present application provides a computer-readable storage medium having stored thereon computer program instructions, which, when executed by a processor, implement the steps of any of the above-described methods.
In one aspect, an embodiment of the present application provides a computer program product comprising a computer program stored on a computer-readable storage medium, the computer program comprising program instructions that, when executed by a processor, implement the steps of any of the methods described above.
According to the data input control method and device, the electronic equipment and the storage medium, the sequence indicating data can be automatically generated for the user in the document editing process of the user, the data input efficiency is improved, particularly, under the online cooperation scene, the automatically generated sequence indicating data can guide each user to input data in sequence, and the risk that data is disordered easily caused by multi-user operation is reduced.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings needed to be used in the embodiments of the present application will be briefly described below, and it is obvious that the drawings described below are only some embodiments of the present application, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.
FIG. 1 is a schematic diagram illustrating a batch serial number generation operation performed by manually dragging cells in the prior art;
fig. 2 is a schematic view of an application scenario of a data input control method according to an embodiment of the present application;
fig. 3 is a schematic flowchart of a data input control method according to an embodiment of the present application;
fig. 4 is a schematic diagram illustrating an operation of a user inputting data in an excel table according to an embodiment of the present application;
fig. 5A is a schematic flowchart of a data input control method according to an embodiment of the present application;
fig. 5B is a schematic flowchart of a data input control method according to an embodiment of the present application;
FIG. 6 is a schematic diagram of an interface for displaying a prompt indicating that an ordered field has been locked according to an embodiment of the present application;
fig. 7A is a schematic flowchart of a data input control method according to an embodiment of the present application;
fig. 7B is a schematic flowchart of a data input control method according to an embodiment of the present application;
FIG. 8 is a flowchart illustrating a process for determining rank display subdomains and setting ranking rules in a document according to an embodiment of the present application;
fig. 9A is a schematic flowchart of a data input control method according to an embodiment of the present application;
fig. 9B is a schematic flowchart of a data input control method according to an embodiment of the present application;
FIG. 10 is a schematic diagram illustrating an interface for terminating generation of ordinal indicator data for subsequent ordered fields according to an embodiment of the present application;
fig. 11A is a schematic flowchart of a data input control method according to an embodiment of the present application;
fig. 11B is a schematic flowchart of a data input control method according to an embodiment of the present application;
FIG. 12 is a diagram illustrating the operation of deleting an ordered domain according to an embodiment of the present application;
FIG. 13 is a diagram illustrating operation of a mobile ordered domain according to an embodiment of the present application;
FIG. 14 is a diagram illustrating operation of a mobile ordered domain according to an embodiment of the present application;
FIG. 15 is a flowchart illustrating a data input control method applied to an online collaboration table according to an embodiment of the present application;
fig. 16 is a schematic structural diagram of a data input control device according to an embodiment of the present application;
fig. 17 is a schematic structural diagram of an electronic device according to an embodiment of the present application.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application.
For convenience of understanding, terms referred to in the embodiments of the present application are explained below:
online collaboration document: the document editing method includes the steps that documents such as word, excel and ppt can be directly edited through the web, a document creator can directly send the documents to other users through links, the other users can view the documents on line, and the users can jointly edit the documents. It should be noted that the documents in the present application include online collaboration documents and general documents.
An ordered domain: refers to an editable row or column in the document. A document includes a plurality of ordered fields arranged in sequence. Taking excel as an example, one ordered domain may be a row of cells or a column of cells in an excel document; taking a word as an example, one ordered field may be a line of text or a paragraph of text in a word document, and one ordered field may also be a line of cells or a column of cells in a table in a word document. The target ordered field refers specifically to the ordered field that the user is currently editing.
The terminal equipment: the electronic device can be mobile or fixed, and can be used for installing various applications and displaying objects provided in the installed applications. For example, a mobile phone, a tablet computer, various wearable devices, a vehicle-mounted device, a Personal Digital Assistant (PDA), a point of sale (POS), or other electronic devices capable of implementing the above functions may be used.
Any number of elements in the drawings are by way of example and not by way of limitation, and any nomenclature is used solely for differentiation and not by way of limitation.
In a specific practice process, in a process of editing a document, some data meeting the sorting rule, such as a sequence number of the data, time information and the like, often needs to be edited, and various document editing software provides some convenient operations to assist a user in quickly processing the data meeting the sorting rule. Taking Excel software as an example, as shown in fig. 1, a user can select a cell containing a sequence number, click the lower right corner of the selected cell and manually drag the selected cell, and then the sequence numbers can be automatically generated in batches in subsequent cells. However, the online collaboration document supports multiple users to edit the same document at the same time, in such a scenario, multiple users are required to manually fill data in the online collaboration document one by one, which is prone to causing data confusion, and particularly for data with a sorting rule, a document creator needs to manually adjust or complete the data for multiple times, which is cumbersome to operate and prone to error.
For this reason, the inventor of the present application considers that, in a process of editing a document by a user, a terminal device or a server responds to a data input operation for a data input sub-domain in a target ordered domain, and displays ordinal indication data generated for the target ordered domain in advance in a first state in an ordinal display sub-domain of the target ordered domain, so that the terminal device or the server can automatically generate ordinal indication data (such as a number) for the user in the process of editing the document by the user, assist the user to complete data input quickly and accurately, and improve data input efficiency. Further, in the process of editing the online collaborative document, when a certain user starts editing the target ordered domain, the data input operation authority of the target ordered domain can be allocated to the user who executes the data input operation, that is, only the user can edit the target ordered domain, and other users cannot edit the target ordered domain, so that the risk of data confusion caused by multi-user operation is further reduced. In addition, the generated sequence indication data can be displayed in a second state in the sequence display sub-domain corresponding to the sequence domain, the second state represents that the data input sub-domain of the sequence domain is in an editable state, and the first state represents that the data input sub-domain of the sequence domain is in a locked state.
After introducing the design concept of the embodiment of the present application, some simple descriptions are provided below for application scenarios to which the technical solution of the embodiment of the present application can be applied, and it should be noted that the application scenarios described below are only used for describing the embodiment of the present application and are not limited. In specific implementation, the technical scheme provided by the embodiment of the application can be flexibly applied according to actual needs.
Fig. 2 is a schematic view of an application scenario of the data input control method according to the embodiment of the present application. The application scenario comprises a plurality of terminal devices 201 (including terminal device 201-1, terminal device 201-2, … … terminal device 201-n) and a server 202. The terminal device 201 and the server 202 are connected through a wireless or wired network, and the terminal device 201 includes but is not limited to an electronic device such as a desktop computer, a mobile phone, a mobile computer, a tablet computer, a media player, a smart wearable device, and a smart television. The server 202 may be a server, a server cluster composed of several servers, or a cloud computing center. The implementation manner of the user terminal 201 is not particularly limited in the embodiment of the present application, as long as each user can edit the online collaboration document on the user terminal 201. For example, the user 1 creates an online collaboration document through the terminal device 201-1 and sends the online collaboration document to the server 202, the terminal device 201-1 may send a link for obtaining the online collaboration document to the terminal device 201-2 and the terminal device 201-3, the user 2 may view and edit the online collaboration document stored in the server 202 through the link, and the user 3 may view and edit the online collaboration document stored in the server 202 through the link.
Of course, the method provided in the embodiment of the present application may also be used in an application scenario in which a general document is edited, and a user creates a document through the terminal device 201, and in a process of editing the document through the terminal device 201, any data input control method provided in the present application may be executed through the terminal device 201.
Of course, the method provided in the embodiment of the present application is not limited to the application scenario shown above, and may also be used in other possible application scenarios, and the embodiment of the present application is not limited. The functions that can be implemented by each device in the application scenario shown in fig. 2 will be described in the following method embodiments, and will not be described in detail herein.
To further illustrate the technical solutions provided by the embodiments of the present application, the following detailed description is made with reference to the accompanying drawings and the detailed description. Although the embodiments of the present application provide the method operation steps as shown in the following embodiments or figures, more or less operation steps may be included in the method based on the conventional or non-inventive labor. In steps where no necessary causal relationship exists logically, the order of execution of the steps is not limited to that provided by the embodiments of the present application.
The following describes the technical solution provided in the embodiment of the present application with reference to the application scenario shown in fig. 2.
It should be noted that, in the embodiment of the present application, tables are mainly used as an example to describe a data input control method, and processing methods for documents in other forms are similar and will not be described again. In the embodiment of the present application, the execution subject of the limited data input control method may be, for example, a terminal device or a server.
Referring to fig. 3, an embodiment of the present application provides a data input control method, including the following steps:
s301, responding to data input operation aiming at a target ordered domain in at least two ordered domains, wherein the at least two ordered domains are sequentially arranged, each ordered domain comprises an ordered bit display sub-domain used for displaying ordered bit indication data and at least one data input sub-domain used for displaying input data.
In the embodiment of the present application, the ordinal display sub-field refers to a region in the ordinal field in which ordinal indication data is displayed, and the data input sub-field refers to a region in the ordinal field other than the ordinal display sub-field. Of course, the user may also manually fill in data in the ordinal display sub-field, as will be described in more detail below. Taking a table as an example, assuming that the sequence field is a row of cells in the table, the sequence display subfield in the sequence field is a cell displaying a sequence number (i.e., sequence indication data) in the row of cells, the data input subfield is other cells except for the cell displaying the sequence number, and the table has 10 rows, which indicates that there are 10 sequence fields.
In the embodiment of the present application, the ordinal number indicating data is data satisfying a certain sort rule, for example, numbers (e.g., "1, 2, 3 …", "1, 2, 4, 8 …"), letters (e.g., A, B, C …), time (e.g., 8 o 'clock, 9 o' clock, …), date (e.g., 2019, 10, 17 th), month (e.g., January), week (e.g., monday, tuesday, wednesday), a combination of fields and numbers (e.g., "user 1, user 2, user 3"), and the like may be used as the ordinal number indicating data. In practice, the sequence indication data is not limited to the content and format in the above-mentioned examples.
S302, when the data input operation is the input operation in the data input subdomain, the sequence indicating data generated for the target sequence domain in advance is displayed to the sequence display subdomain of the target sequence domain.
Referring to fig. 4, taking an excel table as an example, when a user inputs data in the third row of the table, the sequence indication data "3" is displayed in the first column (i.e., the sequence display sub-field) of the third row, and data input by the user in other cells (i.e., the data input sub-field) in the third row is normally displayed. Therefore, when a user inputs data in the table, the cells in the first column do not need to be edited, the processing efficiency is improved, and the risk of data confusion caused by simultaneous operation of a plurality of users in an online collaboration scene can be reduced.
In specific implementation, the sequence indication data corresponding to the ordered domain can be generated according to the set ordering rule.
Further, the ordinal indication data corresponding to one or more ordered fields can be generated at a time according to the set ordering rule.
Referring to fig. 5A, an embodiment of the present application further provides a data input control method, including the following steps:
s501, responding to data input operation of the data input sub-domain aiming at the target ordered domain in at least two ordered domains.
S502, displaying the sequence indication data generated for the target ordered domain to the sequence display subdomain of the target ordered domain in advance.
S503, generating corresponding ordinal indicator data for the next ordered domain arranged behind the target ordered domain according to the set ordering rule.
In the embodiment shown in fig. 5A, while a user edits one ordered field, the ordinal indication data corresponding to the next ordered field is generated.
Referring to fig. 5B, an embodiment of the present application further provides a data input control method, including the following steps:
s511, responding to a data input operation of the data input sub-field for the target ordered domain of the at least two ordered domains.
S512, the sequence indication data generated for the target sequence domain in advance are displayed to a sequence display subdomain of the target sequence domain.
And S513, if it is determined that the next ordered domain arranged behind the target ordered domain does not have corresponding ordinal indication data, generating corresponding ordinal indication data for a preset number of ordered domains arranged behind the target ordered domain according to a set ordering rule.
For example, when the predetermined number is 5, the corresponding ordinal indicator data is generated for 5 ordered fields at a time.
In specific implementation, if it is determined that the next ordered domain arranged after the target ordered domain has corresponding ordered bit indication data, it is not necessary to generate the ordered bit indication data.
In the embodiment shown in fig. 5B, when a user edits one ordered field, if there is no corresponding ordinal indicator data in the next ordered field, a predetermined number of ordered fields are generated to generate corresponding ordinal indicator data.
According to the data input control method, the ordinal indicator data can be automatically generated for the user in the document editing process of the user, the user is assisted to quickly and accurately complete data input, the data input efficiency can be improved, particularly, under an online cooperation scene, the ordinal indicator data automatically generated can guide each user to input data orderly, and the risk that data are disordered easily caused by multi-user operation is reduced.
Further, on the basis of the method shown in fig. 3, the method of the embodiment of the present application further includes the following steps: and distributing the data input operation authority of the target ordered domain to a user executing the corresponding data input operation.
In specific implementation, when the ordinal indication data corresponding to the target ordered domain is displayed in the ordinal display sub-domain of the target ordered domain, the user ID of the user can be associated with the target ordered domain, that is, only the user associated with the target ordered domain can perform data input operation on the target ordered domain, so that the assignment of data input operation authority is completed. After the association between the target ordered domain and the user ID is completed, if the data input operation aiming at the target ordered domain is detected, whether the user ID of the user executing the data input operation is the same as the user ID associated with the target ordered domain is detected, if so, the data input operation is executed, and if not, the data input operation is forbidden.
Referring to fig. 4, a user is editing the third row of the table, and at this time, the data input authority of the third row may be assigned to the user, so that other users cannot edit the data of the third row of the table, and the risk of data confusion caused by simultaneous operation of multiple users in an online collaboration scene may be reduced.
In the embodiment of the application, when the data input operation authority of one ordered domain is already allocated to a certain user, it indicates that the ordered domain is in a locked state, which indicates that only the user edits the target ordered domain, and other users cannot edit the target ordered domain.
Further, in an online collaboration scenario, if another user attempts to edit an ordered field configured in a locked state, a prompt may be displayed in the document of the other user that the ordered field is locked. As shown in fig. 6, the user "open a full egg" is editing the 3 rd row, and the user "liu can" is editing the 4 th row, at this time, if a user other than open a full egg attempts to edit the 3 rd row, a prompt message indicating that the row is being input and please try again later, etc. is displayed on the user interface, and similarly, if a user other than liu attempts to edit the 4 th row, the prompt message indicating that the row is locked is also displayed on the user interface.
Further, after the user associated with a certain ordered domain finishes editing the ordered domain, the user ID associated with the ordered domain may be cleared, that is, the ordered domain is in an editable state, but not in a locked state, and at this time, other users may edit the ordered domain.
By the method for distributing the data input operation authority, the ordered domain which is edited by the user can be locked in the process of editing the online collaborative document, only one user can edit the target ordered domain, and the risk of data disorder caused by multi-user operation is further reduced.
In addition to any of the above embodiments, the generated ordinal position indication data may be displayed in a second state in the ordinal position display sub-field corresponding to the ordinal position field, the second state indicating that the data input sub-field of the ordinal position field is in an editable state, and the first state indicating that the data input sub-field of the ordinal position field is in a locked state. Correspondingly, step S302 specifically includes: when the data input operation is an input operation in the data input sub-domain, the ordinal bit indication data of the target ordered domain is modified from the second state to the first state. Therefore, a user can select an editable ordered domain to perform data input operation according to the display state of the sequence indication data, so that the data collection process is more ordered, and the risk of data disorder is reduced.
The first state and the second state are not limited to specific expressions in the present application as long as the first state and the second state are different. For example, the first state is a black font, the second state is a gray font, or the font in the first state is larger than the font in the second state, or the ordinal position indication data in the cell in the first state is centered, and the ordinal position indication data in the cell in the second state is located in the upper left corner, etc.
Referring to fig. 6, the user "liu is inputting data content in row 4, at this time, the color of the serial number" 4 "in row 4 changes from gray (i.e., corresponding to the first state) to black (i.e., corresponding to the second state), while the predicted serial number" 5 "is displayed in the serial number cell in row 5, and the color of the serial number" 5 "is gray; when a user enters data content in line 5, the color of the serial number "5" in line 5 changes from gray to black, while the predicted serial number "6" is displayed in the serial number cell in line 6, and so on.
Referring to fig. 7A, an embodiment of the present application further provides a data input control method, including the following steps:
s701, responding to data input operation aiming at a data input sub-domain in the target ordered domain, and modifying the ordinal indicator data of the target ordered domain from the second state to the first state.
S702, generating corresponding ordinal indicator data for the next ordered domain arranged behind the target ordered domain according to the set ordering rule, and displaying the ordinal indicator data in the ordinal display sub-domain of the next ordered domain in a second state.
In the embodiment shown in fig. 7A, while a user edits one ordered domain, the ordinal indication data corresponding to the next ordered domain is generated and displayed in the ordinal display sub-domain corresponding to the ordered domain in the second state, so that the user can select the editable ordered domain to perform data input operation according to the display state of the ordinal indication data, the data collection process is more ordered, and the risk of data confusion is reduced.
Referring to fig. 7B, an embodiment of the present application further provides a data input control method, including the following steps:
and S711, modifying the ordinal number indicating data of the target ordered domain from the second state to the first state in response to the data input operation aiming at the data input sub-domain in the target ordered domain.
And S712, if it is determined that the next ordered domain arranged behind the target ordered domain does not have corresponding ordinal indicator data, generating corresponding ordinal indicator data for a preset number of ordered domains arranged behind the target ordered domain according to a set ordering rule, and displaying the ordinal indicator data in an ordinal display sub-domain of the ordered domain in a second state.
For example, when the predetermined number is 5, the corresponding ordinal indicator data is generated for 5 ordered fields at a time.
In specific implementation, if it is determined that the next ordered domain arranged after the target ordered domain has corresponding ordered bit indication data, it is not necessary to generate the ordered bit indication data.
In the embodiment shown in fig. 7B, when a user edits one ordered domain, if there is no corresponding ordinal indication data in the next ordered domain, a preset number of ordered domains are generated to generate corresponding ordinal indication data, and the data is displayed in the ordinal display sub-domain corresponding to the ordered domain in the second state, so that the user can select an editable ordered domain to perform data input operation according to the display state of the ordinal indication data, thereby making the data collection process more orderly and reducing the risk of data confusion. In addition, when the number of online collaborators is large, the possibility of simultaneous operation of multiple users is high, multiple users can select one of the ordered domains displaying the ordinal indication data in the second state for editing, and the probability that the multiple users select the same ordered domain for editing at the same time is reduced.
On the basis of any one of the above embodiments, the rank display subdomains and the corresponding set ranking rules in the document may be determined by any one of the following ways:
first, the user can designate an order display sub-domain in an ordered domain of a document upon creation of the document, and designate an order to display a set sort rule satisfied by order indication data in the sub-domain.
Referring to fig. 4, taking an excel table as an example, when a user creates the table, a first column of cells in the table may be selected as an ordinal level display sub-field, at this time, each line in the table is an ordered domain, each cell in the first column is an ordinal level display sub-field, for example, a cell in a first row and a first column is an ordinal level display sub-field of a first ordered domain, and a cell in a second row and a first column is an ordinal level display sub-field of a second ordered domain. Then, the user may designate a corresponding set ordering rule for the sequence display sub-field, and then may automatically generate the sequence indication data of each row of the sequence display sub-field according to the set ordering rule, for example, if the set ordering rule is "1, 2, and 3 …", that is, the values are sequentially incremented by 1, the sequence indication data of the first row of the sequence display sub-field is 1, the sequence indication data of the second row of the sequence display sub-field is 2, and the sequence indication data of the third row of the sequence display sub-field is 3.
In specific implementation, after a user designates a sorting order display subdomain, a sorting rule setting window can be displayed on an operation interface, a plurality of selectable sorting rules are listed in the sorting rule setting window, and the user can select one of the sorting rules as a set sorting rule. Referring to fig. 4, when a user inputs data in the third row, the ordinal number indicating data "3" is displayed in the first state in the third row and the first column, so that the user does not need to edit the cells in the first column, which not only improves the processing efficiency, but also reduces the risk of data confusion caused by simultaneous operation of a plurality of users.
In the second way, if the user does not specify the set ordering rule corresponding to the rank display sub-domain when creating the document, the execution subject (terminal device or server) may determine the ordering rule according to the data that the user has input in a plurality of consecutive rank display sub-domains, and use the determined ordering rule as the set ordering rule corresponding to the rank display sub-domain.
Taking fig. 4 as an example, assuming that when creating a document, a user selects a first column cell in the table as a rank display sub-domain, but does not specify a set sort rule, the user creating the document may input "1" in the first row and the first column and "2" in the second row and the first column, and the execution subject may determine that the set sort rule is "1, 2, 3 …" from data in the first row and the first column and the second row and the first column.
In practical application, it belongs to the prior art to determine a sort rule according to data in a plurality of continuous cells, for example, a method for determining a sort rule according to data in a plurality of continuous cells is adopted in a method for automatically generating serial numbers in subsequent cells in batches through manual dragging in an excel table, and details are not repeated here.
In the third mode, if the user does not specify the rank display sub-domain nor set the ranking rule when creating the document, the execution subject (terminal device or server) may use a row or a column of cells having the ranking rule as the rank display sub-domain according to the data that the user has input, and use the determined ranking rule as the set ranking rule corresponding to the rank display sub-domain.
Specifically, referring to fig. 8, the rank display subdomain in a document and the set sort rules may be determined as follows:
s801, responding to data input operation of an ordered domain which does not contain the order indication data, judging whether the input data contains characters which represent sorting, if so, executing step S802, otherwise, executing step S804.
In this application, characters representing a rank include, but are not limited to, numbers (including arabic numbers, roman numerals), letters, dates, months, weeks, and the like.
S802, judging whether a sorting rule exists according to the input data and the data in at least one ordered domain adjacent to the ordered domain, if so, executing a step S803, otherwise, executing a step S804.
And S803, marking the row or column where the continuous cells meeting the sorting rule are positioned as a sequence display subdomain, and determining the sorting rule as a set sorting rule.
In this embodiment, the data in the cells marked as the ordinal display sub-field may be marked as ordinal indication data, and the data in the cells not marked as the ordinal display sub-field may be processed as normal text.
In specific implementation, if it is determined that the data in a plurality of continuous cells in a column conforms to the sorting rule, the cells in the column are marked as order display sub-fields, and accordingly, in the subsequent processing process, one order field corresponds to one row in the table. If the data in a plurality of continuous cells in a row are determined to accord with the sorting rule, the cells in the row are marked as order display sub-fields, and correspondingly, in the subsequent processing process, one order field corresponds to one column in the table.
S804, determining that no sorting rule is detected, and waiting for the next data input operation.
The method is explained by taking a table as an example, assuming that a user does not specify a sequence display sub-domain nor a set sequencing rule when creating a document, when the user inputs '1' in a first row and a first column of cells C11, responding to the data input operation, detecting that no sequencing rule exists in data in cells adjacent to the left, the right, the top and the bottom of the cell C11, and waiting for data input by the user next time; when the user inputs "2" in the cell C21 in the first column of the second row, and it is detected that there is a sort rule "1, 2, 3 …" in the data in the adjacent cell C11 and cell C21, the first column is marked as the ordinal display sub-field, the sort rule "1, 2, 3 …" is taken as the set sort rule, and the data in the cell C11 and cell C21 is marked as ordinal indication data. Subsequently, based on the determined sorting rule "1, 2, 3 …", the rank indication data corresponding to the rank display sub-field (e.g., cell C31, cell C41, etc.) after cell C21 is generated.
In specific implementation, a document creator may input data meeting a certain sort rule into a plurality of consecutive cells in a document, and a terminal device or a server may determine, based on the method shown in fig. 8, a row or a column corresponding to a sequential display sub-domain, and set the sort rule. In the online collaboration document scenario, after a plurality of users manually input data, the server may determine, based on the method shown in fig. 8, a row or a column corresponding to the rank display sub-domain according to the data in the online collaboration document, and set a ranking rule.
On the basis of any one of the above embodiments, the method in the embodiments of the present application further includes the steps of: when the data input operation is an input operation in the ordinal display sub-field, data input for the ordinal display sub-field in the target ordered field is displayed in the ordinal display sub-field of the target ordered field.
In specific implementation, a user can manually input data in the sequence display sub-domain of the target ordered domain according to requirements, at this time, if the data input by the user is different from the sequence indication data corresponding to the target ordered domain, the user does not want to use the sequence indication data generated according to the set ordering rule, the generation of the sequence indication data for the subsequent ordered domain can be terminated, and if the sequence indication data for the subsequent ordered domain has been generated, the generation of the sequence indication data for the subsequent ordered domain can be cleared. In an embodiment of the application, the subsequent ordered domain is an ordered domain arranged after the target ordered domain and containing the ordinal indicator data. Specifically, the ordinal indication data in the ordinal display sub-field of a subsequent ordered field may be deleted; or the sequence indication data in the sequence display sub-domain of the subsequent ordered domain is marked as a common text, namely the data displayed in the sequence display sub-domain of the subsequent ordered domain is unchanged; or marking the ordinal level indicating data displayed in the first state in the ordinal level display sub-field of the subsequent ordered domain as a common text, and deleting the ordinal level indicating data displayed in the second state, so that the data displayed in the ordinal level display sub-field of the ordered domain edited by the user is unchanged, and the ordinal level indicating data in the ordinal level display sub-field of the ordered domain not edited by the user can disappear.
On this basis, referring to fig. 9A, an embodiment of the present application further provides a data input control method, including the following steps:
s901, responding to the data input operation aiming at the sequence display sub-field in the target ordered domain, and displaying the data input aiming at the sequence display sub-field in the target ordered domain into the sequence display sub-field of the target ordered domain.
And S902, judging whether the data input by the sequential display subdomain in the target sequential domain is the same as the sequential indication data corresponding to the target sequential domain, if so, executing the step S903, and otherwise, not executing the step S903.
And S903, generating corresponding ordinal indicator data for the next ordered domain arranged behind the target ordered domain according to the set ordering rule, and displaying the ordinal indicator data in an ordinal display sub-domain of the next ordered domain in a second state.
Referring to fig. 9B, an embodiment of the present application further provides a data input control method, including the following steps:
and S911, responding to the data input operation aiming at the ordinal display sub-field in the target ordered domain, and displaying the data input aiming at the ordinal display sub-field in the target ordered domain into the ordinal display sub-field of the target ordered domain.
S912, determining whether the data input to the sequential display sub-field of the target sequential field is the same as the sequential indication data corresponding to the target sequential field, if yes, performing step S913, and if no, not performing step S913.
S913, determining whether the next ordered domain arranged behind the target ordered domain has corresponding ordinal indicator data, if not, performing step S914, otherwise, not performing step S914.
S914, generating corresponding sequence indicating data for a preset number of ordered domains arranged behind the target ordered domain according to the set ordering rule, and displaying the sequence indicating data in a sequence displaying sub-domain of the ordered domain in a second state.
Referring to fig. 10, taking filling in the entry form online as an example, when the 4 th user "liu can write information in the online collaboration form, the corresponding ordinal indicator data" 5 "may be displayed in the cell in the fifth row and the first column (i.e., the ordinal display sub-field in the fifth row) according to the set sorting rule. At this time, if the creator of the form considers that the number of entries is sufficient, "enough number of persons" can be filled in the cell in the first column of the fifth row, and it is obvious that "enough number of persons" filled by the creator is different from the ordinal indication data "5", the generation of ordinal indication data for the subsequent ordered fields is terminated, that is, the ordinal indication data "6" is not displayed in the cell in the first column of the sixth row. If the corresponding ordinal position indicating data are displayed in the sixth line and even a plurality of lines after the sixth line, the ordinal position indicating data displayed in the sixth line and thereafter may be deleted.
Based on the above embodiment, the user can manually terminate the function of automatically generating the ordinal indicator data by inputting the contents which do not accord with the sorting rule in the ordinal display sub-domain according to the actual requirement, so as to give corresponding prompts to other users in the online collaboration process, so as to guide other users to complete data input more orderly.
On this basis, before the ordinal number indicating data generated for the target ordered domain in advance is displayed in the ordinal number display sub-domain of the target ordered domain in the first state, the method of the embodiment of the application further comprises the following steps: and confirming the data in the ordinal display sub-field of the last ordered field arranged before the target ordered field as ordinal indication data.
Specifically, referring to fig. 11A, an embodiment of the present application further provides a data input control method, including the following steps:
s1101, responding to the data input operation of the data input sub-field in the target ordered domain, judging whether the data in the ordered bit display sub-field of the previous ordered domain arranged in front of the target ordered domain is ordered bit indicating data, if so, executing the step S1102, and if not, not executing the step S1102.
And S1102, modifying the sequence bit indicating data of the target ordered domain from the second state to the first state.
The method shown in FIG. 11A may further include the steps of: and S1103, generating corresponding ordinal indicator data for the next ordered domain arranged behind the target ordered domain according to the set ordering rule, and displaying the ordinal indicator data in an ordinal display sub-domain of the next ordered domain in a second state.
Referring to fig. 11B, an embodiment of the present application further provides a data input control method, including the following steps:
s1111, in response to the data input operation for the data input sub-field in the target ordered domain, determining whether the data in the ordinal display sub-field of the previous ordered domain arranged before the target ordered domain is ordinal indicator data, if so, performing step S1112, otherwise, not performing step S1112.
S1112, modifying the order bit indication data of the target ordered domain from the second state to the first state.
S1113, judging whether the next ordered domain arranged behind the target ordered domain has corresponding ordinal order indicating data, if not, executing the step S1114, otherwise, not executing the step S1114.
And S1114, generating corresponding ordinal indicator data for a preset number of ordered domains arranged behind the target ordered domain according to the set ordering rule, and displaying the ordinal indicator data in an ordinal display sub-domain of the ordered domain in a second state.
On the basis of any one of the above embodiments, the method in the embodiments of the present application further includes the steps of: and updating the ordinal number indication data in the ordinal number display sub-domain of the subsequent ordinal number domain according to the set ordering rule and the position sequence of the subsequent ordinal number domain after the deletion operation in response to the deletion operation aiming at the ordinal number domain containing the ordinal number indication data. Wherein the subsequent ordered domain is an ordered domain containing the ordinal indicator data arranged after the deleted ordered domain.
Taking the table in fig. 12 as an example, the user performs a delete operation on the row data with the serial number 4, and after deleting the row with the serial number 4, the ordinal number indication data in the remaining ordinal number display sub-fields are 1, 2, 3, 5, 6, and 7 from top to bottom, and according to the set sort rule, the ordinal number indication data in the ordinal number display sub-fields of the subsequent ordinal number fields (i.e., the rows corresponding to the serial numbers 5, 6, and 7) are updated, and the ordinal number indication data in the rows corresponding to the serial numbers 5, 6, and 7 are updated to 4, 5, and 6, respectively.
On the basis of any one of the above embodiments, the method of the embodiment of the present application further includes the steps of: responding to the moving operation of the ordered domain containing the ordered domain indicating data, and judging whether the data in the ordered domain display sub-domain adjacent to the moved ordered domain after the moving operation is executed is the ordered domain indicating data; if so, updating the sequence indication data in the sequence display sub-domain of each sequence domain according to the set sequencing rule and the position sequence of each sequence domain after the moving operation is carried out; if not, updating the ordinal indicator data in ordinal display sub-domains of other ordinal domains according to the set ordering rule and the position sequence of other ordinal domains except the moved ordinal domain after the moving operation.
In a specific implementation, when the data in the ordinal display sub-domain of the ordinal field adjacent to the moved ordinal field after the moving operation is executed is ordinal indication data, if the position of the moved ordinal field is before the position before the moving, the ordinal indication data in the ordinal display sub-domains of the moved ordinal field and the subsequent ordinal field can be updated only from the position of the moved ordinal field; if the position after the movement of the moved ordered domain is after the position before the movement, the order indication data in the order display sub-domain of the subsequent ordered domain can be updated only from the position before the movement of the moved ordered domain.
Taking the table in fig. 13 as an example, when the user moves the row with the serial number 6 between the row with the serial number 3 and the row with the serial number 4, the serial numbers in the sequence number column of the table from top to bottom are: 1. 2, 3, 6, 4, 5, 7, and sequentially updating the sequence numbers in the rows after the row with the sequence number 3 to 4, 5, 6, 7 according to the set sort rule.
In a specific implementation, when the data in the ordinal display sub-field of the ordinal field adjacent to the moved ordinal field after the moving operation is performed is not the ordinal indication data, the ordinal indication data in the ordinal display sub-field of the subsequent ordinal field can be updated only from the position where the moved ordinal field is located before the moving, and the ordinal indication data in the ordinal display sub-field of the moved ordinal field does not need to be updated.
Taking the table in fig. 14 as an example, the user moves the row with the sequence number 4 to the blank row in the table, and at this time, the sequence numbers from top to bottom in the sequence number column of the table are: 1. 2, 3, 5, no sequence indication data exists in the next row of the row with the sequence number 5, and no sequence indication data exists in the previous row and the next row of the row with the sequence number 4 after the movement, the sequence number "5" after the row with the sequence number 3 is updated to 4 only according to the set ordering rule, and meanwhile, the sequence number "4" in the moved row is kept unchanged.
The data input control method in any of the above embodiments can be applied to domain common documents or online collaboration documents.
Referring to fig. 15, an embodiment of the present application further provides a data input control method applied to an online collaboration table, including the following steps:
s1501, a data input operation in response to the data input sub-field for a target ordered field of the at least two ordered fields.
The ordered domain is a row or a column in the online collaboration table, and the target ordered domain is a column or a row currently being edited by the user. The sequence display sub-field is a cell for displaying sequence indication data in the online collaboration table, and the data input sub-field is other cells except the sequence display sub-field in the online collaboration table.
S1502, displaying the ordinal indicator data generated for the target ordered domain in advance to an ordinal display sub-field of the target ordered domain in a first state.
The specific implementation of step S1501 and step S1502 can refer to step S301 and step S302, and will not be described again.
Further, the ordinal indication data corresponding to one or more ordered fields can be generated at a time according to the set ordering rule. For a specific embodiment, refer to fig. 5A and 5B, which are not described again.
According to the data input control method applied to the online collaboration table, the sequence indicating data can be automatically generated for the user in the document editing process of the user, the user is assisted to quickly and accurately complete data input, the user can be guided to orderly input data through the automatically generated sequence indicating data, and the risk that data is disordered easily due to multi-user operation in an online collaboration scene is reduced.
Further, the data input control method applied to the online collaboration table in the embodiment of the present application further includes the following steps: the data input operation authority of the target ordered field is assigned to the user who performs the data input operation in step S1501.
In specific implementation, while the ordinal indication data corresponding to the target ordered domain is displayed in the ordinal display sub-domain of the target ordered domain in the first state, the user ID of the user can be associated with the target ordered domain, that is, only the user associated with the target ordered domain can perform the data input operation on the target ordered domain, so that the assignment of the data input operation authority is completed. After the association between the target ordered domain and the user ID is completed, if the data input operation aiming at the target ordered domain is detected, whether the user ID of the user executing the data input operation is the same as the user ID associated with the target ordered domain is detected, if so, the data input operation is executed, and if not, the data input operation is forbidden. Therefore, in the process of editing the online collaborative document, the user can be allocated with the data input operation authority of the ordered domain which is edited by the user, namely, the ordered domain which is edited by the user can be locked, only the user can edit the ordered domain, and the risk of data disorder caused by multi-user operation is further reduced.
Further, if another user attempts to edit an ordered field configured in a locked state, a prompt may be displayed in the other user's document that the ordered field has been locked.
Further, after the user associated with a certain ordered domain finishes editing the ordered domain, the user ID associated with the ordered domain may be cleared, that is, the ordered domain is in an editable state, but not in a locked state, and at this time, other users may edit the ordered domain.
By the method for distributing the data input operation authority, the ordered domain which is edited by the user can be locked in the process of editing the online collaborative document, only one user can edit the target ordered domain, and the risk of data disorder caused by multi-user operation is further reduced.
In addition to any of the above embodiments, the generated ordinal position indication data may be displayed in a second state in the ordinal position display sub-field corresponding to the ordinal position field, the second state indicating that the data input sub-field of the ordinal position field is in an editable state, and the first state indicating that the data input sub-field of the ordinal position field is in a locked state. Correspondingly, step S1501 specifically includes: the ordinal position indication data of the target ordered field is modified from the second state to the first state in response to a data input operation for the data input sub-field in the target ordered field. Reference is made to fig. 7A and 7B for a specific embodiment.
Therefore, in the process of editing the online collaboration table, each user can select an editable ordered field to perform data input operation according to the display state of the order indicating data, so that the data collection process is more ordered, and the risk of data disorder is reduced.
On the basis of any one of the above embodiments, the data input control method applied to the online collaboration table in the embodiment of the present application further includes the following steps: and displaying the data input for the ordinal order display sub-field in the target ordered domain into the ordinal order display sub-field of the target ordered domain in response to the data input operation for the ordinal order display sub-field in the target ordered domain. Reference is made to fig. 9A and 9B for a specific embodiment.
On the basis of any of the foregoing embodiments, before displaying the ordinal number indication data generated in advance for the target ordered domain into the ordinal number display sub-domain of the target ordered domain in the first state, the data input control method applied to the online collaboration table in the embodiment of the present application further includes the following steps: and confirming the data in the ordinal display sub-field of the last ordered field arranged before the target ordered field as ordinal indication data. Reference may be made to the method illustrated in fig. 11A and 11B for a specific embodiment.
On the basis of any one of the above embodiments, the data input control method applied to the online collaboration table in the embodiment of the present application further includes the following steps: and updating the ordinal number indication data in the ordinal number display sub-domain of the subsequent ordinal number domain according to the set ordering rule and the position sequence of the subsequent ordinal number domain after the deletion operation in response to the deletion operation aiming at the ordinal number domain containing the ordinal number indication data.
On the basis of any one of the above embodiments, the data input control method applied to the online collaboration table in the embodiment of the application further includes the following steps: responding to the moving operation of the ordered domain containing the ordered domain indicating data, and judging whether the data in the ordered domain display sub-domain adjacent to the moved ordered domain after the moving operation is executed is the ordered domain indicating data; if so, updating the sequence indication data in the sequence display sub-domain of each sequence domain according to the set sequencing rule and the position sequence of each sequence domain after the moving operation is carried out; if not, updating the ordinal indicator data in ordinal display sub-domains of other ordinal domains according to the set ordering rule and the position sequence of other ordinal domains except the moved ordinal domain after the moving operation.
The specific implementation of the data input control method applied to the online collaboration table provided in the embodiment of the present application may refer to the data input control method in any of the above implementation manners, and is not described in detail again.
As shown in fig. 16, based on the same inventive concept as the data input control method, the embodiment of the present application further provides a data input control device 160, which includes a response module 1601 and an order display module 1602.
A response module 1061, configured to respond to a data input operation for a target ordered domain of the at least two ordered domains, wherein the at least two ordered domains are arranged in sequence, and each ordered domain includes an order display sub-domain for displaying order indication data and at least one data input sub-domain for displaying input data.
The ordinal display module 1062 is configured to, when the data input operation is an input operation in the data input sub-domain, display ordinal indication data previously generated for the target ordinal domain into an ordinal display sub-domain of the target ordinal domain.
Optionally, the data input control device 160 further comprises a permission configuration module, which is used for allocating the data input operation permission of the target ordered domain to the user performing the data input operation.
Optionally, the ordinal display module 1601 is further configured to generate corresponding ordinal indication data for at least one ordered field arranged after the target ordered field according to a set sorting rule, and display the ordinal indication data in an ordinal display sub-field of the ordered field in a second state.
Accordingly, the ordinal position display module 1601 is specifically configured to modify the ordinal position indication data of the target ordinal position field from the second state to a first state, where the first state indicates that the data input operation authority of the ordinal position field has been assigned to the user performing the data input operation.
Optionally, the ordinal position display module 1601 is further configured to display data input to the ordinal position display sub-field of the target ordered domain into the ordinal position display sub-field of the target ordered domain when the data input operation is an input operation in the ordinal position display sub-field; and confirming that data arranged in an order display sub-domain of a previous ordered domain of the target ordered domain is order indication data before displaying the order indication data generated for the target ordered domain in advance in a first state into an order display sub-domain of the target ordered domain.
Optionally, the data input control device further includes a deletion module, configured to update the ordinal level indication data in the ordinal level display sub-domain of the subsequent ordinal level domain according to a set sorting rule and a position order of the subsequent ordinal level domain after the deletion operation in response to the deletion operation for the ordinal level indication data-containing ordinal level domain, where the subsequent ordinal level domain is the ordinal level indication data-containing ordinal level domain arranged after the deleted ordinal level domain.
Optionally, the data input control device 160 further includes a deleting module, configured to update the ordinal number indication data in the ordinal number display sub-field of the subsequent ordinal number field according to the set sorting rule and the position sequence of the subsequent ordinal number field after the deleting operation in response to the deleting operation for the ordinal number field containing the ordinal number indication data, where the subsequent ordinal number field is the ordinal number field containing the ordinal number indication data and arranged after the deleted ordinal number field.
Optionally, the data input control device 160 further comprises a movement module for:
responding to the moving operation of the ordered domain containing the ordered domain indicating data, and judging whether the data in the ordered domain display sub-domain adjacent to the moved ordered domain after the moving operation is executed is the ordered domain indicating data;
if so, updating the sequence indication data in the sequence display sub-domain of each sequence domain according to the set sequencing rule and the position sequence of each sequence domain after the moving operation is carried out;
if not, updating the ordinal indicator data in ordinal display sub-domains of other ordinal domains according to the set ordering rule and the position sequence of other ordinal domains except the moved ordinal domain after the moving operation.
The data input control device and the data input control method provided by the embodiment of the application adopt the same inventive concept, can obtain the same beneficial effects, and are not repeated herein.
Based on the same inventive concept as the data input control method, the embodiment of the present application further provides an electronic device, which may be specifically a desktop computer, a portable computer, a smart phone, a tablet computer, a Personal Digital Assistant (PDA), a server, and the like. As shown in fig. 17, the electronic device 170 may include a processor 1701 and a memory 1702.
The Processor 1701 may be a general-purpose Processor, such as a Central Processing Unit (CPU), a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic device, discrete hardware components, and may implement or perform the methods, steps, and logic blocks disclosed in the embodiments of the present Application. A general purpose processor may be a microprocessor or any conventional processor or the like. The steps of a method disclosed in connection with the embodiments of the present application may be directly implemented by a hardware processor, or may be implemented by a combination of hardware and software modules in a processor.
Memory 1702 is provided as a non-volatile computer-readable storage medium that may be used to store non-volatile software programs, non-volatile computer-executable programs, and modules. The Memory may include at least one type of storage medium, and may include, for example, a flash Memory, a hard disk, a multimedia card, a card-type Memory, a Random Access Memory (RAM), a Static Random Access Memory (SRAM), a Programmable Read Only Memory (PROM), a Read Only Memory (ROM), a charged Erasable Programmable Read Only Memory (EEPROM), a magnetic Memory, a magnetic disk, an optical disk, and so on. The memory is any other medium that can be used to carry or store desired program code in the form of instructions or data structures and that can be accessed by a computer, but is not limited to such. The memory 1702 of the embodiments of the present application may also be circuitry or any other device capable of performing a storage function for storing program instructions and/or data.
Embodiments of the present application provide a computer-readable storage medium for storing computer program instructions for the electronic device, which includes a program for executing the data input control method.
The computer storage media may be any available media or data storage device that can be accessed by a computer, including but not limited to magnetic memory (e.g., floppy disks, hard disks, magnetic tape, magneto-optical disks (MOs), etc.), optical memory (e.g., CDs, DVDs, BDs, HVDs, etc.), and semiconductor memory (e.g., ROMs, EPROMs, EEPROMs, non-volatile memory (NAND FLASH), Solid State Disks (SSDs)), etc.
The above embodiments are only used to describe the technical solutions of the present application in detail, but the above embodiments are only used to help understanding the method of the embodiments of the present application, and should not be construed as limiting the embodiments of the present application. Modifications and substitutions that may be readily apparent to those skilled in the art are intended to be included within the scope of the embodiments of the present application.

Claims (13)

1. A data input control method, comprising:
responding to a data input operation for a target ordered domain of at least two ordered domains, wherein the at least two ordered domains are arranged in sequence, each ordered domain comprises an order display sub-domain for displaying order indication data and at least one data input sub-domain for displaying input data;
and when the data input operation is an input operation in the data input sub-domain, displaying the ordinal indicator data generated for the target ordered domain in advance into the ordinal display sub-domain of the target ordered domain.
2. The method of claim 1, further comprising:
and distributing the data input operation authority of the target ordered domain to a user executing the data input operation.
3. The method of claim 2, further comprising:
generating corresponding ordinal indicator data for at least one ordered domain arranged behind the target ordered domain according to a set ordering rule, and displaying the ordinal indicator data in an ordinal display sub-domain of the ordered domain in a second state;
the displaying the ordinal number indicating data generated for the target ordered domain in advance to the ordinal number display sub-domain of the target ordered domain in a first state specifically includes:
and modifying the order indication data of the target ordered domain from the second state to a first state, wherein the first state indicates that the data input operation authority of the ordered domain is distributed to a user executing the data input operation.
4. The method of claim 1, further comprising:
when the data input operation is an input operation in the sequence display subdomain, displaying data input aiming at the sequence display subdomain in the target sequence domain into the sequence display subdomain of the target sequence domain; and
before displaying the ordinal number indicating data generated for the target ordered domain in advance in the ordinal number display sub-domain of the target ordered domain in the first state, the method further comprises:
and confirming the data arranged in the ordinal position display sub-field of the last ordinal position of the target ordinal position field as ordinal position indication data.
5. The method of any of claims 1 to 4, further comprising:
and in response to the deletion operation of the ordered domain containing the ordered bit indication data, updating the ordered bit indication data in the ordered bit display sub-domain of the subsequent ordered domain according to the set sorting rule and the position sequence of the subsequent ordered domain after the deletion operation, wherein the subsequent ordered domain is the ordered domain containing the ordered bit indication data arranged after the deleted ordered domain.
6. The method of any of claims 1 to 4, further comprising:
responding to the moving operation of the ordered domain containing the ordered domain indicating data, and judging whether the data in the ordered domain display sub-domain adjacent to the moved ordered domain after the moving operation is executed is the ordered domain indicating data;
if so, updating the sequence indication data in the sequence display sub-domain of each sequence domain according to the set sequencing rule and the position sequence of each sequence domain after the moving operation is carried out;
and if not, updating the ordinal indicator data in ordinal display sub-domains of other ordinal domains according to the set ordering rule and the position sequence of other ordinal domains except the moved ordinal domain after the moving operation.
7. A data input control method applied to an online collaboration form is characterized in that each row or each column in the online collaboration form is an ordered domain, a cell for displaying order indication data in the online collaboration form is an order display sub-domain, and other cells except the order display sub-domain in the online collaboration form are data input sub-domains;
the method comprises the following steps: the method of any of claims 1-6, controlling data entered into the online collaboration form.
8. A data input control device, comprising:
a response module for responding to a data input operation for a target ordered domain of at least two ordered domains, wherein the at least two ordered domains are arranged in sequence, each ordered domain comprises an order display sub-domain for displaying order indication data and at least one data input sub-domain for displaying input data;
and the ordinal display module is used for displaying ordinal indication data which is generated for the target ordered domain in advance into an ordinal display subdomain of the target ordered domain when the data input operation is an input operation in a data input subdomain.
9. The apparatus of claim 8, further comprising a permission configuration module configured to assign a permission for a data entry operation of the target ordered domain to a user performing the data entry operation.
10. The apparatus according to claim 9, wherein the ordinal display module is further configured to generate corresponding ordinal indication data for at least one ordered field arranged after the target ordered field according to a set sorting rule, and display the ordinal indication data in the ordinal display sub-field of the ordered field in the second state;
the ordinal display module is specifically configured to modify ordinal indication data of the target ordered domain from a second state to a first state, where the first state indicates that a data input operation authority of the ordered domain has been assigned to a user performing the data input operation.
11. The apparatus of claim 8, wherein the ordinal display module is further configured to display the data input for the ordinal display sub-field of the target ordinal field into the ordinal display sub-field of the target ordinal field when the data input operation is an input operation in the ordinal display sub-field; and confirming that data arranged in an ordinal display sub-domain of a previous ordinal domain of the target ordinal domain is ordinal indication data before displaying the ordinal indication data generated for the target ordinal domain in advance in a first state into the ordinal display sub-domain of the target ordinal domain.
12. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the steps of the method of any of claims 1 to 7 are implemented when the computer program is executed by the processor.
13. A computer-readable storage medium having computer program instructions stored thereon, which, when executed by a processor, implement the steps of the method of any one of claims 1 to 7.
CN201911048115.7A 2019-10-30 2019-10-30 Data input control method and device, electronic equipment and storage medium Active CN112749533B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201911048115.7A CN112749533B (en) 2019-10-30 2019-10-30 Data input control method and device, electronic equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201911048115.7A CN112749533B (en) 2019-10-30 2019-10-30 Data input control method and device, electronic equipment and storage medium

Publications (2)

Publication Number Publication Date
CN112749533A true CN112749533A (en) 2021-05-04
CN112749533B CN112749533B (en) 2023-08-04

Family

ID=75640977

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201911048115.7A Active CN112749533B (en) 2019-10-30 2019-10-30 Data input control method and device, electronic equipment and storage medium

Country Status (1)

Country Link
CN (1) CN112749533B (en)

Citations (15)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2008015874A (en) * 2006-07-07 2008-01-24 Pioneer Electronic Corp Data editing system, server device, client device and program
US7949633B1 (en) * 2008-05-12 2011-05-24 Adobe Systems Incorporated Shared edit access of electronic content
US20130117714A1 (en) * 2011-11-03 2013-05-09 Microsoft Corporation List-based interactivity features as part of modifying list data and structure
US20130205203A1 (en) * 2012-02-07 2013-08-08 International Business Machines Corporation Transient, real-time position tracking interface for user activity in a document editing application
US20140282078A1 (en) * 2013-03-14 2014-09-18 Quip, Inc. Systems and methods for concurrent online and offline document processing
US20150100503A1 (en) * 2013-10-04 2015-04-09 Clique Intelligence Systems and methods for enterprise management using contextual graphs
US9292482B1 (en) * 2015-04-30 2016-03-22 Workiva Inc. System and method for convergent document collaboration
CN106874250A (en) * 2017-02-15 2017-06-20 中车株洲电机有限公司 A kind of automatic operation method and system based on word domains
EP3230894A1 (en) * 2014-12-11 2017-10-18 Liveloop, Inc. Blended operational transformation for multi-user collaborative applications
CN108460055A (en) * 2017-02-22 2018-08-28 北京京东尚科信息技术有限公司 Export method, system, equipment and the storage medium of excel tables of data
CN108549623A (en) * 2018-04-12 2018-09-18 北京三快在线科技有限公司 Collaborative document editing control method, device, electronic equipment and storage medium
CN109241074A (en) * 2018-09-28 2019-01-18 中国平安财产保险股份有限公司 Check data automatic processing method, device, computer equipment and storage medium
KR101950422B1 (en) * 2017-08-10 2019-02-20 (주)사이냅소프트 Document editing system and method for collaborative editing that supports setting edit permission
CN110019279A (en) * 2019-04-11 2019-07-16 北京字节跳动网络技术有限公司 Collaboration update method, device, equipment and the storage medium of online document
CN110020328A (en) * 2019-04-16 2019-07-16 北京字节跳动网络技术有限公司 Data processing method, device, electronic equipment and the storage medium of online table

Patent Citations (15)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2008015874A (en) * 2006-07-07 2008-01-24 Pioneer Electronic Corp Data editing system, server device, client device and program
US7949633B1 (en) * 2008-05-12 2011-05-24 Adobe Systems Incorporated Shared edit access of electronic content
US20130117714A1 (en) * 2011-11-03 2013-05-09 Microsoft Corporation List-based interactivity features as part of modifying list data and structure
US20130205203A1 (en) * 2012-02-07 2013-08-08 International Business Machines Corporation Transient, real-time position tracking interface for user activity in a document editing application
US20140282078A1 (en) * 2013-03-14 2014-09-18 Quip, Inc. Systems and methods for concurrent online and offline document processing
US20150100503A1 (en) * 2013-10-04 2015-04-09 Clique Intelligence Systems and methods for enterprise management using contextual graphs
EP3230894A1 (en) * 2014-12-11 2017-10-18 Liveloop, Inc. Blended operational transformation for multi-user collaborative applications
US9292482B1 (en) * 2015-04-30 2016-03-22 Workiva Inc. System and method for convergent document collaboration
CN106874250A (en) * 2017-02-15 2017-06-20 中车株洲电机有限公司 A kind of automatic operation method and system based on word domains
CN108460055A (en) * 2017-02-22 2018-08-28 北京京东尚科信息技术有限公司 Export method, system, equipment and the storage medium of excel tables of data
KR101950422B1 (en) * 2017-08-10 2019-02-20 (주)사이냅소프트 Document editing system and method for collaborative editing that supports setting edit permission
CN108549623A (en) * 2018-04-12 2018-09-18 北京三快在线科技有限公司 Collaborative document editing control method, device, electronic equipment and storage medium
CN109241074A (en) * 2018-09-28 2019-01-18 中国平安财产保险股份有限公司 Check data automatic processing method, device, computer equipment and storage medium
CN110019279A (en) * 2019-04-11 2019-07-16 北京字节跳动网络技术有限公司 Collaboration update method, device, equipment and the storage medium of online document
CN110020328A (en) * 2019-04-16 2019-07-16 北京字节跳动网络技术有限公司 Data processing method, device, electronic equipment and the storage medium of online table

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
AGFHO62266: "多人共同在线文档协同编辑的技术实现", Retrieved from the Internet <URL:https://blog.csdn.net/agfho62266/article/details/101435379> *
李林;曾广周;: "一种扩展单用户应用程序实现协同编辑的方法", 计算机应用, no. 11 *

Also Published As

Publication number Publication date
CN112749533B (en) 2023-08-04

Similar Documents

Publication Publication Date Title
EP2564325B1 (en) Temporary formatting and charting of selected data
JP4896444B2 (en) Method, apparatus, and computer-readable medium for managing specific types of content within an electronic document
CN102915297B (en) The animation of underlying network lattice structure and table
US20140181627A1 (en) Electronic document style matrix
US20070126741A1 (en) Techniques for automated animation
EP3314460A1 (en) Visualizing document revisions
US20140208203A1 (en) Key-Frame based Authoring and Generation of Highly Resizable Document Layout
CN103530220A (en) Display method and system and terminal for application program icons
CN109408752A (en) Online document methods of exhibiting, device and electronic equipment
EP3230895A1 (en) Presentation of content from within spreadsheet application
US20180253218A1 (en) System and method for controlling the retention of data on computing devices according to user settings
WO2020151446A1 (en) Method and device for setting mode of monitoring system
CN112654995A (en) Tracking content attribution in online collaborative electronic documents
WO2020186837A1 (en) Text animation control method and device, storage medium and processor
US8645820B2 (en) Method and apparatus for providing comb text field inputs on a mobile device
CN103117052A (en) Information processing apparatus, information processing method, and program
CN114239524A (en) Questionnaire generation method, questionnaire generation device, computer equipment and storage medium
US20140156708A1 (en) Method and system for implementing an array using different data structures
CN112749533B (en) Data input control method and device, electronic equipment and storage medium
CN106713962A (en) Video display method and apparatus and terminal device
CN110619116A (en) Data processing method, device, terminal and storage medium
CN112632930B (en) Table data control method and device
WO2007132984A1 (en) Document editing program of tree-structure and method thereof
US9678937B2 (en) Single click in a partially protected cell of a table
CN107656908B (en) Method and system for implementing placeholder

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
REG Reference to a national code

Ref country code: HK

Ref legal event code: DE

Ref document number: 40043980

Country of ref document: HK

SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant