CN110826305A

CN110826305A - Data processing method and device for online form, terminal and server

Info

Publication number: CN110826305A
Application number: CN201910974859.5A
Authority: CN
Inventors: 王镇佳
Original assignee: Beijing ByteDance Network Technology Co Ltd
Current assignee: Beijing ByteDance Network Technology Co Ltd
Priority date: 2019-10-14
Filing date: 2019-10-14
Publication date: 2020-02-21

Abstract

The embodiment of the disclosure provides a data processing method, a device, a terminal and a server for an online form; the method comprises the following steps: acquiring data input aiming at a target cell in an online form; determining a data type corresponding to the data; sending the data and the corresponding data type to store the data to a data segment corresponding to the data type, wherein the data segment is contained in a data segment group corresponding to the target cell, and the data segment group comprises at least two data segments corresponding to different data types; presenting the target cell including the data; by the method and the device, data of different data types can be presented in one cell of the online table at the same time.

Description

Data processing method and device for online form, terminal and server

Technical Field

The embodiment of the disclosure relates to the internet technology, and in particular, to a data processing method and device for an online form, a terminal and a server.

Background

With the continuous update and development of internet technology, an online form established based on an internet platform is emerging, and the online form is a novel form which can be newly added and edited on the internet.

In the related art, a single cell in the online form only supports one type of data input (such as text data and hyperlinks), which greatly limits the data input of a user in the process of using the online form.

Disclosure of Invention

In view of this, the present disclosure provides a data processing method and apparatus for an online form, a terminal, and a server.

In a first aspect, an embodiment of the present disclosure provides a data processing method for an online form, including:

acquiring data input aiming at a target cell in an online form;

determining a data type corresponding to the data;

sending the data and the corresponding data type to store the data to a data segment corresponding to the data type, wherein the data segment is contained in a data segment group corresponding to the target cell, and the data segment group comprises at least two data segments corresponding to different data types;

presenting the target cell including the data.

In the foregoing scheme, the determining the data type corresponding to the data includes:

identifying data content of the data;

when identification data used for indicating the data type exists in the data content, determining that the data type indicated by the identification data is the data type corresponding to the data.

determining a data type corresponding to the data comprises at least one of the following data types: a text type characterizing a text attribute of the data, a link type characterizing a hyperlink attribute of the data.

In the above scheme, the method further comprises:

when detecting that a mouse pointer moves and the position of the mouse pointer corresponds to the target cell when the movement stops, determining the relative position relation between the mouse pointer and the target cell;

determining a data object corresponding to the mouse pointer in the data based on the relative position relation;

and presenting an editing bullet frame corresponding to the data object, wherein the editing bullet frame is used for performing data editing on the data object.

In the foregoing solution, the determining the relative position relationship between the mouse pointer and the target cell includes:

establishing a coordinate system corresponding to the target cell by taking the first vertex of the target cell as an origin;

acquiring a first offset value of the mouse pointer in a first coordinate system direction and a second offset value of the mouse pointer in a second coordinate system direction;

and determining the position of the mouse pointer on the target cell according to the first offset value and the second offset value.

In the foregoing solution, the determining, based on the relative position relationship, a data object corresponding to the mouse pointer in the data includes:

determining a target character corresponding to the position of the mouse pointer on the target cell according to the first offset value, the second offset value and the character width;

and determining a data object corresponding to the data segment where the target character is located, and determining the data object corresponding to the mouse pointer.

In the above solution, when the data type of the data object is a link type of a hyperlink attribute characterizing data, the method further includes:

and displaying a reference object corresponding to the data object, wherein the reference object is used for linking the data object to corresponding source data.

In the above scheme, the method further comprises:

receiving an editing operation performed on the data object based on the editing popup;

updating the data in the target cell based on the editing operation.

In a second aspect, an embodiment of the present disclosure provides a data processing method for an online form, including:

receiving a data storage request aiming at a target cell in an online table, wherein the data storage request carries data input aiming at the target cell and a corresponding data type;

analyzing the data storage request to obtain the data and the corresponding data type;

and storing the data to a data segment corresponding to the data type, wherein the data segment is contained in a data segment group corresponding to the target cell, and the data segment group comprises at least two data segments corresponding to different data types.

In the above scheme, the method further comprises:

and synchronizing the data to a target terminal so that the target terminal updates the data content in the target cell based on the data.

In a third aspect, an embodiment of the present disclosure provides a data processing apparatus for an online form, including:

the acquisition module is used for acquiring data input aiming at a target cell in the online form;

the determining module is used for determining the data type corresponding to the data;

a sending module, configured to send the data and the corresponding data type, so as to store the data in a data segment corresponding to the data type, where the data segment is included in a data segment group corresponding to the target cell, and the data segment group includes at least two data segments corresponding to different data types;

a presentation module to present the target cell including the data.

In the above solution, the determining module is configured to identify data content of the data;

In the foregoing scheme, the determining module is configured to determine that the data type corresponding to the data includes at least one of the following data types: a text type characterizing a text attribute of the data, a link type characterizing a hyperlink attribute of the data.

In the above scheme, the determining module is further configured to determine a relative position relationship between the mouse pointer and the target cell when it is detected that the mouse pointer moves and the position of the mouse pointer corresponds to the target cell when the movement stops;

the presentation module is further configured to present an edit popup box corresponding to the data object, where the edit popup box is used to perform data editing on the data object.

In the above solution, the determining module is configured to establish a coordinate system corresponding to the target cell with a first vertex of the target cell as an origin;

In the above scheme, the determining module is configured to determine, according to the first offset value, the second offset value, and the character width, a target character corresponding to the position of the mouse pointer on the target cell;

In the above scheme, the presentation module is further configured to display a reference object corresponding to the data object when the data type of the data object is a link type of a hyperlink attribute representing data, where the reference object is used for linking the data object to corresponding source data.

In the above solution, the updating module is configured to receive an editing operation performed on the data object based on the editing popup;

updating the data in the target cell based on the editing operation.

In a fourth aspect, an embodiment of the present disclosure provides a data processing apparatus for an online form, including:

the system comprises a receiving module, a data storage module and a data processing module, wherein the receiving module is used for receiving a data storage request aiming at a target cell in an online table, and the data storage request carries data input aiming at the target cell and a corresponding data type;

the analysis module is used for analyzing the data storage request to obtain the data and the corresponding data type;

and the storage module is used for storing the data to a data segment corresponding to the data type, wherein the data segment is contained in a data segment group corresponding to the target cell, and the data segment group comprises at least two data segments corresponding to different data types.

In the above scheme, the synchronization module is configured to synchronize the data to a target terminal, so that the target terminal updates the data content in the presented target cell based on the data.

In a fifth aspect, an embodiment of the present disclosure provides a terminal, including:

a first memory for storing executable instructions;

and the first processor is used for realizing the data processing method of the online form provided by the embodiment of the disclosure when the executable instruction is executed.

In a sixth aspect, an embodiment of the present disclosure provides a server, including:

a second memory for storing executable instructions;

and the second processor is used for realizing the data processing method of the online form provided by the embodiment of the disclosure when the executable instruction is executed.

In a seventh aspect, the present disclosure provides a storage medium storing executable instructions, where the executable instructions are executed to implement the data processing method for the online table provided in the present disclosure.

In an eighth aspect, the present disclosure provides a storage medium storing executable instructions, where the executable instructions are executed to implement the data processing method for the online form provided in the present disclosure.

The application of the embodiment of the present disclosure has the following beneficial effects:

by applying the embodiment of the disclosure, the data type of the acquired data input by aiming at the target cell is determined, and then the data and the corresponding data type are sent to the server, so that the data are stored in the data segmentation group corresponding to the target cell and the data corresponding to the data type are segmented, and as the data segmentation group corresponding to the target cell comprises at least two data segments corresponding to different data types, the data of different data types can exist in the target cell at the same time, and then the data of multiple different data types can be presented in one cell of the online form at the same time.

Drawings

The above and other features, advantages and aspects of various embodiments of the present disclosure will become more apparent by referring to the following detailed description when taken in conjunction with the accompanying drawings. Throughout the drawings, the same or similar reference numbers refer to the same or similar elements. It should be understood that the drawings are schematic and that elements and features are not necessarily drawn to scale.

FIG. 1 is a block diagram of an architecture of a data processing system for an online form according to an embodiment of the present disclosure;

FIG. 2 is a first schematic structural diagram of a data processing apparatus for an online form according to an embodiment of the present disclosure;

fig. 3 is a first flowchart illustrating a data processing method of an online form according to an embodiment of the present disclosure;

FIG. 4 is a data diagram of different data types provided by embodiments of the present disclosure;

FIG. 5 is an alternative schematic diagram of establishing a coordinate system for a corresponding target cell provided by an embodiment of the present disclosure;

FIG. 6 is an alternative diagram of an edit popup provided by an embodiment of the present disclosure;

FIG. 7 is an alternative diagram of an edit popup box when a data object is of a link type according to an embodiment of the present disclosure;

FIG. 8 is a second flowchart illustrating a data processing method for an online form according to an embodiment of the present disclosure;

FIG. 9 is a second schematic structural diagram of a data processing apparatus of an online form according to an embodiment of the present disclosure;

fig. 10 is a schematic structural diagram three of a data processing apparatus of an online form according to an embodiment of the present disclosure.

Detailed Description

Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While certain embodiments of the present disclosure are shown in the drawings, it is to be understood that the present disclosure may be embodied in various forms and should not be construed as limited to the embodiments set forth herein, but rather are provided for a more thorough and complete understanding of the present disclosure. It should be understood that the drawings and embodiments of the disclosure are for illustration purposes only and are not intended to limit the scope of the disclosure.

It should be understood that the various steps recited in the method embodiments of the present disclosure may be performed in a different order, and/or performed in parallel. Moreover, method embodiments may include additional steps and/or omit performing the illustrated steps. The scope of the present disclosure is not limited in this respect.

The term "include" and variations thereof as used herein are open-ended, i.e., "including but not limited to". The term "based on" is "based, at least in part, on". The term "one embodiment" means "at least one embodiment"; the term "another embodiment" means "at least one additional embodiment"; the term "some embodiments" means "at least some embodiments". Relevant definitions for other terms will be given in the following description.

It should be noted that the terms "first", "second", and the like in the present disclosure are only used for distinguishing different devices, modules or units, and are not used for limiting the order or interdependence relationship of the functions performed by the devices, modules or units.

It is noted that references to "a", "an", and "the" modifications in this disclosure are intended to be illustrative rather than limiting, and that those skilled in the art will recognize that "one or more" may be used unless the context clearly dictates otherwise.

The names of messages or information exchanged between devices in the embodiments of the present disclosure are for illustrative purposes only, and are not intended to limit the scope of the messages or information.

Before further detailed description of the embodiments of the present disclosure, terms and expressions referred to in the embodiments of the present disclosure are explained, and the terms and expressions referred to in the embodiments of the present disclosure are applied to the following explanations.

1) The online form is an Excel form which is used for users to edit online and collaborate with multiple users and is stored in a cloud in real time, forms are displayed through a Hyper Text Markup Language (HTML) page, and synchronization of user editing contents is realized depending on communication between a terminal and a server.

Based on the above explanations of terms and words involved in the embodiments of the present disclosure, referring to fig. 1, fig. 1 is a schematic diagram of an architecture of a data processing system of an online form provided by the embodiments of the present disclosure, in order to support an exemplary application, a terminal 400 (including a terminal 400-1 and a terminal 400-2) is connected to a server 200 through a network 300, and the network 300 may be a wide area network or a local area network, or a combination of both, and uses a wireless or wired link to implement data transmission.

A terminal 400 (e.g., terminal 400-1) for obtaining data entered for a target cell in an online form; determining a data type corresponding to the data; sending the data and the corresponding data type to the server 200; presenting a target cell comprising data;

a server 200 for receiving a data storage request for a target cell in an online form; analyzing the data storage request to obtain data and a corresponding data type; storing the data to the data segments of the corresponding data type.

Referring next to fig. 2, fig. 2 is a schematic structural diagram of a data processing apparatus of an online form according to an embodiment of the present disclosure. The data processing means of the online form may be implemented in various forms, such as: the method is implemented by a terminal such as a smart phone, a tablet computer and a desktop computer, or implemented by a server, or implemented by cooperation of the terminal and the server. The data processing device of the online form provided by the embodiment of the present disclosure may be implemented in hardware or a combination of hardware and software, and the data processing device of the online form shown in fig. 2 is only an example and should not bring any limitation to the function and the scope of use of the embodiment of the present disclosure.

As shown in fig. 2, the data processing device 200 of the online form may include a processing device (e.g., a central processing unit, a graphic processor, etc.) 210, which may perform various appropriate actions and processes according to a program stored in a Read-Only Memory (ROM) 220 or a program loaded from a storage device 280 into a Random Access Memory (RAM) 230. In the RAM230, various programs and data necessary for the operation of the processing device 200 of the online table are also stored. The processing device 210, the ROM 220, and the RAM230 are connected to each other through a bus 240. An Input/Output (I/O) interface 250 is also connected to bus 240.

Generally, the following devices may be connected to I/O interface 250: input devices 260 including, for example, a touch screen, touch pad, keyboard, mouse, camera, microphone, accelerometer, gyroscope, etc.; an output device 270 including, for example, a Liquid Crystal Display (LCD), a speaker, a vibrator, and the like; storage devices 280 including, for example, magnetic tape, hard disk, etc.; and a communication device 290. The communication means 290 may allow the processing means 200 of the online form to communicate with other devices wirelessly or by wire to exchange data.

In particular, the processes described by the provided flowcharts may be implemented as computer software programs according to embodiments of the present disclosure. For example, the disclosed embodiments include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method illustrated in the flow chart. In such embodiments, the computer program may be downloaded and installed from a network through communication device 290, or installed from storage device 280, or installed from ROM 220. The functions in the data processing method of the online form of the embodiment of the present disclosure are performed when the computer program is executed by the processing device 220.

It should be noted that the computer readable medium described above in the embodiments of the present disclosure may be a computer readable signal medium or a computer readable storage medium or any combination of the two. A computer readable storage medium may include, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples of the computer readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a RAM, a ROM, an erasable programmable Read-Only Memory (EPROM), a flash Memory, an optical fiber, a portable compact disc Read-Only Memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

In the disclosed embodiments, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In contrast, in the disclosed embodiments, a computer readable signal medium may comprise a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including over electrical wiring, fiber optics, Radio Frequency (RF), etc., or any suitable combination of the foregoing.

The computer readable medium may be embodied in the terminal; or may be separate and not assembled into the terminal.

The computer readable medium carries one or more programs, and when the one or more programs are executed by the terminal, the terminal is enabled to execute the data processing method of the online form provided by the embodiment of the disclosure.

Computer program code for carrying out operations for embodiments of the present disclosure may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C + +, and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of Network, including a Local Area Network (LAN) and a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).

The flowchart and block diagrams provided by the embodiments of the present disclosure illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.

The units described in the embodiments of the present disclosure may be implemented by software or hardware. Where the name of a unit does not in some cases constitute a limitation of the unit itself, for example, the first retrieving unit may also be described as a "unit for retrieving at least two internet protocol addresses".

The functions described in the embodiments of the present disclosure may be performed, at least in part, by one or more hardware logic components. For example, without limitation, exemplary types of hardware logic components that may be used include: Field-Programmable Gate arrays (FPGAs), Application Specific Integrated Circuits (ASICs), Application Specific Standard Parts (ASSPs)), systems on a chip (SOCs), Complex Programmable Logic Devices (CPLDs), and the like.

In the context of embodiments of the present disclosure, a machine-readable medium may be a tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. The machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

Based on the above description of the data processing system and device for online forms, the data processing method for online forms provided by the embodiments of the present disclosure is described next. Referring to fig. 3, fig. 3 is a first schematic flow chart of a data processing method of an online form provided in the embodiment of the present disclosure, where the data processing method of the online form provided in the embodiment of the present disclosure includes:

step 301: the terminal obtains data input for a target cell in the online form.

In some embodiments, the online form is displayed by a client installed in the terminal, in practical applications, the client may be a social client, such as an IM client, the client integrates functions of the online form, and based on a click operation of a user, the client calls a browser kernel to load a page of the online form through an interface provided by a browser, and based on the loaded page, the user may create and edit the online form, and of course, the user may share the online form through the client; in other embodiments, a browser kernel is integrated in the client, and the page of the online form is displayed in the client by calling the browser kernel; in other embodiments, the client is an online form client, and the page loading of the online form is realized by operating the online form client; in other embodiments, there is an applet to the online form functionality, and the client implements page loading of the online form by downloading and running the source code of the online form applet.

When a user creates or opens a created online form through some of the above embodiments, data editing processing, such as inputting new data into a cell, modifying or deleting data stored in the cell, etc., may be performed on a page of the online form displayed on the terminal according to personal needs. To explicitly indicate the cell on which the user performed the data processing operation, the cell is identified as the target cell.

When the terminal detects that the user inputs data aiming at a target cell of the online form, the data input by the user in the target cell is obtained, and the data is a character string formed by a plurality of characters. The data may be the website "http:// www.online-form. cn", the number "123", the text "online form", etc.

Step 302: and determining the data type corresponding to the data.

In actual implementation, after the terminal acquires data input by a user in a target cell, the data is analyzed or identified, and a data type corresponding to the acquired data is determined.

In some embodiments, the terminal may determine the data type corresponding to the data by:

identifying data content of the data; when identification data for indicating the data type exists in the data content, the data type indicated by the identification data is determined to be the data type corresponding to the data.

Here, the terminal may pre-store a plurality of identification data indicating the data type. The identification data is preset, and there is a corresponding relationship between the identification data and the data type, that is, it is determined which data type is marked by which identification data, for example, a link type may be marked by "www", a text type may be marked by "text", and the like.

In actual implementation, after the terminal acquires the data, the terminal may analyze the data to obtain data content, further identify the data content, and determine whether the data content includes identification data indicating a data type. If the data type exists, judging which data type the existing identification data is used for identifying according to the preset corresponding relation between the identification data and the data type, and determining the data type as the data type corresponding to the acquired data.

For example, the data acquired by the terminal is http:// www.online-form.cn ", the data is analyzed, and the data content is found to have identification data" www "indicating the link type, so that the data type corresponding to the acquired data is determined to be the link type.

In some embodiments, determining the data type to which the data corresponds includes at least one of: a text type characterizing a text attribute of the data, a link type characterizing a hyperlink attribute of the data.

Referring to fig. 4, fig. 4 is a data diagram of different data types provided by the embodiment of the present disclosure. Such as data of text type "plain text", "avatar", and data of link type "www.online-form. In addition, the link type data includes data having a hyperlink attribute, such as data of "@ name" may be input when referring to "someone", "certain document", in addition to a common URL.

Step 303: and sending the data and the corresponding data type to store the data into a data segment of the corresponding data type, wherein the data segment is contained in a data segment group corresponding to the target cell, and the data segment group comprises at least two data segments corresponding to different data types.

After determining the data type corresponding to the data, the terminal sends the data and the data type corresponding to the data to the server so that the server can correspondingly store the data of the target cell. Specifically, the terminal may send a data storage request to the server, and the data storage request carries data to be sent and a corresponding data type. Meanwhile, the data storage request can also carry identification information of an online form where the data are located, indication information of the target cell and the like, so that the server can accurately store the data at a position corresponding to the target cell.

After receiving the data storage request, the server first analyzes the data storage request to obtain the data and the corresponding data type, and obtains relevant information of data storage carried in the data storage request, such as identification information of an online table where the data is located, indication information of a target cell, and the like. And storing the data in the data segment group corresponding to the target cell according to the relevant information. In addition, in the embodiment of the disclosure, the data is stored in a segment structure manner to solve the problem that data of multiple data types in the same cell cannot coexist.

In implementation, the server assigns a corresponding data segment group to each target cell for storing the data input for the target cell, where the data segment group includes at least two data segments corresponding to different data types. Therefore, when the server stores the data, the data is stored according to the data type of the data. For example, a data segment group may include data segments corresponding to a text type, data segments corresponding to a link type, and so on. And after determining the data segment group corresponding to the target cell, the server stores the data into the data segment corresponding to the data type of the data according to the data type.

Step 304: a target cell including data is presented.

The terminal presents the target cell including the input data to the user through the front page.

In some embodiments, after a user enters data for an online form, there may often be a need to make editing modifications to the entered data as well. Since in the embodiment of the present disclosure, one cell stores data of multiple data types, the following operations may be performed to implement accurate editing of data:

when the mouse pointer is detected to move and the position of the mouse pointer when the movement stops corresponds to the target cell, determining the relative position relation between the mouse pointer and the target cell; determining a data object corresponding to a mouse pointer in the data based on the relative position relation; and presenting an editing bullet frame corresponding to the data object, wherein the editing bullet frame is used for carrying out data editing on the data object.

When the user needs to edit the data of a certain cell, the operation mouse moves to the target cell and stays at the position of the data which is specified to be edited by the user. Generally, a mouse pointer can precisely indicate only one character, and most data is composed of a plurality of characters, so when the mouse pointer indicates a certain character, data of a data segment where the character is located is determined as an object that a user wants to edit, i.e., a data object.

In actual implementation, the position of the mouse pointer needs to be determined first before the data object is determined. And when the terminal detects that the mouse pointer moves and the position of the mouse pointer corresponds to the target cell when the movement stops, determining the relative position relation between the mouse pointer and the target cell.

Specifically, determining the relative position relationship between the mouse pointer and the target cell includes:

establishing a coordinate system corresponding to the target cell by taking the first vertex of the target cell as an origin; acquiring a first offset value of a mouse pointer in a first coordinate system direction and a second offset value in a second coordinate system direction; and determining the position of the mouse pointer on the target cell according to the first offset value and the second offset value.

In the process of positioning the position of the mouse pointer, a rectangular coordinate system corresponding to the target cell can be established by taking the first vertex of the target cell as an origin, and then the position of the mouse pointer in the rectangular coordinate system is obtained. Specifically, a first offset value in the first coordinate system direction and a second offset value in the second coordinate system direction may be obtained according to the coordinate system direction. Based on the first offset value and the second offset value, a specific location of the mouse pointer in the target cell is determined.

Referring to fig. 5, fig. 5 is an alternative schematic diagram of establishing a coordinate system for a corresponding target cell according to an embodiment of the present disclosure. Referring to fig. 5, a rectangular coordinate system including an x axis and a y axis is established with a vertex of a lower left corner of the target cell as an origin, a positive direction of the x axis is taken as a direction of a first coordinate system, a positive direction of the y axis is taken as a direction of a second coordinate system, and a first offset value and a second offset value of the mouse pointer in the coordinate system are determined. In addition, a specific coordinate value can be determined according to the first offset value and the second offset value, and the coordinate value is used for describing the position of the mouse pointer in the target cell.

After the relative position relationship between the mouse pointer and the target cell is determined, the data that the user wants to edit, namely the data object indicated by the mouse pointer, is further determined. In practical implementation, the following manner may be adopted to determine the data object according to the determined relative position relationship.

Specifically, determining a data object corresponding to a mouse pointer in data based on the relative position relationship includes: determining a target character corresponding to the position of the mouse pointer on the target cell according to the first offset value, the second offset value and the character width; and determining a data object corresponding to the data segment where the target character is located, and determining the data object corresponding to the mouse pointer.

Based on the steps, the relative position relation of the mouse pointer and the target cell is determined, and a first offset value and a second offset value of the mouse pointer in the target cell are obtained. Since the character width of each character of the data can be determined, the target character indicated by the mouse pointer can be directly determined based on the first and second offset values and the character width. Specifically, the character width may be removed by using the first offset value and/or the second offset value to obtain the number of characters that the mouse pointer is offset in the first coordinate direction and/or the second coordinate direction, so as to determine the target character.

Because the data is composed of characters and is stored in segments, based on the target character, the data segment where the target character is located and the data corresponding to the data segment can be determined, and the data is determined as the data object corresponding to the mouse pointer.

In addition, in the embodiment of the present disclosure, a corresponding edit popup is preset for each data type of data, and the edit popup is used for data editing of a data object. After the data object corresponding to the mouse pointer is determined, the edit popup box corresponding to the data type of the data object is determined according to the data object, and the edit popup box is presented on a front-end page. Referring to fig. 6, fig. 6 is an optional schematic diagram of an edit popup box provided in the embodiment of the present disclosure, where the edit popup box includes edit buttons such as modify and delete buttons, and a user can complete an edit operation of a data object by clicking the edit button.

Because the edit popup box is preset according to the data type, the edit popup boxes corresponding to different data types may be different. In some embodiments, when the data type of the data object is a link type of a hyperlink attribute characterizing the data, a reference object corresponding to the data object is displayed, and the reference object is used for linking the data object to the corresponding source data.

The data with hyperlink properties may have different representations, such as text data linked to a web address, text data with @ characters, etc. In practical applications, the data representing the link type in the above representation generally corresponds to the corresponding source data for the data link.

Illustratively, the following source code may be employed for representation:

SegmentArray：Array(2)

0: { text: "Online Table", type: "url", link: "http:// www.online-form. cn" }

1: { text: "@ Liu XX", type: "comment", name: "Liu XX", en _ name: "XXLiu" }

Here, based on the source code, it can be known that the source data linked to the text data "online form" is "http:// www.online-form. cn", and the source data linked to the text data "@ liu XX" includes "en-name: XXLiu ", etc.

Based on the description of the data of the link type, when the data type of the data object is a link type representing a hyperlink attribute of the data, a reference object corresponding to the data object may be displayed, and the reference object may be used for linking the data object to corresponding source data. Specifically, the reference object may be included in an edit popup presented for the data object, see fig. 7, where fig. 7 is an optional schematic diagram of the edit popup when the data object is of a link type according to the embodiment of the present disclosure. In addition to the data object "online form" to be edited, the edit box shown in FIG. 7 also includes a reference object "http:// www.online-form.

In some embodiments, after the terminal presents the edit box, the following steps are further performed:

receiving an editing operation performed on the data object based on the editing popup; the data in the target cell is updated based on the editing operation.

And the terminal presents the editing bullet frame corresponding to the data object according to the user instruction, and after the user finishes editing operation on the data object, the data in the target cell needs to be updated and displayed. Specifically, the editing operation performed by the user on the data object is obtained, and the editing operation may be an operation of adding data, deleting data, modifying data, and the like on the data object.

And after the terminal acquires the editing operation, updating the data in the target cell according to the editing operation, and presenting the target cell including the editing operation to the user. Meanwhile, the terminal needs to inform the server to execute a corresponding storage operation, for example, if the user adds another data on the basis of the data object, the terminal needs to inform the server of both the added data and the corresponding data object to complete storage, or if the user performs a deletion operation on the data object, the terminal needs to inform the server of which data object is deleted.

And the server completes the storage operation after the data updating according to the notification sent by the terminal, namely, the server stores the data added aiming at the data object or deletes the data deleted aiming at the data object in the data segment corresponding to the data object. Because the online form is a document for multi-user cooperation to be stored in the cloud in real time, after data of a certain terminal aiming at the online form is stored, the data needs to be synchronized to other target terminals except the terminal, so that the other target terminals present target cells comprising the data, and the effect of multi-user cooperation is achieved.

In the embodiment of the disclosure, the data and the corresponding data type are sent to the server by determining the data type of the acquired data input for the target cell, so that the data is stored in the data segmentation group corresponding to the target cell and the data corresponding to the data type is segmented, and because the data segmentation group corresponding to the target cell includes at least two data segments corresponding to different data types, the data of different data types can exist in the target cell at the same time, and further, the data of multiple different data types can be presented in one cell of the online table at the same time.

Continuing to describe the data processing method of the online form provided by the embodiment of the present disclosure, referring to fig. 8, fig. 8 is a second flowchart of the data processing method of the online form provided by the embodiment of the present disclosure, where the data processing method of the online form provided by the embodiment of the present disclosure includes:

step 801: the client loads the page of the online form through the browser kernel, and the terminal acquires the data input by the target cell in the page.

Here, the data may be link type data "http:// www.online-form. cn", "@ Liu XX", and text type data "online form", etc.

Step 802: and determining the data type corresponding to the input data.

Here, the terminal parses the data, identifies the data content of the data, and further determines whether the data content has identification data for indicating the data type; and if so, determining the data type indicated by the identification data as the data type corresponding to the data.

Such as parsing the data "http:// www.online-form. cn" input by the user, it is found that identification data "www" indicating the link type exists in the data content, and thus the input data is determined to be the link type.

Step 803: and sending a data storage request to the server, wherein the data storage request carries data and a corresponding data type.

Step 804: and the server analyzes the data storage request and stores the data into the data segment corresponding to the data type in the data segment group corresponding to the target cell.

Here, the server analyzes the data storage request, and acquires identification information of the online form edited by the user and indication information of the target cell, in addition to the data of the user and the corresponding data type.

Step 805: the terminal presents a target cell including data.

Step 806: detecting the operation of the user for moving the mouse and determining the target cell where the mouse stays.

Step 807: and establishing a rectangular coordinate system by taking one vertex of the target cell as an origin to determine the position of the mouse pointer.

Here, in the rectangular coordinate system established for the target cell, a first offset value in the positive direction of the x-axis and a second offset value in the positive direction of the y-axis of the mouse pointer are acquired, and the position of the mouse pointer in the target cell is determined based on the first offset value and the second offset value.

