A data reference method and device, electronic equipment and storage medium

Abstract

The application provides a data reference method and device, electronic equipment and a storage medium. The method comprises the following steps: determining a selected area of a data collaboration document according to an input instruction; obtaining target data content corresponding to the selected area of the data collaboration document according to the selected area; and referencing the target data content to a target document. In this way, data content interaction between the data collaboration document and the target document (electronic document) is realized, the referencing of the data content is not required in units of cells, and the data content of the data collaboration document is referenced to the target document.

Description

Technical Field

[0001] This invention relates to the field of computer technology, and in particular to a data referencing method, apparatus, electronic device, and storage medium. Background Technology

[0002] A spreadsheet, also known as an electronic data spreadsheet, is a type of computer program that simulates paper-based calculations. It displays cells consisting of rows and columns, where values, calculations, or text can be stored. In related technologies, users frequently utilize data referencing techniques between spreadsheets. For example, when data from one spreadsheet is referenced to another, the user needs to input a range of data from the first spreadsheet to obtain a contiguous area of ​​cells, which is then referenced in the second spreadsheet. A contiguous area of ​​cells refers to adjacent cells whose row or column numbers are consecutive. For instance, one cell might be labeled as the cell in the first row and first column, and another as the cell in the first row and second column. In other words, referencing data from one spreadsheet to another is done on a cell-by-cell basis, explicitly defining the cell's position (label), with the start and end positions of the cells forming a contiguous area of ​​cell labels. For example, if the selected data content is the data content of the range from row 1 to row 5 of the cell labels to column 1 to column 2 of the cell labels, then the selected data content is represented by the command line A1:B5\R1C1:R5C2.

[0003] Data collaboration documents can be used to edit and save data content. The data content in a data collaboration document can be displayed in the form of a grid table, a Kanban view, or an image. In other words, a data collaboration document is a data table that can display data content in multiple views (such as Kanban view, grid table, and brochure).

[0004] Because data collaboration documents do not have cell numbers, it is difficult to define the area of ​​the data collaboration document by cell. Therefore, the data content referencing methods in related technologies are not suitable for obtaining or referencing the data content of data collaboration documents. Therefore, a method is needed to reference the data content of data collaboration documents in other electronic documents to solve the technical problem that existing technologies cannot achieve this. Summary of the Invention

[0005] This invention provides a data referencing method, apparatus, electronic device, and storage medium for enabling the data content of a data collaboration document to be referenced in other electronic documents, thereby facilitating data content interaction between the data collaboration document and the electronic document.

[0006] This invention provides a data referencing method, comprising:

[0007] Based on the input instructions, determine the selected area of ​​the data collaboration document;

[0008] Based on the selected area, obtain the target data content corresponding to the selected area of ​​the data collaboration document;

[0009] The target data content is referenced in the target document.

[0010] Optionally, determining the selected area of ​​the data collaboration document based on the input instruction includes:

[0011] A data reference formula is generated based on the input instruction; wherein the data reference formula contains at least one data reference field;

[0012] Based on the data reference field, determine the data entries corresponding to the data reference field, and use the area formed by combining the data entries as the selected area of ​​the data collaboration document.

[0013] Optionally, generating the data reference formula according to the input instruction includes:

[0014] The generated data reference fields are determined by receiving user clicks or inputs through the user interface.

[0015] When there are multiple data reference fields,

[0016] The data reference formula is generated by combining multiple data reference fields with logical AND.

[0017] Alternatively, the data reference formula can be generated by using an OR logic to reference multiple data reference fields;

[0018] Alternatively, the data reference formula can be generated by combining multiple data reference fields with logical AND and OR logic.

[0019] Optionally, the data reference formula includes at least one data reference field, including:

[0020] The data referencing formula includes: a document address field, a document identifier field, and a table header field;

[0021] The step of determining the data entry corresponding to the data reference field based on the data reference field, and using the area formed by combining the data entries as the selected area of ​​the data collaboration document, includes:

[0022] The storage address of the data collaboration document is determined according to the document address field of the data reference formula. The first data collaboration document corresponding to the document identifier field is found in the storage address. Each first data entry corresponding to the header field is selected in the first data collaboration document. The area formed by combining each first data entry is taken as the first selected area of ​​the first data collaboration document.

[0023] Optionally, the data reference formula includes at least one data reference field, including:

[0024] The data referencing formula includes: a document address field, a document identifier field, a header field, and a filter field;

[0025] The step of determining the data entry corresponding to the data reference field based on the data reference field, and using the area formed by combining the data entries as the selected area of ​​the data collaboration document, includes:

[0026] The storage address of the data collaboration document is determined according to the document address field of the data reference formula. The second data collaboration document corresponding to the document identifier field is found in the storage address. Each second data entry corresponding to the header field is selected in the second data collaboration document. At least one second data entry that meets the filtering field is selected in each second data entry. The area formed by recombining the at least one second data entry is used as the second selected area of ​​the second data collaboration document.

