CN115081412A - Table content processing method, device, equipment and storage medium - Google Patents

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

Info

Publication number
CN115081412A
CN115081412A CN202110233247.8A CN202110233247A CN115081412A CN 115081412 A CN115081412 A CN 115081412A CN 202110233247 A CN202110233247 A CN 202110233247A CN 115081412 A CN115081412 A CN 115081412A
Authority
CN
China
Prior art keywords
information
data row
row information
data
content processing
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202110233247.8A
Other languages
Chinese (zh)
Inventor
陈伟
韦宗延
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Zitiao Network Technology Co Ltd
Original Assignee
Beijing Zitiao Network Technology Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Beijing Zitiao Network Technology Co Ltd filed Critical Beijing Zitiao Network Technology Co Ltd
Priority to CN202110233247.8A priority Critical patent/CN115081412A/en
Priority to JP2023552498A priority patent/JP2024508012A/en
Priority to PCT/CN2022/078661 priority patent/WO2022184063A1/en
Publication of CN115081412A publication Critical patent/CN115081412A/en
Priority to US18/239,719 priority patent/US20240012985A1/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/177Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F3/00Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
    • G06F3/01Input arrangements or combined input and output arrangements for interaction between user and computer
    • G06F3/048Interaction techniques based on graphical user interfaces [GUI]
    • G06F3/0481Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • General Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Human Computer Interaction (AREA)
  • Health & Medical Sciences (AREA)
  • Artificial Intelligence (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The disclosure provides a table content processing method, a table content processing device, a table content processing apparatus and a storage medium. The table content processing method comprises the following steps: selecting first data row information in a first table; in response to an insertion operation in a first document or a second table, inserting the first data row information into the first document or the second table, and generating second data row information, wherein the first data row information and the second data row information have a reference relationship. The method and the device can realize real-time bidirectional synchronous updating of part of contents in the table, reduce repeated secondary processing in a cooperation process, and improve the use experience of a user.

Description

Table content processing method, device, equipment and storage medium
Technical Field
The present disclosure relates to the field of computer software technologies, and in particular, to a method, an apparatus, a device, and a storage medium for processing table contents.
Background
With the development of internet technology, forms have become common data management tools, and in the process of using forms, sometimes a plurality of users are required to maintain the content of one form together, and each user is only responsible for part of the content of the form, while data isolation is also considered.
In the prior art, if a form is to be entered together, each user is often required to separately establish a form, the forms are uniformly sent to someone after the contents of the user are edited, then the contents of each form are copied into a total form for summary, the operations are repeated every time the total form is updated, and the process is complicated.
Disclosure of Invention
The present disclosure has been made to solve the above problems, and an object of the present disclosure is to provide a method, an apparatus, a device, and a storage medium for processing table contents, which are simple and efficient and can realize real-time bidirectional synchronization of partial content data in a table. This disclosure provides this summary in order to introduce a selection of concepts in a simplified form that are further described below in the detailed description. This summary is not intended to identify key features or essential features of the claimed subject matter, nor is it intended to be used to limit the scope of the claimed subject matter.
In order to solve the above technical problem, an embodiment of the present disclosure provides a table content processing method, which adopts the following technical solutions:
selecting first data row information in a first table;
in response to an insertion operation in a first document or a second table, inserting the first data row information into the first document or the second table to generate second data row information, wherein the first data row information and the second data row information have a reference relationship.
In order to solve the above technical problem, an embodiment of the present disclosure further provides a table content processing apparatus, which adopts the following technical solution, including:
the information selection module is used for selecting first data row information in the first table;
the information inserting module is used for responding to an inserting operation in a first document or a second table, inserting the first data row information into the first document or the second table to generate second data row information, wherein the first data row information and the second data row information have a reference relation;
the display module is used for responding to the editing operation of the second data line information and displaying the edited data line information in the first data line information; and for displaying the reference relationship with a particular identity;
and the judging and setting module is used for judging whether the preset attributes of the first table and the second table are the same, if so, generating the second data row information, and determining whether to establish the reference relationship between the second data row information and the first data row information.
In order to solve the above technical problem, an embodiment of the present disclosure further provides a computer device, which adopts the following technical solutions:
comprising a memory having a computer program stored therein and a processor implementing the method as described above when executing the computer program.
In order to solve the above technical problem, an embodiment of the present disclosure further provides a computer-readable storage medium, which adopts the following technical solutions:
the computer-readable storage medium has stored thereon a computer program which, when executed by a processor, implements the method as described above.
According to the technical scheme disclosed by the disclosure, compared with the prior art, the method and the device can realize that partial contents in the table can be synchronously updated in real time and bidirectionally only by copying once, reduce repeated secondary processing in a cooperation process and contribute to improving the working efficiency.
Drawings
FIG. 1 is an exemplary system architecture diagram in which the present disclosure may be applied;
FIG. 2 is a flow diagram for one embodiment of a table content processing method according to the present disclosure;
FIG. 3 is a schematic diagram for one embodiment of a table content processing method, according to the present disclosure;
FIG. 4 is a schematic diagram of one embodiment of a table content processing apparatus, according to the present disclosure;
FIG. 5 is a schematic block diagram of one embodiment of a computer device according to the present disclosure.
The above and other features, advantages and aspects of various embodiments of the present disclosure will become more apparent by referring to the following detailed description when taken in conjunction with the accompanying drawings. Throughout the drawings, the same or similar reference numbers refer to the same or similar elements. It should be understood that the drawings are schematic and that elements and components are not necessarily drawn to scale.
Detailed Description
Unless defined otherwise, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this disclosure belongs; the terminology used in the description of the application herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the disclosure; the terms "including" and "having," and any variations thereof, in the description and claims of this disclosure and the description of the above figures are intended to cover non-exclusive inclusions. The terms "first," "second," and the like in the description and claims of the present disclosure or in the above-described drawings are used for distinguishing between different objects and not for describing a particular order.
Reference herein to "an embodiment" means that a particular feature, structure, or characteristic described in connection with the embodiment can be included in at least one embodiment of the disclosure. The appearances of the phrase in various places in the specification are not necessarily all referring to the same embodiment, nor are separate or alternative embodiments mutually exclusive of other embodiments. It is explicitly and implicitly understood by one skilled in the art that the embodiments described herein can be combined with other embodiments.
In order to make the technical solutions of the present disclosure better understood by those skilled in the art, the technical solutions in the embodiments of the present disclosure will be clearly and completely described below with reference to the accompanying drawings.
[ System Structure ]
First, the structure of the system of one embodiment of the present disclosure is explained. As shown in fig. 1, the system architecture 100 may include terminal devices 101, 102, 103, 104, a network 105, and a server 106. The network 105 serves as a medium for providing communication links between the terminal devices 101, 102, 103, 104 and the server 106.
In the present embodiment, an electronic device (for example, the terminal device 101, 102, 103, or 104 shown in fig. 1) on which the table content processing method operates can perform transmission of various information through the network 105. Network 105 may include various connection types, such as wired, wireless communication links, or fiber optic cables, to name a few. It should be noted that the wireless connection means may include, but is not limited to, a 3G/4G/5G connection, a Wi-Fi connection, a bluetooth connection, a WiMAX connection, a Zigbee connection, a UWB connection, and other now known or later developed wireless connection means.
A user may use terminal devices 101, 102, 103, 104 to interact with a server 106 via a network 105 to receive or send messages or the like. Various client applications, such as a video live and play application, a web browser application, a shopping application, a search application, an instant messaging tool, a mailbox client, social platform software, etc., may be installed on the terminal device 101, 102, 103, or 104.
The terminal device 101, 102, 103 or 104 may be various electronic devices having a touch screen display and/or supporting web browsing, including but not limited to smart phones, tablet computers, e-book readers, MP3 players (moving picture experts group compressed standard audio layer 3), MP4 (moving picture experts group compressed standard audio layer 4) players, head mounted display devices, laptop portable computers, desktop computers, and the like.
The server 106 may be a server that provides various services, such as a background server that provides support for pages displayed on the terminal devices 101, 102, 103, or 104.
It should be understood that the number of terminal devices, networks, and servers in fig. 1 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.
Here, the terminal device may implement the embodiment method of the present disclosure independently or by running an application in the android system in cooperation with other electronic terminal devices, and may also run an application in other operating systems, for example, an application in an iOS system, a Windows system, a hongmeng system, or the like, to implement the embodiment method of the present disclosure.
[ method of processing Table contents ]
First the noun explanation of part of the application scenario of the present disclosure is explained,
record: for example, a row in a table may be referred to as a record or record. In the table, the order of records is marked with an array to describe the number of rows in the table for each record. When one or more records are selected, what is actually selected is a range in the array, which may be described as [ start, end ], for example.
Index column: for example, the key information of each record is used to identify the attribute information of each record, and cannot be deleted. When a user copies contents in one table to another table in a copy-paste manner, it is necessary to ensure that index columns of the two tables are the same, and if the index columns are different, the contents cannot be pasted.
Field information: for example, the title and attributes of columns of a table, e.g., the column in the table with the "most important degree" may be represented.
Referring to FIG. 2, a flow diagram for one embodiment of a table content processing method according to the present disclosure is shown. The table content processing method comprises the following steps:
s21, selecting first data row information in the first table;
in one or more embodiments, the first table is, for example, an original table in which the first data row information is located, and may also be referred to as a secondary table, for example; the second table in the subsequent step is, for example, a table that refers to the reference content, and may also be referred to as a master table, for example.
In one or more embodiments, the manner of selecting the first data row information in the first table may include, for example, checking one or more records on the sub-table to perform the selection, that is, selecting a [ start, end ] range in an array in the sub-table, writing the version of the table at this time, and recording as version.
As shown in fig. 3, the document a is a sub-table, the document B is a main table, and after the reference content is selected, the selected first data row information, i.e., the reference content, is copied and the selected reference content is written in the clipboard.
In one or more embodiments, the reference operation may also be performed by clicking a reference triggering tool or menu, where the display position of the reference triggering tool or menu is not limited, and may be located in a menu bar or in another tool bar, preferably located in a position before the selected one or more records, and automatically pops up when one or more records are selected, and the display content of the reference triggering tool or menu may be, for example, "copy real-time reference" or "create real-time reference", and the like, and is not limited.
S22, in response to an insertion operation in a first document or a second table, inserting the first data row information into the first document or the second table to generate second data row information, wherein the first data row information and the second data row information have a reference relationship;
in one or more embodiments, as shown in fig. 3, a first document or a second table is opened, first data row information, i.e., reference content, is obtained from a clipboard and inserted into the first document or the second table in response to an insertion operation and second data row information is generated.
In one or more embodiments, in response to an insertion operation in the first document or the second table, it is further required to determine whether preset attributes of the first table and the second table are the same, if so, second data row information is generated, and it is determined whether a reference relationship between the second data row information and the first data row information is established; and if the difference is not the same, copying the first data row information into the first document or the second table to generate second data row information, or refusing the insertion operation.
In one or more embodiments, the preset attribute may be, for example, the index column mentioned above, and may also include a data type of the index column; the reference mode for establishing the reference relationship between the second data line information and the first data line information is, for example, a real-time reference mode.
In one or more embodiments, for a database table, since the index columns of the database table have a set fixed data type (that is, each column can only input data of a fixed type, for example, column a can only input people, column b can only input time and date), in response to an insertion operation in the first document or the second table, whether the preset attributes of the first table and the second table are the same is judged, if the two tables have the same index column, second data row information is generated and whether to paste as "real-time reference", and if the index columns of the two tables are different, the "index column is different and paste is not supported.
In one or more embodiments, for a common electronic form, when the common electronic form is built, because an index column of the common electronic form does not have a fixed data type (that is, each column can input different types of data at the same time), in response to an insertion operation in a first document or a second table, judging whether preset attributes of the first table and the second table are the same, generating second data row information, and determining whether to establish a reference relationship between the second data row information and the first data row information; and if the data row information is different from the first data row information, copying the first data row information into the first document or the second table to generate second data row information.
In one or more embodiments, it is only necessary to ensure that the index columns are the same, and copy-paste can succeed even if the columns of the two tables are not identical.
In one or more embodiments, the method further includes generating a reference trigger area in response to an insertion operation in the first document or the second table, for example, the reference trigger tool or the menu is set in the reference trigger area, and by performing a trigger operation on the reference trigger tool or the menu in the reference trigger area, a manner of generating the second data row information may be determined, for example, in one or more embodiments, in response to a first trigger operation on the reference trigger area, the second data row information is generated and a reference relationship between the second data row information and the first data row information is established, specifically, when the first data row information is inserted 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 reference trigger tool or the menu is automatically popped up, and the display content of the reference trigger tool or the menu may be content such as "copy real-time reference" or "create real-time reference", and are not intended to be limiting; in one or more embodiments, for example, in response to a second trigger operation on the reference trigger area, 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 the first data row information is inserted into the first document or the second table to generate the second data row information, for example, when the second table is subjected to an insertion operation, the real-time reference method is not set or the real-time reference method is selected to be cancelled, and the text of the first data row information is directly inserted to be copied to the first document or the second table to generate the second data row information, at this time, the part of the first data row information is updated on the secondary table, and the synchronous update is not performed on the primary table; the second data row information is updated on the main table and is not updated synchronously on the auxiliary table.
In one or more embodiments, if the range of [ start, end ] in the first table has been modified when the first data line information is inserted into the second table, the server calculates a new [ start, end ] by means of version and a collaborative algorithm to describe the new table range and updates the new table range into the second table.
In one or more embodiments, a reference relationship between second data line information in a second table and first data line information of a first table is established according to, for example, a real-time reference manner, and the reference relationship is displayed on the first data line information and the second data line information with a specific identifier, for example, a first reference identifier is displayed in an associated area of the first data line information in the first table, a second reference identifier is displayed in an associated area of the second data line information in the second table, and display positions of the associated areas of the first reference identifier and the second reference identifier are not limited, and may be located in a menu bar, may also be located in another toolbar, and may be located within a certain distance range of the first data line information or the second data line information.
In one or more embodiments, the referenced information of the first data line information is displayed in response to the triggering operation of the first reference identifier of the first data line information, and the content updating information and/or the data source information such as a document/table of the second data line information is displayed in response to the triggering operation of the second reference identifier of the second data line information. For example, reference information of other documents or tables of the first data line information may appear after clicking on the first reference identifier of the first data line information, a link to the first table or a name of the first table may appear after clicking on the second reference identifier of the second data line information, and jump to the first table after clicking on the link to the first table or the name of the first table; in one or more embodiments, the second reference identification further includes, for example, displaying the most recent update time and the person of the update at the location of the associated area of the reference, knowing at what time and by what person the update was made, even if the reference sub-table was not opened; the second reference identifier, for example, displays the names of the sub-tables of the source document at the referenced position, and displays which tables are referenced at the position of the source document through the first reference identifier, and the tables can be jumped to each other to be viewed, so that the tables are linked.
In one or more embodiments, in response to an editing operation on first data row information, edited first data row information is displayed in second data row information, and changes of the first data row information and the second data row information in the first table and the second table are detected and synchronized according to a reference relationship.
As shown in fig. 3, whether ranges of the first data row information and the second data row information in the first table and the second table are changed or not is detected, and if the first data row information and the second data row information in the first table and the second table are edited, the changed collaborative data is sent to the server, and the data is synchronized into the main table or the auxiliary table.
In one or more embodiments, after the form content processing is completed, the form content processing method of the present disclosure also solves the field information conflict problem between the referenced primary form and secondary form, in one or more embodiments, the field information includes at least a column header and/or a column attribute, for example.
In one or more embodiments, the primary table and the secondary table may generate a conflict due to inconsistency of the field information, and the table content processing method of the present disclosure further includes:
when a user accesses the main form, acquiring field information of the main form and all the auxiliary forms, and returning the acquired form information;
aiming at the main table, all information is displayed according to the initialization data;
detecting whether the field information of the auxiliary table is consistent with the main table or not aiming at the auxiliary table; if the two fields are consistent, the two fields are displayed according to the logic of the main table, and if the two fields are not consistent, for example, a part of fields do not exist in the main table, the two fields are hidden and displayed in the auxiliary table; for inconsistent field information, it is shown as empty in both the primary and secondary tables.
If the field information existing in the secondary table is added to one of the primary table and the secondary table, for example, the primary table, the field information is inserted into the primary table and is filled with the corresponding initialization content, each record has the field information due to the addition of the field information to the primary table, and defaults to an empty content, and the contents of the primary table and the secondary table are synchronized after the filling is successful.
It should be understood that, although the steps in the flowcharts of the figures are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and may be performed in other orders unless explicitly stated herein. Moreover, at least a portion of the steps in the flow chart of the figure may include multiple sub-steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of execution is not necessarily sequential, but may be performed alternately or alternately with other steps or at least a portion of the sub-steps or stages of other steps.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by a computer program, which can be stored in a computer-readable storage medium, and can include the processes of the embodiments of the methods described above when the computer program is executed. 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).
[ Table content processing apparatus ]
As shown in fig. 4, in order to implement the technical solution in the embodiment of the present disclosure, the present disclosure provides a table content processing apparatus, which may be specifically applied to various electronic terminal devices. The same content of nouns, terms, etc. in the table content processing apparatus of the present disclosure as in the above table content processing method will not be described again.
The table content processing apparatus according to this embodiment includes: the device comprises an information selection module 401, an information insertion module 402, a display module 403 and a judgment setting module 404.
An information selecting module 401, configured to select first data row information in a first table;
in one or more embodiments, the first table is, for example, an original table in which the first data row information is located, and may also be referred to as a secondary table, for example; the second table in the subsequent step is, for example, a table that refers to the reference content, and may also be referred to as a master table, for example.
In one or more embodiments, the manner in which the information selecting module 401 determines the first data row information in the first table may include, for example, checking one or more records on the sub-table to select, that is, selecting a [ start, end ] range in an array in the sub-table, writing the version of the table at this time, and recording as version.
As shown in fig. 3, the document a is an auxiliary table, the document B is a main table, and the information selection module 401 copies the selected first data row information, i.e., the reference content, and writes the selected reference content into the clipboard after selecting the first data row information.
In one or more embodiments, the information selecting module 401 may further perform a reference operation by clicking a reference triggering tool or menu, where a display position of the reference triggering tool or menu is not limited, and may be located in a menu bar or other tool bars, preferably located in a position before the selected one or more records, and automatically pops up when the selected one or more records are selected, and a display content of the reference triggering tool or menu may be, for example, a content such as "copy real-time reference" or "create real-time reference", and is not limited.
An information inserting module 402, configured to insert the first data row information into a first document or a second table in response to an inserting operation in the first document or the second table to generate second data row information, where the first data row information and the second data row information have a reference relationship.
In one or more embodiments, as shown in fig. 3, the information insertion module 402 is configured to open a first document or a second table, obtain first data row information, i.e., reference content, from a clipboard and write the first document or the second table and generate second data row information.
As shown in fig. 3, the information inserting module 402 is further configured to detect whether ranges of the reference contents in the first table and the second table, that is, the first data row information and the second data row information, are changed, and if the reference contents in the first table and the second table are edited, send the changed collaborative data to the information inserting module 402, and synchronize the data into the main table.
In one or more embodiments, the information inserting module 402 is further configured to generate a reference trigger area in response to an inserting operation in the first document or the second table, where, for example, the reference trigger tool or the menu is set, and by performing a trigger operation on the reference trigger tool or the menu in the reference trigger area, a manner of generating the second data row information may be determined, for example, in one or more embodiments, in response to a first trigger operation on the reference trigger area, the second data row information is generated and a reference relationship between the second data row information and the first data row information is established, specifically, when the first data row information is inserted 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 reference trigger tool or the menu is automatically popped up, and a display content of the reference trigger tool or the menu may be, for example, "copy real-time reference" or "create real-time reference", and the like, and are not intended to be limiting; in one or more embodiments, the information inserting module 402 further copies only the first data row information into the first document or the second table to generate the second data row information, for example, in response to a second trigger operation on the reference trigger area, specifically, when the first data row information is inserted into the first document or the second table to generate the second data row information, for example, when the second table is subjected to an inserting operation, the information inserting module 402 does not set a real-time reference manner or select a cancellation of the real-time reference manner, and the like, and directly inserts a text of the first data row information to copy into the first document or the second table to generate the second data row information, at this time, the first data row information is updated on the sub-table, and the updating is not synchronized on the main table; the second data row information is updated on the main table, and the second data row information is not updated on the auxiliary table synchronously.
In one or more embodiments, if the range of [ start, end ] in the first table has been modified when the first data line information is inserted into the second table, the information insertion module 402 calculates a new [ start, end ] by means of version and a collaborative algorithm to describe the new table range and update the new table range into the second table.
In one or more embodiments, the information inserting module 402 is further configured to establish a reference relationship between the second data row information in the second table and the first data row information of the first table according to, for example, a real-time reference manner;
in one or more embodiments, the apparatus further includes a display module 403 for displaying the reference relationship with a specific identifier on the first data line information and the second data line information; for example, the first reference identifier is displayed in the associated area of the first data line information in the first table, the second reference identifier is displayed in the associated area of the second data line information in the second table, the display positions of the associated areas of the first reference identifier and the second reference identifier are not limited, and the associated areas may be located in a menu bar, other tool bars, or within a certain distance range of the first data line information or the second data line information.
The display module 403 is further configured to display referenced information of the first data line information, for example, in response to a triggering operation of the first reference identifier of the first data line information; and in response to the triggering operation of the second reference identifier of the second data line information, displaying the content updating information of the second data line information and/or data source information such as a document/table. For example, reference information of the first data line information to other documents or tables may appear after clicking a first reference identifier of the first data line information, for example, a link to the first table or a name of the first table may appear after clicking a second reference identifier of the second data line information, and a jump to the first table may occur after clicking the occurring link to the first table or the name of the first table; in one or more embodiments, the second reference identification further includes, for example, displaying the most recent update time and the updated person at the location of the associated area of the reference, knowing at what time the person updated even if the reference sub-table was not opened; the second reference identifier displays, for example, the secondary table names of the source document at the referenced positions, and displays which tables are referenced at the positions of the source document through the first reference identifier, and the tables can jump to each other to be viewed, so that the tables are linked.
In one or more embodiments, the display module 403 is further configured to display the edited first data line information in the second data line information in response to an editing operation on the first data line information; and the data processing device is used for detecting the change of the first data row information and the second data row information in the first table and the second table according to the reference relation and synchronizing;
a judgment setting module 404, configured to respond to an insertion operation in the first document or the second table, judge whether preset attributes of the first table and the second table are the same, if so, generate second data row information, and determine whether to establish a reference relationship between the second data row information and the first data row information; if the first data row information is different from the second data row information, copying the first data row information into a first document or a second table to generate second data row information, or refusing insertion operation; and the data processing device is used for determining whether to establish the reference relationship between the second data line information and the first data line information when the first data line information is inserted into the first document or the second table to generate the second data line information.
In one or more embodiments, the preset attribute may be, for example, the index column mentioned above, and may also include a data type of the index column; the reference mode for establishing the reference relationship between the second data line information and the first data line information is, for example, a real-time reference mode.
In one or more embodiments, for a database table, since the index columns of the database table have a set fixed data type (that is, each column can only input data of a fixed type, for example, column a can only input people, column b can only input time and date), in response to an insertion operation in the first document or the second table, whether the preset attributes of the first table and the second table are the same is judged, if the two tables have the same index column, second data row information is generated and whether to paste as "real-time reference", and if the index columns of the two tables are different, the "index column is different and paste is not supported.
In one or more embodiments, for a common electronic form, when the common electronic form is built, because an index column of the common electronic form does not have a fixed data type (that is, each column can input different types of data at the same time), in response to an insertion operation in a first document or a second table, judging whether preset attributes of the first table and the second table are the same, generating second data row information, and determining whether to establish a reference relationship between the second data row information and the first data row information; and if the data row information is different from the first data row information, copying the first data row information into the first document or the second table to generate second data row information.
In one or more embodiments, the decision setting module 404 only needs to ensure that the index columns are the same, and even if the columns of the two tables are not identical, the copy-paste can be successful.
In one or more embodiments, after the form content processing is completed, the form content processing method of the present disclosure also solves the field information conflict problem between the referenced primary form and secondary form, in one or more embodiments, the field information includes at least a column header and/or a column attribute, for example.
In one or more embodiments, the primary table and the secondary table may generate a conflict due to inconsistency of the field information, and the table content processing apparatus of the present disclosure further includes:
the field information acquisition module is used for acquiring the field information of the main form and all the auxiliary forms and returning the acquired form information; aiming at the main table, all information is displayed according to the initialization data;
the field information detection module is used for detecting whether the field information of the auxiliary table is consistent with the main table or not;
the field information display module is used for displaying according to the detection result of the field information detection module, if the field information is consistent with the detection result of the field information detection module, the field information is displayed according to the logic of the main table, and if the field information is inconsistent with the detection result of the field information detection module, for example, a part of fields do not exist in the main table, the field information is hidden and displayed in the auxiliary table; for inconsistent field information, it is shown as empty in both the primary and secondary tables.
And the field information adding module is used for inserting the field information into the main table and filling corresponding initialization content if the field information existing in the auxiliary table is added into one of the main table and the auxiliary table, such as the main table.
It should be understood that although each block in the block diagrams of the figures may represent a module, a portion of which comprises one or more executable instructions for implementing the specified logical function(s), the blocks are not necessarily executed sequentially. Each module and functional unit in the device embodiments in the present disclosure may be integrated into one processing module, or each unit may exist alone physically, or two or more modules or functional units are integrated into one module. The integrated modules can be realized in a hardware mode, and can also be realized in a software functional module mode. The integrated module, if implemented in the form of a software functional module and sold or used as a stand-alone product, may also be stored in a computer readable storage medium. The storage medium mentioned above may be a read-only memory, a magnetic or optical disk, etc.
[ Table content processing apparatus ]
In order to solve the technical problem, an embodiment of the present disclosure further provides an electronic device. Referring now to fig. 5, a schematic diagram of an electronic device (e.g., the terminal device or the server in fig. 1) 500 suitable for implementing embodiments of the present disclosure is shown. The terminal device in the embodiments of the present disclosure may include, but is not limited to, a mobile terminal such as a mobile phone, a notebook computer, a digital broadcast receiver, a PDA (personal digital assistant), a PAD (tablet computer), a PMP (portable multimedia player), a vehicle terminal (e.g., a car navigation terminal), and the like, and a stationary terminal such as a digital TV, a desktop computer, and the like. The electronic device shown in fig. 5 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiments of the present disclosure.
As shown in fig. 5, electronic device 500 may include a processing means (e.g., central processing unit, graphics processor, etc.) 501 that may perform various appropriate actions and processes in accordance with a program stored in a Read Only Memory (ROM)502 or a program loaded from a storage means 506 into a Random Access Memory (RAM) 503. In the RAM503, various programs and data necessary for the operation of the electronic apparatus 500 are also stored. The processing device 501, the ROM502, and the RAM503 are connected to each other through a bus 504. An input/output (I/O) interface 505 is also connected to bus 504.
Generally, the following devices may be connected to the I/O interface 505: input devices 506 including, for example, a touch screen, touch pad, keyboard, mouse, camera, microphone, accelerometer, gyroscope, etc.; output devices 507 including, for example, a Liquid Crystal Display (LCD), speakers, vibrators, and the like; storage devices 506 including, for example, magnetic tape, hard disk, etc.; and a communication device 509. The communication means 509 may allow the electronic device 500 to communicate with other devices wirelessly or by wire to exchange data. While fig. 5 illustrates an electronic device 500 having various means, it is to be understood that not all illustrated means are required to be implemented or provided. More or fewer devices may alternatively be implemented or provided.
In particular, according to an embodiment of the present disclosure, the processes described above with reference to the flowcharts may be implemented as computer software programs. For example, embodiments of the present disclosure include a computer program product comprising a computer program carried on a non-transitory computer readable medium, the computer program containing program code for performing the method illustrated by the flow chart. In such an embodiment, the computer program may be downloaded and installed from a network via the communication means 509, or installed from the storage means 506, or installed from the ROM 502. The computer program performs the above-described functions defined in the methods of the embodiments of the present disclosure when executed by the processing device 501.
It should be noted that the computer readable medium in the present disclosure can be a computer readable signal medium or a computer readable storage medium or any combination of the two. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples of the computer readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the present disclosure, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In contrast, in the present disclosure, a computer readable signal medium may comprise a propagated data signal with computer readable program code embodied therein, either in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: electrical wires, optical cables, RF (radio frequency), etc., or any suitable combination of the foregoing.
In some embodiments, the clients, servers may communicate using any currently known or future developed network protocol, such as HTTP (hypertext transfer protocol), and may interconnect with any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include a local area network ("LAN"), a wide area network ("WAN"), the Internet (e.g., the Internet), and peer-to-peer networks (e.g., ad hoc peer-to-peer networks), as well as any currently known or future developed network.
The computer readable medium may be embodied in the electronic device; or may exist separately without being assembled into the electronic device.
The computer readable medium carries one or more programs which, when executed by the electronic device, cause the electronic device to: acquiring at least two internet protocol addresses; sending a node evaluation request comprising the at least two internet protocol addresses to node evaluation equipment, wherein the node evaluation equipment selects the internet protocol addresses from the at least two internet protocol addresses and returns the internet protocol addresses; receiving an internet protocol address returned by the node evaluation equipment; wherein the obtained internet protocol address indicates an edge node in the content distribution network.
Alternatively, the computer readable medium carries one or more programs which, when executed by the electronic device, cause the electronic device to: receiving a node evaluation request comprising at least two internet protocol addresses; selecting an internet protocol address from the at least two internet protocol addresses; returning the selected internet protocol address; wherein the received internet protocol address indicates an edge node in the content distribution network.
Computer program code for carrying out operations for the present disclosure may be written in any combination of one or more programming languages, including but not limited to an object oriented programming language such as Java, Smalltalk, C + +, and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).
The flowchart and block diagrams 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 flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The units described in the embodiments of the present disclosure may be implemented by software or hardware. Where the name of a unit does not in some cases constitute a limitation of the unit itself, for example, the first retrieving unit may also be described as a "unit for retrieving at least two internet protocol addresses".
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. The machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
According to one or more embodiments of the present disclosure, there is provided a table content processing method, including:
selecting first data row information in a first table;
in response to an insertion operation in a first document or a second table, inserting the first data row information into the first document or the second table to generate second data row information, wherein the first data row information and the second data row information have a reference relationship.
According to one or more embodiments of the present disclosure, there is provided a table content processing method characterized in that,
the first document includes the second table.
According to one or more embodiments of the present disclosure, there is provided a table content processing method characterized in that,
and responding to the editing operation of the first data line information, and displaying the edited first data line information in the second data line information.
According to one or more embodiments of the present disclosure, there is provided a table content processing method characterized in that,
responding to an insertion operation in a first document or a second table, and judging whether preset attributes of the first table and the second table are the same or not;
if the data line information is the same as the first data line information, generating the second data line information, and determining whether to establish a reference relationship between the second data line information and the first data line information;
and if the first data row information is different from the second data row information, copying the first data row information into the first document or a second table to generate the second data row information, or rejecting the insertion operation.
According to one or more embodiments of the present disclosure, there is provided a table content processing method characterized in that,
generating a reference trigger area in response to an insert operation in the first document or the second table;
the generating the second data line information comprises:
responding to a first trigger operation of the reference trigger area, generating second data line information, and establishing a reference relation between the second data line information and the first data line information; alternatively, the first and second electrodes may be,
in response to a second trigger operation on the reference trigger area, copying the first data row information into the first document or a second table, and generating the second data row information.
According to one or more embodiments of the present disclosure, there is provided a table content processing method characterized in that,
and displaying a first reference identifier in an associated area of the first data row information in the first table.
According to one or more embodiments of the present disclosure, there is provided a table content processing method characterized in that,
and displaying a second reference identifier in an associated area of second data row information in the second table.
According to one or more embodiments of the present disclosure, there is provided a table content processing method characterized in that,
and in response to the triggering operation of the first reference identifier, displaying the referenced information of the first data line information.
According to one or more embodiments of the present disclosure, there is provided a table content processing method characterized in that,
and in response to the triggering operation of the second reference identifier, displaying the content updating information and/or the data source information of the second data line information.
According to one or more embodiments of the present disclosure, there is provided a table content processing method characterized in that,
acquiring field information of the first form and the second form;
detecting whether the field information of the second table is consistent with the first table;
if not, hiding and displaying in the second table;
the field information includes at least a column title and/or a column attribute.
According to one or more embodiments of the present disclosure, there is provided a table content processing method characterized in that,
displaying as null in the first table and the second table for the field information that is inconsistent.
According to one or more embodiments of the present disclosure, there is provided a table content processing method characterized in that,
and if the field information existing in one of the first table and the second table is added into the other table, inserting the field information into the one table and filling corresponding initialization content.
According to one or more embodiments of the present disclosure, there is provided a table content processing apparatus including:
the information selection module is used for selecting first data row information in the first table;
the information inserting module is used for responding to an inserting operation in a first document or a second table, inserting the first data row information into the first document or the second table to generate second data row information, wherein the first data row information and the second data row information have a reference relation;
the display module is used for responding to the editing operation of the first data line information and displaying the edited first data line information in the second data line information; and for displaying the reference relationship with a particular identity;
the judging and setting module is used for judging whether the preset attributes of the first table and the second table are the same or not, if so, generating second data row information, and determining whether a reference relation between the second data row information and the first data row information is established or not; and if the first data row information is different from the second data row information, copying the first data row information into the first document or a second table to generate the second data row information, or rejecting the insertion operation.
According to one or more embodiments of the present disclosure, there is provided a computer device comprising a memory having a computer program stored therein and a processor that, when executed, implements the method of any of the above.
According to one or more embodiments of the present disclosure, a computer-readable storage medium is provided, characterized in that a computer program is stored thereon, which, when being executed by a processor, implements the method according to any one of the above.
The foregoing description is only exemplary of the preferred embodiments of the disclosure and is illustrative of the principles of the technology employed. It will be appreciated by those skilled in the art that the scope of the disclosure herein is not limited to the particular combination of features described above, but also encompasses other embodiments in which any combination of the features described above or their equivalents does not depart from the spirit of the disclosure. For example, the above features and the technical features disclosed in the present disclosure (but not limited to) having similar functions are replaced with each other to form the technical solution.
Further, while operations are depicted in a particular order, this should not be understood as requiring that such operations be performed in the particular order shown or in sequential order. Under certain circumstances, multitasking and parallel processing may be advantageous. Likewise, while several specific implementation details are included in the above discussion, these should not be construed as limitations on the scope of the disclosure. Certain features that are described in the context of separate embodiments can also be implemented in combination in a single embodiment. Conversely, various features that are described in the context of a single embodiment can also be implemented in multiple embodiments separately or in any suitable subcombination.
Although the subject matter has been described in language specific to structural features and/or methodological acts, it is to be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or acts described above. Rather, the specific features and acts described above are disclosed as example forms of implementing the claims.

