Table content processing method, device, equipment, and storage medium

Abstract

The present disclosure provides a table content processing method, an apparatus, a device, and a storage medium. The table content processing method includes the steps of: selecting data row information in a first table; generating a first document or a second table in response to a trigger operation on the data row information, where the first document includes the second table and the second table includes the data row information; and sending the first document or the second table to a target access user. The present disclosure can directly share part of the content in the table and support two-way synchronization of data, improving the user's usage experience.

Description

[Technical Field]

[0001] (CROSS-REFERENCE TO RELATED APPLICATIONS) This application is based on and claims priority to a Chinese patent application having application number 202110227849.2, filing date March 1, 2021, and titled "Table Content Processing Method, Apparatus, Device, and Storage Medium," and application number 202110233247.8, filing date March 1, 2021, and titled "Table Content Processing Method, Apparatus, Device, and Storage Medium," the entire contents of which are hereby incorporated by reference into this application.

[0002] (Technical field) The present disclosure relates to the technical field of computer software, and in particular to a table content processing method, device, apparatus, and storage medium. [Background technology]

[0003] With the development of Internet technology, tables have become a common data management tool. In the process of using tables, tables are often shared with other users for viewing or editing. Sometimes multiple users need to jointly maintain the contents of a table, and each user is responsible for only a part of the contents of the table, and data separation must also be taken into consideration.

[0004] In the prior art, if a user needs to provide part of the contents of a table to another user, they must close the current table, open a new table, copy the corresponding contents into the new table, and then send it to the other user. This process is too cumbersome. To complete a table together, each user must often create a table individually, edit the contents corresponding to their own needs, and then send the table together to someone else. The user must then copy the contents of each table into a general table, combine them, and then repeat these operations each time the general table is updated, resulting in a cumbersome process. Summary of the Invention [Problem to be solved by the invention]

[0005] The present disclosure has been made to solve the above-mentioned problems, and aims to provide a simple and efficient table content processing method, device, apparatus, and storage medium that can directly share part of the table content to support two-way data synchronization, or realize real-time two-way synchronization of part of the table content data. This disclosure provides a summary of the invention to explain the concepts, which will be described in detail in the following detailed description. This summary is not intended to identify key or necessary features of the claimed technical solution, nor is it intended to limit the scope of the claimed technical solution. [Means for solving the problem]

[0006] In order to solve the above technical problems, the embodiments of the present disclosure provide technical solutions as follows: selecting data row information in Table 1; generating a first document or a second table in response to a trigger operation on the data row information, the first document including the second table and the second table including the data row information; and sending the first document or the second table to the target access user.

[0007] In order to solve the above technical problems, the embodiments of the present disclosure further provide technical solutions as follows: an information selection module for selecting data row information in the first table; a document generation module that generates a first document or a second table in response to a trigger operation on the data row information, the first document including the second table, and the second table including the data row information; a document transmission module for transmitting the first document or the second table to the target access user; and a citation synchronization module that cites data line information in a second table in an area of ​​data line information in a first table, highlights the relevant area of ​​the data line information in the first table, and displays the edited data line information in the data line information of the first table in response to an editing operation on the data line information of the second table.

[0008] In order to solve the above technical problems, the embodiments of the present disclosure provide technical solutions as follows: selecting a first data row of information in a first table; A table content processing method is provided, which includes a step of inserting the first data line information into the first document or the second table in response to an insert operation into the first document or the second table, and generating second data line information in the first document or the second table, wherein the first data line information and the second data line information have a citation relationship.

[0009] In order to solve the above technical problems, the embodiments of the present disclosure further provide technical solutions as follows: an information selection module for selecting information from a first data row in the first table; an information insertion module that inserts first data line information into the first document or the second table and generates second data line information in response to an insert operation into the first document or the second table, wherein the first data line information and the second data line information have a citation relationship; a display module that, in response to an editing operation on the second data line information, displays the edited data line information on the first data line information and also displays the citation relationship with a specific marker; A table content processing device is provided, which includes a determination setting module that determines whether the predetermined attributes of the first table and the second table are the same, and if they are the same, generates second data line information and determines whether to establish a citation relationship between the second data line information and the first data line information.

[0010] In order to solve the above technical problems, the embodiments of the present disclosure further provide technical solutions as follows: a memory in which a computer program is stored; A computing device is provided, comprising a processor that, when executing a computer program, implements the method.

[0011] In order to solve the above technical problems, the embodiments of the present disclosure further provide technical solutions as follows: A computer readable storage medium is provided having stored thereon a computer program which, when executed by a processor, implements the method. [Effects of the Invention]

[0012] According to the technical solution disclosed in this disclosure, compared with the prior art, the present disclosure allows a portion of the content in a table to be directly shared, eliminating the need to create a new table and then copy and paste the content into it before sharing, simplifying the operation procedure and contributing to work efficiency. The present disclosure also allows a portion of the content in a table to be synchronized and updated in real time in both directions with just one copy, reducing the need for repetitive processing during collaboration and contributing to work efficiency. [Brief explanation of the drawings]

[0013] [Figure 1] FIG. 1 is an exemplary system architecture diagram to which the present disclosure may be applied. [Figure 2] 1 is a flowchart of an embodiment of a table content processing method according to the present disclosure. [Figure 3] 1 is a schematic diagram of an embodiment of a table content processing method according to the present disclosure; [Figure 4] 1 is a schematic diagram of an embodiment of a table content processing method according to the present disclosure; [Figure 5] 1 is a schematic diagram of an embodiment of a table content processing device according to the present disclosure; [Figure 6] 10 is a flowchart of another embodiment of a table content processing method according to the present disclosure. [Figure 7] FIG. 10 is a schematic diagram of another embodiment of a table content processing method according to the present disclosure. [Figure 8] 1 is a schematic diagram of another embodiment of a table content processing device according to the present disclosure; [Figure 9]1 is a structural schematic diagram of an embodiment of a computer device according to the present disclosure; DETAILED DESCRIPTION OF THE INVENTION

[0014] These and other features, advantages, and aspects of the embodiments of the present disclosure will become more apparent upon reference to the following detailed description, taken in conjunction with the drawings. Throughout the drawings, identical or similar reference numerals represent identical or similar elements. It should be understood that the drawings are schematic, and that elements and components are not necessarily drawn to scale. Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art of the present disclosure. The terms used in the specification of the application herein are used only for the purpose of describing particular embodiments and are not intended to limit the present disclosure. The terms "comprise" and "have," as well as any variations thereof, in the specification and claims of the present disclosure and the foregoing description of the drawings are intended to cover a non-exclusive inclusion. The terms "first," "second," etc., in the specification and claims of the present disclosure or the foregoing drawings are intended to distinguish between different objects and not to describe a particular order.

[0015] An "embodiment" described herein means that a particular feature, structure, or characteristic described with reference to the embodiment may be included in at least one embodiment of the present disclosure. The appearance of this phrase in various places in this specification does not necessarily refer to the same embodiment, nor does it mean an embodiment that is exclusive, independent, or an alternative to other embodiments. As one skilled in the art will understand, both explicitly and implicitly, the embodiments described herein may be combined with other embodiments.

[0016] In order to enable those skilled in the art to better understand the aspects of the present disclosure, the following clearly and completely describes the technical solutions of the embodiments of the present disclosure with reference to the drawings.

[0017] (System Structure) First, the structure of a system according to an embodiment of the present disclosure will be described. As shown in Fig. 1, a system structure 100 may include terminal devices 101, 102, 103, and 104, a network 105, and a server 106. The network 105 is used as a medium for providing a communication link between the terminal devices 101, 102, 103, and 104 and the server 106.

[0018] In this embodiment, an electronic device (e.g., terminal device 101, 102, 103, or 104 shown in FIG. 1) on which the table content processing method operates can transmit various types of information over network 105. Network 105 may include various connection types, such as wired, wireless communication links, or fiber optic cables. Note that the wireless connections may include, but are not limited to, 3G / 4G / 5G connections, Wi-Fi connections, Bluetooth connections, WiMAX connections, Zigbee connections, UWB connections, and other wireless connections now known or developed in the future.

[0019] Users can use terminal devices 101, 102, 103, and 104 to interact with server 106 via network 105 and receive or send messages, etc. Various client applications, such as a live video playback application, a web browser application, a shopping application, a search application, an instant messenger, a mailbox client, and social platform software, can be installed on terminal devices 101, 102, 103, and 104.

[0020] Terminal device 101, 102, 103, or 104 may be a variety of electronic devices that have a touch display and / or support web browsing, including, but not limited to, smartphones, tablets, e-book readers, MP3 players (Professional Video Compression Standard Audio Level 3), MP4 (Professional Video Compression Standard Audio Level 4) players, head-mounted display devices, laptop portable computers, and desktop computers.

[0021] Server 106 may be a server that provides various services, such as a back-end server that supports pages displayed on terminal devices 101, 102, 103, or 104.

[0022] It should be understood that the number of terminal devices, networks, and servers in Figure 1 is only approximate, and there can be any number of terminal devices, networks, and servers depending on implementation needs.

[0023] Here, the terminal device can implement the method of the embodiment of the present disclosure by running an application of the Android (registered trademark) system, either independently or in cooperation with other electronic terminal devices, or can implement the method of the embodiment of the present disclosure by running an application of other operating systems, such as the iOS system, the Windows system, or the Hongmeng system.

[0024] (Table content processing method) First, nouns in some application scenarios of the present disclosure will be described. Data row (record): For example, a row in a table can be called a data row or a record. In a table, an array is specified for the order of the data rows, describing the row number in the table for each data row. When selecting one or more data rows, the range within the array is actually selected. For example, it can be written as [start,end]. Index column: For example, it may be the key information of each record that identifies the attribute information of each record, and it may not be deleted. When a user copies the contents of one table to another table by copy and paste, it is necessary to ensure that the index columns of the two tables are the same; otherwise, the contents cannot be pasted. Field information: For example, it can represent the headings or attributes of columns in a table. For example, a table may have a column called "Most Important."

[0025] 2, there is shown a flowchart of an embodiment of a table content processing method according to the present disclosure, which includes steps S21 to S23.

[0026] S21: Select the data row information in the first table.

[0027] In one or more embodiments, the first table may be, for example, an original table in which selected data row information is located, and may be, for example, referred to as a main table, and the second table described below may be, for example, a shared table, and may be, for example, referred to as a sub-table. The main table and the sub-table may be two separate tables or two sub-tables within the same table.

[0028] Optionally, when selecting the data row information in Table 1, the selection may be made in the interface of Table 1 or in another interface where the data row information of Table 1 is displayed.

[0029] Optionally, the selection operation includes directly selecting by region in the data row or selecting a marker corresponding to the data row, where each marker corresponds to a complete data row. For example, the method for selecting the data row information in the first table can be, for example, by checking one or more data in the main table, that is, selecting a part of the [start, end] range of the array in the main table.

[0030] After selecting the above data row information, a trigger operation such as a sharing operation can be performed, for example, by clicking on a sharing-related tool or menu. There is no limitation on the display location of the sharing-related tool or menu; it may be on the menu bar or on another toolbar, and it is preferable that it is located before the selected one or more data rows. When one or more data rows are selected, the sharing-related tool or menu will automatically pop up, and the display content of the sharing-related tool or menu may be, for example, "Move to new table" or "Share new table", but is not particularly limited.

[0031] S22: In response to a trigger operation on the data row information, a first document or a second table is generated, the first document including the second table, and the second table including the data row information.

[0032] In one or more embodiments, for example, the generated first document is itself the second table, although of course the first document may include the second table.

[0033] In one or more embodiments, the trigger operation includes at least setting a name of the first document or a name of the second table, or setting a target to be sent. For example, when a share operation is performed by clicking a share-related tool or menu, a pop-up window pops up, for example, for setting a heading or name of the newly generated document or sub-table, or for selecting a target target for sharing.

[0034] In one or more embodiments, as shown in FIG. 3, a creation command based on the content of the selected [start, end] range is sent to the server to create a new document or sub-table for sharing, and after creating the new document or sub-table, attribute information of the sub-table is returned, where the field information of the new sub-table is maintained consistent with that of the main table.

[0035] S23: The first document or the second table is transmitted to the target access user.

[0036] In one or more embodiments, the method further includes citing the data line information in the second table in the area of ​​the data line information in the first table. In one or more embodiments, the citation of the data line of the second table into the first table is performed by, for example, replacing the content of [start, end] in the main table and inserting the corresponding data line of the second table as a special cited data line in the corresponding position, as shown in Figure 3.

[0037] Optionally, when quoting, the data line information may be shifted by the number of lines from the start position to match the contents of Table 2.

[0038] In one or more embodiments, referencing the data line information in the second table in the region of the data line information in the first table includes highlighting the relevant region of the data line information in the first table, for example, by highlighting the data line region, highlighting an edge of the data line region, or adding a marker to the relevant region of the data line information in the first table, for example, by making a unique marker appear in or near the relevant region.

[0039] In one or more embodiments, the name and / or link to the second table is displayed in response to a trigger operation on the relevant region or a trigger operation on a marker in the relevant region. In one or more embodiments, for example, when the unique marker is clicked, a link to the second table or the name of the second table appears, and when the link to the second table or the name of the second table appears, clicking jumps to the second table.

[0040] Optionally, after generating the first document or the second table, the relevant area of ​​the cited corresponding data line information in the second table is highlighted, for example by highlighting the data line area, highlighting the edge of the data line area, or adding a marker within or near the relevant area of ​​the cited data line information in the second table.

[0041] Optionally, in response to a trigger operation on the relevant region in the second table or a trigger operation on a marker in the relevant region, all information in the first table that references the data row information in the second table is displayed.

[0042] Optionally, any information from the first table that quotes the data row information in the displayed second table will jump to the corresponding first table when clicked.

[0043] In one or more embodiments, in response to an editing operation on the data line information of the second table, edited data line information is displayed on the data line information of the first table.

[0044] In one or more embodiments, the method further includes the steps of identifying the accessing user's authority information for the first document or the second table, and determining the display content for the accessing user of the data row information in the first table based on the authority information, specifically, in response to the accessing user not having the authority information, hiding the data row information in the first table and displaying link information of the second table in the area where the data row information is located, and in response to the accessing user having the authority information, displaying the data row information in the first table.

[0045] In one or more embodiments, for example, if the settings of Table 1 indicate that the main table has viewing authority over the sub-table, the contents of the data row information can be viewed in the main table, and if not, the contents cannot be viewed; if the settings of Table 1 indicate that the main table has editing authority over the sub-table, the contents of the data row information can be edited in the main table; when editing the data row information in the main table, the edited contents are synchronized with the sub-table, which is Table 2; when editing in the sub-table, the edited contents are synchronized with the data row information of the main table and can be viewed or edited.

[0046] In one or more embodiments, once table content processing is completed, the table content processing method of the present disclosure solves the problem of inconsistent field information between the main table and the sub-table after sharing, and in one or more embodiments, the field information includes at least column headers and / or column attributes, for example.