Step 808: and determining a data object corresponding to the mouse pointer according to the position of the mouse pointer.

Here, the target character corresponding to the mouse pointer is determined based on the first offset value, the second offset value, and the character width. And determining the data corresponding to the data segment where the target character is located as a data object.

Step 809: and presenting an edit popup of the corresponding data object on a page of the online form.

Here, the user can perform an editing operation for the data object according to the prompt of the edit popup.

Step 810: and receiving an editing operation performed by a user, and updating the data in the target cell based on the editing operation.

For example, the user modifies http:// www.online-form.cn to online form according to the presented edit box; and the terminal receives the editing operation of the user aiming at the target cell, and updates the data presented in the target cell, namely presents the data of the ' online table ' obtained by modifying ' http:// www.online-form.

Step 811: the server synchronizes data to other terminals.

The following describes units and/or modules in a data processing apparatus that implements an online form provided by an embodiment of the present disclosure. It is understood that the units or modules in the data processing device of the online form can be implemented in the data processing device of the online form shown in fig. 2 by software (for example, a computer program stored in the above computer software program), and can also be implemented in the data processing device of the online form shown in fig. 2 by the above hardware logic components (for example, FPGA, ASIC, SOC, and CPLD).

Referring to fig. 9, fig. 9 is an alternative structural diagram of a data processing apparatus 900 for implementing an online form according to an embodiment of the present disclosure, showing the following modules: an obtaining module 901, a determining module 902, a sending module 903 and a presenting module 904, the functions of each of which will be described below.

Referring to fig. 10, fig. 10 is an alternative structural diagram of a data processing apparatus 1000 for implementing an online form according to an embodiment of the present disclosure, showing the following modules: a receiving module 1001, a parsing module 1002 and a storing module 1003, the functions of each of which will be described below.

It should be noted that the above classification of modules does not constitute a limitation on the electronic device itself, for example, some modules may be split into two or more sub-modules, or some modules may be combined into a new module.

It should be further noted that the names of the above modules do not limit the modules themselves in some cases, and for example, the above acquiring module 901 may also be described as a module for "acquiring data input for a target cell in an online form".

For the same reason, elements and/or modules not described in detail in the terminal do not represent defaults of the corresponding elements and/or modules, and all operations performed by the terminal may be implemented by the corresponding elements and/or modules in the terminal.

With continued reference to fig. 9, fig. 9 is a schematic structural diagram of a data processing apparatus 900 for an online form according to an embodiment of the present disclosure, where the apparatus includes:

an obtaining module 901, configured to obtain data input for a target cell in an online form;

a determining module 902, configured to determine a data type corresponding to the data;

a sending module 903, configured to send the data and the corresponding data type, so as to store the data into a data segment corresponding to the data type, where the data segment is included in a data segment group corresponding to the target cell, and the data segment group includes at least two data segments corresponding to different data types;

a presenting module 904 for presenting the target cell including the data.

In some embodiments, the determining module 902 is specifically configured to identify the data content of the data;

In some embodiments, the determining module 902 is further specifically configured to determine that the data type corresponding to the data includes at least one of the following data types: a text type characterizing a text attribute of the data, a link type characterizing a hyperlink attribute of the data.

In some embodiments, the determining module 902 is further configured to determine a relative position relationship between the mouse pointer and the target cell when it is detected that the mouse pointer moves and the position of the mouse pointer when the movement stops corresponds to the target cell;

the presenting module 904 is further configured to present an edit popup box corresponding to the data object, where the edit popup box is used to perform data editing on the data object.

In some embodiments, the determining module 902 is further configured to establish a coordinate system corresponding to the target cell with the first vertex of the target cell as an origin;

In some embodiments, the determining module 902 is further configured to determine, according to the first offset value, the second offset value, and the character width, a target character corresponding to the position of the mouse pointer on the target cell;

In some embodiments, the presenting module 904 is further configured to display a reference object corresponding to the data object when the data type of the data object is a link type of a hyperlink attribute representing data, where the reference object is used for linking the data object to corresponding source data.

In some embodiments, the apparatus further comprises an update module;

the updating module is used for receiving the editing operation executed on the data object based on the editing popup; updating the data in the target cell based on the editing operation.

With continued reference to fig. 10, fig. 10 is a schematic structural diagram of a data processing apparatus 1000 for an online form according to an embodiment of the present disclosure, where the apparatus includes:

a receiving module 1001, configured to receive a data storage request for a target cell in an online table, where the data storage request carries data input for the target cell and a corresponding data type;

the analyzing module 1002 is configured to analyze the data storage request to obtain the data and a corresponding data type;

a storage module 1003, configured to store the data to a data segment corresponding to the data type, where the data segment is included in a data segment group corresponding to the target cell, and the data segment group includes at least two data segments corresponding to different data types.

In some embodiments, the apparatus further comprises a synchronization module;

and the synchronization module is used for synchronizing the data to a target terminal so that the target terminal updates the data content in the presented target cell based on the data.

An embodiment of the present disclosure further provides a terminal, where the terminal includes:

a first memory for storing an executable program;

and the first processor is used for realizing the data processing method of the online form provided by the embodiment of the disclosure when the executable program is executed.

An embodiment of the present disclosure further provides a server, where the server includes:

a second memory for storing an executable program;

and the second processor is used for realizing the data processing method of the online form provided by the embodiment of the disclosure when the executable program is executed.

Here, it should be noted that: for the technical details that are not disclosed in the embodiments of the data processing apparatus for an online form according to the embodiments of the present disclosure, please refer to the description of the embodiments of the data processing method for an online form.

The embodiment of the present disclosure also provides a storage medium, which stores executable instructions, and when the executable instructions are executed, the storage medium is used for implementing the data processing method for the online form provided by the embodiment of the present disclosure.

According to one or more embodiments of the present disclosure, an embodiment of the present disclosure provides a data processing method for an online form, including:

acquiring data input aiming at a target cell in an online form;

determining a data type corresponding to the data;

presenting the target cell including the data.

According to one or more embodiments of the present disclosure, an embodiment of the present disclosure provides a data processing method for an online form, further including:

the determining the data type corresponding to the data includes:

identifying data content of the data;

the determining the data type corresponding to the data includes:

the determining the relative position relationship between the mouse pointer and the target cell includes:

determining a data object corresponding to the mouse pointer in the data based on the relative position relationship, including:

and when the data type of the data object is a link type of a hyperlink attribute representing data, displaying a reference object corresponding to the data object, wherein the reference object is used for linking the data object to corresponding source data.

updating the data in the target cell based on the editing operation.

According to one or more embodiments of the present disclosure, there is also provided a data processing method for an online form, including:

According to one or more embodiments of the present disclosure, an embodiment of the present disclosure provides a data processing apparatus for an online form, including:

a presentation module to present the target cell including the data.

According to one or more embodiments of the present disclosure, there is also provided a data processing apparatus for an online form, including:

The above description is only an example of the present disclosure and is illustrative of the principles of the technology employed. It will be appreciated by those skilled in the art that the scope of the disclosure herein is not limited to the particular combination of features described above, but also encompasses other embodiments in which any combination of the features described above or their equivalents does not depart from the spirit of the disclosure. For example, the above features and (but not limited to) the features disclosed in this disclosure having similar functions are replaced with each other to form the technical solution.

Further, while operations are depicted in a particular order, this should not be understood as requiring that such operations be performed in the particular order shown or in sequential order. Under certain circumstances, multitasking and parallel processing may be advantageous. Likewise, while several specific implementation details are included in the above discussion, these should not be construed as limitations on the scope of the disclosure. Certain features that are described in the context of separate embodiments can also be implemented in combination in a single embodiment. Conversely, various features that are described in the context of a single embodiment can also be implemented in multiple embodiments separately or in any suitable subcombination.

Although the subject matter has been described in language specific to structural features and/or methodological acts, it is to be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or acts described above. Rather, the specific features and acts described above are disclosed as example forms of implementing the claims.

Claims

1. A method of data processing for an online form, the method comprising:

acquiring data input aiming at a target cell in an online form;

determining a data type corresponding to the data;

presenting the target cell including the data.

2. The method of claim 1, wherein the determining the data type to which the data corresponds comprises:

identifying data content of the data;

3. The method of claim 1, wherein the determining the data type to which the data corresponds comprises:

4. The method of claim 1, wherein the method further comprises:

5. The method of claim 4, wherein said determining a relative positional relationship of said mouse pointer to said target cell comprises:

6. The method of claim 5, wherein said determining a data object in the data corresponding to the mouse pointer based on the relative positional relationship comprises:

7. The method of claim 4, wherein when the data type of the data object is a link type characterizing hyperlink properties of data, the method further comprises:

8. The method of claim 4, wherein the method further comprises:

updating the data in the target cell based on the editing operation.

9. A method of data processing for an online form, the method comprising:

10. The method of claim 9, wherein the method further comprises:

11. An apparatus for processing data of an online form, the apparatus comprising:

a presentation module to present the target cell including the data.

12. The apparatus of claim 11,

the determining module is used for identifying the data content of the data;

13. The apparatus of claim 11,

the determining module is further configured to determine a relative position relationship between the mouse pointer and the target cell when it is detected that the mouse pointer moves and the position of the mouse pointer corresponds to the target cell when the movement stops;

14. The apparatus of claim 13,

15. An apparatus for processing data of an online form, the apparatus comprising:

16. The apparatus of claim 15,

17. A terminal, characterized in that the terminal comprises:

a first memory for storing executable instructions;

a first processor, configured to execute the executable instructions to implement the data processing method of the online form according to any one of claims 1 to 8.

18. A server, characterized in that the server comprises:

a second memory for storing executable instructions;

a second processor, configured to execute the executable instructions to implement the data processing method of the online form according to any one of claims 9 to 10.

19. A storage medium storing executable instructions for implementing a data processing method of an online form according to any one of claims 1 to 8 when executed.

20. A storage medium storing executable instructions for implementing a data processing method of an online form according to any one of claims 9 to 10 when executed.