CN114417789A - Data reference method and device, electronic equipment and storage medium - Google Patents
Data reference method and device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN114417789A CN114417789A CN202111589397.9A CN202111589397A CN114417789A CN 114417789 A CN114417789 A CN 114417789A CN 202111589397 A CN202111589397 A CN 202111589397A CN 114417789 A CN114417789 A CN 114417789A
- Authority
- CN
- China
- Prior art keywords
- data
- document
- field
- referencing
- target
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
Abstract
The invention provides a data reference method, a data reference device, electronic equipment and a storage medium, wherein the method comprises the following steps: determining a selected area of the data collaboration document according to the input instruction; acquiring 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, reference of the data content is not required to be performed by taking a cell as a unit, and the data content of the data collaboration document is referenced to the target document.
Description
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a data reference method and apparatus, an electronic device, and a storage medium.
Background
Spreadsheets, also known as spreadsheets, are a class of computer programs that simulate a computational form on paper. It displays a cell made up of a series of rows and columns in which values, calculations or text can be stored. In the related art, a user often uses a data content reference technology between spreadsheets, for example, in a case where data content in a first spreadsheet is referred to a second spreadsheet, data content of a continuous cell area is acquired according to an interval instruction input into the first spreadsheet, and then the data content is referred to the second spreadsheet. The continuous cell area refers to the forward and backward extension of the row number or the column number of two adjacent cells, for example, the label of one cell is the cell corresponding to the first row and the first column, and the label of the other cell is the cell corresponding to the first row and the second column. That is, the manner of reference in which the data content in the first spreadsheet is referred to the second spreadsheet is to explicitly define the position (label) of the cell in units of cells, and the start position and end position of the cell constitute the area of the continuous cell label. For example, the selected data content is the data content of the region from row 1 to row 5 of the cell label to column 1 to column 2 of the cell label, the selected data content is represented by command lines A1: B5\ R1C1: R5C 2.
The data collaboration document can be used for editing and saving data content, and the data content in the data collaboration document can be displayed in a grid table form, a billboard view form or a picture form. That is, a data collaboration document is a data table that may display data content in multiple views (e.g., billboard view, grid list, album).
Since the data cooperation document does not set the labels of the respective cells, it is difficult to define the area of the data cooperation document in units of cells, and therefore, the data content reference method in the related art is not suitable for acquisition, reference, and the like of the data content of the data cooperation document. Therefore, a method for referring the data content of the data collaboration document to other electronic documents is needed to solve the technical problem that the prior art cannot realize that the data content of the data collaboration document is referred to other electronic documents.
Disclosure of Invention
The invention provides a data reference method, a data reference device, electronic equipment and a storage medium, which are used for realizing that data contents of a data cooperation document are referred to other electronic documents and realizing data content interaction between the data cooperation document and the electronic documents.
The invention provides a data reference method, which comprises the following steps:
determining a selected area of the data collaboration document according to the input instruction;
acquiring 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.
Optionally, the determining a selected area of the data collaboration document according to the input instruction includes:
generating a data reference formula according to the input instruction; wherein the data reference formula contains at least one data reference field;
and determining data items corresponding to the data reference fields according to the data reference fields, and taking the area formed by combining the data items as the selected area of the data collaboration document.
Optionally, the generating a data reference formula according to the input instruction includes:
receiving click operation or input operation of a user through a user interface, and determining the generated data reference field;
in the case where the data reference field is plural,
generating the data reference formula with a plurality of data reference fields and logic;
or generating the data reference formula by using a plurality of data reference fields in OR logic;
alternatively, a plurality of data reference fields are combined with logic and or logic to generate the data reference formula.
Optionally, the data reference formula contains at least one data reference field, including:
the data reference formula comprises: a document address field, a document identification field and a header field;
determining data items corresponding to the data reference fields according to the data reference fields, and taking the area formed by combining the data items as the selected area of the data collaboration document, wherein the method comprises the following steps:
determining a storage address of the data cooperation document according to a document address field of the data reference formula, searching a first data cooperation document corresponding to the document identification field in the storage address, selecting each first data entry corresponding to the header field in the first data cooperation document, and taking an area formed by combining the first data entries as a first selected area of the first data cooperation document.
Optionally, the data reference formula contains at least one data reference field, including:
the data reference formula comprises: a document address field, a document identification field, a header field and a screening field;
determining data items corresponding to the data reference fields according to the data reference fields, and taking the area formed by combining the data items as the selected area of the data collaboration document, wherein the method comprises the following steps:
determining a storage address of the data collaboration document according to a document address field of the data reference formula, searching a second data collaboration document corresponding to the document identification field in the storage address, selecting each second data entry corresponding to the header field in the second data collaboration document, selecting at least one second data entry conforming to the screening field in each second data entry, and recombining and combining the at least one second data entry to form a region as a second selected region of the second data collaboration document.
Optionally, the data reference formula contains at least one data reference field, including:
the data reference formula comprises: a document address field, a document identification field, a header field and a sorting field;
determining data items corresponding to the data reference fields according to the data reference fields, and taking the area formed by combining the data items as the selected area of the data collaboration document, wherein the method comprises the following steps:
determining a storage address of the data cooperation document according to a document address field of the data reference formula, searching a third data cooperation document corresponding to the document identification field in the storage address, selecting each third data entry corresponding to the header field in the third data cooperation document, arranging the third initial data entries according to the sequence of the sequencing fields, and recombining and combining the third initial data entries after the arrangement sequence to form a region as a third selected region of the third data cooperation document.
Optionally, before accessing the data collaboration document, the method further comprises:
determining whether there is access permission for the data collaboration document;
and if so, executing the access operation on the data collaboration document.
Optionally, after the referring of the target data content to the target document, the method further includes:
setting a callback parameter for the data collaboration document;
monitoring whether the target data content is updated or not by utilizing the callback parameter;
and sending an update notification to the target document when the target data content is monitored to be updated.
Optionally, the data collaboration document is a data table for specifying data content;
the target document comprises any one of a data table, an online table and an electronic table.
The present invention also provides a data referencing apparatus, comprising:
the first processing unit is used for determining a selected area of the data collaboration document according to an input instruction;
the second processing unit is used for acquiring target data content corresponding to the selected area of the data collaboration document according to the selected area;
and the third processing unit is used for referencing the target data content to a target document.
The invention also provides an electronic device comprising a memory, a processor and a computer program stored on 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.
The present invention also provides a computer readable storage medium having stored thereon a computer program which, when executed by a processor, performs the steps of the data referencing method as described in any one of the above.
The invention provides a data reference method, a data reference device, electronic equipment and a storage medium, wherein the data reference method determines a selected area of a data cooperation document according to an input instruction; acquiring target data content corresponding to the selected area of the data collaboration document according to the selected area; the target data content is referenced to the target document. In this way, data content interaction between the data collaboration document and the target document (electronic document) is realized, reference of the data content is not required to be performed by taking a cell as a unit, and the data content of the data collaboration document is referenced to the target document.
Drawings
In order to more clearly illustrate the technical solutions of the present invention or the prior art, the drawings needed for the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and those skilled in the art can also obtain other drawings according to the drawings without creative efforts.
FIG. 1 is a flow chart diagram of a data referencing method provided by the present invention;
FIG. 2 is a schematic diagram of a data collaboration document provided by the present invention;
FIG. 3 is a diagram illustrating the result of data referencing according to one embodiment of the present invention;
FIG. 4 is a schematic diagram of a data collaboration document provided by the present invention displayed in a billboard view;
FIG. 5 is a flow chart diagram of a data referencing method provided by the present invention;
FIG. 6 is a schematic diagram of a user interface for obtaining a filter field according to the present invention;
FIG. 7 is a flow chart diagram of a data referencing method provided by the present invention;
FIG. 8 is a flow chart diagram of a data referencing method provided by the present invention;
FIG. 9 is a schematic diagram of the present invention providing a reference of target data content to a target document;
FIG. 10 is a flow chart diagram of a data referencing method provided by the present invention;
FIG. 11 is a flow chart diagram of a data referencing method provided by the present invention;
FIG. 12 is a diagram illustrating a method for locating data content in multiple regions of a data collaboration document according to the present invention;
FIG. 13 is a schematic structural diagram of a data referencing device provided by the present invention;
fig. 14 is a schematic structural diagram of an electronic device provided by the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention clearer, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings, and it is obvious that the described embodiments are some, but not all embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
First, the noun terms to which the embodiments of the present invention relate are exemplarily explained.
Data collaboration document: the data collaboration document is a novel document between a database and an electronic form, data contents can be edited and stored by using the data collaboration document, and the data contents in the data collaboration document can be displayed in a grid form, a view form or a picture form.
Data entry: the data unit describing the related information of a specific data entity in the data collaboration document represents a row or a column of data in the data collaboration document or a view unit in the data collaboration document.
The target document: an electronic document that references data content of a data collaboration document, which may be a local spreadsheet, an online spreadsheet, another data collaboration document, and so on.
The technical solutions of the embodiments of the present invention are described below with reference to fig. 1 to 14.
Fig. 1 is a schematic flowchart of a data referencing method according to an embodiment of the present invention, as shown in fig. 1, including the following steps:
In this embodiment, the data collaboration document is a data table for specifying data content.
The input command may be a command manually input by the user, or may be a command generated by various operations performed by the user on the user interface, such as a click operation, a slide operation, and a touch operation.
And selecting the area, namely the area corresponding to the input instruction in the data cooperation document. Note that, since the data cooperation document does not have a reference number for each cell, the selected area is not an area defined in units of cells. In this embodiment, the data collaboration document includes a plurality of rows and columns of data content, each row including a plurality of consecutive cells; each column containing a plurality of consecutive cells; each row or each column of data content forms an initial data entry, and the selected area may be an area where one or more selected complete initial data entries are located, or an area where partial data content in one or more initial data entries is located.
Referring to FIG. 2, FIG. 2 illustrates an example of a data collaboration document. The data collaboration document comprises 5 initial data items 1-5. Specifically, the initial data entry 1 includes a data content line next to the header line, that is, includes "the project is project 1; the scheduled completion date is 2021/9/18; the state is in progress; the row corresponding to the "Mingming" is responsible. Initial data entry 2 contains the data content line of the second line of the header line, i.e. contains the "project is project 3; the scheduled completion date is 2021/9/23; the state is finished; the responsible person is the row corresponding to the little red. The initial data entry 3 contains the data content line of the third row of the title line, i.e. contains the "project is project 2; the scheduled completion date is 2021/9/17; the state is not started; responsible for the corresponding row of Wangwu. The initial data entry 4 contains the data content line of the fourth line of the title line, i.e. contains the "project is project 5; the scheduled completion date is 2021/9/3; the state is finished; the responsible person is Zhang three corresponding rows. The initial data entry 5 contains the data content line of the fifth line of the header line, i.e. contains the "project is project 4; the scheduled completion date is 2021/9/16; the state is in progress; the person in charge is the row corresponding to lie four'. According to the input instruction, the whole data content of at least one initial data entry can be determined as the selected area. A portion of the data content of at least one of the initial data entries may also be designated as a selected area.
And step 120, acquiring target data content corresponding to the selected area of the data collaboration document according to the selected area.
And after the selected area is determined, acquiring the target data content corresponding to the selected area for standby. Referring to fig. 2, each initial data entry contains a plurality of data contents, for example, the data content of the first row may be used as one initial data entry, which includes { project 1; 2021/9/18, respectively; carrying out the following steps; decimal) 4 items of content, the target data content may include all 4 items of content of the first row of data content, or may include partial items of content of the first row of data, for example, { project 1; 2021/9/18, respectively; go ahead 3 items of content.
In this embodiment, the target document includes any one of a data table, an online table, and an electronic table.
Specifically, as shown in fig. 3, the obtained target data content, such as "project 1" and "project 4", is referred to in the target document, illustratively, "project 1" is added to the a1 cell location of the target document; project 4 is added to the target document at position a 2. Wherein the letters of a1 and a2 represent column numbers and the numbers represent row numbers. In this case, the data contents may be arranged in an ascending order or a descending order, for example, according to the size of the field value data of the target data contents.
It should be noted that, for data content displayed in the billboard view form (as shown in fig. 4), a display interface includes a plurality of billboard views, a corresponding billboard view is determined in the data collaboration document according to an input instruction, and corresponding target data content in the billboard view is acquired.
It should be noted that the selected area of the data cooperation document determined according to the input instruction may be a continuous area of the data cooperation document or an interval area of the data cooperation document. The continuous area refers to an area corresponding to a part of cells in an area formed by a plurality of rows with continuous labels of the row numbers of the data cooperation documents, a plurality of columns with continuous labels of the column numbers of the data cooperation documents, or a plurality of rows with continuous labels of the data cooperation documents and a plurality of columns with continuous labels. In the case of a numerical label, consecutive index numbers are sorted in ascending order one by one or in descending order one by one with a1 difference between the label and the label. For example, a region formed by three lines having a line number of 1, a line number of 2, and a line number of 3 is a continuous region. The space area refers to an area corresponding to a part of cells in an area where rows of a reference number of a data cooperation document are discontinuous, or columns of a reference number of a column number of a data cooperation document are discontinuous, or where rows of a reference number of a discontinuous data cooperation document and columns of a discontinuous reference number intersect.
According to the data reference method provided by the embodiment of the invention, the selected area of the data collaboration document is determined according to the input instruction; acquiring target data content corresponding to the selected area of the data collaboration document according to the selected area; the target data content is referenced to the target document. In this way, data content interaction between the data collaboration document and the target document (electronic document) is realized, reference of the data content is not required to be performed by taking a cell as a unit, and the data content of the data collaboration document is referenced to the target document.
Further, in order to ensure the security of the data collaboration document, corresponding access rights can be set for the data collaboration document. Before accessing the data collaboration document, the method provided by the invention further comprises the following steps: judging whether the data collaboration document has access authority; and if so, executing the access operation on the data collaboration document. Therefore, the safe use of the data content of the data collaboration document can be ensured, and other users without access authority can be prevented from using and viewing the data content of the data collaboration document.
Further, in a specific embodiment of the present invention, referring to fig. 5, the determining the selected area of the data collaboration document according to the input instruction in step 110 includes:
and 510, generating a data reference formula according to the input instruction.
Wherein the data reference formula contains at least one data reference field.
The data reference field indicates attribute information of the data collaboration document, and may be, for example, a storage address of the data collaboration document, a title name of the data collaboration document, or the like.
Specifically, step 510 includes: and receiving a clicking operation or an input operation of a user through the user interface, and determining the generated data reference field.
In the case where the data reference field is plural,
generating a data reference formula from the plurality of data reference fields with logic, for example, the generated data reference formula includes: data reference field 1, data reference field 2, and data reference field 3. And logic refers to that a plurality of data reference fields process data contents in a 'and' relationship, namely, the determined data items are the data contents meeting the definition of the data reference fields. For example, where the data reference field is 3, then the data entry should satisfy the definition of all 3 data reference fields.
Alternatively, the data reference formula is generated by or logic of a plurality of data reference fields, for example, the generated data reference formula includes: data reference field 1, or data reference field 2, or data reference field 3. Or logic means that a plurality of data reference fields process data content in an "one" relationship, or logic may also means that a plurality of data reference fields process data content in a "select part" relationship. I.e. the determined data entry is the data content that satisfies the definition of one of the above-mentioned data reference fields. The determined data entry may also be a data content that satisfies the definition of some of the various data reference fields described above. For example, in the case of 3 data reference fields, then the data entry may satisfy the definition of 1 of the data reference fields; the data entry may also satisfy the definition of 2 of the data reference fields.
Alternatively, the plurality of data reference fields are combined with logic and or logic to generate a data reference formula, for example, the generated data reference formula includes: a data reference field 1 or a data reference field 2, and a data reference field 3.
The click operation refers to that a user clicks a data reference field set by the selection user interface on the user interface, and the data reference field can be displayed in the form of a menu on the user interface, displayed in the form of a control, and the like. The input operation means that a user inputs a calling instruction on a user interface, and a data reference field to be used is determined according to the calling instruction so as to generate the data reference field.
For example, the data reference formula is of the form:
import (data reference field 1, data reference field 2, data reference field 3);
import (data reference field 1, data reference field 2, data reference field 3, data reference field 4);
import (data reference field 1, data reference field 2, data reference field 3, data reference field 5);
import (data reference field 1, data reference field 2, data reference field 3, data reference field 4, data reference field 5).
Wherein, denotes an identifier of the data collaboration document generating the target data content, and the identifier may be a name of the data collaboration document. The data reference field 1 is a document address field of the data collaboration document, and a citation party can directly open the data collaboration document and access all data therein by accessing the address in case of having corresponding authority. Data reference field 2 is a document identification field, typically an identification (id) or name of the data collaboration document. The data reference field 3 is a header field including a header field id or a header field name, and the data reference field 4 is a screening field according to which the target data content is screened if the screening field is used. The data reference field 5 is an ordering field to identify the ordering of the respective target data content.
Take a specific data reference formula as an example:
(https:// www.kdocs.cn/p/100003833749"," project management table "," project "," filter: state | | in progress | | state ═ not started ")
The meaning of the data reference formula is to view the data collaboration document by accessing the address "https:// www.kdocs.cn/p/100003833749" of the data collaboration document, specifying that the source of the referenced data is a data collaboration document named "project management table" (as shown in FIG. 2), where the "project management table" includes 5 initial data entries, each of which includes data content corresponding to a different header field identification, where the header field identification includes "project", "project completion date", "status", "responsible person". And specifying that the referenced data is a data entry corresponding to the header field identification "item" through a header field in the data reference formula, and setting a screening field of "state | | | state in progress | | state | | not started" to screen the selected data entry.
Referring to fig. 6, and to fig. 6, fig. 6 is a schematic view of a user interface. And receiving the operation of the user in the screening conditions displayed in the user interface for selection, and determining the corresponding screening fields.
And step 520, determining data items corresponding to the data reference fields according to the data reference fields, and using the areas formed by combining the data items as the selected areas of the data collaboration document.
Determining the selected region of the data collaboration document by way of the data reference formula may be accomplished via step 510 and step 520.
Step 520 is schematically illustrated below in a number of specific examples.
The data reference formula contains at least one data reference field, including:
in the first case, the formula for data reference contains: in the case of the document address field, the document identification field, and the header field, referring to fig. 7, the data entries corresponding to the data reference field are determined according to the data reference field, and the area formed by combining the data entries is used as the selected area of the data collaboration document, including:
And 720, searching the first data collaboration document corresponding to the document identification field in the storage address.
In the second case, the formula for data reference contains: in the case of the document address field, the document identification field, the header field, and the filter field, referring to fig. 8, determining the data entries corresponding to the data reference field according to the data reference field, and using the area formed by combining the data entries as the selected area of the data collaboration document includes:
In particular, incorporating data reference formulas
The storage address of the data collaboration document is determined based on the document address field "https:// www.kdocs.cn/p/100003833749" of the data reference formula.
In particular, incorporating data reference formulas
And acquiring a second data collaboration document according to a document identification field of the data reference formula, namely an item management table (https:// www.kdocs.cn/p/100003833749), an item management table (project), an item and a filter, wherein the state is the state of not starting.
Specifically, each of the second initial data entries corresponding to the header field "item" is selected according to the header field "item" of the data reference formula.
At least one second data entry corresponding to the screening field is selected from the second initial data entries, step 840.
Specifically, according to the filter field "filter, state | | | not-started item" of the data reference formula, at least one second data entry conforming to the filter field is selected:
(project 1 "," 2021/9/18 "," go in "," xiao ming ");
(project 2 "," 2021/9/17 "," not started "," wangwu ");
("engineering 4", "2021/9/16", "go in", "Litetra").
Then, according to the description of the foregoing step 120-130, the target data content corresponding to the selected area of the data collaboration document is obtained according to the second selected area. The target document is generated by referring the target data content to the target document as shown in fig. 9.
In a third case, the reference formula for data contains: in the case of the document address field, the document identification field, the header field, and the sorting field, referring to fig. 10, determining the data entries corresponding to the data reference field according to the data reference field, and using the area formed by combining the data entries as the selected area of the data collaboration document includes:
And step 1020, searching a third data collaboration document corresponding to the document identification field in the storage address.
In a fourth case, the reference formula for the data contains: in the case of the document address field, the document identification field, the header field, the screening field, and the sorting field, referring to fig. 11, the data entries corresponding to the data reference field are determined according to the data reference field, and the area formed by combining the data entries is used as the selected area of the data collaboration document, including:
At least one fourth data entry that matches the screening field is selected among the fourth initial data entries, step 1140.
Further, the data collaboration document may include a complete region in which data content is searched through a data reference formula; the data collaboration document may also include a plurality of regions spaced apart from each other, as shown in FIG. 12, where data content searches are performed simultaneously within the plurality of regions through a data reference formula.
Further, the data content of the data cooperation document may be changed, such as deletion, update, or addition of data content. In a specific embodiment of the present invention, after the target data content is referred to the target document, the method provided by the present invention further includes:
s131, setting callback parameters for the data collaboration document;
step S132, monitoring whether the target data content is updated or not by utilizing the callback parameter;
and step S133, sending an update notification to the target document when the target data content is monitored to be updated.
After the display interface of the target document receives the update notification, the user can determine the updated target data content based on the update notification and update the target document according to the updated target data content; or whether to update the corresponding target data content in the target document is determined according to the use requirement.
If the conditions of the data reference formula change, new callback parameters need to be deleted or re-registered.
In another case, if the referenced data content is not required to be dynamic, it can also be represented by setting a fixed record id in the data reference formula:
(https:// www.kdocs.cn/p/100003833749"," project management table Id "," project Id, person of responsibility Id "," Id: record Id "). The record id refers to the id of each line, and the id is generated during creation, and cannot be changed after being moved to any position in the data collaboration document, and cannot be recycled and reused even after being deleted.
In the embodiment provided by the invention, data contents of multiple pieces of data cooperation documents can be respectively screened by using a data reference formula, and the data contents determined to be referenced by each piece of data cooperation document are used as target data contents and are referenced to the same piece of target document.
The data collaboration document is a data table used to specify the content of data. The target document includes any one of a data table, an online table, and a spreadsheet.
The data citation device provided by the invention is described below, and the data citation device described below and the data citation method described above can be correspondingly referred to each other.
Fig. 13 is a schematic structural diagram of a data referencing apparatus provided in the present invention, including:
a first processing unit 1310 configured to determine a selected area of the data collaboration document according to an input instruction;
a second processing unit 1320, configured to obtain, according to the selected area, target data content corresponding to the selected area of the data collaboration document;
a third processing unit 1330 for referencing the target data content to the target document.
Optionally, the first processing unit 1310 includes:
the formula generation subunit is used for generating a data reference formula according to the input instruction; wherein the data reference formula contains at least one data reference field;
and the area selection subunit is used for determining the data items corresponding to the data reference fields according to the data reference fields, and taking the areas formed by combining the data items as the selected areas of the data cooperation document.
Optionally, the formula generation subunit is specifically configured to:
receiving click operation or input operation of a user through a user interface, and determining a generated data reference field;
in the case where the data reference field is plural,
generating a data reference formula by using a plurality of data reference fields and logic;
or generating a data reference formula by using a plurality of data reference fields and OR logic;
alternatively, multiple data reference fields are combined with logic and or logic to generate a data reference formula.
Optionally, the data reference formula contains at least one data reference field, including: the data reference formula contains: a document address field, a document identification field and a header field;
a region selection subunit, specifically configured to:
determining a storage address of the data cooperation document according to a document address field of a data reference formula, searching a first data cooperation document corresponding to a document identification field in the storage address, selecting each first initial data entry corresponding to a header field in the first data cooperation document, and taking an area formed by combining each first initial data entry as a first selected area of the first data cooperation document.
Optionally, the data reference formula contains at least one data reference field, including: the data reference formula contains: a document address field, a document identification field, a header field and a screening field;
a region selection subunit, specifically configured to:
determining a storage address of the data collaboration document according to a document address field of a data reference formula, searching a second data collaboration document corresponding to a document identification field in the storage address, selecting each second initial data entry corresponding to a header field in the second data collaboration document, selecting at least one second data entry conforming to a screening field in each second initial data entry, and recombining and combining at least one second data entry to form a region as a second selected region of the second data collaboration document.
Optionally, the data reference formula contains at least one data reference field, including: the data reference formula contains: a document address field, a document identification field, a header field and a sorting field;
a region selection subunit, specifically configured to:
determining a storage address of the data cooperation document according to a document address field of a data reference formula, searching a third data cooperation document corresponding to a document identification field in the storage address, selecting each third initial data entry corresponding to a header field in the third data cooperation document, arranging the third initial data entries according to a sorting field sequence, and recombining and combining the arranged third initial data entries to form an area serving as a third selected area of the third data cooperation document.
Optionally, the data referencing apparatus provided by the present invention further includes: a judging unit configured to judge whether or not there is an access right for the data cooperation document before accessing the data cooperation document; and if so, executing the access operation on the data collaboration document.
Optionally, the data referencing means further comprises:
the callback parameter setting unit is used for setting callback parameters for the data collaboration document after the target data content is quoted to the target document;
the update notification unit is used for monitoring whether the target data content is updated or not by utilizing the callback parameter;
and sending an update notification to the target document when the target data content is monitored to be updated.
The data reference device provided by the invention determines the selected area in the data collaboration document according to the input instruction; acquiring corresponding target data content in the data collaboration document according to the selected area; and the target data content is referred to the target document, so that the data content of the data collaboration document is referred to other target documents without taking a cell as a unit.
Fig. 14 illustrates a physical structure diagram of an electronic device, and as shown in fig. 14, the electronic device may include: a processor (processor)1410, a communication Interface (Communications Interface)1420, a memory (memory)1430 and a communication bus 1440, wherein the processor 1410, the communication Interface 1420 and the memory 1430 communicate with each other via the communication bus 1440. The present invention provides an electronic device comprising a memory 1430, a processor 1410 and a computer program stored in the memory 1430 and executable on the processor 1410. Processor 1410 may invoke logic instructions in memory 1430 to perform a data referencing method comprising: determining a selected area of the data collaboration document according to the input instruction; acquiring target data content corresponding to the selected area of the data collaboration document according to the selected area; the target data content is referenced to the target document.
In addition, the logic instructions in the memory 1430 may be implemented in software functional units and stored in a computer readable storage medium when sold or used as a stand-alone product. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
In another aspect, the present invention also provides a computer program product comprising a computer program stored on a non-transitory computer-readable storage medium, the computer program comprising program instructions which, when executed by a computer, enable the computer to perform the data referencing method provided by the above methods, the method comprising: determining a selected area of the data collaboration document according to the input instruction; acquiring target data content corresponding to the selected area of the data collaboration document according to the selected area; the target data content is referenced to the target document.
In yet another aspect, the present invention also provides a computer-readable storage medium having stored thereon a computer program which, when executed by a processor, is implemented to perform the data referencing methods provided above, the method comprising: determining a selected area of the data collaboration document according to the input instruction; acquiring target data content corresponding to the selected area of the data collaboration document according to the selected area; the target data content is referenced to the target document.
The above-described embodiments of the apparatus are merely illustrative, and the units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment. One of ordinary skill in the art can understand and implement it without inventive effort.
Through the above description of the embodiments, those skilled in the art will clearly understand that each embodiment can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware. With this understanding in mind, the above-described technical solutions may be embodied in the form of a software product, which can be stored in a computer-readable storage medium such as ROM/RAM, magnetic disk, optical disk, etc., and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the methods described in the embodiments or some parts of the embodiments.
Finally, it should be noted that: the above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.
Claims (12)
1. A data referencing method, comprising:
determining a selected area of the data collaboration document according to the input instruction;
acquiring 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.
2. The data referencing method according to claim 1, wherein said determining a selected region of a data collaboration document based on an input instruction comprises:
generating a data reference formula according to the input instruction; wherein the data reference formula contains at least one data reference field;
and determining data items corresponding to the data reference fields according to the data reference fields, and taking the area formed by combining the data items as the selected area of the data collaboration document.
3. The data referencing method according to claim 2, wherein said generating a data referencing formula according to said input instruction comprises:
receiving click operation or input operation of a user through a user interface, and determining the generated data reference field;
in the case where the data reference field is plural,
generating the data reference formula with a plurality of data reference fields and logic;
or generating the data reference formula by using a plurality of data reference fields in OR logic;
alternatively, a plurality of data reference fields are combined with logic and or logic to generate the data reference formula.
4. The data referencing method according to claim 2, wherein said data referencing formula contains at least one data referencing field, comprising:
the data reference formula comprises: a document address field, a document identification field and a header field;
determining data items corresponding to the data reference fields according to the data reference fields, and taking the area formed by combining the data items as the selected area of the data collaboration document, wherein the method comprises the following steps:
determining a storage address of the data cooperation document according to a document address field of the data reference formula, searching a first data cooperation document corresponding to the document identification field in the storage address, selecting each first initial data entry corresponding to the header field in the first data cooperation document, and taking an area formed by combining each first initial data entry as a first selected area of the first data cooperation document.
5. The data referencing method according to claim 2, wherein said data referencing formula contains at least one data referencing field, comprising:
the data reference formula comprises: a document address field, a document identification field, a header field and a screening field;
determining data items corresponding to the data reference fields according to the data reference fields, and taking the area formed by combining the data items as the selected area of the data collaboration document, wherein the method comprises the following steps:
determining a storage address of the data collaboration document according to a document address field of the data reference formula, searching a second data collaboration document corresponding to the document identification 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 conforming to the screening field in each second initial data entry, and recombining and combining the at least one second data entry to form a region serving as a second selected region of the second data collaboration document.
6. The data referencing method according to claim 2, wherein said data referencing formula contains at least one data referencing field, comprising:
the data reference formula comprises: a document address field, a document identification field, a header field and a sorting field;
determining data items corresponding to the data reference fields according to the data reference fields, and taking the area formed by combining the data items as the selected area of the data collaboration document, wherein the method comprises the following steps:
determining a storage address of the data cooperation document according to a document address field of the data reference formula, searching a third data cooperation document corresponding to the document identification field in the storage address, selecting each third initial data entry corresponding to the header field in the third data cooperation document, arranging the third initial data entries according to the sorting field sequence, and recombining and combining the third initial data entries after the arrangement sequence to form an area as a third selected area of the third data cooperation document.
7. The data referencing method according to any one of claims 4 to 6, wherein before accessing the data collaboration document, said method further comprises:
determining whether there is access permission for the data collaboration document;
and if so, executing the access operation on the data collaboration document.
8. The data referencing method according to claim 1, wherein after said referencing of said target data content to a target document, said method further comprises:
setting a callback parameter for the data collaboration document;
monitoring whether the target data content is updated or not by utilizing the callback parameter;
and sending an update notification to the target document when the target data content is monitored to be updated.
9. The data referencing method according to any one of claims 1 to 6, wherein said data collaboration document is a data table for specifying data content;
the target document comprises any one of a data table, an online table and an electronic table.
10. A data referencing apparatus, comprising:
the first processing unit is used for determining a selected area of the data collaboration document according to an input instruction;
the second processing unit is used for acquiring target data content corresponding to the selected area of the data collaboration document according to the selected area;
and the third processing unit is used for referencing the target data content to a target document.
11. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the steps of the data referencing method according to any one of claims 1 to 9 when executing the program.
12. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the data referencing method according to any one of claims 1 to 9.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111589397.9A CN114417789A (en) | 2021-12-23 | 2021-12-23 | Data reference method and device, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111589397.9A CN114417789A (en) | 2021-12-23 | 2021-12-23 | Data reference method and device, electronic equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114417789A true CN114417789A (en) | 2022-04-29 |
Family
ID=81267712
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111589397.9A Pending CN114417789A (en) | 2021-12-23 | 2021-12-23 | Data reference method and device, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114417789A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2023217074A1 (en) * | 2022-05-11 | 2023-11-16 | 北京字跳网络技术有限公司 | Data block control method, apparatus and system, electronic device, and storage medium |
-
2021
- 2021-12-23 CN CN202111589397.9A patent/CN114417789A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2023217074A1 (en) * | 2022-05-11 | 2023-11-16 | 北京字跳网络技术有限公司 | Data block control method, apparatus and system, electronic device, and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| EP3549013B1 (en) | Spreadsheet-based software application development | |
| CN109614424B (en) | Page layout generation method, device, computing equipment and medium | |
| US8743122B2 (en) | Interactive visualization for exploring multi-modal, multi-relational, and multivariate graph data | |
| US9805015B2 (en) | System and method for enhanced user interactions with a grid | |
| KR101794373B1 (en) | Temporary formatting and charting of selected data | |
| CN109408764B (en) | Page area dividing method, device, computing equipment and medium | |
| EP4231137A1 (en) | Spreadsheet-based software application development | |
| US20210125144A1 (en) | Bill of material conversion method, electronic apparatus and non-transitory computer-readable storage medium | |
| CN110543303B (en) | Visual service platform | |
| US20220318310A1 (en) | Template-based faceted search experience | |
| CN112035708A (en) | Knowledge graph display method and device, computer device and readable storage medium | |
| CN114417789A (en) | Data reference method and device, electronic equipment and storage medium | |
| CN116401407A (en) | Node attribute configuration method, device, equipment and storage medium of mind map | |
| CN109033157B (en) | Complex data retrieval method and system based on user-defined search condition tree | |
| US10657152B2 (en) | Synchronization of diagrams and associated structured data | |
| CN114647735A (en) | Relation graph display method, medium and display device | |
| JP5352225B2 (en) | Data reuse method, data reuse system, data reuse device, and data reuse program | |
| CN106372121B (en) | Server and data processing method | |
| US9355376B2 (en) | Rules library for sales playbooks | |
| KR20230171986A (en) | Dynamic graphics containers | |
| CN113626030A (en) | Method and system for quickly building data visualization large screen | |
| CN113076716A (en) | Typesetting method and device for yearbook | |
| CN112785368A (en) | Label production method, management method, device and system | |
| CN112231802A (en) | Multi-window examination method and device of BIM file and computer storage medium | |
| CN110019035A (en) | A kind of method and system of graphical file management |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |