CN118246416B - Data reference method, device, electronic equipment and storage medium - Google Patents

Abstract

The embodiment of the present application discloses a data reference method, device, electronic device and storage medium. The method includes: in response to a user's first reference operation, obtaining the table range data and table content data selected by the first reference operation, the table range data including a table identifier and the selected first row and column data; in response to a user's second reference operation, pasting the table content data to a target location, and obtaining the address identifier of the target location and the second row and column data after pasting; associating and storing the table identifier, the first row and column data, the address identifier, and the second row and column data to obtain reference associated data; synchronizing the table content data pasted to the target location with the table content data selected by the first reference operation using the reference associated data. The partial table in the target location is bidirectionally synchronized with the table content data in the source table, avoiding the user from directly processing in the complete table and reducing the consumption of user-side memory resources.

Description

Data reference method, device, electronic device and storage medium

Technical Field

The embodiments of the present application relate to the field of data synchronization technology, and in particular, to a data reference method, device, electronic device and storage medium.

Background Art

With the advent of the data age, both work and life are increasingly inseparable from the use and interaction of data. Especially after paperless office has been vigorously advocated, the degree of office dataization has become deeper and deeper.

At present, many office scenarios involve various forms. When it involves interactions between multiple departments or multiple employees, it is usually necessary to share the forms as a whole or distribute them to each department and employee, and each department or employee processes the parts of the form that they need to pay attention to.

However, when the table content is large, overall table sharing will consume a large amount of memory resources on the employee's device.

Summary of the invention

The embodiments of the present application provide a data citation method, device, electronic device, and storage medium to reduce memory consumption of a user-end device by citing only a portion of a table that a user needs to pay attention to.

In a first aspect, an embodiment of the present application provides a data citation method, the method comprising:

In response to a first reference operation of the user, obtaining table range data and table content data selected by the first reference operation, wherein the table range data includes a table identifier and the first row and column data selected;

In response to the user's second reference operation, the table content data is pasted to a target location, and an address identifier of the target location and the second row and column data after pasting are obtained;

The table identifier, the first row and column data, the address identifier, and the second row and column data are stored in association with each other to obtain reference associated data;

The table content data pasted to the target location is synchronized with the table content data selected by the first reference operation by using the reference associated data.

In a second aspect, an embodiment of the present application provides a data citation device, the device comprising:

A selection acquisition module, for acquiring, in response to a first reference operation of a user, table range data and table content data selected by the first reference operation, wherein the table range data includes a table identifier and the selected first row and column data;

A paste acquisition module, used for pasting the table content data to a target location in response to a second reference operation by the user, and acquiring an address identifier of the target location and the second row and column data after pasting;

An association module is used to associate and store the table identifier, the first row and column data, the address identifier, and the second row and column data to obtain reference associated data;

The synchronization module is used to synchronize the table content data pasted to the target location with the table content data selected by the first reference operation by using the reference associated data.

In a third aspect, an embodiment of the present application further provides an electronic device, the electronic device comprising:

one or more processors;

a storage device for storing one or more programs,

When one or more programs are executed by one or more processors, the one or more processors implement the data reference method provided in any embodiment of the present application.

In a fourth aspect, an embodiment of the present application further provides a computer-readable storage medium on which a computer program is stored, characterized in that when the program is executed by a processor, a data reference method provided in any embodiment of the present application is implemented.

The technical solution of the embodiment of the present application, in response to the user's first reference operation, obtains the table range data and table content data selected by the first reference operation, the table range data includes a table identifier and the selected first row and column data; in response to the user's second reference operation, pastes the table content data to the target location, and obtains the address identifier of the target location and the second row and column data after pasting; associates and stores the table identifier, the first row and column data, the address identifier, and the second row and column data to obtain reference associated data; uses the reference associated data to synchronize the table content data pasted to the target location with the table content data selected by the first reference operation. Based on this, the user pastes a part of the table range in the table to the target location through the first reference operation and the second reference operation, and the part of the table in the target location is bidirectionally synchronized with the table content data in the source table. The subsequent user only needs to process the part of the table at the target location, avoiding the user directly processing in the complete table, and reducing the consumption of user-side memory resources.

BRIEF DESCRIPTION OF THE DRAWINGS

FIG1 is a schematic diagram of a flow chart of a data reference method provided in Example 1 of the present application;

FIG2 is a schematic diagram of the structure of a data citation device provided in Embodiment 2 of the present application;

FIG3 is a schematic diagram of the structure of an electronic device provided in Embodiment 3 of the present application.

DETAILED DESCRIPTION

The present application will be further described in detail below in conjunction with the accompanying drawings and embodiments. It is to be understood that the specific embodiments described herein are only used to explain the present application, rather than to limit the present application. It should also be noted that, for ease of description, only the parts related to the present application, rather than all structures, are shown in the accompanying drawings.

Embodiment 1

FIG1 is a flow chart of a data reference method provided in Embodiment 1 of the present application. As shown in FIG1 , the data reference method provided in this embodiment can be applied to a data reference platform mounted on a device with data processing capability such as a computer, and can be used in conjunction with some work platform software to achieve a better experience. Specifically, the following steps may be included:

Step 101: In response to a first reference operation by a user, obtain table range data and table content data selected by the first reference operation, wherein the table range data includes a table identifier and the first row and column data selected.

In this step, the user's first reference operation may be a combination of common selection and copy operations (the copy operation is only the name of an operation, which can be customized by the developer, and the operation is mainly used to trigger the processing of this step 101).

That is, for a table, the user selects part of the table from the table, and performs a copy operation after selection. This step can obtain the first row and column data of the selected part of the table and the table identifier of the table. Among them, the first row and column data are the starting row, ending row, starting column, and ending column of the selected part. In addition, the table content data is the data contained in each cell.

It should be noted that the table on which the user performs the first reference operation may be a source table in a database, hereinafter referred to as a source table, and the source table may be presented on any platform.

Step 102: In response to the user's second reference operation, the table content data is pasted to a target location, and an address identifier of the target location and the second row and column data after pasting are obtained.

In this step, the target location can be a content box in any platform where table content can be input. The second reference operation can be an operation similar to paste, and the name of the operation can also be customized by the developer. The operation is mainly used to trigger the related actions of step 102.

It should be noted that the pasting process is mainly to present the table content data of the part of the table selected in the above step in the target location, and the presentation needs to keep the form of the table unchanged.

After the pasting is completed, this step can obtain the address identifier of the target location. It should be noted that the address identifier can be composed of different components according to the type of the target location. Specifically, if the target location is a content box in a user platform, the address identifier can be composed of the platform identifier, the content box identifier in the platform, and the currently logged in user identifier.

In addition, this step will also obtain the second row and column data after pasting. After pasting the table content data to the target location, the original table row and column attributes will usually be lost. Therefore, this step will re-acquire it, that is, the new row and column data of this part of the table in the target location, usually arranged from the 1st row and the 1st column.

In a specific example, the selected part of the table is a table with 2 rows and 3 columns, so the first row and column data can be the number of rows and columns in the source table, such as starting row 20, ending row 21, starting column 1, and ending row 3.

After pasting, the corresponding second row and column data will be starting row 1, ending row 2, starting column 1, and ending row 3.

Step 103: store the table identifier, the first row and column data, the address identifier, and the second row and column data in an associated manner to obtain reference associated data.

In this step, when associating, first associate the table identifier and the address identifier to obtain identifier associated data; then associate the first row and column data and the second row and column data cell by cell according to the table arrangement to obtain row and column associated data; then map the identifier associated data and the row and column associated data to store as reference associated data.

Among them, cell-by-cell association refers to associating cells one by one. Specifically, for any cell to be associated in the first row and column data, according to the table arrangement of the cell to be associated within the table data range, a target cell matching the position of the cell to be associated is determined from the second row and column data; the row and column number of the cell to be associated is associated with the row and column number of the target cell to obtain cell association data of the cell to be associated and the target cell; after matching all the cells to be associated in the first row and column data, all the obtained cell association data are stored as row and column association data.

Still taking the above table with 2 rows and 3 columns as an example, for the sake of convenience, the number of rows and columns of a cell is expressed in the form of a value pair, that is, (number of rows, number of columns). Then when associating, since the layout of the tables at both ends is the same, the cells of the part of the table corresponding to the first row and column data can be traversed.

When traversing to any cell, for example, a cell with row and column numbers (20,3) and a table layout of 1st row and 3rd column, then the corresponding table pasted to the target location has a cell with row and column numbers (1,3) in 1st row and 3rd column. Therefore, the cell with row and column numbers (20,3) obtained from the first row and column data is determined as the cell to be associated, and the cell with row and column numbers (1,3) obtained from the second row and column data is the target cell.

After the traversal is completed according to the above process, the matching is completed, and finally all the obtained cell-related data are stored as row-column related data.

Step 104: Synchronize the table content data pasted to the target location with the table content data selected by the first reference operation by using the reference associated data.

The synchronization in this step can be bidirectional, which can be synchronized from the table pasted to the target location to the source table, or from the source table to the table pasted to the target location. In order to improve the synchronization performance, the synchronization of this embodiment can be implemented by a separately set transfer station, and the aforementioned referenced associated data are stored in the transfer station as the associated basis for synchronization.

Among them, when the content data of the table pasted to the target position changes, the reference associated data corresponding to the changed cell row and column number, the changed content and the address identifier of the target position are obtained; for any changed cell row and column number, based on the reference associated data, the cell row and column number to be synchronized in the source table corresponding to the changed cell row and column number is determined; the changed content is synchronized to the cell corresponding to the cell row and column number to be synchronized in the source table.

It should be noted that this embodiment can monitor the state changes of each cell in the table. Every time the user edits the table pasted to the target location, the state of the edited cell will change, and the state change will be monitored, thereby determining that the content data of the table pasted to the target location has changed.

In addition, each time a state change event is detected, the cell whose state has changed can be directly recorded, and the latest content of the cell can be determined as the changed content. Based on the record, this embodiment can directly obtain the row and column number of the cell, that is, the row and column number of the changed cell, and the changed content. In addition, since the aforementioned reference associated data also includes the association relationship between the table identifier and the address identifier, in order to distinguish a specific table, it is also necessary to obtain the address identifier of the target location, and then obtain the reference associated data associated with the address identifier, that is, the reference associated data corresponding to the address identifier of the target location.

After the corresponding reference-related data is determined, the row and column related data therein can be used to find the number of rows and columns of cells to be synchronized in the original table. The source table to be synchronized can be determined based on the table identifier included in the reference-related data first; then the number of target cell rows and columns corresponding to the number of changed cell rows and columns can be determined based on the row and column related data included in the reference-related data; finally, the number of target cell rows and columns can be determined as the number of cells rows and columns to be synchronized in the source table.

Specifically, since the row and column association data includes a one-to-one correspondence between cells, as in the above example, each cell has an association relationship with the row and column number. Since the row and column number of the changed cell is obtained above, at this time, the row and column number of the target cell corresponding to the row and column number of the changed cell can be found from the row and column association data.

It should be noted that in order to distinguish the table to which the row and column numbers belong, a reference identifier or source identifier can be added to the row and column numbers. The reference identifier refers to the row and column numbers of the cells in the table pasted to the target location, and the source identifier is the row and column numbers of the cells in the source table.

After determining the number of target cell rows and columns, it can be determined as the number of cells rows and columns to be synchronized in the source table, and then the changed content is synchronized to the cells corresponding to the number of cells rows and columns to be synchronized in the source table.

In addition to the above synchronization direction, this embodiment describes the process of synchronizing from the source table to the table at the target location as follows:

When the table content data selected by the first reference operation changes, obtain the changed cell row and column number, the changed content, and the reference associated data corresponding to the table identifier in the table range data selected by the first reference operation; for any changed cell row and column number, determine the cell row and column number to be synchronized in the target position table corresponding to the changed cell row and column number based on the reference associated data; synchronize the changed content to the cell corresponding to the cell row and column number to be synchronized in the source table.

It should be noted that the above process is the opposite direction of the aforementioned synchronization direction. For the specific process, please refer to the relevant description of the aforementioned synchronization direction, which will not be repeated here.