Claims (15)

1. A table content processing method is characterized by comprising the following steps:
selecting first data row information in a first table;
in response to an insertion operation in a first document or a second table, inserting the first data row information into the first document or the second table, and generating second data row information, wherein the first data row information and the second data row information have a reference relationship.
2. A form content processing method as claimed in claim 1, wherein the first document includes the second form.
3. A table content processing method according to claim 1, characterized in that the method further comprises:
and responding to the editing operation of the first data line information, and displaying the edited first data line information in the second data line information.
4. The form content processing method of claim 1, further comprising,
responding to an insertion operation in a first document or a second table, and judging whether preset attributes of the first table and the second table are the same or not;
if the data row information is the same as the first data row information, generating the second data row information, and determining whether to establish a reference relation between the second data row information and the first data row information;
and if the first data row information is different from the second data row information, copying the first data row information into the first document or a second table to generate the second data row information, or rejecting the insertion operation.
5. The table content processing method of claim 1, further comprising:
generating a reference trigger area in response to an insert operation in the first document or the second table;
the generating of the second data line information includes:
responding to a first trigger operation of the reference trigger area, generating second data line information, and establishing a reference relation between the second data line information and the first data line information; alternatively, the first and second electrodes may be,
in response to a second trigger operation on the reference trigger area, copying the first data row information into the first document or a second table, and generating the second data row information.
6. The table content processing method of claim 1, further comprising:
and displaying a first reference identifier in an associated area of first data row information in the first table.
7. The table content processing method of claim 1, further comprising:
and displaying a second reference identifier in an associated area of second data row information in the second table.
8. The table content processing method of claim 6, further comprising:
and in response to the triggering operation of the first reference identifier, displaying the referenced information of the first data line information.
9. The table content processing method of claim 7, further comprising:
and in response to the triggering operation of the second reference identifier, displaying the content updating information and/or the data source information of the second data line information.
10. The table content processing method of claim 1, further comprising:
acquiring field information of the first table and the second table;
detecting whether the field information of the second table is consistent with the first table;
if not, hiding and displaying in the second table;
the field information includes at least a column title and/or a column attribute.
11. The form content processing method of claim 10, further comprising,
displaying as null in the first table and the second table for the field information that is inconsistent.
12. The form content processing method of claim 10,
and if the field information existing in one of the first table and the second table is added into the other table, inserting the field information into the one table and filling corresponding initialization content.
13. A form content processing apparatus, comprising:
the information selection module is used for selecting first data row information in the first table;
the information inserting module is used for responding to an inserting operation in a first document or a second table, inserting the first data row information into the first document or the second table to generate second data row information, wherein the first data row information and the second data row information have a reference relation;
the display module is used for responding to the editing operation of the first data line information and displaying the edited first data line information in the second data line information; and for displaying the reference relationship with a particular identity;
the judging and setting module is used for judging whether the preset attributes of the first table and the second table are the same or not, if so, generating second data row information, and determining whether a reference relation between the second data row information and the first data row information is established or not; and if the first data row information is different from the second data row information, copying the first data row information into the first document or a second table to generate the second data row information, or rejecting the insertion operation.
14. A computer device comprising a memory having stored therein a computer program and a processor implementing the method of any of claims 1-12 when executing the computer program.
15. A computer-readable storage medium, characterized in that the computer-readable storage medium has stored thereon a computer program which, when being executed by a processor, carries out the method according to any one of claims 1-12.
CN202110233247.8A 2021-03-01 2021-03-01 Table content processing method, device, equipment and storage medium Pending CN115081412A (en)

Priority Applications (4)

Application Number Priority Date Filing Date Title
CN202110233247.8A CN115081412A (en) 2021-03-01 2021-03-01 Table content processing method, device, equipment and storage medium
JP2023552498A JP2024508012A (en) 2021-03-01 2022-03-01 Table content processing method, device, equipment, and storage medium
PCT/CN2022/078661 WO2022184063A1 (en) 2021-03-01 2022-03-01 Table content processing method and apparatus, and device and storage medium
US18/239,719 US20240012985A1 (en) 2021-03-01 2023-08-29 Table content processing method and apparatus, and device and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202110233247.8A CN115081412A (en) 2021-03-01 2021-03-01 Table content processing method, device, equipment and storage medium

Publications (1)

Publication Number Publication Date
CN115081412A true CN115081412A (en) 2022-09-20

Family

ID=83240432

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202110233247.8A Pending CN115081412A (en) 2021-03-01 2021-03-01 Table content processing method, device, equipment and storage medium

Country Status (1)

Country Link
CN (1) CN115081412A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN116956846A (en) * 2023-07-25 2023-10-27 北京字跳网络技术有限公司 Information processing method, apparatus, electronic device and storage medium

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20190138587A1 (en) * 2017-11-03 2019-05-09 Dropbox, Inc. Collaborative Spreadsheet Embedding and Management
US20190138588A1 (en) * 2017-11-03 2019-05-09 Dropbox, Inc. Embedded spreadsheet data implementation and synchronization
CN109829144A (en) * 2018-12-28 2019-05-31 陈德芹 A kind of across table reference method and device of online table
CN111368520A (en) * 2020-02-28 2020-07-03 中国平安人寿保险股份有限公司 Editing method and device for electronic forms

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20190138587A1 (en) * 2017-11-03 2019-05-09 Dropbox, Inc. Collaborative Spreadsheet Embedding and Management
US20190138588A1 (en) * 2017-11-03 2019-05-09 Dropbox, Inc. Embedded spreadsheet data implementation and synchronization
CN109829144A (en) * 2018-12-28 2019-05-31 陈德芹 A kind of across table reference method and device of online table
CN111368520A (en) * 2020-02-28 2020-07-03 中国平安人寿保险股份有限公司 Editing method and device for electronic forms

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN116956846A (en) * 2023-07-25 2023-10-27 北京字跳网络技术有限公司 Information processing method, apparatus, electronic device and storage medium