[0047] In one or more embodiments, inconsistencies may occur due to mismatched field information between the main table and the sub-table. As shown in FIG. 4, the table content processing method of the present disclosure includes: When a user accesses a main table, obtaining field information of the main table and all sub-tables, and returning the obtained table information; For the main table, display all information as initialization data; For sub-tables, the method further includes a step of detecting whether the field information of the sub-table matches that of the main table, and if so, displaying it according to the logic of the main table, and if not, hiding, for example, fields that do not exist in the main table in the sub-table, and displaying the mismatched field information as empty in both the main table and the sub-table.

[0048] When adding field information that exists in a subtable to one of the main table and subtable, for example, the main table, the field information is inserted into the main table and the corresponding initialization content is input. Since the field information is newly added to the main table, the field information exists for each data row and is empty by default. If the input is successful, the contents of the main table and subtable are synchronized.

[0049] In one or more embodiments, when a table is shared, both the primary table owner and the target of the shared table may receive a notification, for example, via messenger software, thus improving the timeliness and efficiency of handling table documents.

[0050] Although the steps in the flowcharts of the figures are shown sequentially, as indicated by the arrows, it should be understood that they are not necessarily performed sequentially in the order indicated by the arrows. Unless explicitly stated herein, there is no strict order restriction on the performance of these steps, and they may be performed in other orders. Furthermore, at least some of the steps in the flowcharts of the figures may include multiple sub-steps or multiple stages that are not necessarily completed at the same time but may be performed at different times, and the order of execution is not necessarily sequential, and may be performed sequentially or alternately with other steps or at least some of the sub-steps or stages of other steps.

[0051] Those skilled in the art will understand that implementing all or part of the steps in the method of the above-mentioned embodiments may be achieved by instructing relevant hardware with a computer program, and this computer program may be stored in a computer-readable storage medium, which, when executed, may include the steps of the above-mentioned method embodiments. Here, the storage medium may be a non-volatile storage medium such as a magnetic disk, an optical disk, a read-only memory (ROM), or a random access memory (RAM), etc.

[0052] (Table Content Processing Device) As shown in Figure 5, in order to realize the technical solutions in the embodiments of the present disclosure, the present disclosure specifically provides a table content processing device that can be applied to various electronic terminal devices. No further reference will be made to nouns, terms, etc. in the table content processing device of the present disclosure that are the same as those in the above table content processing method.

[0053] The table content processing device of this embodiment includes an information selection module 501 , a document generation module 502 , a document transmission module 503 and a citation synchronization module 504 .

[0054] The information selection module 501 selects the data row information in the first table.

[0055] In one or more embodiments, the first table is, for example, an original table in which selected data row information is located, and may be referred to as, for example, a main table, and the second table is, for example, a shared table, and may be referred to as, for example, a sub-table.

[0056] In one or more embodiments, the information selection module 501 may determine the data row information in the first table by, for example, checking one or more data rows in the main table, i.e., selecting a portion of the [start, end] range of the array in the main table.

[0057] After selecting the above data row information, the information selection module 501 clicks on a sharing-related tool or menu to trigger an operation such as a sharing operation. There is no limitation on the display location of the sharing-related tool or menu, and it may be on the menu bar or on another toolbar, and it is preferable that it is located before the selected one or more data rows. When one or more data rows are selected, the sharing-related tool or menu will automatically pop up, and the display content of the sharing-related tool or menu may be, for example, "Move to a new table" or "Share the new table", but is not particularly limited.

[0058] The document generation module 502 generates a first document or a second table in response to a trigger operation on the data row information, the first document including the second table, and the second table including the data row information. In one or more embodiments, for example, the generated first document is itself the second table, although of course the first document may include the second table.

[0059] In one or more embodiments, the trigger operation may further include a sharing setting module for setting a name of the first document or a name of the second table, or for setting a transmission target. For example, the trigger operation may include at least setting a name of the first document or a name of the second table, or for setting a transmission target. For example, when a sharing operation is performed by clicking a sharing-related tool or menu, a pop-up window may pop up, for example, for setting a heading or name of the newly generated document or sub-table, or for selecting a target target for sharing.

[0060] In one or more embodiments, as shown in FIG. 3 , the sharing setting module may, for example, use the content of the selected [start, end] range as the base content, send a creation command to the server to create a new document or sub-table for sharing, and after creating the new document or sub-table, return attribute information of the sub-table, where the field information of the new sub-table is kept consistent with that of the main table.

[0061] The document sending module 503 sends the first document or the second table to the target access user.

[0062] In one or more embodiments, the system further includes a citation synchronization module 504 that cites data line information in the second table in the area of ​​data line information in the first table, and in one or more embodiments, the citation is performed by, for example, deleting the content of [start, end] in the main table from the main table and inserting the corresponding data line in the second table at the start position as a new special cited data line, as shown in Figure 3. When citing, the number of display lines of the data line information is shifted from the start position to match the data line information with the content of the second table.

[0063] The citation synchronization module 504 further displays the edited data line information on the data line information of the first table in response to an edit operation on the data line information of the second table.

[0064] In one or more embodiments, the system further includes an authority control module that identifies the authority information of an accessing user for the first document or the second table and determines the display content of the data row information in the first table for the accessing user based on the authority information.

[0065] In one or more embodiments, the authority control module further hides the data row information in the first table in response to not having the authority information and displays link information of the second table in the area where the data row information is located, and displays the data row information in the first table in response to the accessing user having the authority information.

[0066] In one or more embodiments, the authority control module, for example, determines that if the setting of the first table indicates that the main table has viewing authority over the sub-table, the content of the data row information in the main table can be viewed, otherwise it cannot be viewed; if the setting of the first table indicates that the main table has editing authority over the sub-table, the content of the data row information in the main table can be edited; when editing the data row information in the main table, the edited content is synchronized with the sub-table, which is the second table; when editing in the sub-table, the edited content is synchronized with the data row information of the main table, and can be viewed or edited.

[0067] In one or more embodiments, the system further includes a display module that highlights a relevant region of the data row information in the first table, e.g., displays a unique marker in the relevant region, and the display module further displays a name and / or a link to the second table in response to a trigger operation on the relevant region. In one or more embodiments, for example, when the unique marker is clicked, a link to the second table or the name of the second table appears, and when the link to the second table or the name of the second table that appears is clicked, a jump to the second table occurs.

[0068] In one or more embodiments, once the table content processing is completed, the table content processing device of the present disclosure also solves the problem of inconsistent field information between the main table and the sub-table after sharing, and in one or more embodiments, the field information includes at least column headers and / or column attributes, for example.

[0069] In one or more embodiments, the main table and the sub-table may have inconsistent field information, which may cause inconsistencies. The table content processor of the present disclosure: a field information acquisition module that acquires field information of the main table and all sub-tables, returns the acquired table information, and displays all information of the main table as initialization data; a field information detection module for detecting whether the field information of the sub-table is consistent with that of the main table; a field information display module that displays the results of the detection by the field information detection module, and if there is a match, displays them according to the logic of the main table, and if there is no match, hides the fields that do not exist in the main table in the sub-table, and displays the mismatched field information as empty in both the main table and the sub-table; The system further includes a field information addition module that, when adding field information present in a subtable to one of the main table and the subtable, for example, the main table, inserts the field information into the main table and inputs corresponding initialization content; since the field information is newly added to the main table, the field information exists for each data row and is empty by default; and, if the input is successful, synchronizes the content of the main table and the subtable.

[0070] In one or more embodiments, the system further includes a notification module that enables both the primary table owner and the target objects to which the table is shared to receive notifications, for example, via messenger software, when the table is shared, thereby improving the timeliness and efficiency of handling table documents.

[0071] (Another embodiment of the table content processing method) First, nouns in some application scenarios of the present disclosure will be described.

[0072] Record: For example, a row in a table can be called a record. In a table, you specify an array in the order of records and describe the number of rows in the table for each record. When you select one or more records, the range within the array is actually selected. For example, you can write [start,end].

[0073] Index column: For example, it may be the key information of each record that identifies the attribute information of each record, and it may not be deleted. When a user copies the contents of one table to another table by copy and paste, it is necessary to ensure that the index columns of the two tables are the same; otherwise, the contents cannot be pasted.

[0074] Field information: For example, it can represent the headings or attributes of columns in a table. For example, a table may have a column called "Most Important."

[0075] 6, a flowchart of an embodiment of a table content processing method according to the present disclosure is shown, which includes steps S61 and S62.

[0076] S61: The first data row information in the first table is selected.

[0077] In one or more embodiments, the first table is, for example, the original table in which the first data row information is located, and may be called, for example, a sub-table, and in the following steps, the second table is, for example, a table that cites the cited content, and may be called, for example, a main table.

[0078] In one or more embodiments, the method of selecting the first data row information in the first table may include, for example, selecting by checking one or more records in the subtable, i.e., selecting a portion of the [start, end] range of the array in the subtable, and writing the version of the table at that time as version.

[0079] As shown in Figure 7, Document A is the subtable and Document B is the main table. When the above citation is selected, the citation, which is the selected first data row information, is copied and written to the clipboard.

[0080] In one or more embodiments, a citation operation may be performed by clicking on a citation trigger tool or menu, and the display location of the citation trigger tool or menu is not limited, and may be in the menu bar or other toolbar, preferably in a position before the selected record or records. When one or more records are selected, the citation trigger tool or menu automatically pops up, and the display content of the citation trigger tool or menu may be, for example, "Copy real-time citation" or "Create real-time citation," but is not particularly limited.

[0081] S62: In response to an insert operation into the first document or the second table, the first data line information is inserted into the first document or the second table to generate second data line information, and the first data line information and the second data line information are in a citation relationship.

[0082] In one or more embodiments, as shown in FIG. 7, the first document or the second table is opened, and the citation content, which is the first data row information, is obtained from the clipboard, and inserted into the first document or the second table in response to an insert operation, thereby generating the second data row information. In one or more embodiments, the first document may include the second table, but of course, it may also be an independent document.

[0083] In one or more embodiments, in response to an insert operation into the first document or the second table, it is necessary to determine whether the preset attributes of the first table and the second table are the same, and if they are the same, generate second data line information and determine whether to establish a citation relationship between the second data line information and the first data line information; if they are not the same, copy the first data line information into the first document or the second table and generate second data line information, or reject the insert operation.

[0084] In one or more embodiments, the preset attribute may be, for example, the above-mentioned index string or a data type including the index string, and the citation method for establishing a citation relationship between the second data row information and the first data row information is, for example, a real-time citation method.

[0085] In one or more embodiments, in the case of a database table, its index columns have a set fixed data type (i.e., each column can only input a fixed data type, for example, column a can only input person, column b can only input date and time), so in response to an insert operation into the first document or the second table, it determines whether the pre-set attributes of the first table and the second table are the same, and if the two tables have the same index column, it generates second data row information and prompts whether to paste it as a "real-time quote", and if the index columns of the two tables are different, it prompts "paste is not supported because the index columns are different".

[0086] In one or more embodiments, in the case of a typical spreadsheet, when it is created, its index columns do not have a fixed data type (i.e., various data types can be input into any column), so in response to an insert operation into the first document or the second table, it is determined whether the preset attributes of the first table and the second table are the same, and if they are the same, it is determined whether to establish a citation relationship between the second data row information and the first data row information, and if they are not the same, the first data row information is copied to the first document or the second table, and the second data row information is generated.

[0087] In one or more embodiments, copy and paste is possible even if the columns of the two tables are not exactly the same, as long as you can ensure that the index columns are the same.

[0088] In one or more embodiments, the method further includes generating a citation trigger area in response to an insert operation into the first document or the second table, where the citation trigger area includes, for example, the above-mentioned citation trigger tool or menu. A trigger operation on the citation trigger tool or menu in the citation trigger area can determine the manner of generating the second data row information. For example, in one or more embodiments, in response to a first trigger operation on the citation trigger area, the second data row information is generated and a citation relationship between the second data row information and the first data row information is established. Specifically, when inserting the first data row information into the first document or the second table to generate the second data row information, for example, when one or more records are selected, the citation trigger tool or menu automatically pops up. The displayed content of the citation trigger tool or menu may be, for example, "Copy real-time citation" or "Create real-time citation," but is not limited thereto. In one or more embodiments, for example, in response to a second trigger operation on the citation trigger region, only the first data row information is copied to the first document or the second table to generate the second data row information. Specifically, when inserting the first data row information into the first document or the second table to generate the second data row information, for example, when performing an insert operation on the second table, the text of the first data row information may be directly inserted and copied to the first document or the second table by not setting the above-mentioned real-time citation method or by choosing to cancel the above-mentioned real-time citation method, so as to generate the second data row information. In this case, when updating this part of the first data row information in the subtable, the update will not be synchronized in the main table, and when updating the second data row information in the main table, the update will not be synchronized in the subtable.

[0089] In one or more embodiments, when inserting the first data row information into the second table, if the range of [start, end] in the first table has changed, the server calculates the new [start, end] through the version and collaboration algorithm, describes the new table range with it, and updates it in the second table.

[0090] In one or more embodiments, for example, a real-time citation method is used to establish a citation relationship between the second data line information in the second table and the first data line information in the first table, and the citation relationship is displayed with a specific marker in the first data line information and the second data line information, for example, a first citation marker is displayed in the relevant area of ​​the first data line information in the first table, and a second citation marker is displayed in the relevant area of ​​the second data line information in the second table, and the display positions of the relevant areas of the first citation marker and the second citation marker are not limited, and may be on a menu bar, another toolbar, or within a predetermined distance of the first data line information or the second data line information.

[0091] In one or more embodiments, in response to a trigger operation on a first citation marker in the first data line information, cited information for the first data line information is displayed, and in response to a trigger operation on a second citation marker in the second data line information, content update information and / or data source information, such as a document or table, for the second data line information is displayed. For example, clicking the first citation marker in the first data line information displays, for example, citation information by another document or table for the first data line information. Clicking the second citation marker in the second data line information displays, for example, a link to Table 1 or the name of Table 1, and clicking the link to Table 1 or the name of Table 1 causes a jump to Table 1. In one or more embodiments, the second citation marker may display, for example, the most recent update time or the person who updated the citation at the location of the related area. In this way, it is possible to know when and by whom an update was made without having to open the citation subtable. The second citation marker, for example, displays the name of a subtable in the source document at the citation location, and indicates which table is cited by the first citation marker at the source document location, making it possible to jump between and view the tables, thereby linking them together.

[0092] In one or more embodiments, in response to an editing operation on the first data line information, the edited first data line information is displayed in the second data line information, and changes in the first data line information and the second data line information in the first table and the second table are detected and synchronized based on the citation relationship.

[0093] As shown in FIG. 7, it detects whether the range of the first data row information and the second data row information in the first table and the second table has changed, and if the first data row information and the second data row information in the first table and the second table have been edited, it sends the changed collaborative data to the server and synchronizes the data with the main table or sub-table.

[0094] In one or more embodiments, once table content processing is completed, the table content processing method of the present disclosure solves the problem of inconsistent field information between a cited main table and a sub-table, and in one or more embodiments, the field information includes, for example, at least column headers and / or column attributes.

[0095] In one or more embodiments, inconsistencies may occur due to mismatched field information between the main table and the sub-table. The table content processing method of the present disclosure includes: When a user accesses a master table, obtaining field information of the master table and the owned subtable, and returning the obtained table information; For the main table, display all information as initialization data; For sub-tables, the method further includes a step of detecting whether the field information of the sub-table matches that of the main table, and if so, displaying it according to the logic of the main table, and if not, hiding, for example, fields that do not exist in the main table in the sub-table, and displaying the mismatched field information as empty in both the main table and the sub-table.

[0096] When adding field information that exists in a subtable to one of the main table and subtable, for example, the main table, the field information is inserted into the main table and the corresponding initialization content is input. Since the field information is newly added to the main table, the field information exists for each record and is empty by default. If the input is successful, the contents of the main table and subtable are synchronized.

[0097] Although the steps in the flowcharts of the figures are shown sequentially, as indicated by the arrows, it should be understood that they are not necessarily performed sequentially in the order indicated by the arrows. Unless explicitly stated herein, there is no strict order restriction on the performance of these steps, and they may be performed in other orders. Furthermore, at least some of the steps in the flowcharts of the figures may include multiple sub-steps or multiple stages that are not necessarily completed at the same time but may be performed at different times, and the order of execution is not necessarily sequential, and may be performed sequentially or alternately with other steps or at least some of the sub-steps or stages of other steps.

[0098] Those skilled in the art will understand that implementing all or part of the steps in the method of the above-mentioned embodiments may be achieved by instructing relevant hardware with a computer program, and this computer program may be stored in a computer-readable storage medium, which, when executed, may include the steps of the above-mentioned method embodiments. Here, the storage medium may be a non-volatile storage medium such as a magnetic disk, an optical disk, a read-only memory (ROM), or a random access memory (RAM), etc.

[0099] (Other embodiments of table content processing device) As shown in Figure 8, in order to realize the technical solutions in the embodiments of the present disclosure, the present disclosure specifically provides a table content processing device that can be applied to various electronic terminal devices. No further reference will be made to nouns, terms, etc. in the table content processing device of the present disclosure that are the same as those in the above table content processing method.

[0100] The table content processing device of this embodiment includes an information selection module 801, an information insertion module 802, a display module 803, and a judgment setting module 804.

[0101] The information selection module 801 selects the first data row information in the first table.

[0102] In one or more embodiments, the first table is, for example, the original table in which the first data row information is located, and may be called, for example, a sub-table, and in the following steps, the second table is, for example, a table that cites the cited content, and may be called, for example, a main table.

[0103] In one or more embodiments, the manner in which the information selection module 801 determines the first data row information in the first table may include, for example, selecting one or more records in the subtable by checking them, i.e., selecting a portion of the [start, end] range of the array in the subtable, and writing the version of the table at that time as version.

[0104] As shown in FIG. 7, document A is a sub-table and document B is a main table. When the information selection module 801 selects the first data row information, it copies the citation content, which is the selected first data row information, and writes the selected citation content to the clipboard.

[0105] In one or more embodiments, the information selection module 801 may perform a citation operation by clicking a citation trigger tool or menu. There is no limitation on the display location of the citation trigger tool or menu, and it may be located on the menu bar or other toolbar, preferably before the selected record or records. When one or more records are selected, the citation trigger tool or menu automatically pops up, and the display content of the citation trigger tool or menu may be, for example, "Copy real-time citation" or "Create real-time citation", but is not particularly limited thereto.

[0106] In response to an insert operation into the first document or the second table, the information insertion module 802 inserts the first data line information into the first document or the second table to generate second data line information, and the first data line information and the second data line information are in a citation relationship.

[0107] In one or more embodiments, as shown in FIG. 7 , the information insertion module 802 opens the first document or the second table, obtains the citation content, which is the first data row information, from the clipboard, and writes it into the first document or the second table to generate the second data row information. In one or more embodiments, the first document may include the second table, but of course, it may also be an independent document.

[0108] As shown in FIG. 7, the information insertion module 802 further detects whether the range of the first data row information and the second data row information, which are the citation contents in the first table and the second table, has changed. If the citation contents in the first table and the second table have been edited, the information insertion module 802 sends the changed collaborative data to synchronize the data with the main table.

[0109] In one or more embodiments, the information insertion module 802 further generates a citation trigger area in response to an insertion operation into the first document or the second table, where, for example, the above-mentioned citation trigger tool or menu is set in the citation trigger area. A trigger operation can be performed on the citation trigger tool or menu in the citation trigger area to determine the manner of generating the second data row information. For example, in one or more embodiments, in response to a first trigger operation on the citation trigger area, the second data row information is generated and a citation relationship between the second data row information and the first data row information is established. Specifically, when inserting the first data row information into the first document or the second table to generate the second data row information, for example, when one or more records are selected, the citation trigger tool or menu automatically pops up. The displayed content of the citation trigger tool or menu may be, for example, "Copy real-time citation" or "Create real-time citation," but is not limited thereto. In one or more embodiments, the information insertion module 802, for example, in response to a second trigger operation on the citation trigger area, copies only the first data row information to the first document or the second table to generate the second data row information. Specifically, when inserting the first data row information into the first document or the second table to generate the second data row information, for example, when performing an insert operation on the second table, the information insertion module 802 may directly insert and copy the text of the first data row information into the first document or the second table to generate the second data row information, for example, by not setting a real-time citation method or by choosing to cancel the real-time citation method. In this case, when updating the first data row information in the subtable, the update is not synchronized in the main table, and when updating the second data row information in the main table, the update is not synchronized in the subtable.

[0110] In one or more embodiments, when inserting the first data row information into the second table, if the range of [start, end] in the first table has changed, the information insertion module 802 calculates the new [start, end] through the version and collaboration algorithm, and then describes the new table range and updates it in the second table.

[0111] In one or more embodiments, the information insertion module 802 further establishes a citation relationship between the second data row information in the second table and the first data row information in the first table, for example, by real-time citation.

[0112] In one or more embodiments, the display module 803 further includes a display module for displaying the citation relationship with a specific marker in the first data line information and the second data line information, for example, displaying a first citation marker in the relevant area of ​​the first data line information in the first table and a second citation marker in the relevant area of ​​the second data line information in the second table. The display locations of the relevant areas of the first citation marker and the second citation marker are not limited, and may be on a menu bar, another toolbar, or within a predetermined distance of the first data line information or the second data line information.

[0113] The display module 803 further displays cited information for the first data line information, for example, in response to a trigger operation on a first citation marker in the first data line information, and displays content update information and / or data source information, such as a document or table, for the second data line information, in response to a trigger operation on a second citation marker in the second data line information. For example, clicking the first citation marker in the first data line information displays citation information for the first data line information by another document or table, for example, clicking the second citation marker in the second data line information displays a link to Table 1 or the name of Table 1, and clicking the link to Table 1 or the name of Table 1 displays a jump to Table 1. In one or more embodiments, the second citation marker may display, for example, the most recent update time or the person who updated the citation at the location of the related area. This allows a user to know when and by whom an update was made without having to open the citation subtable. The second citation marker, for example, displays the name of a subtable in the source document at the citation location, and indicates which table is cited by the first citation marker at the source document location, making it possible to jump between and view the tables, thereby linking them together.

[0114] In one or more embodiments, the display module 803 further comprises: In response to an editing operation on the first data line information, displaying the edited first data line information on the second data line information; Based on the citation relationship, changes in the first data line information and the second data line information in the first table and the second table are detected and synchronized.

[0115] The determination setting module 804 In response to an insert operation into the first document or the second table, determine whether the preset attributes of the first table and the second table are the same, and if they are the same, generate second data line information and determine whether to establish a citation relationship between the second data line information and the first data line information, and if they are not the same, copy the first data line information into the first document or the second table, generate second data line information, or reject the insert operation; When the first data line information is inserted into the first document or the second table to generate the second data line information, it is determined whether or not a citation relationship between the second data line information and the first data line information is established.

[0116] In one or more embodiments, the pre-set attribute may be, for example, the index string described above or a data type including an index string, and the citation method for establishing a citation relationship between the second data row information and the first data row information is, for example, a real-time citation method.

[0117] In one or more embodiments, in the case of a database table, its index columns have a set fixed data type (i.e., each column can only input a fixed data type, for example, column a can only input person, column b can only input date and time), so in response to an insert operation into the first document or the second table, it determines whether the pre-set attributes of the first table and the second table are the same, and if the two tables have the same index column, it generates second data row information and prompts whether to paste it as a "real-time quote", and if the index columns of the two tables are different, it prompts "paste is not supported because the index columns are different".

[0118] In one or more embodiments, in the case of a typical spreadsheet, when it is created, its index columns do not have a fixed data type (i.e., various data types can be input into any column), so in response to an insert operation into the first document or the second table, it is determined whether the preset attributes of the first table and the second table are the same, and if they are the same, it is determined whether to establish a citation relationship between the second data row information and the first data row information, and if they are not the same, the first data row information is copied to the first document or the second table, and the second data row information is generated.

[0119] In one or more embodiments, the decision setting module 804 allows copy and paste even if the columns of the two tables are not exactly the same, as long as it can ensure that the index columns are the same.

[0120] In one or more embodiments, once table content processing is completed, the table content processing method of the present disclosure solves the problem of inconsistent field information between a cited main table and a sub-table, and in one or more embodiments, the field information includes, for example, at least column headers and / or column attributes.

[0121] In one or more embodiments, the main table and the sub-table may have inconsistent field information, which may cause inconsistencies. The table content processor of the present disclosure: a field information acquisition module that acquires field information of the main table and all sub-tables, returns the acquired table information, and displays all information of the main table as initialization data; a field information detection module for detecting whether the field information of the sub-table is consistent with that of the main table; a field information display module that displays the results of the detection by the field information detection module, and if there is a match, displays them according to the logic of the main table, and if there is no match, hides the fields that do not exist in the main table in the sub-table, and displays the mismatched field information as empty in both the main table and the sub-table; The system further includes a field information addition module that, when adding field information present in a subtable to one of the main table and the subtable, for example, the main table, inserts the field information into the main table and inputs corresponding initialization content; since the field information is newly added to the main table, the field information exists for each record and is empty by default; and, if the input is successful, synchronizes the content of the main table and the subtable.

[0122] Each block in the block diagrams in the drawings may represent a module including one or more executable instructions for implementing a predetermined logical function, but it should be understood that these modules are not necessarily executed in order. Each module and functional unit in the embodiments of the device disclosed herein may be integrated into a single processing module, may exist physically as separate units, or two or more modules or functional units may be integrated into a single module. Each of the integrated modules can be realized as either hardware or software functional modules. When the integrated module is implemented in the form of a software functional module and sold or used as an independent product, it can also be stored on a computer-readable storage medium. The storage medium may be a read-only memory, a magnetic disk, an optical disk, etc.

[0123] (Table Content Processing Equipment) To solve the above technical problems, an embodiment of the present disclosure further provides an electronic device. Referring now to FIG. 9, a structural schematic diagram of an electronic device (e.g., the terminal device or server of FIG. 1) 600 suitable for implementing the embodiment of the present disclosure is shown. The terminal device in the embodiment of the present disclosure may include, but is not limited to, mobile terminals such as mobile phones, notebook computers, digital broadcast receivers, personal digital assistants (PDAs), tablets (PADs), portable multimedia players (PMPs), and in-vehicle terminals (e.g., car navigation terminals), as well as fixed terminals such as digital TVs and desktop computers. The electronic device shown in FIG. 9 is merely an example and does not limit the functions and scope of use of the embodiment of the present disclosure.

[0124] 9, electronic device 600 may include a processing unit (e.g., a central processor, a graphics processor, etc.) 601 that can perform various appropriate operations and processes in accordance with a program stored in read-only memory (ROM) 602 or a program loaded from storage device 606 into random access memory (RAM) 603. RAM 603 also stores various programs and data necessary for the operation of electronic device 600. Processing unit 601, ROM 602, and RAM 603 are connected to one another via a bus 604. An input / output (I / O) interface 605 is also connected to bus 604.

[0125] Typically, input devices 606, including, for example, a touchscreen, touchpad, keyboard, mouse, camera, microphone, accelerometer, gyroscope, etc.; output devices 607, including, for example, a liquid crystal display (LCD), speaker, vibrator, etc.; storage devices 606, including, for example, a magnetic tape, hard disk, etc.; and communication devices 609 can be connected to the I / O interface 605. The communication devices 609 can enable the electronic device 600 to communicate wirelessly or via wires with other devices to exchange data. While FIG. 6 illustrates the electronic device 600 with various devices, it should be understood that not all of the devices shown need be implemented or included. Alternatively, more or fewer devices can be implemented or included.

[0126] In particular, according to embodiments of the present disclosure, the processes described above with reference to the flowcharts can be implemented as a computer software program. For example, embodiments of the present disclosure include a computer program product including a computer program embodied on a non-transitory computer-readable medium, the computer program including program code for performing the methods illustrated in the flowcharts. In such embodiments, the computer program may be downloaded and installed from a network via the communication device 609, installed from the storage device 606, or installed from the ROM 602. When the computer program is executed by the processing device 601, the functions defined in the methods according to the embodiments of the present disclosure are performed.

[0127] It should be noted that the computer-readable medium referred to above in this disclosure may be a computer-readable signal medium or a computer-readable storage medium, or any combination of the two. The computer-readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples of computer-readable storage media may include, but are not limited to, an electrical connection having one or more wires, a portable computer disk, 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 disk read-only memory (CD-ROM), an optical memory device, a magnetic memory device, or any suitable combination of the above. In this disclosure, a computer-readable storage medium may be any tangible medium that contains or stores a program that can be used by or in combination with an instruction execution system, apparatus, or device. In contrast, in this disclosure, a computer-readable signal medium may include a baseband or propagating data signal as part of a carrier carrying computer-readable program code. Such propagated data signals may take a variety of forms, including, but not limited to, electromagnetic signals, optical signals, or any suitable combination of the above. A computer-readable signal medium may be any computer-readable medium, other than a computer-readable storage medium, that can transmit, propagate, or transmit a program for use by or in connection with an instruction execution system, apparatus, or device. The program code contained in the computer-readable medium may be transmitted over any suitable medium, including, but not limited to, wire, optical cable, RF (radio frequency), etc., or any suitable combination of the above.

[0128] In some embodiments, clients and servers may communicate using any network protocol now known or hereafter developed, such as HTTP (Hypertext Transfer Protocol), and may interconnect with any form or medium of digital data communication (e.g., a communications network). Examples of communications networks include local area networks ("LANs"), wide area networks ("WANs"), networks (e.g., the Internet), and end-to-end networks (e.g., ad-hoc end-to-end networks), as well as any network now known or hereafter developed.

[0129] The computer-readable medium may be included in the electronic device, or may be separate and not integrated into the electronic device.

[0130] The computer-readable medium includes one or more programs, which, when executed by the electronic device, cause the electronic device to perform the following steps: obtaining at least two Internet Protocol addresses; sending a node evaluation request including the at least two Internet Protocol addresses to a node evaluation device, the node evaluation device selecting and returning an Internet Protocol address from the at least two Internet Protocol addresses; and receiving the Internet Protocol address returned from the node evaluation device, wherein the obtained Internet Protocol address indicates an edge node in a content distribution network.

[0131] Alternatively, the computer-readable medium includes one or more programs that, when executed by the electronic device, cause the electronic device to perform the steps of receiving a node evaluation request including at least two Internet Protocol addresses, selecting an Internet Protocol address from the at least two Internet Protocol addresses, and returning the selected Internet Protocol address, wherein the received Internet Protocol address indicates an edge node in a content distribution network.

[0132] Computer program code for carrying out operations of the present disclosure can be written in one or more programming languages, or combinations thereof, including, but not limited to, object-oriented programming languages ​​such as Java, Smalltalk, C++, etc. The program code can execute entirely on the user computer, partially on the user computer, as a separate software package, partially on the user computer, partially on a remote computer, or entirely on a remote computer or server. When a remote computer is involved, the remote computer can be connected to the user computer via any type of network, including a local area network (LAN) or a wide area network (WAN), or can be connected to an external computer (e.g., connected via the Internet using an Internet Service Provider).

[0133] The flowcharts and block diagrams in the figures 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 flowcharts or block diagrams may represent a module, program segment, or portion of code, including one or more executable instructions for implementing a given logical function. Note that in some alternative implementations, the functions shown in the blocks may occur in a different order than that shown in the figures. For example, two blocks shown in succession may actually be executed substantially in parallel or may be executed in the reverse order depending on the functionality involved. Furthermore, each block of the block diagrams and / or flowcharts, and combinations of blocks in the block diagrams and / or flowcharts, may be implemented in a dedicated hardware-based system that performs a given function or operation, or may be implemented as a combination of dedicated hardware and computer instructions.

[0134] The units described in the embodiments of the present disclosure may be implemented by software or hardware. The names of the units may not necessarily limit the units themselves. For example, the first acquisition unit may be described as a "unit for acquiring at least two Internet Protocol addresses."

[0135] In the context of this 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. A 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 thereof. More specific examples of machine-readable storage media include one or more wire-based electrical connections, a portable computer disk, 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 disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination thereof.

[0136] One or more embodiments of the present disclosure may include: selecting data row information in Table 1; generating a first document or a second table in response to a trigger operation on the data row information, wherein the first document includes the second table and the second table includes the data row information; and sending the first document or the second table to a target access user.

[0137] One or more embodiments of the present disclosure may include: The present invention provides a table content processing method, characterized in that the data line information in the second table is referenced in an area of ​​the data line information in the first table.

[0138] One or more embodiments of the present disclosure may include: The present invention provides a table content processing method, characterized in that in response to an editing operation on the data row information of the second table, edited data row information is displayed on the data row information of the first table.

[0139] One or more embodiments of the present disclosure may include: The step of quoting the data line information in the second table in the area of ​​the data line information in the first table includes: A method for processing table contents is provided, comprising the step of highlighting relevant areas of the data row information in the first table.

[0140] One or more embodiments of the present disclosure may include: The present invention provides a table content processing method, further comprising the step of displaying the name and / or link of the second table in response to a trigger operation on the related area.

[0141] One or more embodiments of the present disclosure may include: The present invention provides a table content processing method, characterized in that the trigger operation includes setting the name of the first document or the name of the second table, or setting a transmission target.

[0142] One or more embodiments of the present disclosure may include: Identifying the access user's authority information for the first document or the second table; The present invention provides a table content processing method, characterized in that display content for the access user of the data row information in the first table is determined based on the authority information.

[0143] One or more embodiments of the present disclosure may include: The step of determining display content for the access user of the data row information in the first table based on the authority information includes: in response to the accessing user not having the authority information, hiding the data row information in the first table and displaying link information of the second table in the area where the data row information is located; and displaying the data row information in the first table in response to the accessing user having the authority information.

[0144] One or more embodiments of the present disclosure may include: Obtaining field information of the first table and the second table; determining whether the field information in the second table matches that in the first table; If there is no match, the display in the second table is hidden. The table content processing method is characterized in that the field information includes at least a column header and / or a column attribute.

[0145] One or more embodiments of the present disclosure may include: The table content processing method is characterized in that the field information that does not match is displayed as empty in the first table and the second table.

[0146] One or more embodiments of the present disclosure may include: A table content processing method is provided, characterized in that when field information existing in one of the first table and the second table is added to the other table, the field information is inserted into the one table and corresponding initialization content is input.

[0147] One or more embodiments of the present disclosure may include: an information selection module for selecting data row information in the first table; a document generation module that generates a first document or a second table in response to a trigger operation on the data row information, the first document including the second table, and the second table including the data row information; a document transmission module that transmits the first document or the second table to a target access user; and a quotation synchronization module that quotes the data line information in the second table in the area of ​​the data line information in the first table, and displays the edited data line information in the data line information of the first table in response to an editing operation on the data line information of the second table.

[0148] One or more embodiments of the present disclosure may include: a display module that highlights a relevant region of the data row information in the first table and displays a name and / or a link to the second table in response to a trigger operation on the relevant region; a shared setting module for setting the name of the first document or the name of the second table, or for setting a transmission target; an authority control module that identifies authority information of an accessing user for the first document or the second table, and determines display content for the accessing user of the data row information in the first table based on the authority information; The authority control module further provides a table content processing device characterized in that, in response to the accessing user not having the authority information, it hides the data row information in the first table and displays link information of the second table in the area where the data row information is located, and in response to the accessing user having the authority information, it displays the data row information in the first table.

[0149] One or more embodiments of the present disclosure may include: a field information acquisition module for acquiring field information of the first table and the second table; a field information detection module that detects whether the field information in the second table matches that in the first table; If the field information does not match, hide the display in the second table; a field information display module for displaying the non-matching field information as empty in the first table and the second table; a field information addition module that, when adding the field information existing in one of the first table and the second table to the other table, inserts the field information into the one table and inputs corresponding initialization content; The table content processing device is characterized in that the field information includes at least a column header and / or a column attribute.

[0150] One or more embodiments of the present disclosure may include: selecting a first data row of information in a first table; A table content processing method is provided, comprising: a step of inserting the first data line information into the first document or the second table in response to an insert operation into the first document or the second table to generate second data line information, wherein the first data line information and the second data line information are in a citation relationship.

[0151] One or more embodiments of the present disclosure may include: The first document includes the second table.

[0152] One or more embodiments of the present disclosure may include: The table content processing method is characterized in that, in response to an editing operation on the first data line information, the edited first data line information is displayed on the second data line information.

[0153] One or more embodiments of the present disclosure may include: In response to an insert operation into the first document or the second table, determining whether the predetermined attributes of the first table and the second table are the same; If they are the same, generate the second data line information, and determine whether to establish a citation relationship between the second data line information and the first data line information; If they are not the same, the first data row information is copied to the first document or the second table, and the second data row information is generated, or the insert operation is rejected.

[0154] One or more embodiments of the present disclosure may include: generating a citation trigger region in response to an insert operation into the first document or the second table; The step of generating second data row information includes: generating second data line information in response to a first trigger operation on the citation trigger region and establishing a citation relationship between the second data line information and the first data line information; or There is provided a table content processing method, characterized by including a step of copying the first data row information to the first document or the second table in response to a second trigger operation on the quote trigger area, and generating the second data row information.

[0155] One or more embodiments of the present disclosure may include: The table content processing method further comprises displaying a first citation marker in a related area of ​​the first data row information in the first table.

[0156] One or more embodiments of the present disclosure may include: A table content processing method is provided, characterized in that a second citation marker is displayed in an area related to the second data row information in the second table.

[0157] One or more embodiments of the present disclosure may include: The present invention provides a table content processing method, characterized in that cited information of the first data line information is displayed in response to a trigger operation on the first citation marker.

[0158] One or more embodiments of the present disclosure may include: The present invention provides a table content processing method, characterized in that content update information and / or data source information of the second data row information is displayed in response to a trigger operation on the second quotation marker.

[0159] One or more embodiments of the present disclosure may include: Obtaining field information of the first table and the second table; determining whether the field information in the second table matches that in the first table; If there is no match, the display in the second table is hidden. The table content processing method is characterized in that the field information includes at least a column header and / or a column attribute.

[0160] One or more embodiments of the present disclosure may include: The table content processing method is characterized in that the field information that does not match is displayed as empty in the first table and the second table.

[0161] One or more embodiments of the present disclosure may include: A table content processing method is provided, characterized in that when field information existing in one of the first table and the second table is added to the other table, the field information is inserted into the one table and corresponding initialization content is input.

[0162] One or more embodiments of the present disclosure may include: an information selection module for selecting information from a first data row in the first table; an information insertion module that, in response to an insert operation into a first document or a second table, inserts the first data line information into the first document or the second table and generates second data line information, wherein the first data line information and the second data line information have a citation relationship; a display module that, in response to an editing operation on the first data line information, displays the edited first data line information on the second data line information and displays the citation relationship with a specific marker; and a judgment setting module that determines whether the predetermined attributes of the first table and the second table are the same, and if they are the same, generates the second data line information and determines whether to establish a citation relationship between the second data line information and the first data line information, and if they are not the same, copies the first data line information to the first document or the second table, generates the second data line information, or rejects the insert operation.

[0163] One or more embodiments of the present disclosure provide a computing device comprising: a memory having a computer program stored therein; and a processor that, when executed, performs the method according to any one of the preceding claims.

[0164] One or more embodiments of the present disclosure provide a computer-readable storage medium having stored thereon a computer program that, when executed by a processor, implements the method according to any one of the preceding claims.

[0165] The above description merely describes the preferred embodiments and applied technical principles of the present disclosure. Those skilled in the art will understand that the scope of the present disclosure is not limited to the technical solution consisting of a specific combination of the above technical features, but should also cover other technical solutions consisting of any combination of the above technical features or their equivalent features without departing from the idea of ​​the above disclosure. For example, a technical solution formed by mutually replacing the above features with technical features having similar functions (but not limited to) disclosed in the present disclosure.

[0166] Additionally, although operations are shown in a particular order, this should not be understood as requiring that these operations be performed in the particular order shown, or sequentially. In some environments, multitasking or parallel processing may be advantageous. Similarly, although several specific implementation details are included in the above discussion, these should not be construed as limiting the scope of the present disclosure. Some features described in the context of separate embodiments may also be implemented in combination in a single embodiment. Conversely, various features described in the context of a single embodiment may also be implemented in multiple embodiments separately or in any suitable subcombination.

[0167] Although the present subject matter has been described in language specific to structural features and / or logical operations of methods, it should be understood that the subject matter defined in the claims is not necessarily limited to the specific features or operations described above. Rather, the specific features and operations described above are merely example forms of implementing the claims.

Claims

1. 1. A method for processing table content executed by a processor of a computing device, comprising: the processor selecting data row information in a first table; In response to selecting the data row information in the first table, the processor automatically pops up an interface element configured to trigger a sharing operation of sharing with a target user; in response to selecting the interface element, the processor displaying a pop-up window configured to set a name for the first document or the second table to be generated for sharing, the pop-up window further configured to select the target user for sharing; generating, by the processor, the first document or the second table in response to setting the name via the pop-up window, the first document including the second table, and the second table including the data row information; a step of determining whether to establish a citation relationship between the data row information in the first table and the data row information in the second table based on whether a preset attribute of the first table is the same as a preset attribute of the second table, wherein the preset attribute is an index column or a data type including the index column; the processor sending the first document or the second table to the target user for sharing. Table content processing method.

2. 2. The table content processing method according to claim 1, further comprising the step of: said processor quoting said data line information in said second table in a region of said data line information in said first table.

3. 3. The table content processing method according to claim 1, further comprising a step in which, in response to an editing operation on the data row information of the second table, the processor displays the edited data row information on the data row information of the first table.

4. The step of quoting the data line information in the second table in the area of ​​the data line information in the first table comprises: the processor includes a step of highlighting an associated area of ​​the data row information in the first table. The table content processing method according to claim 2.

5. 5. The method of claim 4, further comprising the step of: said processor displaying a name and / or a link to said second table in response to a trigger operation on said related area.

6. 6. The table content processing method according to claim 5, wherein the trigger operation further includes setting a name of the first document or a name of the second table, or setting a transmission target.

7. The processor identifies permission information of an access user for the first document or the second table; The display content for the access user of the data row information in the first table is determined based on the authority information. The table content processing method according to claim 1 .

8. The step of determining display content for the access user of the data row information in the first table based on the authority information includes: In response to the access user not having the authority information, the processor hides the data row information in the first table and displays link information of the second table in an area where the data row information is located; and wherein the processor displays the data row information in the first table in response to the access user having the authority information. The table content processing method according to claim 7.

9. the processor obtains field information of the first table and the second table; determining whether the field information in the second table matches that in the first table; If there is no match, the processor hides the display in the second table; The field information includes at least a column header and / or a column attribute. The table content processing method according to claim 1 .

10. 10. The method of claim 9, further comprising the step of: displaying the field information that does not match as empty in the first table and the second table by the processor.

11. 10. The table content processing method of claim 9, wherein when adding field information existing in one of the first table and the second table to the other table, the processor inserts the field information into the one table and inputs corresponding initialization content.

12. A table content processing device, an information selection module for selecting data row information in the first table; a sharing setting module that automatically pops up an interface element configured to trigger a sharing operation of sharing with a target user in response to selecting the data row information in the first table, a sharing setting module that displays a pop-up window in response to selecting the interface element, the pop-up window configured to set a name of the first document or the second table to be generated for sharing, and the pop-up window is further configured to select the target user for sharing; a document generation module that generates the first document or the second table in response to setting the name via the pop-up window, the first document including the second table, and the second table including the data row information; a document transmission module that transmits the first document or the second table to the target user for sharing; a citation synchronization module that cites the data line information in the second table in an area of ​​the data line information in the first table, and displays the edited data line information in the data line information of the first table in response to an editing operation on the data line information of the second table; a determination setting module that determines whether to establish a citation relationship between the data row information in the first table and the data row information in the second table based on whether a preset attribute of the first table is the same as a preset attribute of the second table, wherein the preset attribute is an index column or a data type including the index column. Table content processor.

13. a display module that highlights an associated region of the data row information in the first table and displays a name and / or a link to the second table in response to a trigger operation on the associated region; a sharing setting module for setting a name of the first document or a name of the second table, or for setting a transmission target; an authority control module that identifies authority information of an accessing user for the first document or the second table, and determines display content of the data row information in the first table for the accessing user based on the authority information; The authority control module further comprises: In response to the fact that the accessing user does not have the authority information, the data row information in the first table is hidden, and link information of the second table is displayed in the area where the data row information is located; In response to the access user having the authority information, the data row information in the first table is displayed. The table content processing device of claim 12.

14. a field information acquisition module for acquiring field information of the first table and the second table; a field information detection module that detects whether the field information in the second table matches that in the first table; a field information display module that, when the field information does not match, hides the display in the second table and displays the mismatched field information as blank in the first table and the second table; a field information addition module that, when adding the field information existing in one of the first table and the second table to the other table, inserts the field information into the one table and inputs corresponding initialization content; The field information includes at least a column header and / or a column attribute. The table content processing device of claim 12.

15. a memory in which a computer program is stored; a processor that, when executing the computer program, realizes the table content processing method according to any one of claims 1 to 11; Equipped with Computer equipment.

16. A computer-readable storage medium storing a computer program that, when executed by a processor, implements the table content processing method according to any one of claims 1 to 11.

Images