In this embodiment, in response to the user's first reference operation, the table range data and table content data selected by the first reference operation are obtained, and the table range data includes a table identifier and the selected first row and column data; in response to the user's second reference operation, the table content data is pasted to the target location, and the address identifier of the target location and the second row and column data after pasting are obtained; the table identifier, the first row and column data, the address identifier, and the second row and column data are associated and stored to obtain reference associated data; the table content data pasted to the target location is synchronized with the table content data selected by the first reference operation using the reference associated data. Based on this, the user pastes a partial table range in the table to the target location through the first reference operation and the second reference operation, and the partial table in the target location is bidirectionally synchronized with the table content data in the source table. The subsequent user only needs to process the partial table at the target location, avoiding the user directly processing in the complete table and reducing the consumption of user-side memory resources.

Embodiment 2

FIG2 is a schematic diagram of the structure of a data reference device provided in the second embodiment of the present application. The data reference device provided in the embodiment of the present application can execute the data reference method provided in any embodiment of the present application, and has the corresponding functional modules and beneficial effects of the execution method. The device can be implemented in software and/or hardware. As shown in FIG2, the data reference device specifically includes: a selection acquisition module 201, a paste acquisition module 202, an association module 203, and a synchronization module 204.

The selection acquisition module is used to respond to the user's first reference operation and acquire the table range data and table content data selected by the first reference operation, wherein the table range data includes a table identifier and the selected first row and column data;

A paste acquisition module, used for pasting the table content data to a target location in response to a second reference operation by the user, and acquiring an address identifier of the target location and the second row and column data after pasting;

An association module is used to associate and store the table identifier, the first row and column data, the address identifier, and the second row and column data to obtain reference associated data;

The synchronization module is used to synchronize the table content data pasted to the target location with the table content data selected by the first reference operation by using the reference associated data.

Furthermore, the associated modules include:

A first associating unit, used to associate the table identifier with the address identifier to obtain identifier associated data;

A second associating unit is used to associate the first row and column data with the second row and column data in a table arrangement, cell by cell, to obtain row and column associated data;

The mapping storage unit is used to map and store the identification associated data and the row-column associated data into reference associated data.

Furthermore, the second association unit is specifically used for:

For any cell to be associated in the first row and column of data, according to the table arrangement of the cell to be associated within the table data range, determine a target cell matching the position of the cell to be associated from the second row and column of data;

Associating the row and column numbers of the cell to be associated with the row and column numbers of the target cell to obtain cell association data of the cell to be associated and the target cell;

After all the cells to be associated in the first row and column data are matched, all the obtained cell associated data are stored as row and column associated data.

Furthermore, the synchronization module is specifically used for:

When the content data of the table pasted to the target position changes, the reference associated data corresponding to the changed cell row and column number, the changed content and the address identifier of the target position are obtained;

For any number of changed cell rows and columns, based on the referenced associated data, determine the number of cells rows and columns to be synchronized in the source table corresponding to the number of changed cell rows and columns;

Synchronize the changed content to the cells in the source table that correspond to the number of rows and columns of cells to be synchronized.

Furthermore, the synchronization module is specifically used for:

Determine the source table to be synchronized based on the table identifier included in the referenced associated data;

Based on the row and column associated data included in the reference associated data, determine the target cell row and column numbers corresponding to the changed cell row and column numbers;

The number of target cell rows and columns is determined as the number of cells rows and columns to be synchronized in the source table.

Furthermore, the synchronization module is specifically used for:

When the content data of the table selected by the first reference operation changes, the number of rows and columns of the changed cells, the changed content, and the reference associated data corresponding to the table identifier in the table range data selected by the first reference operation are obtained;

For any number of changed cell rows and columns, based on the referenced associated data, determine the number of cells rows and columns to be synchronized in the table at the target position corresponding to the number of changed cell rows and columns;

Synchronize the changed content to the cells in the source table that correspond to the number of rows and columns of cells to be synchronized.

Embodiment 3

Figure 3 is a schematic diagram of the structure of an electronic device provided in Example 3 of the present application. As shown in Figure 3, the electronic device includes a processor 310, a memory 320, an input device 330 and an output device 340; the number of processors 310 in the electronic device can be one or more, and Figure 3 takes one processor 310 as an example; the processor 310, memory 320, input device 330 and output device 340 in the electronic device can be connected via a bus or other methods, and Figure 3 takes connection via a bus as an example.

The memory 320 is a computer-readable storage medium that can be used to store software programs, computer executable programs and modules, such as program instructions/modules corresponding to the data reference method in the embodiment of the present invention. The processor 310 executes various functional applications and data processing of the electronic device by running the software programs, instructions and modules stored in the memory 320, that is, implements the above-mentioned data reference method:

In response to a first reference operation of the user, obtaining table range data and table content data selected by the first reference operation, wherein the table range data includes a table identifier and the first row and column data selected;

In response to the user's second reference operation, the table content data is pasted to a target location, and an address identifier of the target location and the second row and column data after pasting are obtained;

The table identifier, the first row and column data, the address identifier, and the second row and column data are stored in association with each other to obtain reference associated data;

The table content data pasted to the target location is synchronized with the table content data selected by the first reference operation by using the reference associated data.

Furthermore, the table identifier, the first row and column data, the address identifier, and the second row and column data are stored in association with each other to obtain reference associated data, including:

Associating the table identifier with the address identifier to obtain identifier-associated data;

Associating the first row and column data with the second row and column data in a table arrangement, cell by cell, to obtain row and column associated data;

The identification association data and the row-column association data mapping are stored as reference association data.

Furthermore, the first row and column data and the second row and column data are associated cell by cell according to the table arrangement to obtain row and column associated data, including:

For any cell to be associated in the first row and column of data, according to the table arrangement of the cell to be associated within the table data range, determine a target cell matching the position of the cell to be associated from the second row and column of data;

Associating the row and column numbers of the cell to be associated with the row and column numbers of the target cell to obtain cell association data of the cell to be associated and the target cell;

After all the cells to be associated in the first row and column data are matched, all the obtained cell associated data are stored as row and column associated data.

Furthermore, synchronizing the table content data pasted to the target location with the table content data selected by the first reference operation by using the reference associated data includes:

When the content data of the table pasted to the target position changes, the reference associated data corresponding to the changed cell row and column number, the changed content and the address identifier of the target position are obtained;

For any number of changed cell rows and columns, based on the referenced associated data, determine the number of cells rows and columns to be synchronized in the source table corresponding to the number of changed cell rows and columns;

Synchronize the changed content to the cells in the source table that correspond to the number of rows and columns of cells to be synchronized.

Further, based on the referenced associated data, determining the number of rows and columns of cells to be synchronized in the source table corresponding to the number of rows and columns of cells that have changed includes:

Determine the source table to be synchronized based on the table identifier included in the referenced associated data;

Based on the row and column associated data included in the reference associated data, determine the target cell row and column numbers corresponding to the changed cell row and column numbers;

The number of target cell rows and columns is determined as the number of cells rows and columns to be synchronized in the source table.

Furthermore, synchronizing the table content data pasted to the target location with the table content data selected by the first reference operation by using the reference associated data includes:

When the content data of the table selected by the first reference operation changes, the number of rows and columns of the changed cells, the changed content, and the reference associated data corresponding to the table identifier in the table range data selected by the first reference operation are obtained;

For any number of changed cell rows and columns, based on the referenced associated data, determine the number of cells rows and columns to be synchronized in the table at the target position corresponding to the number of changed cell rows and columns;

Synchronize the changed content to the cells in the source table that correspond to the number of rows and columns of cells to be synchronized.

The memory 320 may mainly include a program storage area and a data storage area, wherein the program storage area may store an operating system and at least one application required for a function; the data storage area may store data created according to the use of the terminal, etc. In addition, the memory 320 may include a high-speed random access memory, and may also include a non-volatile memory, such as at least one disk storage device, a flash memory device, or other non-volatile solid-state storage device. In some instances, the memory 320 may further include a memory remotely arranged relative to the processor 310, and these remote memories may be connected to the electronic device via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

Embodiment 4

Embodiment 4 of the present application further provides a storage medium containing computer executable instructions, and when the computer executable instructions are executed by a computer processor, they are used to execute a data reference method, the method comprising:

In response to a first reference operation of the user, obtaining table range data and table content data selected by the first reference operation, wherein the table range data includes a table identifier and the first row and column data selected;

In response to the user's second reference operation, the table content data is pasted to a target location, and an address identifier of the target location and the second row and column data after pasting are obtained;

The table identifier, the first row and column data, the address identifier, and the second row and column data are stored in association with each other to obtain reference associated data;

The table content data pasted to the target location is synchronized with the table content data selected by the first reference operation by using the reference associated data.

Furthermore, the table identifier, the first row and column data, the address identifier, and the second row and column data are stored in association with each other to obtain reference associated data, including:

Associating the table identifier with the address identifier to obtain identifier-associated data;

Associating the first row and column data with the second row and column data in a table arrangement, cell by cell, to obtain row and column associated data;

The identification association data and the row-column association data mapping are stored as reference association data.

Furthermore, the first row and column data and the second row and column data are associated cell by cell according to the table arrangement to obtain row and column associated data, including:

For any cell to be associated in the first row and column of data, according to the table arrangement of the cell to be associated within the table data range, determine a target cell matching the position of the cell to be associated from the second row and column of data;

Associating the row and column numbers of the cell to be associated with the row and column numbers of the target cell to obtain cell association data of the cell to be associated and the target cell;

After all the cells to be associated in the first row and column data are matched, all the obtained cell associated data are stored as row and column associated data.

Furthermore, synchronizing the table content data pasted to the target location with the table content data selected by the first reference operation by using the reference associated data includes:

When the content data of the table pasted to the target position changes, the reference associated data corresponding to the changed cell row and column number, the changed content and the address identifier of the target position are obtained;

For any number of changed cell rows and columns, based on the referenced associated data, determine the number of cells rows and columns to be synchronized in the source table corresponding to the number of changed cell rows and columns;

Synchronize the changed content to the cells in the source table that correspond to the number of rows and columns of cells to be synchronized.

Further, based on the referenced associated data, determining the number of rows and columns of cells to be synchronized in the source table corresponding to the number of rows and columns of cells that have changed includes:

Determine the source table to be synchronized based on the table identifier included in the referenced associated data;

Based on the row and column associated data included in the reference associated data, determine the target cell row and column numbers corresponding to the changed cell row and column numbers;

The number of target cell rows and columns is determined as the number of cells rows and columns to be synchronized in the source table.

Furthermore, synchronizing the table content data pasted to the target location with the table content data selected by the first reference operation by using the reference associated data includes:

When the content data of the table selected by the first reference operation changes, the number of rows and columns of the changed cells, the changed content, and the reference associated data corresponding to the table identifier in the table range data selected by the first reference operation are obtained;

For any number of changed cell rows and columns, based on the referenced associated data, determine the number of cells rows and columns to be synchronized in the table at the target position corresponding to the number of changed cell rows and columns;

Synchronize the changed content to the cells in the source table that correspond to the number of rows and columns of cells to be synchronized.

Of course, the storage medium containing computer executable instructions provided in the embodiment of the present application, whose computer executable instructions are not limited to the above method operations, can also execute related operations in the data reference method provided in any embodiment of the present application.

Through the above description of the implementation method, the technicians in the relevant field can clearly understand that the present application can be implemented by means of software and necessary general hardware, and of course it can also be implemented by hardware, but in many cases the former is a better implementation method. Based on such an understanding, the technical solution of the present application can be essentially or the part that contributes to the prior art can be embodied in the form of a software product, and the computer software product can be stored in a computer-readable storage medium, such as a computer floppy disk, read-only memory (ROM), random access memory (RAM), flash memory (FLASH), hard disk or optical disk, etc., including a number of instructions for a computer device (which can be a personal computer, server, or network device, etc.) to execute the methods of each embodiment of the present application.

It is worth noting that in the embodiment of the above-mentioned search device, the various units and modules included are only divided according to functional logic, but are not limited to the above-mentioned division, as long as the corresponding functions can be achieved; in addition, the specific names of the functional units are only for the convenience of distinguishing each other, and are not used to limit the scope of protection of this application.

Note that the above are only preferred embodiments of the present application and the technical principles used. Those skilled in the art will understand that the present application is not limited to the specific embodiments herein, and that various obvious changes, readjustments and substitutions can be made by those skilled in the art without departing from the scope of protection of the present application. Therefore, although the present application is described in more detail through the above embodiments, the present application is not limited to the above embodiments, and may include more other equivalent embodiments without departing from the concept of the present application, and the scope of the present application is determined by the scope of the appended claims.

Claims (9)

1. A data reference method, characterized in that the method comprises: In response to a first reference operation of the user, obtaining table range data and table content data selected by the first reference operation, wherein the table range data includes a table identifier and first row and column data selected; the first row and column data are the start row, end row, start column, and end column of the selected part; In response to a second reference operation by the user, the table content data is pasted to a target location, and an address identifier of the target location and the second row and column data after pasting are acquired; The table identifier, the first row and column data, the address identifier, and the second row and column data are stored in association with each other to obtain reference association data; The table content data pasted to the target location is synchronized with the table content data selected by the first reference operation using the reference associated data. 2. The method according to claim 1, characterized in that the step of associating and storing the table identifier, the first row and column data, the address identifier, and the second row and column data to obtain reference associated data comprises: Associating the table identifier with the address identifier to obtain identifier association data; Associating the first row and column data with the second row and column data in a table arrangement, cell by cell, to obtain row and column associated data; The identification association data and the row-column association data are mapped and stored as reference association data. 3. The method according to claim 2, characterized in that the step of associating the first row and column data with the second row and column data in a table arrangement cell by cell to obtain row and column associated data comprises: For any cell to be associated in the first row and column of data, according to the table arrangement of the cell to be associated within the table data range, determine a target cell matching the position of the cell to be associated from the second row and column of data; Associating the row and column numbers of the to-be-associated cell with the row and column numbers of the target cell to obtain cell association data of the to-be-associated cell and the target cell; After all the cells to be associated in the first row and column data are matched, all the obtained cell-associated data are stored as row and column associated data. 4. The method according to claim 1, characterized in that the step of synchronizing the table content data pasted to the target location with the table content data selected by the first reference operation by using the reference associated data comprises: When the table content data pasted to the target location changes, obtaining the number of changed cell rows and columns, the changed content, and the reference associated data corresponding to the address identifier of the target location; For any of the changed cell row and column numbers, based on the reference associated data, determine the cell row and column number to be synchronized in the source table corresponding to the changed cell row and column number; The changed content is synchronized to the cells corresponding to the number of rows and columns of cells to be synchronized in the source table. 5. The method according to claim 4, characterized in that the step of determining the number of rows and columns of cells to be synchronized in the source table corresponding to the number of rows and columns of cells to be synchronized based on the referenced associated data comprises: Determining a source table to be synchronized based on the table identifier included in the reference associated data; Based on the row and column association data included in the reference association data, determining the target cell row and column numbers corresponding to the changed cell row and column numbers; The number of rows and columns of the target cells is determined to be the number of rows and columns of cells to be synchronized in the source table. 6. A data citation device, characterized in that the device comprises: A selection acquisition module, for acquiring, in response to a first reference operation of a user, table range data and table content data selected by the first reference operation, wherein the table range data includes a table identifier and first row and column data selected; the first row and column data are a start row, an end row, a start column, and an end column of the selected part; A paste acquisition module, used for pasting the table content data to a target location in response to a second reference operation by the user, and acquiring an address identifier of the target location and the second row and column data after pasting; An association module, used for associating and storing the table identifier, the first row and column data, the address identifier, and the second row and column data to obtain reference associated data; A synchronization module is used to synchronize the table content data pasted to the target location with the table content data selected by the first reference operation using the reference associated data. 7. The device according to claim 6, characterized in that the association module comprises: A first associating unit, used to associate the table identifier with the address identifier to obtain identifier association data; A second associating unit, used to associate the first row and column data with the second row and column data in a table arrangement, cell by cell, to obtain row and column associated data; The mapping storage unit is used to map and store the identification associated data and the row-column associated data into reference associated data. 8. An electronic device, comprising: one or more processors; a storage device for storing one or more programs, When the one or more programs are executed by the one or more processors, the one or more processors implement the data reference method as described in any one of claims 1 to 5. 9. A computer-readable storage medium having a computer program stored thereon, wherein when the program is executed by a processor, the data reference method as described in any one of claims 1 to 5 is implemented.