[0027] Optionally, the data reference formula includes at least one data reference field, including:

[0028] The data referencing formula includes: a document address field, a document identifier field, a table header field, and a sorting field;

[0029] The step of determining the data entry corresponding to the data reference field based on the data reference field, and using the area formed by combining the data entries as the selected area of ​​the data collaboration document, includes:

[0030] The storage address of the data collaboration document is determined according to the document address field of the data reference formula. The third data collaboration document corresponding to the document identifier field is found in the storage address. Each third data entry corresponding to the header field is selected in the third data collaboration document. Each third initial data entry is arranged in the sorting order according to the sorting field. The area formed by recombining the third initial data entries after sorting is taken as the third selected area of ​​the third data collaboration document.

[0031] Optionally, the method further includes, before accessing the data collaboration document:

[0032] Determine whether there is access permission for the data collaboration document;

[0033] If so, perform an access operation on the data collaboration document.

[0034] Optionally, after referencing the target data content to the target document, the method further includes:

[0035] Set callback parameters for the data collaboration document;

[0036] The callback parameters are used to monitor whether the target data content has been updated.

[0037] If an update to the target data content is detected, an update notification is sent to the target document.

[0038] Optionally, the data collaboration document is a data table used to standardize data content;

[0039] The target document includes any one of the following: a data table, an online table, or a spreadsheet.

[0040] The present invention also provides a data referencing device, comprising:

[0041] The first processing unit is used to determine the selected area of ​​the data collaboration document according to the input instructions;

[0042] The second processing unit is used to obtain the target data content corresponding to the selected area of ​​the data collaboration document based on the selected area.

[0043] The third processing unit is used to reference the target data content to the target document.

[0044] The present invention also provides an electronic device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the program to implement the steps of any of the data referencing methods described above.

[0045] The present invention also provides a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the steps of any of the data referencing methods described above.

[0046] This invention provides a data referencing method, apparatus, electronic device, and storage medium. The data referencing method involves determining a selected area of ​​a data collaboration document based on an input instruction; obtaining the target data content corresponding to the selected area; and referencing the target data content to the target document. This enables data content interaction between the data collaboration document and the target document (electronic document) without requiring data referencing on a cell-by-cell basis, thus allowing the data content of the data collaboration document to be referenced in the target document. Attached Figure Description

[0047] To more clearly illustrate the technical solutions in this invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of this invention. For those skilled in the art, other drawings can be obtained from these drawings without creative effort.

[0048] Figure 1 This is a flowchart illustrating a data referencing method provided by the present invention;

[0049] Figure 2 This is a schematic diagram of a data collaboration document provided by the present invention;

[0050] Figure 3 This is a schematic diagram illustrating the referencing result of a data referencing method provided by the present invention;

[0051] Figure 4 This is a schematic diagram of a data collaboration document displayed in a Kanban view format, provided by the present invention;

[0052] Figure 5 This is a flowchart illustrating a data referencing method provided by the present invention;

[0053] Figure 6 This is a schematic diagram of the user interface for obtaining filter fields provided by the present invention;

[0054] Figure 7 This is a flowchart illustrating a data referencing method provided by the present invention;

[0055] Figure 8 This is a flowchart illustrating a data referencing method provided by the present invention;

[0056] Figure 9 This is a schematic diagram illustrating how target data content is referenced to a target document, as provided by the present invention.

[0057] Figure 10 This is a flowchart illustrating a data referencing method provided by the present invention;

[0058] Figure 11 This is a flowchart illustrating a data referencing method provided by the present invention;

[0059] Figure 12 This is a schematic diagram illustrating how to search for data content in multiple areas of a data collaboration document, as provided by the present invention.

[0060] Figure 13 This is a schematic diagram of the data referencing device provided by the present invention;

[0061] Figure 14 This is a schematic diagram of the structure of the electronic device provided by the present invention. Detailed Implementation

[0062] To make the objectives, technical solutions, and advantages of this invention clearer, the technical solutions of this invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some, not all, of the embodiments of this invention. All other embodiments obtained by those skilled in the art based on the embodiments of this invention without creative effort are within the scope of protection of this invention.

[0063] First, the terminology used in the embodiments of the present invention will be explained by way of example.

[0064] Data collaboration documents: Data collaboration documents are a new type of document that falls between databases and spreadsheets. Data content can be edited and saved using data collaboration documents. The data content in data collaboration documents can be displayed in the form of grid tables, views, or images.

[0065] Data entry: A data unit in a data collaboration document that describes relevant information about a specific data entity. In this invention, it represents a row or column of data in a data collaboration document, or a view unit in a data collaboration document.

[0066] Target document: An electronic document that references the data content of a data collaboration document. It can be a local spreadsheet, an online spreadsheet, another data collaboration document, etc.

[0067] The following is combined Figures 1-14 The technical solutions of various embodiments of the present invention are described.

[0068] Figure 1 This is a flowchart illustrating a data referencing method provided in an embodiment of the present invention, as shown below. Figure 1 As shown, it includes the following steps:

[0069] Step 110: Determine the selected area of ​​the data collaboration document according to the input instructions.

[0070] In this embodiment, the data collaboration document is a data table used to standardize data content.

[0071] The input commands can be commands manually entered by the user, or commands generated through various user operations in the user interface, such as point operations, swipe operations, touch operations, etc.

[0072] The selected area is the region in the data collaboration document corresponding to the input command. It should be noted that the data collaboration document does not assign numbers to individual cells, so the selected area is not defined on a cell-by-cell basis. In this embodiment, the data collaboration document includes multiple rows and columns of data content. Each row contains multiple consecutive cells; each column contains multiple consecutive cells; each row or column of data content forms an initial data entry. The selected area can be the region containing one or more complete initial data entries, or it can be the region containing a portion of the data content from one or more initial data entries.

[0073] See Figure 2 , Figure 2 The following is an example of a data collaboration document. This document includes five initial data entries, 1 through 5. Specifically, initial data entry 1 contains the data content line following the header row, namely the line corresponding to "Project is Engineering 1; Planned completion date is 2021 / 9 / 18; Status is in progress; Person in charge is Xiaoming". Initial data entry 2 contains the data content line following the header row, namely the line corresponding to "Project is Engineering 3; Planned completion date is 2021 / 9 / 23; Status is completed; Person in charge is Xiaohong". Initial data entry 3 contains the data content line following the header row, namely the line corresponding to "Project is Engineering 2; Planned completion date is 2021 / 9 / 17; Status is not started; Person in charge is Wang Wu". Initial data entry 4 contains the data content line following the header row, namely the line corresponding to "Project is Engineering 5; Planned completion date is 2021 / 9 / 3; Status is completed; Person in charge is Zhang San". Initial data entry 5 contains the data content row of the fifth row of the header row, specifically the row corresponding to "Project is Engineering 4; Planned completion date is 2021 / 9 / 16; Status is in progress; Person in charge is Li Si". Based on the input command, the entire data content of at least one initial data entry can be selected as the selected area. Alternatively, a portion of the data content from at least one initial data entry can be selected as the selected area.

[0074] Step 120: Based on the selected area, obtain the target data content corresponding to the selected area in the data collaboration document.

[0075] After selecting the region, the target data content for that region will be retrieved and reserved. See also... Figure 2Each initial data entry contains multiple data items. For example, the first row of data can be used as an initial data entry, which includes four items: {Project 1; 2021 / 9 / 18; In Progress; Xiaoming}. The target data can contain all four items of the first row of data, or it can contain some of the items of the first row of data. For example, it can contain three items: {Project 1; 2021 / 9 / 18; In Progress}.

[0076] Step 130: Reference the target data content to the target document.

[0077] In this embodiment, the target document includes any one of a data table, an online table, or an electronic spreadsheet.

[0078] Specifically, such as Figure 3 As shown, the acquired target data content, such as "Project 1" and "Project 4", is referenced in the target document. For example, "Project 1" is added to cell A1 of the target document, and "Project 4" is added to cell A2. The letters in A1 and A2 represent column numbers, and the numbers represent row numbers. The order of the target data content can be customized, such as sorting it in ascending or descending order based on the size of its field values.

[0079] It should be noted that for data content displayed in a Kanban view format (such as...) Figure 4 As shown, the display interface contains multiple Kanban views. Based on the input instructions, the corresponding Kanban view is determined in the data collaboration document, and the target data content in the Kanban view is obtained.

[0080] It should be noted that the selected area of ​​the data collaboration document determined by the input command can be either a continuous area or an intermittent area. A continuous area refers to a region consisting of multiple rows with consecutive row numbers, multiple columns with consecutive column numbers, or a portion of the cells within a region formed by multiple consecutive rows and columns with consecutive column numbers. When the labels are numbers, the consecutive labels are sorted in ascending or descending order, and the labels differ by 1. For example, the area consisting of rows 1, 2, and 3 is a continuous area. An intermittent area refers to a region consisting of multiple rows with non-consecutive row numbers, multiple columns with non-consecutive column numbers, or a portion of the cells within the intersection of multiple non-consecutive rows and columns with non-consecutive column numbers.

[0081] The data referencing method provided in this invention involves determining a selected area of ​​a data collaboration document based on an input instruction; obtaining the target data content corresponding to the selected area of ​​the data collaboration document; and referencing the target data content to the target document. This enables data content interaction between the data collaboration document and the target document (electronic document) without needing to reference data content on a cell-by-cell basis, thus allowing the data content of the data collaboration document to be referenced to the target document.

[0082] Furthermore, to ensure the security of data collaboration documents, corresponding access permissions can be set for them. Before accessing the data collaboration document, the method provided by this invention further includes: determining whether there is access permission for the data collaboration document; if so, performing an access operation on the data collaboration document. This ensures the secure use of the data content of the data collaboration document, preventing other users without access permissions from using or viewing the data content of the data collaboration document.

[0083] Furthermore, in a specific embodiment of the present invention, see [link to specific embodiment]. Figure 5 Step 110, which involves determining the selected area of ​​the data collaboration document based on the input instructions, includes:

[0084] Step 510: Generate data reference formulas according to the input instructions.

[0085] The data reference formula contains at least one data reference field.

[0086] Data reference fields refer to the attribute information of data collaboration documents, such as the storage address of the data collaboration document or the title of the data collaboration document.

[0087] Specifically, step 510 includes: receiving user clicks or inputs through the user interface and determining the generated data reference fields.

[0088] When there are multiple fields referenced in the data.

[0089] Multiple data reference fields are used in an AND logic to generate a data reference formula. For example, the generated data reference formula includes: data reference field 1, data reference field 2, and data reference field 3. The AND logic means that multiple data reference fields are processed in a "union" relationship; that is, the determined data item is the data content that satisfies the constraints of each of the aforementioned data reference fields. For example, if there are three data reference fields, then the data item should satisfy the constraints of all three data reference fields.

[0090] Alternatively, multiple data reference fields can be used with OR logic to generate a data reference formula. For example, the generated data reference formula could include: data reference field 1, OR data reference field 2, OR data reference field 3. OR logic refers to multiple data reference fields processing data content in an "either / or" relationship, or it can also refer to multiple data reference fields processing data content in a "partial" relationship. That is, the determined data entry is data content that satisfies the constraints of one of the aforementioned data reference fields. The determined data entry can also be data content that satisfies the constraints of some of the aforementioned data reference fields. For example, when there are three data reference fields, a data entry can satisfy the constraints of one of the data reference fields; a data entry can also satisfy the constraints of two of the data reference fields.

[0091] Alternatively, multiple data reference fields can be combined with logical AND and OR logic to generate a data reference formula, for example, the generated data reference formula includes: data reference field 1 or data reference field 2, and data reference field 3.

[0092] The click operation refers to the user clicking to select a data reference field in the user interface settings. This data reference field can be displayed in the user interface as a menu, a control, etc. The input operation refers to the user entering a call command in the user interface, which determines the data reference field to be used, and then generates the data reference field.

[0093] For example, the data referencing formula is in the following form:

[0094] =import*(data reference field1, data reference field2, data reference field3);

[0095] =import*(data reference field1, data reference field2, data reference field3, data reference field4);

[0096] =import*(data reference field1, data reference field2, data reference field3, data reference field5);

[0097] =import*(data reference field1, data reference field2, data reference field3, data reference field4, data reference field5).

[0098] In this context, * represents the identifier of the data collaboration document that generates the target data content. This identifier can be the name of the data collaboration document, etc. Data Reference Field 1 is the document address field for the data collaboration document. With the appropriate permissions, the referrer can directly open the data collaboration document and access all its data by accessing this address. Data Reference Field 2 is the document identifier field, typically the identifier (id) or name of the data collaboration document. Data Reference Field 3 is the header field, including the header field id or header field name. Data Reference Field 4 is the filter field; if used, the target data content will be filtered based on this field. Data Reference Field 5 is the sorting field, used to identify the sorting method for each target data content item.

[0099] Let's take a specific data referencing formula as an example:

[0100] =import*("https: / / www.kdocs.cn / p / 100003833749", "Project Management Table", "Project", "filter:Status=In Progress||Status=Not Started")

[0101] The meaning of this data referencing formula is to access the data collaboration document at the address "https: / / www.kdocs.cn / p / 100003833749", view the data collaboration document, and specify that the source of the referenced data is the data collaboration document named "Project Management Table" (e.g., Figure 2 As shown in the diagram, the "Project Management Table" includes 5 initial data entries. Each initial data entry includes data content corresponding to different header fields. These header fields include "Project," "Planned Completion Date," "Status," and "Responsible Person." The data reference formula specifies that the referenced data is the data entry corresponding to the header field "Project," and a filter field of "Status = In Progress || Status = Not Started" is set to filter the selected data entries.

[0102] See Figure 6 See Figure 6 , Figure 6 The diagram shows a user interface. Users select from the filter criteria displayed in the user interface to determine the corresponding filter fields.

[0103] Step 520: Based on the data reference field, determine the data entries corresponding to the data reference field, and use the area formed by combining the data entries as the selected area of ​​the data collaboration document.

[0104] Steps 510-520 allow you to determine the selected area of ​​a data collaboration document using data reference formulas.

[0105] The following examples illustrate step 520.

[0106] A data reference formula contains at least one data reference field, including:

[0107] In the first scenario, where the data referencing formula includes a document address field, a document identifier field, and a table header field, please refer to [link to relevant documentation]. Figure 7 Based on the data reference field, determine the data entries corresponding to that data reference field, and use the area formed by combining these data entries as the selected area of ​​the data collaboration document, including:

[0108] Step 710: Determine the storage address of the data collaboration document based on the document address field of the data reference formula.

[0109] Step 720: Locate the first data collaboration document corresponding to the document identifier field in the storage address.

[0110] Step 730: Select the first initial data entries corresponding to the header fields in the first data collaboration document.

[0111] Step 740: The area formed by combining each of the first initial data entries is taken as the first selected area of ​​the first data collaboration document.

[0112] The second scenario, where the data referencing formula includes: document address field, document identifier field, table header field, and filter field, see [link to relevant documentation]. Figure 8 Based on the data reference field, determine the data entries corresponding to that data reference field, and use the area formed by combining these data entries as the selected area of ​​the data collaboration document, including:

[0113] Step 810: Determine the storage address of the data collaboration document based on the document address field of the data reference formula.

[0114] Specifically, combining data reference formulas

[0115] =import*("https: / / www.kdocs.cn / p / 100003833749", "Project Management Table", "Project", "filter:Status=In Progress||Status=Not Started"), determines the storage address of the data collaboration document based on the document address field "https: / / www.kdocs.cn / p / 100003833749" in the data reference formula.

[0116] Step 820: Locate the second data collaboration document corresponding to the document identifier field in the storage address.

[0117] Specifically, combining data reference formulas

[0118] =importDb("https: / / www.kdocs.cn / p / 100003833749", "Project Management Table", "Project", "filter:Status=In Progress||Status=Not Started"), retrieves the second data collaboration document based on the document identifier field "Project Management Table" in the data reference formula.

[0119] Step 830: Select the respective second initial data entries corresponding to the header fields in the second data collaboration document.

[0120] Specifically, based on the "Item" header field of the data reference formula, select each of the second initial data entries corresponding to the "Item" header field.

[0121] Step 840: Select at least one second data entry from each of the second initial data entries that meets the filter field.

[0122] Specifically, based on the filter field "filter:status=in progress||status=not started project" in the data referencing formula, at least one second data entry that matches the filter field is selected:

[0123] ("Project 1", "2021 / 9 / 18", "In Progress", "Xiaoming");

[0124] ("Project 2", "2021 / 9 / 17", "Not Started", "Wang Wu");

[0125] (“Project 4”, “2021 / 9 / 16”, “In Progress”, “Li Si”).

[0126] Step 850: The area formed by recombining at least one second data entry is used as the second selected area of ​​the second data collaboration document.

[0127] Then, according to steps 120-130 above, based on the second selected area, the target data content corresponding to the selected area of ​​the data collaboration document is obtained. The target data content is then referenced in the target document, resulting in the target document as follows: Figure 9 As shown.

[0128] The third scenario involves data referencing formulas that include: document address fields, document identifier fields, header fields, and sorting fields. See [link to relevant documentation]. Figure 10 Based on the data reference field, determine the data entries corresponding to that data reference field, and use the area formed by combining these data entries as the selected area of ​​the data collaboration document, including:

[0129] Step 1010: Determine the storage address of the data collaboration document based on the document address field of the data reference formula.

[0130] Step 1020: Locate the third-party data collaboration document corresponding to the document identifier field in the storage address.

[0131] Step 1030: Select the respective third initial data entries corresponding to the header fields in the third data collaboration document.

[0132] Step 1040: Arrange each third initial data entry according to the sorting field, and use the area formed by recombining the third initial data entries after sorting as the third selected area of ​​the third data collaboration document.

[0133] The fourth scenario involves data referencing formulas that include: document address fields, document identifier fields, header fields, filter fields, and sorting fields. See [link to relevant documentation]. Figure 11 Based on the data reference field, determine the data entries corresponding to that data reference field, and use the area formed by combining these data entries as the selected area of ​​the data collaboration document, including:

[0134] Step 1110: Determine the storage address of the data collaboration document based on the document address field of the data reference formula.

[0135] Step 1120: Locate the fourth data collaboration document corresponding to the document identifier field in the storage address.

[0136] Step 1130: Select the fourth initial data entries corresponding to the header fields in the fourth data collaboration document.

[0137] Step 1140: Select at least one fourth data entry from each of the fourth initial data entries that meets the filter field.

[0138] Step 1150: Arrange the fourth data entries that meet the filtering fields according to the sorting field, and use the area formed by recombining the fourth data entries after sorting as the fourth selected area of ​​the fourth data collaboration document.

[0139] Furthermore, a data collaboration document can include a complete area where data content can be searched using data referencing formulas; a data collaboration document can also include multiple areas spaced apart from each other, such as... Figure 12 As shown, data content can be searched simultaneously in multiple areas using data referencing formulas.

[0140] Furthermore, the data content of the data collaboration document may change, such as through deletion, updating, or addition of data content. In a specific embodiment of the present invention, after referencing the target data content to the target document, the method provided by the present invention further includes:

[0141] Step S131: Set callback parameters for the data collaboration document;

[0142] Step S132: Monitor whether the target data content has been updated using callback parameters;

[0143] Step S133: If an update to the target data content is detected, send an update notification to the target document.

[0144] After receiving an update notification on the target document's display interface, users can determine the updated target data content based on the update notification and update the target document accordingly; or decide whether to update the corresponding target data content in the target document based on their usage needs.

[0145] If the conditions for referencing the data formula change, you need to delete or re-register the new callback parameter.

[0146] In another scenario, if the referenced data does not need to be dynamic, it can be represented by setting a fixed record ID in the data reference formula:

[0147] =import*("https: / / www.kdocs.cn / p / 100003833749", "Project Management Table Id", "Project id, Responsible Person id", "id: Record id"). Here, "Record id" refers to the id of each row. This id is generated when the data is created and will not change regardless of where it is moved in the data collaboration document. Even if the data is deleted, this id will not be recycled.

[0148] In the embodiments provided by the present invention, data reference formulas can be used to filter the data content of multiple data collaboration documents, and the data content of each data collaboration document that is determined to be referenced can be used as the target data content and referenced to the same target document.

[0149] A data collaboration document is a data table used to standardize data content. The target document can be any type of data table, online spreadsheet, or electronic spreadsheet.

[0150] The data referencing device provided by the present invention is described below. The data referencing device described below and the data referencing method described above can be referred to in correspondence.

[0151] Figure 13 A schematic diagram of the data referencing device provided by the present invention includes:

[0152] The first processing unit 1310 is used to determine the selected area of ​​the data collaboration document according to the input instruction;

[0153] The second processing unit 1320 is used to obtain the target data content corresponding to the selected area of ​​the data collaboration document based on the selected area.

[0154] The third processing unit 1330 is used to reference the target data content to the target document.

[0155] Optionally, the first processing unit 1310 includes:

[0156] The formula generation subunit is used to generate a data reference formula based on the input instruction; wherein the data reference formula contains at least one data reference field;

[0157] The region selection sub-unit is used to determine the data entries corresponding to the data reference fields based on the data reference fields, and to use the region formed by combining the data entries as the selected region of the data collaboration document.

[0158] Optionally, the formula generates sub-cells, specifically for:

[0159] The system receives user clicks or inputs through the user interface and determines the fields referenced in the generated data.

[0160] When there are multiple fields referenced in the data.

[0161] Multiple data reference fields are combined with logic to generate data reference formulas;

[0162] Alternatively, multiple data reference fields can be used in an OR logic to generate a data reference formula;

[0163] Alternatively, multiple data reference fields can be combined with logical AND / OR logic to generate a data reference formula.

[0164] Optionally, the data reference formula includes at least one data reference field, including: the data reference formula includes: a document address field, a document identifier field, and a table header field;

[0165] The region selection sub-unit is specifically used for:

[0166] The storage address of the data collaboration document is determined based on the document address field of the data reference formula. The first data collaboration document corresponding to the document identifier field is found in the storage address. Each first initial data entry corresponding to the table header field is selected in the first data collaboration document. The area formed by combining each first initial data entry is taken as the first selected area of ​​the first data collaboration document.

[0167] Optionally, the data reference formula includes at least one data reference field, including: the data reference formula includes: a document address field, a document identifier field, a header field, and a filter field;

[0168] The region selection sub-unit is specifically used for:

[0169] The storage address of the data collaboration document is determined based on the document address field of the data reference formula. The second data collaboration document corresponding to the document identifier field is found in the storage address. Each second initial data entry corresponding to the table header field is selected in the second data collaboration document. At least one second data entry that meets the filtering field is selected in each second initial data entry. The area formed by recombining at least one second data entry is used as the second selected area of ​​the second data collaboration document.

[0170] Optionally, the data reference formula includes at least one data reference field, including: the data reference formula includes: a document address field, a document identifier field, a header field, and a sort field;

[0171] The region selection sub-unit is specifically used for:

[0172] The storage address of the data collaboration document is determined based on the document address field of the data reference formula. The third data collaboration document corresponding to the document identifier field is found in the storage address. Each third initial data entry corresponding to the table header field is selected in the third data collaboration document. Each third initial data entry is arranged in the sorting order according to the sorting field. The area formed by recombining the sorted third initial data entries is used as the third selected area of ​​the third data collaboration document.

[0173] Optionally, the data referencing device provided by the present invention further includes: a judging unit, used to judge whether there is access permission for the data collaboration document before accessing the data collaboration document; if so, to perform an access operation on the data collaboration document.

[0174] Optionally, the data referencing device further includes:

[0175] The callback parameter setting unit is used to set callback parameters for the data collaboration document after the target data content is referenced to the target document;

[0176] The update notification unit is used to monitor whether the target data content has been updated using callback parameters;

[0177] If an update to the target data content is detected, an update notification is sent to the target document.

[0178] The data referencing device provided by this invention determines a selected area in a data collaboration document according to an input instruction; obtains the corresponding target data content in the data collaboration document according to the selected area; and references the target data content to the target document, thereby eliminating the need to reference data content on a cell-by-cell basis and enabling the reference of data content from a data collaboration document to other target documents.

[0179] Figure 14 An example is a schematic diagram of the physical structure of an electronic device, such as... Figure 14As shown, the electronic device may include a processor 1410, a communications interface 1420, a memory 1430, and a communication bus 1440, wherein the processor 1410, the communications interface 1420, and the memory 1430 communicate with each other via the communication bus 1440. The electronic device provided by this invention includes a memory 1430, a processor 1410, and a computer program stored in the memory 1430 and executable on the processor 1410. The processor 1410 can invoke logical instructions in the memory 1430 to execute a data referencing method, which includes: determining a selected area of ​​a data collaboration document according to an input instruction; obtaining target data content corresponding to the selected area of ​​the data collaboration document according to the selected area; and referencing the target data content to the target document.

[0180] Furthermore, the logical instructions in the aforementioned memory 1430 can be implemented as software functional units and, when sold or used as independent products, can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention, or the part that contributes to the prior art, or a part of the technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute all or part of the steps of the methods described in the various embodiments of the present invention. The aforementioned storage medium includes various media capable of storing program code, such as USB flash drives, portable hard drives, read-only memory (ROM), random access memory (RAM), magnetic disks, or optical disks.

[0181] On the other hand, the present invention also provides a computer program product, the computer program product including a computer program stored on a non-transitory computer-readable storage medium, the computer program including program instructions, and when the program instructions are executed by a computer, the computer is able to execute the data referencing method provided by the above methods, the method including: determining a selected area of ​​a data collaboration document according to an input instruction; obtaining target data content corresponding to the selected area of ​​the data collaboration document according to the selected area; and referencing the target data content to the target document.

[0182] In another aspect, the present invention also provides a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, is implemented to perform the data referencing methods provided above, the method comprising: determining a selected area of ​​a data collaboration document according to an input instruction; obtaining target data content corresponding to the selected area of ​​the data collaboration document according to the selected area; and referencing the target data content to the target document.

[0183] The device embodiments described above are merely illustrative. The units described as separate components may or may not be physically separate. The components shown as units may or may not be physical units; that is, they may be located in one place or distributed across multiple network units. Some or all of the modules can be selected to achieve the purpose of this embodiment according to actual needs. Those skilled in the art can understand and implement this without any creative effort.

[0184] Through the above description of the embodiments, those skilled in the art can clearly understand that each embodiment can be implemented by means of software plus necessary general-purpose hardware platforms, and of course, it can also be implemented by hardware. Based on this understanding, the above technical solutions, in essence or the part that contributes to the prior art, can be embodied in the form of a software product. This computer software product can be stored in a computer-readable storage medium, such as ROM / RAM, magnetic disk, optical disk, etc., and includes several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute the methods described in the various embodiments or some parts of the embodiments.

[0185] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, and not to limit them; although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some of the technical features; and these modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A data referencing method, characterized in that, include: Based on the input command, the selected area of ​​the data collaboration document is determined, and the data collaboration document is displayed in the form of a view; Based on the selected area, obtain the target data content corresponding to the selected area of ​​the data collaboration document; Reference the target data content to the target document; The step of determining the selected area of ​​the data collaboration document based on the input command includes: A data reference formula is generated based on the input instruction; wherein the data reference formula contains at least one data reference field; Based on the data reference field, determine the data entries corresponding to the data reference field, and use the area formed by combining the data entries as the selected area of ​​the data collaboration document; wherein, the data entry is a view unit in the data collaboration document, and is a data unit in the data collaboration document that describes relevant information of a specific data entity; The data referencing formula includes at least one data referencing field, including: a document address field, a document identifier field, a header field, and a filter field; determining the data entries corresponding to the data referencing fields based on the data referencing fields, and using the area formed by combining the data entries as the selected area of ​​the data collaboration document, includes: determining the storage address of the data collaboration document based on the document address field of the data referencing formula; searching for a second data collaboration document corresponding to the document identifier field in the storage address; selecting each second initial data entry corresponding to the header field in the second data collaboration document; selecting at least one second data entry that meets the filter field from each second initial data entry; and using the area formed by recombining the at least one second data entry as the second selected area of ​​the second data collaboration document; or... The data reference formula includes at least one data reference field, including: a document address field, a document identifier field, a header field, and a sorting field; determining the data entries corresponding to the data reference fields based on the data reference fields, and using the area formed by combining the data entries as the selected area of ​​the data collaboration document, includes: determining the storage address of the data collaboration document based on the document address field of the data reference formula; searching for a third data collaboration document corresponding to the document identifier field in the storage address; selecting each third initial data entry corresponding to the header field in the third data collaboration document; arranging each third initial data entry according to the sorting field; and using the area formed by recombining the arranged third initial data entries as the third selected area of ​​the third data collaboration document.

2. The data referencing method according to claim 1, characterized in that, The step of generating a data reference formula based on the input instruction includes: The generated data reference fields are determined by receiving user clicks or inputs through the user interface. When there are multiple data reference fields, The data reference formula is generated by combining multiple data reference fields with logical AND. Alternatively, the data reference formula can be generated by using an OR logic to reference multiple data reference fields; Alternatively, the data reference formula can be generated by combining multiple data reference fields with logical AND and OR logic.

3. The data referencing method according to claim 1, characterized in that, The data reference formula includes at least one data reference field, including: The data referencing formula includes: a document address field, a document identifier field, and a table header field; The step of determining the data entry corresponding to the data reference field based on the data reference field, and using the area formed by combining the data entries as the selected area of ​​the data collaboration document, includes: The storage address of the data collaboration document is determined according to the document address field of the data reference formula. The first data collaboration document corresponding to the document identifier field is found in the storage address. Each first initial data entry corresponding to the header field is selected in the first data collaboration document. The area formed by combining each first initial data entry is taken as the first selected area of ​​the first data collaboration document.

4. The data referencing method according to claim 1 or 3, characterized in that, The method further includes, prior to accessing the data collaboration document: Determine whether there is access permission for the data collaboration document; If so, perform an access operation on the data collaboration document.

5. The data referencing method according to claim 1, characterized in that, After referencing the target data content to the target document, the method further includes: Set callback parameters for the data collaboration document; The callback parameters are used to monitor whether the target data content has been updated. If an update to the target data content is detected, an update notification is sent to the target document.

6. The data referencing method according to any one of claims 1-3, characterized in that, The data collaboration document is a data table used to standardize data content; The target document includes any one of the following: a data table, an online table, or a spreadsheet.

7. A data referencing device, characterized in that, include: The first processing unit is used to determine the selected area of ​​the data collaboration document according to the input instruction, wherein the data collaboration document is displayed in the form of a view; The second processing unit is used to obtain the target data content corresponding to the selected area of ​​the data collaboration document based on the selected area. The third processing unit is used to reference the target data content to the target document; The first processing unit includes: The formula generation subunit is used to generate a data reference formula based on the input instruction; wherein the data reference formula contains at least one data reference field; The region selection sub-unit is used to determine the data entries corresponding to the data reference fields based on the data reference fields, and to use the region formed by combining the data entries as the selected region of the data collaboration document; wherein, the data entries are view units in the data collaboration document, which are data units in the data collaboration document that describe relevant information of a specific data entity; The data referencing formula includes at least one data referencing field, including: a document address field, a document identifier field, a header field, and a filter field; determining the data entries corresponding to the data referencing fields based on the data referencing fields, and using the area formed by combining the data entries as the selected area of ​​the data collaboration document, includes: determining the storage address of the data collaboration document based on the document address field of the data referencing formula; searching for a second data collaboration document corresponding to the document identifier field in the storage address; selecting each second initial data entry corresponding to the header field in the second data collaboration document; selecting at least one second data entry that meets the filter field from each second initial data entry; and using the area formed by recombining the at least one second data entry as the second selected area of ​​the second data collaboration document; or... The data reference formula includes at least one data reference field, including: a document address field, a document identifier field, a header field, and a sorting field; determining the data entries corresponding to the data reference fields based on the data reference fields, and using the area formed by combining the data entries as the selected area of ​​the data collaboration document, includes: determining the storage address of the data collaboration document based on the document address field of the data reference formula; searching for a third data collaboration document corresponding to the document identifier field in the storage address; selecting each third initial data entry corresponding to the header field in the third data collaboration document; arranging each third initial data entry according to the sorting field; and using the area formed by recombining the arranged third initial data entries as the third selected area of ​​the third data collaboration document.

8. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that, When the processor executes the program, it implements the steps of the data referencing method as described in any one of claims 1 to 6.

9. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by a processor, it implements the steps of the data referencing method as described in any one of claims 1 to 6.

Images