Similar Documents

Publication Publication Date Title
CN109408752B (en) Online document display method and device and electronic equipment
WO2022127838A1 (en) Document processing method and apparatus, and electronic device
CN111599022A (en) House display method and device and electronic equipment
US20240168605A1 (en) Text input method and apparatus, and electronic device and storage medium
WO2022022619A1 (en) Document editing method and apparatus, and electronic device
US20240126417A1 (en) Method, form data processing method, apparatus, and electronic device for form generation
CN113239049B (en) Information processing method, device, terminal and storage medium
US20230409816A1 (en) Document update method and apparatus, device, and medium
US20240202249A1 (en) Information processing method and apparatus, terminal, and storage medium
CN113868260A (en) Data processing method and device and electronic equipment
CN108334516A (en) Information-pushing method and device
CN110119386A (en) Data processing method, data processing equipment, medium and calculating equipment
CN113128185A (en) Interaction method and device and electronic equipment
US20240012985A1 (en) Table content processing method and apparatus, and device and storage medium
US20240160650A1 (en) Document processing method and apparatus, device, and medium
CN109710866A (en) Image display method and device in online document
CN115081412A (en) Table content processing method, device, equipment and storage medium
CN113220752A (en) Display method and device and electronic equipment
CN114997124A (en) Table content processing method, device, equipment and storage medium
CN110568976B (en) Method, device, equipment and storage medium for controlling application display
CN112084441A (en) Information retrieval method and device and electronic equipment
CN112307393A (en) Information issuing method and device and electronic equipment
US9965484B1 (en) Template-driven data extraction and insertion
CN115061601B (en) Electronic document processing method, device, terminal and storage medium
CN109614603A (en) Method and apparatus for generating information

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination