WO2023280145A1 - 信息引用方法、系统、装置和电子设备 - Google Patents

信息引用方法、系统、装置和电子设备 Download PDF

Info

Publication number
WO2023280145A1
WO2023280145A1 PCT/CN2022/103826 CN2022103826W WO2023280145A1 WO 2023280145 A1 WO2023280145 A1 WO 2023280145A1 CN 2022103826 W CN2022103826 W CN 2022103826W WO 2023280145 A1 WO2023280145 A1 WO 2023280145A1
Authority
WO
WIPO (PCT)
Prior art keywords
target
document
referenced
user
formula
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.)
Ceased
Application number
PCT/CN2022/103826
Other languages
English (en)
French (fr)
Inventor
骆铭涛
徐力
陈文健
温卓臻
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Zitiao Network Technology Co Ltd
Original Assignee
Beijing Zitiao Network Technology Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Beijing Zitiao Network Technology Co Ltd filed Critical Beijing Zitiao Network Technology Co Ltd
Publication of WO2023280145A1 publication Critical patent/WO2023280145A1/zh
Priority to US18/518,048 priority Critical patent/US20240086632A1/en
Anticipated expiration legal-status Critical
Ceased legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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 OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/103—Formatting, i.e. changing of presentation of documents
    • G06F40/106—Display of layout of documents; Previewing
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
    • G06F16/33—Querying
    • G06F16/3331—Query processing
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F21/60—Protecting data
    • G06F21/602—Providing cryptographic facilities or services
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F21/60—Protecting data
    • G06F21/64—Protecting data integrity, e.g. using checksums, certificates or signatures
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/103—Formatting, i.e. changing of presentation of documents
    • G06F40/117—Tagging; Marking up; Designating a block; Setting of attributes

Definitions

  • the embodiments of the present disclosure relate to the field of computer technology, and in particular to an information reference method, system, device and electronic equipment.
  • an embodiment of the present disclosure provides an information citation method, including: in response to creating a target formula, determining parameters of the target formula, wherein the target formula is used for citing content in a referenced document in a citing document, and the parameters include The identification of the referenced document and the identification of the referenced area; using the first target information to generate the identification token of the target formula, wherein the first target information includes the user identification of the target user, the identification of the referenced document, the identification of the referenced document and the reference The identification of the area, the target user is the user who created the target formula; receive the first verification result returned based on the second target information, where the second target information includes the identification token and the first target information; based on the first verification result, Information presentation in the referenced document.
  • an embodiment of the present disclosure provides an information citation method, including: determining the parameters of the target formula in response to creating the target formula, wherein the target formula is used to cite content in the referenced document in the citing document, and the parameters include The identification of the cited document and the identification of the referenced area; using the first target information to generate the identification token of the target formula, wherein the first target information includes the user identification of the target user, the identification of the reference document, the identification of the referenced document and the reference The identification of the area, the target user being the user who created the target formula; based on the identification token and the first target information, presenting the content of the referenced area in the reference document; in response to detecting an update instruction, obtaining the latest data referenced by the target formula, wherein, The update command is used to update the content of the reference area; use the latest data to update the content referenced by the target formula.
  • an embodiment of the present disclosure provides an information reference method, including: in response to receiving the identification token and target information of the target formula sent by the user terminal, using the identification token and target information of the target formula to update the target formula
  • the reference authority of the reference authority is verified to obtain the first verification result, wherein the target formula is used to reference the content in the referenced document in the reference document, and the target information includes the user ID of the target user, the ID of the referencing document, and the ID of the referenced document and the identification of the referenced area, the target user is the user who created the target formula; the first verification result is returned to the user terminal.
  • an embodiment of the present disclosure provides an information reference system, including: a user terminal, configured to determine parameters of a target formula in response to creating a target formula, generate an identification token of the target formula by using the first target information, and set Send the second target information to the server, receive the first verification result returned by the server, and perform information presentation in the reference document based on the first verification result, wherein the target formula is used to refer to the referenced document in the reference document Content, the parameters include the ID of the referenced document and the ID of the referenced area, the first target information includes the user ID of the target user, the ID of the referenced document, the ID of the referenced document, and the ID of the referenced area, and the target user is the user who created the target formula , the second target information includes an identification token and the first target information; the server is configured to, in response to receiving the second target information, use the second target information to verify the reference authority of the target formula to obtain the first verification result, Return the first verification result to the user terminal.
  • an embodiment of the present disclosure provides an information citation device, including: a determining unit, configured to determine parameters of a target formula in response to creating a target formula, wherein the target formula is used for citing a referenced document in a citing document The content, the parameters include the identification of the referenced document and the identification of the reference area; the generation unit is used to generate the identification token of the target formula by using the first target information, wherein the first target information includes the user ID of the target user, the reference document The identification of the referenced document and the identification of the referenced area, the target user is the user who created the target formula; the first receiving unit is configured to receive the first verification result returned based on the second target information, wherein the second target information The identification token and the first target information are included; the first presentation unit is configured to present information in the reference document based on the first verification result.
  • an embodiment of the present disclosure provides an information citation device, including: a determining unit, configured to determine parameters of a target formula in response to creating a target formula, wherein the target formula is used for referencing a referenced document in a citing document The content, the parameters include the identification of the referenced document and the identification of the reference area; the generation unit is used to generate the identification token of the target formula by using the first target information, wherein the first target information includes the user ID of the target user, the reference document The identification of the referenced document and the identification of the reference area, the target user is the user who creates the target formula; the presentation unit is used to present the content of the reference area in the reference document based on the identification token and the first target information; the acquisition unit , used to obtain the latest data referenced by the target formula in response to detecting an update command, wherein the update command is used to update the content of the reference area; the update unit is used to use the latest data to update the content referenced by the target formula .
  • an embodiment of the present disclosure provides an information reference device, including: a verification unit, configured to use the identification token and the target information of the target formula in response to receiving the target formula identification token and target information sent by the user terminal Target information, verifying the reference authority of the target formula to obtain the first verification result, wherein the target formula is used to quote the content in the referenced document in the referencing document, and the target information includes the user ID of the target user and the ID of the referencing document , an identifier of the referenced document and an identifier of the referenced area, the target user is the user who creates the target formula; a return unit, configured to return the first verification result to the user terminal.
  • a verification unit configured to use the identification token and the target information of the target formula in response to receiving the target formula identification token and target information sent by the user terminal Target information, verifying the reference authority of the target formula to obtain the first verification result, wherein the target formula is used to quote the content in the referenced document in the referencing document, and the target information includes the user ID of the target user and
  • an embodiment of the present disclosure provides an electronic device, including: one or more processors; a storage device for storing one or more programs, when the one or more programs are executed by the one or more executed by one or more processors, so that the one or more processors realize the information reference method described in the first aspect, the second aspect and the third aspect.
  • the embodiments of the present disclosure provide a computer-readable medium, on which a computer program is stored, and when the program is executed by a processor, the information reference method described in the first aspect, the second aspect and the third aspect is realized A step of.
  • FIG. 1 is an exemplary system architecture diagram in which various embodiments of the present disclosure can be applied;
  • FIG. 2 is a flowchart of an embodiment of an information reference method according to the present disclosure
  • Fig. 3 is a flowchart of an embodiment of updating reference content in the information reference method according to the present disclosure
  • FIG. 4 is a flow chart of an embodiment of viewing a target formula in an information reference method according to the present disclosure
  • Fig. 5 is a flowchart of another embodiment of an information reference method according to the present disclosure.
  • FIG. 6 is a flow chart of another embodiment of an information reference method according to the present disclosure.
  • Fig. 7 is a flow chart of another embodiment of updating reference content in the information reference method according to the present disclosure.
  • Fig. 8 is a flowchart of an embodiment of checking the viewing authority of the viewing user in the information reference method according to the present disclosure
  • Fig. 9 is a flowchart of an embodiment of revoking the citation authority of the target formula in the information citation method according to the present disclosure.
  • FIG. 10 is a sequence diagram of an embodiment of an information reference system according to the present disclosure.
  • Fig. 11 is a sequence diagram of an embodiment of updating reference content in the information reference system according to the present disclosure.
  • Fig. 12 is a sequence diagram of an embodiment of viewing target formulas in the information reference system according to the present disclosure.
  • Fig. 13 is a sequence diagram of an embodiment of revoking the citation authority of the target formula in the information citation system according to the present disclosure
  • Fig. 14 is a schematic structural diagram of an embodiment of an information reference device according to the present disclosure.
  • Fig. 15 is a schematic structural diagram of another embodiment of an information reference device according to the present disclosure.
  • Fig. 16 is a schematic structural diagram of another embodiment of an information reference device according to the present disclosure.
  • Fig. 17 is a structural schematic diagram of a computer system suitable for implementing the electronic device of the embodiment of the present disclosure.
  • the term “comprise” and its variations are open-ended, ie “including but not limited to”.
  • the term “based on” is “based at least in part on”.
  • the term “one embodiment” means “at least one embodiment”; the term “another embodiment” means “at least one further embodiment”; the term “some embodiments” means “at least some embodiments.” Relevant definitions of other terms will be given in the description below.
  • FIG. 1 illustrates an exemplary system architecture 100 to which embodiments of the information referencing method of the present disclosure may be applied.
  • the system architecture 100 may include terminal devices 1011 , 1012 , and 1013 , a network 102 and a server 103 .
  • the network 102 is used as a medium for providing communication links between the terminal devices 1011 , 1012 , 1013 and the server 103 .
  • Network 102 may include various connection types, such as wires, wireless communication links, or fiber optic cables, among others.
  • terminal devices 1011, 1012, 1013 Users can use terminal devices 1011, 1012, 1013 to interact with server 103 through network 102 to send or receive messages, etc.
  • terminal devices 1011, 1012, 1013 can send target formula identification tokens and target information to server 103.
  • Various communication client applications may be installed on the terminal devices 1011, 1012, and 1013, such as document editing applications, graphics editing applications, instant messaging software, and enterprise collaboration platforms.
  • the terminal devices 1011, 1012, and 1013 may respond to creating the target formula, and determine the parameters of the target formula; after that, they may use the target user's user ID, the ID of the referenced document, the ID of the referenced document, and the ID of the referenced area.
  • the first target information of the above-mentioned target formula is generated; then, the second target information including the above-mentioned identification token and the above-mentioned first target information can be sent to the server 103, and the first verification result returned by the server 103 can be received ;Finally, based on the above first verification result, information presentation may be performed in the above referenced document.
  • the terminal devices 1011, 1012, and 1013 may be hardware or software.
  • the terminal devices 1011, 1012, and 1013 When the terminal devices 1011, 1012, and 1013 are hardware, they may be various electronic devices with display screens and supporting information interaction, including but not limited to smart phones, tablet computers, and laptop computers.
  • the terminal devices 1011, 1012, 1013 When the terminal devices 1011, 1012, 1013 are software, they can be installed in the electronic devices listed above. It may be implemented as multiple software or software modules (for example, multiple software or software modules for providing distributed services), or as a single software or software module. No specific limitation is made here.
  • the server 103 may be a server that provides various services. For example, it may process the identification token and target information of the target formula sent by the terminal devices 1011, 1012, 1013, and send the obtained verification results to the servers of the terminal devices 1011, 1012, 1013.
  • the server 103 may first respond to receiving the identification token and target information of the target formula sent by the terminal device 1011, 1012, 1013, and use the identification token of the target formula and the target information to verify the reference authority of the target formula The first verification result is obtained; after that, the first verification result may be returned to the terminal devices 1011 , 1012 , and 1013 .
  • the server 103 may be hardware or software.
  • the server 103 can be implemented as a distributed server cluster composed of multiple servers, or as a single server.
  • the server 103 is software, it may be implemented as multiple software or software modules (for example, for providing distributed services), or as a single software or software module. No specific limitation is made here.
  • the information reference method provided by the embodiments of the present disclosure can be executed by the terminal devices 1011 , 1012 , and 1013 , and the information reference apparatus can be set in the terminal devices 1011 , 1012 , and 1013 .
  • the information reference method provided by the embodiment of the present disclosure can also be executed by the server 103 , and the information reference device can also be set in the server 103 .
  • terminal devices, networks and servers in Fig. 1 are only illustrative. According to the implementation needs, there can be any number of terminal devices, networks and servers.
  • the information quoting method is usually applied to a user terminal, and the information quoting method includes the following steps:
  • Step 201 in response to creating a target formula, determine parameters of the target formula.
  • the executing subject of the information reference method can detect whether the user has created a target formula in the document.
  • the above target formula can also be referred to as a cross-table reference formula, which can be used to refer to content in the referenced document in the referencing document.
  • the user can create the target formula in the following way: a cross-table reference selection panel can be presented in the document, and the user can select a document in the cross-table reference selection panel in the currently displayed document (reference document) as the referenced document, And select the area in the referenced document as the reference area, and then click the "Confirm" icon, and the target formula is created successfully.
  • the user can also create the target formula in the following way: the user can input the identifier (for example, url) of the referenced document and the range of the referenced area in the edit box of the target formula to create the target formula.
  • the identifier for example, url
  • the execution subject may determine the parameters of the target formula.
  • the above-mentioned parameters may include the identifier and the reference area of the above-mentioned referenced document.
  • the above execution subject can determine that the referenced document ID of the target formula is "xxx.com”, and the referenced area ID is "A1" this area.
  • the above execution subject can obtain the identifier of the referenced document from the cell A1 in the currently presented document, and obtain the referenced document from the currently presented document Get the ID of the referenced range in cell B1 in .
  • Step 202 using the first target information to generate an identification token of the target formula.
  • the execution subject may use the first target information to generate an identification token (token) of the target formula.
  • the identification token of the target formula is usually used to uniquely identify the target formula and can be represented as a string.
  • the above-mentioned first target information usually includes the user ID of the target user, the ID of the referenced document (currently presented document), the ID of the referenced document (data source document) and the ID of the referenced area.
  • the target user can create the above-mentioned The user of the target formula.
  • the above-mentioned execution subject can use a preset encryption algorithm (such as MD5 (MD5Message-Digest Algorithm, MD5 information digest algorithm) to encrypt the user identification of the above-mentioned target user, the identification of the above-mentioned cited document, the identification of the above-mentioned cited document and the above-mentioned
  • a preset encryption algorithm such as MD5 (MD5Message-Digest Algorithm, MD5 information digest algorithm) to encrypt the user identification of the above-mentioned target user, the identification of the above-mentioned cited document, the identification of the above-mentioned cited document and the above-mentioned
  • the identification of the referenced area is encrypted to obtain the identification token of the above target formula.
  • Step 203 receiving the first verification result returned based on the second target information.
  • the execution subject may receive the first verification result returned based on the second target information.
  • the above-mentioned second target information may include the above-mentioned identification token and the above-mentioned first target information.
  • Step 204 based on the first verification result, perform information presentation in the reference document.
  • the execution subject may present information in the referenced document based on the first verification result. If the above-mentioned first verification result indicates that the verification fails, the above-mentioned executive body may present the information of the verification failure in the above-mentioned reference document.
  • the above-mentioned information indicating that the verification failed may include an error code, and an error code corresponds to a reason for the verification failure. .
  • the execution subject may receive the first verification result returned based on the second target information in the following manner: the execution subject may send the second target information to the target server.
  • the above-mentioned target server may be a server that verifies the authority of the target formula, for example, it may be a server that verifies whether the user has the authority to cite the content of the reference area in the referenced document.
  • the target server may generate and return a first verification result based on the second target information.
  • the above-mentioned execution subject After the user performs an operation (action), the above-mentioned execution subject usually sends an operation instruction to the above-mentioned target server.
  • a setcell action editing a cell instruction
  • the above-mentioned second target information can be added to the operation instruction, and sent to the above target server.
  • the first verification result may include area content of the referenced area in the cited document.
  • the execution subject may present information in the cited document based on the first verification result in the following manner: if the first verification result indicates that the verification is successful, the execution subject may present the content of the area in the reference document.
  • the execution subject may detect whether the user performs the target operation on the target formula.
  • the above-mentioned target operation may include a modification operation or a deletion operation, that is, the above-mentioned execution subject may detect whether the user performs a modification operation or a deletion operation on the target formula. If it is detected that the user performs the above-mentioned target operation on the target formula, the above-mentioned execution subject may send a target instruction to the above-mentioned target server.
  • the above-mentioned target instruction may include a modification instruction or a deletion instruction for the target formula targeted by the above-mentioned target operation.
  • the execution subject may determine whether the permission withdrawal instruction sent by the target server is received.
  • the authority revocation instruction is usually sent to the execution subject after the target server receives the modification instruction or deletion instruction for the target formula sent by the user terminal.
  • the authority revoking instruction may include an identification token of the invalid target formula, and the authority revoking instruction is used to withdraw the reference authority of the invalid target formula. If the above permission withdrawal instruction is received, the execution subject can use the identification token of the invalid target formula in the above permission withdrawal instruction to withdraw the content referenced by the above invalid target formula in the currently presented document, that is, not in the current presentation The documentation for the above invalid target formula references. In this way, the identification token of the modified or deleted target formula becomes invalid and cannot be restored, which prevents illegal acquisition of data through the invalid identification token and ensures data security.
  • the above execution subject may present prompt information, and the above prompt information may be used to prompt to re-edit the above invalid target formula.
  • the reference authority of the formula is verified.
  • the second target information may also include a synchronization style identifier, which may be used to indicate whether to synchronize the style of the reference region when the content of the reference region is referenced in the reference document . If the synchronization style identifier is "1" or "T”, it may indicate that the style of the above-mentioned reference area is synchronized when the content of the above-mentioned reference area is referenced in the above-mentioned reference document. If the synchronization style identifier is "0" or "F”, it may indicate that the style of the above-mentioned reference area is not synchronized when the content of the above-mentioned reference area is referenced in the above-mentioned reference document.
  • a synchronization style identifier may be used to indicate whether to synchronize the style of the reference region when the content of the reference region is referenced in the reference document . If the synchronization style identifier is "1" or "T”, it may indicate that the style of the above-mentioned reference
  • the style of the above reference area may include but not limited to at least one of the following: the font of the reference area, the font size of the reference area, the font color of the reference area, the highlight color of the reference area, whether the reference area is bold, whether the reference area is Italics, underlining of references, paragraph formatting of references, and background color of references.
  • the above-mentioned first verification result may include a verification result indicating whether the above-mentioned target user has the right to cite the content in the referenced document. If it is verified that the target user has the authority to cite the content in the referenced document, the first verification result may be represented as 1 or T. If it is verified that the above-mentioned target user does not have the authority to quote the content in the referenced document, then the above-mentioned first verification result can be characterized as 0 or F.
  • the first verification result may further include a verification result of the validity of the first target information.
  • the above-mentioned first target information usually includes a user identifier of the target user, an identifier of the above-mentioned referenced document, an identifier of the above-mentioned referenced document, and an identifier of the above-mentioned referenced area.
  • the above-mentioned target server can verify the legitimacy of the above-mentioned first target information in the following way: the above-mentioned target server can check whether the identification of the above-mentioned referenced document exists, and can also check whether the reference area indicated by the identification of the above-mentioned reference area exceeds the above-mentioned The document area of the referenced document. If the identifier of the cited document exists and the reference area indicated by the identifier of the referenced area does not exceed the document area of the referenced document, it can be explained that the verification is successful. If the identifier of the referenced document does not exist or the reference area indicated by the identifier of the referenced area exceeds the document area of the referenced document, it may indicate that the verification fails.
  • the above-mentioned target formula may include a copy function, a table link, and an identification of the referenced area, wherein the above-mentioned copy function is used to copy the content in the referenced table to the reference table, and the above-mentioned table link is the above-mentioned The link to the referenced table.
  • the form of the above target formula can be IMPORTRANGE(String spreadsheet_url,String range_string,(Optional)Boolean if_sync_formatting), where the IMPORTRANGE function is a copy function, which can copy the contents of one table to another table, and spreadsheet_url usually refers to the table link , is the url (Uniform Resource Locator, Uniform Resource Locator) link of the data source table, range_string usually refers to the referenced area string, that is, the identification of the referenced area, if_sync_formatting usually refers to whether to synchronize the style, whether to synchronize the style
  • the parameter is an optional parameter.
  • Whether to synchronize the style indicates whether to synchronize the style of the referenced area when referencing the contents of the data source table in a table.
  • the style of the referenced area can include but not limited to at least one of the following: Font, font size of the quoted area, font color of the quoted area, highlight color of the quoted area, bold of the quoted area, italic of the quoted area, underline of the quoted area, paragraph format of the quoted area, and background color.
  • the above-mentioned reference document or referenced document may include one of a spreadsheet document, an online form document, or an online database form document.
  • a flow 300 of an embodiment of updating reference content in the information reference method according to the present disclosure is shown.
  • the method for updating reference content is usually applied to a user terminal, and the method for updating reference content includes the following steps:
  • Step 301 in response to detecting an update instruction, use the identification token of the target formula to be updated in the update instruction to acquire the latest data referenced by the target formula to be updated.
  • the execution subject of the information reference method may determine whether an update instruction is detected.
  • the update instruction above can be used to update the content referenced by the target formula in the currently presented document.
  • the above update instruction usually includes an identification token of the target formula to be updated.
  • the execution subject may use the identification token of the target formula to be updated in the update instruction to obtain the latest data referenced by the target formula to be updated from the target server.
  • the target server when a target formula is created, the target server usually maintains the reference relationship chain of the target formula (that is, the corresponding relationship between the referencing document and the referenced document).
  • the target server When the content in the reference area of the referenced document changes, the target server will usually obtain the content change notification, and find the document requiring content change as the document to be notified through the above reference relationship chain.
  • the target server may send an update instruction to the user terminal that opens the above-mentioned document to be notified.
  • Step 302 using the latest data to update the content referenced by the target formula to be updated in the currently presented document.
  • the execution subject can use the latest data to update the content referenced by the target formula to be updated in the currently presented document, so that the updated content of the reference area can be displayed in the currently presented document.
  • the method provided by the above embodiments of the present disclosure obtains the latest data to update the content of the reference area in the reference document when the content of the reference area in the referenced document changes, thereby ensuring real-time data update.
  • the update instruction may be generated in the following manner: in response to detecting that the current time is a preset time, the execution subject may generate the update instruction. If there is a target formula in the currently presented document, the above-mentioned executive body can set a timer, and if the current time is the set timing time, it can request the latest data of the target formula in the currently presented document to the above-mentioned target server, so that the data can be guaranteed Timeliness and effectiveness of updates.
  • a flow 400 of an embodiment of viewing target formulas in the information citation method according to the present disclosure is shown.
  • the method for viewing the target formula is usually applied to a user terminal, and the method for viewing the target formula includes the following steps:
  • Step 401 in response to detecting that the content referenced by the target formula in the currently presented document is viewed, obtain the user ID of the viewing user and the ID token of the viewed target formula.
  • the execution subject of the information reference method (for example, the terminal device shown in FIG. 1 ) can detect whether the user views the content referenced by the target formula in the currently presented document.
  • the execution subject detects that the user has opened a document and there is a target formula in the document, it may be determined that the user views content referenced by the target formula in the currently presented document.
  • the execution subject detects that the user browses the currently presented document and the browsed area is the area referenced by the target formula, it may be determined that the user views the content referenced by the target formula in the currently presented document.
  • the execution subject may obtain the user ID of the viewing user and the ID token of the viewed target formula.
  • Step 402 Send the user ID of the viewing user and the ID token of the viewed target formula to the target server, and receive the second verification result returned by the target server.
  • the execution subject may send the user ID of the viewing user and the ID token of the viewed target formula to the target server.
  • the above-mentioned target server can use the user ID of the above-mentioned viewing user and the identification token of the above-mentioned viewing target formula to verify whether the above-mentioned viewing user has the authority to view the content referenced by the above-mentioned viewing target formula.
  • the above-mentioned target server may use the identification token of the above-mentioned viewed target formula to query the set of user IDs of users who can view the referenced content of the above-mentioned viewed target formula. Then, it may be determined whether the user identification of the viewing user exists in the user identification set. If the user identification of the viewing user exists in the user identification set, the target server can determine that the viewing user has the right to view the content referenced by the target formula. At this time, the target server can generate a representation of the above View the verification results that the user has the right to view the content referenced by the target formula being viewed.
  • the target server may determine that the viewing user does not have the authority to view the content referenced by the target formula viewed above. At this time, the target server may generate A verification result that indicates that the above viewing user does not have the right to view the content referenced by the target formula being viewed.
  • the execution subject may receive the second verification result returned by the target server.
  • Step 403 based on the second verification result, perform information presentation in the currently presented document.
  • the execution subject may present information in the currently presented document based on the second verification result.
  • the above-mentioned second verification result indicates that the above-mentioned viewing user does not have the permission to view the content referenced by the target formula being viewed
  • the above-mentioned execution subject may present in the currently presented document a document indicating that the user does not have the viewing permission Information.
  • the method provided by the above-mentioned embodiments of the present disclosure checks the viewing authority of the viewing user for viewing the content referenced by the target formula, and presents information in the currently presented document based on the verification result, thereby ensuring data security sex.
  • the above-mentioned second verification result may include the above-mentioned viewing user's What the view's target formula refers to.
  • the execution subject may perform information presentation in the currently presented document based on the second verification result in the following manner: the execution subject may present the content referenced by the target formula viewed by the viewing user in the currently presented document.
  • the information quoting method is usually applied to a user terminal, and the information quoting method includes the following steps:
  • Step 501 in response to creating a target formula, determine parameters of the target formula.
  • the executing subject of the information reference method can detect whether the user has created a target formula in the document.
  • the above target formula can also be referred to as a cross-table reference formula, which can be used to refer to content in the referenced document in the referencing document.
  • the above target formula can be in the form of IMPORTRANGE(String spreadsheet_url,String range_string,(Optional)Boolean if_sync_formatting), where the IMPORTRANGE function can copy the contents of one table to another table, and spreadsheet_url usually refers to the url of the data source table Link, range_string usually refers to the referenced range string, if_sync_formatting usually refers to whether to synchronize the style, whether to synchronize the style is an optional parameter, whether to synchronize the style means to refer to the content in the data source table in a table Whether to synchronize the style of the reference area, the style of the reference area can include but not limited to at least one of the following: the font of the reference area, the font size of the reference area, the font color of the reference area, whether the highlight color of the reference area, the reference area Whether to bold, whether to italize the quoted area, whether to underline the quoted area, the paragraph format of the quoted area, and the background
  • the user can create the target formula in the following way: a cross-table reference selection panel can be presented in the document, and the user can select a document in the cross-table reference selection panel in the currently displayed document (reference document) as the referenced document, And select the area in the referenced document as the reference area, and then click the "Confirm" icon, and the target formula is created successfully.
  • the user can also create the target formula in the following manner: the user can input the identifier of the referenced document and the range of the referenced area in the edit box of the target formula to create the target formula.
  • the above-mentioned execution subject can determine the parameters of the target formula.
  • the above-mentioned parameters may include the identifier and the reference area of the above-mentioned referenced document.
  • the above execution subject can determine that the referenced document ID of the target formula is "xxx.com”, and the referenced area ID is "A1" this area.
  • the above execution subject can obtain the identifier of the referenced document from the cell A1 in the currently presented document, and obtain the referenced document from the currently presented document Get the ID of the referenced range in cell B1 in .
  • Step 502 using the first target information to generate an identification token of the target formula.
  • the execution subject may use the first target information to generate the identification token of the target formula.
  • the identification token of the target formula is usually used to uniquely identify the target formula and can be represented as a string.
  • the above-mentioned first target information usually includes the user ID of the target user, the ID of the referenced document (currently presented document), the ID of the referenced document (data source document) and the ID of the referenced area.
  • the target user can create the above-mentioned The user of the target formula.
  • the execution subject can use a preset encryption algorithm to encrypt the user ID of the target user, the ID of the referenced document, the ID of the referenced document, and the ID of the referenced area to obtain the ID token of the target formula .
  • Step 503 based on the identification token and the first target information, present the content of the reference area in the reference document.
  • the execution subject may present the content of the reference area in the reference document based on the identification token and the first target information.
  • the execution subject may receive the first verification result returned based on the identification token and the first target information.
  • the above-mentioned first verification result may include a verification result indicating whether the above-mentioned target user has the authority to cite the content in the referenced document. If it is verified that the target user has the authority to cite the content in the referenced document, the first verification result may be represented as 1 or T.
  • the first verification result may include the area content of the reference area in the referenced document, and the execution subject may present the area content in the reference document.
  • Step 504 in response to detecting the update instruction, acquire the latest data referenced by the target formula.
  • the execution subject may determine whether an update instruction is detected.
  • the above-mentioned update instruction may be used to update the content of the above-mentioned reference area.
  • the above execution subject may obtain the latest data referenced by the above target formula from the target server.
  • the target server when a target formula is created, the target server usually maintains the reference relationship chain of the target formula (that is, the corresponding relationship between the referencing document and the referenced document).
  • the target server When the content in the reference area of the referenced document changes, the target server will usually obtain the content change notification, and find the document requiring content change as the document to be notified through the above reference relationship chain.
  • the target server may send an update instruction to the user terminal that opens the above-mentioned document to be notified.
  • Step 505 using the latest data to update the content referenced by the target formula.
  • the execution subject may use the latest data to update the content referenced by the target formula, so that the updated content of the reference area may be displayed in the currently presented document.
  • the method provided by the above embodiments of the present disclosure updates the content of the reference area in the currently presented document by obtaining the latest data when the content of the reference area in the currently presented document changes, thereby ensuring real-time data update.
  • the information quoting method is usually applied to a server, and the information quoting method includes the following steps:
  • Step 601 in response to receiving the identification token and target information of the target formula sent by the user terminal, use the identification token and target information of the target formula to verify the reference authority of the target formula to obtain a first verification result.
  • the executing subject of the information reference method may determine whether the identification token and the target information of the target formula sent by the user terminal are received.
  • the above target formula can be used to refer to the content in the referenced document in the referencing document.
  • the identification token of the above target formula is usually used to uniquely identify the target formula and can be represented as a string.
  • the above-mentioned target information usually includes the user ID of the target user, the ID of the referenced document (currently presented document), the ID of the referenced document (data source document) and the ID of the referenced area.
  • the target user can create the target formula User.
  • the execution subject can use the identification token of the target formula and the target information to verify the reference authority of the target formula to obtain the first verification result.
  • Step 602 returning the first verification result to the user terminal.
  • the execution subject may return the first verification result obtained in step 601 to the user terminal.
  • the user terminal may present information in the referenced document based on the first verification result. If the above-mentioned first verification result indicates that the verification fails, the above-mentioned executive body may present the information of the verification failure in the above-mentioned reference document.
  • the above-mentioned information indicating that the verification failed may include an error code, and an error code corresponds to a reason for the verification failure. .
  • the method provided by the above-mentioned embodiments of the present disclosure uses the identification token and target information of the target formula sent by the user terminal to verify the reference authority of the target formula, and returns the verification result to the user terminal, so that the user terminal based on The received verification results are presented in the reference document, thus realizing a more concise and efficient cross-table reference implementation scheme.
  • the first verification result may include area content of the referenced area in the cited document.
  • the execution subject may associate and store the identification token of the target formula with the target information, that is, the identification token of the target formula, the user ID of the target user, the ID of the referenced document (currently presented document), the The five items of the identification of the reference document (data source document) and the identification of the referenced area are stored in association.
  • the target information may further include a synchronization style identifier, which may be used to indicate whether to synchronize the style of the reference region when the content of the reference region is referenced in the reference document. If the synchronization style identifier is "1" or "T”, it may indicate that the style of the above-mentioned reference area is synchronized when the content of the above-mentioned reference area is referenced in the above-mentioned reference document. If the synchronization style identifier is "0" or "F”, it may indicate that the style of the above-mentioned reference area is not synchronized when the content of the above-mentioned reference area is referenced in the above-mentioned reference document.
  • a synchronization style identifier may be used to indicate whether to synchronize the style of the reference region when the content of the reference region is referenced in the reference document. If the synchronization style identifier is "1" or "T”, it may indicate that the style of the above-mentioned reference area is
  • the style of the above reference area may include but not limited to at least one of the following: the font of the reference area, the font size of the reference area, the font color of the reference area, the highlight color of the reference area, whether the reference area is bold, whether the reference area is Italics, underlining of references, paragraph formatting of references, and background color of references.
  • the above-mentioned first verification result may include a verification result indicating whether the above-mentioned target user has the right to cite the content in the referenced document.
  • the execution subject may store a correspondence table of the corresponding relationship between the identifier of the document and the user identification of the user who has the reference authority to refer to the content of the document, and the execution subject may query the above-mentioned target in the correspondence table Whether there is a corresponding relationship between the user ID of the user and the ID of the referenced document. If there is a corresponding relationship, it can be determined that the above-mentioned target user has the authority to quote the content in the cited document.
  • the verification result, the first verification result may be represented as 1 or T. If there is no corresponding relationship, it can be determined that the above-mentioned target user does not have the authority to quote the content in the cited document.
  • the first verification result, the first verification result may be represented as 0 or F.
  • the first verification result may further include a verification result of the validity of the target information.
  • the above target information usually includes the user ID of the target user, the ID of the referenced document, the ID of the referenced document, and the ID of the referenced area.
  • the above-mentioned execution subject can verify the legality of the above-mentioned first target information in the following manner: the above-mentioned execution subject can verify whether the identification of the cited document exists, or check whether the reference area indicated by the identification of the above-mentioned reference area exceeds the above-mentioned The document area of the referenced document.
  • the identifier of the cited document exists and the reference area indicated by the identifier of the referenced area does not exceed the document area of the referenced document, it can be explained that the verification is successful. If the identifier of the referenced document does not exist or the reference area indicated by the identifier of the referenced area exceeds the document area of the referenced document, it may indicate that the verification fails.
  • the above-mentioned target formula may include a copy function, a table link, and an identification of the referenced area, wherein the above-mentioned copy function is used to copy the content in the referenced table to the reference table, and the above-mentioned table link is the above-mentioned The link to the referenced form.
  • the form of the above target formula can be IMPORTRANGE(String spreadsheet_url,String range_string,(Optional)Boolean if_sync_formatting), where the IMPORTRANGE function is a copy function, which can copy the contents of one table to another table, and spreadsheet_url usually refers to the table link , is the url (Uniform Resource Locator, Uniform Resource Locator) link of the data source table, range_string usually refers to the referenced area string, that is, the identification of the referenced area, if_sync_formatting usually refers to whether to synchronize the style, whether to synchronize the style
  • the parameter is an optional parameter.
  • Whether to synchronize the style indicates whether to synchronize the style of the referenced area when referencing the contents of the data source table in a table.
  • the style of the referenced area can include but not limited to at least one of the following: Font, font size of the quoted area, font color of the quoted area, highlight color of the quoted area, bold of the quoted area, italic of the quoted area, underline of the quoted area, paragraph format of the quoted area, and background color.
  • the above-mentioned reference document or referenced document may include one of an electronic form document, an online form document, or an online database form document.
  • FIG. 7 a flow 700 of another embodiment of updating reference content in the information reference method according to the present disclosure is shown.
  • the method for updating reference content is usually applied to a server, and the method for updating reference content includes the following steps:
  • Step 701 in response to receiving the modification instruction for the reference area sent by the user terminal, use the modified document identification and modification area in the modification instruction to query the corresponding identification of the document to be modified and the identification token of the target formula to be updated .
  • the execution subject of the information reference method may determine whether an instruction for modifying the reference area sent by the user terminal is received.
  • the execution subject When a target formula is created, the execution subject usually maintains the reference relationship chain of the target formula (that is, the corresponding relationship between the referencing document and the referenced document).
  • the execution subject When the content in the referenced area of the referenced document is changed, the execution subject will usually receive a modification instruction for the referenced area sent by the user terminal, and the modification instruction may include the identification of the modified document and the modified area.
  • the above-mentioned execution subject can use the ID of the modified document and the modification area in the above-mentioned modification instruction to query the corresponding ID of the document to be changed and the ID token of the target formula to be updated through the above-mentioned reference relationship chain.
  • Step 702 Using the identifier of the document to be changed, an update instruction is sent to the first target user terminal.
  • the execution subject may use the identifier of the document to be changed to send an update instruction to the first target user terminal.
  • the first target user terminal may be a user terminal whose currently presented document is the document to be changed indicated by the identifier of the document to be changed, and the update instruction includes the identification token of the target formula to be updated.
  • the above-mentioned first target user terminal After the above-mentioned first target user terminal receives the update instruction, it can use the identification token of the target formula to be updated in the above-mentioned update instruction to obtain the latest data referenced by the target formula to be updated from the above-mentioned execution subject; after that, the above-mentioned first A target user terminal can use the latest data to update the content referenced by the target formula to be updated in the currently presented document, so that the updated content of the reference area can be displayed in the currently presented document.
  • a flow 800 of an embodiment of checking the viewing authority of the viewing user in the information reference method according to the present disclosure is shown.
  • the method for verifying the viewing authority of the user is usually applied to the server, and the method for verifying the viewing authority of the user includes the following steps:
  • Step 801 in response to receiving the user ID of the viewer and the ID token of the target formula being viewed, perform verification using the user ID of the viewing user and the ID token of the target formula being viewed to obtain a second verification result.
  • the execution subject of the information reference method may determine whether the user ID of the viewing user and the identification token of the viewed target formula are received.
  • the above-mentioned user terminal can obtain the user ID of the viewing user and the identification token of the target formula being viewed, and the obtained viewing user The user ID of and the ID token of the viewed target formula are sent to the above execution subject.
  • the user terminal may determine that the user views content referenced by the target formula in the currently presented document.
  • the user terminal may determine the content of the user's reference to the target formula in the currently presented document to view.
  • the execution subject can use the user ID of the viewing user and the identification token of the target formula to be checked to obtain the second verification result.
  • the above-mentioned second verification result may represent whether the above-mentioned viewing user has the right to view the content referenced by the viewed target formula.
  • the execution subject may use the identification token of the viewed target formula to query the user identification set of users who can view the referenced content of the viewed target formula. Then, it may be determined whether the user identification of the viewing user exists in the user identification set. If the user ID of the above-mentioned viewing user exists in the above-mentioned user ID set, the above-mentioned execution subject can determine that the above-mentioned viewing user has the authority to view the content referenced by the above-mentioned target formula. View the verification results that the user has the right to view the content referenced by the target formula being viewed.
  • the execution subject may determine that the viewing user does not have the authority to view the content referenced by the target formula viewed above, and at this time, the execution subject may generate A verification result that indicates that the above viewing user does not have the right to view the content referenced by the target formula being viewed.
  • Step 802 returning the second verification result to the user terminal used by the viewing user.
  • the execution subject may return the second verification result to the user terminal used by the viewing user.
  • the user terminal may present information in the currently presented document based on the second verification result.
  • the user terminal may display a document indicating that the user does not have the viewing right in the currently presented document. Information.
  • the method provided by the above-mentioned embodiments of the present disclosure checks the viewing authority of the viewing user who views the content referenced by the target formula, and returns the verification result to the user terminal used by the viewing user, thereby ensuring the security of the data .
  • the above-mentioned second verification result may include the The content referenced by the target formula.
  • the above-mentioned user terminal may present information in the above-mentioned currently presented document based on the above-mentioned second verification result in the following manner: the above-mentioned user terminal may present in the above-mentioned currently presented document content referenced by the target formula viewed by the viewing user.
  • a flow 900 of an embodiment of revoking the citation authority of the target formula in the information citation method according to the present disclosure is shown.
  • the method for withdrawing the reference authority of the target formula is usually applied to the server, and the method for withdrawing the reference authority of the target formula includes the following steps:
  • Step 901 in response to receiving a target instruction for a target formula sent by a user terminal, set the identification token of the target formula targeted by the target instruction as invalid.
  • the execution subject of the information reference method may determine whether the target instruction for the target formula sent by the user terminal is received.
  • the above-mentioned target instruction may include a modification instruction or a deletion instruction.
  • the above-mentioned target instruction is usually generated by the above-mentioned user terminal detecting that the user performs a target operation on the target formula, and the above-mentioned target operation may include a modification operation or a deletion operation.
  • the execution subject may set the identification token of the target formula targeted by the target instruction as invalid.
  • Step 902 sending a permission withdrawal instruction to the second target user terminal.
  • the execution subject may send a permission withdrawal instruction to the second target user terminal.
  • the authority revoking instruction may include an identification token of the invalid target formula, and the authority revoking instruction is generally used to withdraw the reference authority of the invalid target formula.
  • the second target user terminal may be a user terminal whose currently presented document is the document where the invalid target formula is located.
  • the second target user terminal can use the identification token of the invalid target formula in the authority withdrawal instruction to reference the invalid target formula in the currently presented document. , that is, do not display the content referenced by the invalid target formula above in the currently rendered document.
  • the method provided by the above embodiments of the present disclosure can set the identification token of the target formula as invalid after receiving an instruction that the target formula is modified or deleted, and send the currently presented document to the document where the invalid target formula is located.
  • the user terminal sends a permission withdrawal instruction.
  • the identification token of the modified or deleted target formula becomes invalid and cannot be restored, which prevents illegal acquisition of data through the invalid identification token and ensures data security.
  • FIG. 10 a timing diagram of one embodiment of an information reference system according to the present disclosure is shown.
  • the information reference system in this embodiment includes: a user terminal and a server.
  • the user terminal is configured to determine the parameters of the target formula in response to creating the target formula, use the first target information to generate an identification token of the target formula, send the second target information to the server, and receive the first verification returned by the server.
  • information presentation is performed in the reference document, wherein the target formula is used to reference the content in the referenced document in the reference document, and the parameters include the identifier of the referenced document and the identifier of the referenced area, the first
  • the first target information includes the user ID of the target user, the ID of the referenced document, the ID of the referenced document, and the ID of the referenced area.
  • the target user is the user who created the target formula.
  • the second target information includes the identification token and the first target information.
  • a verification result includes a verification result indicating whether the target user has the authority to quote the content in the referenced document; the server is configured to use the second target information to quote the target formula in response to receiving the second target information The authority is verified to obtain a first verification result, and the first verification result is returned to the user terminal.
  • step 1001 the user terminal determines the parameters of the target formula in response to creating the target formula.
  • the user terminal can detect whether the user creates a target formula in the document.
  • the above target formula can also be referred to as a cross-table reference formula, which can be used to refer to content in the referenced document in the referencing document.
  • the above target formula can be in the form of IMPORTRANGE(String spreadsheet_url,String range_string,(Optional)Boolean if_sync_formatting), where the IMPORTRANGE function can copy the contents of one table to another table, and spreadsheet_url usually refers to the url of the data source table link, range_string usually refers to the referenced range string, if_sync_formatting usually refers to whether to synchronize the style, whether to synchronize the style is an optional parameter, whether to synchronize the style means to refer to the content in the data source table in a table Whether to synchronize the style of the reference area, the style of the reference area can include but not limited to at least one of the following: the font of the reference area, the
  • the user can create the target formula in the following way: a cross-table reference selection panel can be presented in the document, and the user can select a document in the cross-table reference selection panel in the currently displayed document (reference document) as the referenced document, And select the area in the referenced document as the reference area, and then click the "Confirm" icon, and the target formula is created successfully.
  • the user can also create the target formula in the following way: the user can input the identifier (for example, url) of the referenced document and the range of the referenced area in the edit box of the target formula to create the target formula.
  • the identifier for example, url
  • the user terminal may determine the parameters of the target formula.
  • the above-mentioned parameters may include the identifier and the reference area of the above-mentioned referenced document.
  • the user terminal can determine that the referenced document ID of the target formula is "xxx.com”, and the referenced area ID is "xxx.com”. A1" area.
  • the user terminal can obtain the identifier of the referenced document from the cell A1 in the currently presented document, and obtain the identifier of the referenced document from the currently presented document Get the ID of the referenced range in cell B1.
  • step 1002 the user terminal uses the first target information to generate an identification token of the target formula.
  • the user terminal may use the first goal information to generate the identification token of the above goal formula.
  • the identification token of the target formula is usually used to uniquely identify the target formula and can be represented as a string.
  • the above-mentioned first target information usually includes the user ID of the target user, the ID of the referenced document (currently presented document), the ID of the referenced document (data source document) and the ID of the referenced area.
  • the target user can create the above-mentioned The user of the target formula.
  • the user terminal may use a preset encryption algorithm to encrypt the user ID of the target user, the ID of the referenced document, the ID of the cited document, and the ID of the referenced area to obtain the identification token of the target formula.
  • step 1003 the user terminal sends the second target information to the server.
  • the user terminal may send the above-mentioned second target information to the server.
  • the above-mentioned second target information may include the above-mentioned identification token and the above-mentioned first target information.
  • the user terminal After the user performs an operation, the user terminal usually sends an operation instruction to the above-mentioned server.
  • the above-mentioned second target information can be added to the operation instruction and sent to the above-mentioned server.
  • step 1004 in response to receiving the second target information, the server uses the second target information to verify the reference authority of the target formula to obtain a first verification result.
  • the server may determine whether the second target information sent by the user terminal is received. If the identification token of the target formula and the first target information sent by the user terminal are received, the execution subject can use the identification token of the target formula and the first target information to verify the reference authority of the target formula to obtain The result of the first verification.
  • step 1005 the server returns the first verification result to the user terminal.
  • the server may return the first verification result obtained in step 1004 to the above-mentioned user terminal.
  • step 1006 the user terminal performs information presentation in the reference document based on the first verification result.
  • the user terminal may present information in the reference document based on the first verification result. If the first verification result indicates that the verification fails, the user terminal may present information indicating that the verification failed in the referenced document. For example, the information indicating that the verification failed may include an error code, and an error code corresponds to a reason for the verification failure.
  • the foregoing user terminal may determine whether an update instruction is detected.
  • the update instruction above can be used to update the content referenced by the target formula in the currently presented document.
  • the above update instruction usually includes an identification token of the target formula to be updated. If an update instruction is detected, the user terminal may use the identification token of the target formula to be updated in the update instruction to obtain the latest data referenced by the target formula to be updated from the server.
  • the server when a target formula is created, the server usually maintains a reference relationship chain of the target formula. When the content in the reference area of the referenced document changes, the above-mentioned server will usually obtain the content change notification, and find the document requiring content change as the document to be notified through the above-mentioned reference relationship chain.
  • the above-mentioned server may send an update instruction to the user terminal that opens the above-mentioned file to be notified.
  • the above-mentioned user terminal can use the above-mentioned latest data to update the content referenced by the target formula to be updated in the currently presented document, so that the updated content of the reference area can be displayed in the currently presented document.
  • the update instruction may be generated in the following manner: in response to detecting that the current time is a preset time, the user terminal may generate the update instruction. If there is a target formula in the currently presented document, the above-mentioned user terminal can set a timer, and if the current time is the set timing time, it can request the latest data of the target formula in the currently presented document to the above-mentioned server, thereby ensuring data update timeliness and effectiveness.
  • the first verification result may include area content of the referenced area in the cited document.
  • the above-mentioned user terminal may present information in the above-mentioned reference document based on the above-mentioned first verification result in the following manner: if the above-mentioned first verification result indicates that the verification is successful, the above-mentioned user terminal may present the above-mentioned area content in the above-mentioned reference document.
  • the second target information may also include a synchronization style identifier, which may be used to indicate whether to synchronize the style of the reference region when the content of the reference region is referenced in the reference document . If the synchronization style flag is "1" or "T”, it can indicate that the style of the above-mentioned reference area is synchronized when the content of the above-mentioned reference area is referenced in the above-mentioned reference document. If the synchronization style identifier is "0" or "F”, it may indicate that the style of the above-mentioned reference area is not synchronized when the content of the above-mentioned reference area is referenced in the above-mentioned reference document.
  • a synchronization style identifier may be used to indicate whether to synchronize the style of the reference region when the content of the reference region is referenced in the reference document .
  • the style of the above reference area may include but not limited to at least one of the following: the font of the reference area, the font size of the reference area, the font color of the reference area, the highlight color of the reference area, whether the reference area is bold, whether the reference area is Italics, underlining of references, paragraph formatting of references, and background color of references.
  • the first verification result may further include a verification result of the validity of the first target information.
  • the above-mentioned first target information usually includes a user identifier of the target user, an identifier of the above-mentioned referenced document, an identifier of the above-mentioned referenced document, and an identifier of the above-mentioned referenced area.
  • the above-mentioned server may check the legality of the above-mentioned first target information in the following manner: the above-mentioned server may check whether the identifier of the cited document exists, or check whether the reference area indicated by the identifier of the above-mentioned referenced area exceeds the above-mentioned referenced area.
  • the document area of the document If the identifier of the cited document exists and the reference area indicated by the identifier of the referenced area does not exceed the document area of the referenced document, it can be explained that the verification is successful. If the identifier of the referenced document does not exist or the reference area indicated by the identifier of the referenced area exceeds the document area of the referenced document, it may indicate that the verification fails.
  • the above-mentioned first verification result may include a verification result indicating whether the above-mentioned target user has the right to cite the content in the referenced document.
  • the server may store a corresponding relationship table between the identification of the document and the user identification of the user who has the reference authority to refer to the content of the document, and the server may query the user identification of the above-mentioned target user in the above-mentioned corresponding relationship table Whether there is a corresponding relationship with the identifier of the above-mentioned referenced document. If there is a corresponding relationship, it can be determined that the above-mentioned target user has the authority to quote the content in the cited document.
  • the verification result, the first verification result may be represented as 1 or T. If there is no corresponding relationship, it can be determined that the above-mentioned target user does not have the authority to quote the content in the cited document.
  • the first verification result, the first verification result may be represented as 0 or F.
  • the first verification result may include area content of the referenced area in the cited document.
  • the server may associate and store the identification token of the target formula with the target information, that is, the identification token of the target formula, the user ID of the target user, the ID of the referenced document (currently presented document), the referenced The five items of the identification of the document and the identification of the reference area mentioned above are stored in association.
  • the above-mentioned target formula may include a copy function, a table link, and an identification of the referenced area, wherein the above-mentioned copy function is used to copy the content in the referenced table to the reference table, and the above-mentioned table link is the above-mentioned The link to the referenced form.
  • the form of the above target formula can be IMPORTRANGE(String spreadsheet_url,String range_string,(Optional)Boolean if_sync_formatting), where the IMPORTRANGE function is a copy function, which can copy the contents of one table to another table, and spreadsheet_url usually refers to the table link , is the url (Uniform Resource Locator, Uniform Resource Locator) link of the data source table, range_string usually refers to the referenced area string, that is, the identification of the referenced area, if_sync_formatting usually refers to whether to synchronize the style, whether to synchronize the style
  • the parameter is an optional parameter.
  • Whether to synchronize the style indicates whether to synchronize the style of the referenced area when referencing the contents of the data source table in a table.
  • the style of the referenced area can include but not limited to at least one of the following: Font, font size of the quoted area, font color of the quoted area, highlight color of the quoted area, bold of the quoted area, italic of the quoted area, underline of the quoted area, paragraph format of the quoted area, and background color.
  • the above-mentioned reference document or referenced document may include one of an electronic form document, an online form document, or an online database form document.
  • FIG. 11 shows a sequence diagram of an embodiment of updating reference content in the information reference system according to the present disclosure.
  • the information reference system in this embodiment further includes: other user terminals, wherein the other user terminals include user terminals other than the above-mentioned user terminals.
  • the above-mentioned other user terminals are used to send to the server an instruction for changing the reference area in the referenced document.
  • step 1101 other user terminals send a modification instruction for the referenced area to the server.
  • other user terminals may send a modification instruction for the referenced area to the server.
  • a change instruction for the reference area may be sent to the server.
  • the above-mentioned change instruction may include the identification of the changed document and the changed area.
  • step 1102 in response to receiving the modification instruction for the referenced area, the server uses the modified document ID and the modified area in the modification instruction to query the corresponding identification of the document to be changed and the identification token of the target formula to be updated.
  • the server may determine whether an instruction for modifying the referenced area is received from another user terminal.
  • the execution subject When a target formula is created, the execution subject usually maintains the reference relationship chain of the target formula (that is, the corresponding relationship between the referencing document and the referenced document).
  • the server When the content in the reference area of the referenced document is changed, the server usually receives a change instruction for the reference area sent by the user terminal, and the above change instruction may include the identifier of the changed document and the change area. Afterwards, the server can use the ID of the modified document and the modification area in the above-mentioned modification instruction to query the corresponding ID of the document to be changed and the ID token of the target formula to be updated through the above-mentioned reference relationship chain.
  • step 1103 the server sends an update instruction to the user terminal by using the identifier of the document to be changed.
  • the server may use the identifier of the document to be changed to send an update instruction to the user terminal.
  • the document currently presented by the user terminal is the document to be changed indicated by the identifier of the document to be changed.
  • the server may also send the update instruction to other first target user terminals whose currently presented document is the document to be changed indicated by the identifier of the document to be changed.
  • the above-mentioned update instruction includes the identification token of the above-mentioned target formula to be updated.
  • step 1104 in response to detecting the update instruction, the user terminal uses the identification token of the target formula to be updated in the update instruction to obtain the latest data referenced by the target formula to be updated.
  • the user terminal may determine whether an update instruction is detected.
  • the above update instruction can be used to update the content referenced by the target formula in the currently presented document.
  • the above update instruction usually includes an identification token of the target formula to be updated.
  • the user terminal may use the identification token of the target formula to be updated in the update instruction to obtain the latest data referenced by the target formula to be updated from the server.
  • step 1105 the user terminal uses the latest data to update the content referenced by the target formula to be updated in the currently presented document.
  • the user terminal can use the latest data to update the content referenced by the target formula to be updated in the currently presented document, so that the updated content of the reference area can be displayed in the currently presented document.
  • the system provided by the above embodiments of the present disclosure obtains the latest data to update the content of the reference area in the reference document when the content of the reference area in the referenced document changes, thereby ensuring real-time data update.
  • FIG. 12 shows a sequence diagram of an embodiment of a viewing target formula in the information reference system according to the present disclosure.
  • the user terminal obtains the user ID of the viewing user and the identification token of the viewed target formula in response to detecting content referenced by the target formula in the currently presented document.
  • the user terminal can detect whether the user views the content referenced by the target formula in the currently presented document.
  • the user terminal detects that the user has opened a document and there is a target formula in the document, it may be determined that the user views content referenced by the target formula in the currently presented document.
  • the user terminal may determine that the user views the content referenced by the target formula in the currently presented document.
  • the user terminal may acquire the user ID of the viewing user and the ID token of the viewed target formula.
  • step 1202 the user terminal sends the user ID of the viewing user and the identification token of the viewed target formula to the server.
  • the user terminal may send the user ID of the viewing user and the identification token of the viewed target formula to the server.
  • step 1203 in response to receiving the user ID of the viewing user and the ID token of the target formula being viewed, the server performs verification using the user ID of the viewing user and the ID token of the target formula being viewed to obtain a second verification result.
  • the server may determine whether the user ID of the viewing user and the ID token of the viewed target formula are received. If the user ID of the viewing user and the ID token of the target formula being viewed are received, the server may use the user ID of the viewing user and the identification token of the target formula being checked to obtain a second verification result.
  • the above-mentioned second verification result may represent whether the above-mentioned viewing user has the right to view the content referenced by the viewed target formula.
  • the server may use the identification token of the viewed target formula to query the user identification set of users who can view the referenced content of the viewed target formula. Then, it may be determined whether the user identification of the viewing user exists in the user identification set. If the user ID of the above-mentioned viewing user exists in the above-mentioned user ID set, the server can determine that the above-mentioned viewing user has the right to view the content referenced by the above-mentioned target formula. The verification result of the authority to view the content referenced by the target formula being viewed.
  • the server may determine that the above-mentioned viewing user does not have the right to view the content referenced by the above-mentioned target formula. Validation results that do not have permission to view the content referenced by the target formula being viewed.
  • step 1204 the server returns the second verification result to the user terminal used by the viewing user.
  • the server may return the second verification result to the user terminal used by the viewing user.
  • step 1205 the user terminal presents information in the currently presented document based on the second verification result.
  • the user terminal may present information in the currently presented document based on the second verification result.
  • the user terminal may present in the currently presented document a document indicating that the user does not have the viewing permission. information.
  • the system provided by the above-mentioned embodiments of the present disclosure checks the viewing authority of the viewing user for viewing the content referenced by the target formula, and presents information in the currently presented document based on the verification result, thereby ensuring data security sex.
  • the above-mentioned second verification result may include the above-mentioned viewing user's What the view's target formula refers to.
  • the above-mentioned user terminal may present information in the above-mentioned currently presented document based on the above-mentioned second verification result in the following manner: the above-mentioned user terminal may present in the above-mentioned currently presented document content referenced by the target formula viewed by the viewing user.
  • FIG. 13 shows a sequence diagram of an embodiment of revoking the citation authority of the target formula in the information citation system according to the present disclosure.
  • step 1301 the user terminal sends a target instruction to the server in response to detecting that the user performs a target operation on the target formula.
  • the user terminal can detect whether the user performs the target operation on the target formula.
  • the above-mentioned target operation may include a modification operation or a deletion operation, that is, the user terminal may detect whether the user performs a modification operation or a deletion operation on the target formula. If it is detected that the user performs the above-mentioned target operation on the target formula, the user terminal may send a target instruction to the server.
  • the above-mentioned target instruction may include a modification instruction or a deletion instruction for the target formula targeted by the above-mentioned target operation.
  • step 1302 in response to receiving the target instruction, the server sets the identification token of the target formula targeted by the target instruction to invalid.
  • the server may determine whether the target instruction for the target formula sent by the user terminal is received. If the target instruction for the target formula sent by the above-mentioned user terminal is received, the server may set the identification token of the target formula targeted by the above-mentioned target instruction as invalid.
  • step 1303 the server sends a permission withdrawal instruction to the user terminal.
  • the server may send a permission withdrawal instruction to the above-mentioned user terminal.
  • the authority revoking instruction may include an identification token of the invalid target formula, and the authority revoking instruction is generally used to withdraw the reference authority of the invalid target formula.
  • the document currently presented on the user terminal is the document where the invalid target formula is located. It should be noted that, in addition to sending the permission revocation instruction to the user terminal, the server usually also needs to send a permission revocation instruction to other second target user terminals whose currently presented document is the document where the invalid target formula is located.
  • step 1304 in response to receiving the authority withdrawal instruction, the user terminal uses the identification token of the invalid target formula in the authority withdrawal instruction to withdraw the content referenced by the invalid target formula in the currently presented document.
  • the user terminal may determine whether to receive the permission withdrawal instruction sent by the server. If the above permission withdrawal instruction is received, the user terminal can use the identification token of the invalid target formula in the above permission withdrawal instruction to withdraw the content referenced by the above invalid target formula in the currently presented document, that is, it is not in the currently presented document.
  • the docs show what the invalid target formula referenced above.
  • the system provided by the above-mentioned embodiments of the present disclosure can set the identification token of the target formula as invalid after receiving an instruction that the target formula is modified or deleted, and send the currently presented document to the document where the invalid target formula is located.
  • the user terminal sends a permission withdrawal instruction.
  • the identification token of the modified or deleted target formula becomes invalid and cannot be restored, which prevents illegal acquisition of data through the invalid identification token and ensures data security.
  • the above-mentioned user terminal may present prompt information, and the above-mentioned prompt information can be used to prompt to re-review the above-mentioned invalid target formula.
  • the reference authority of the formula is verified.
  • the present disclosure provides an embodiment of an information reference device.
  • This device embodiment corresponds to the method embodiment shown in FIG. 2 , and the device can specifically be Used in various electronic equipment.
  • the information reference apparatus 1400 of this embodiment includes: a determining unit 1401 , a generating unit 1402 , a first receiving unit 1403 and a first presenting unit 1404 .
  • the determining unit 1401 is configured to determine parameters of the target formula in response to creating the target formula, wherein the target formula is used for citing content in the referenced document in the citing document, and the parameters include an identifier of the referenced document and an identifier of the referenced region;
  • the generating unit 1402 is configured to generate an identification token of the target formula by using the first target information, wherein the first target information includes the user ID of the target user, the ID of the referencing document, the ID of the referenced document, and the ID of the referenced area, and the target user For the user who creates the target formula;
  • the first receiving unit 1403 is configured to receive the first verification result returned based on the second target information, wherein the second target information includes an identification token and the first target information, and the first verification result includes A verification result representing whether
  • the specific processing of the determining unit 1401, the generating unit 1402, the first receiving unit 1403, and the first presenting unit 1404 of the information reference device 1400 can refer to step 201, step 202, and step 203 in the corresponding embodiment in FIG. and step 204 .
  • the information referencing apparatus 1400 may further include: a first acquiring unit (not shown in the figure) and an updating unit (not shown in the figure).
  • the above-mentioned first obtaining unit may be configured to use the identification token of the target formula to be updated in the above-mentioned update instruction to obtain the latest data referenced by the above-mentioned target formula to be updated in response to the detection of the update instruction, wherein the above-mentioned update instruction is used for The content referenced by the target formula in the currently presented document is updated; the update unit can be used to update the content referenced by the target formula to be updated in the currently presented document by using the latest data.
  • the update instruction may be generated in the following manner: an update instruction is generated in response to detecting that the current time is a preset time.
  • the first verification result indicates that the verification is successful
  • the first verification result includes the area content of the reference area in the cited document
  • the presentation unit 1404 can be further used to pass Based on the first verification result, information presentation is performed in the reference document in the following manner: present the content of the area in the reference document.
  • the first receiving unit 1403 may be further configured to receive the first verification result returned based on the second target information in the following manner: the first receiving unit 1403 may send the second target information to The target server, wherein the target server generates and returns a first verification result based on the second target information.
  • the information reference apparatus 1400 may further include: a second acquiring unit (not shown in the figure), a second receiving unit (not shown in the figure), and a second presentation unit (not shown in the figure). show).
  • the above-mentioned second obtaining unit may be configured to obtain the user identification of the viewing user and the identification token of the viewed target formula in response to detecting that the content referenced by the target formula in the currently presented document is checked;
  • the above-mentioned second receiving unit may It is used to send the user ID of the viewing user and the identification token of the target formula viewed to the target server, and receive the verification result returned by the target server as the second verification result, wherein the second verification result represents Checking whether the user has the right to view the content referenced by the target formula being viewed;
  • the second presentation unit may be configured to present information in the currently presented document based on the second verification result.
  • the above-mentioned second verification result indicates that the above-mentioned viewing user has the right to view the content referenced by the viewed target formula
  • the above-mentioned second verification result includes the target formula viewed by the above-mentioned viewing user The referenced content
  • the second presentation unit may be further configured to present information in the currently presented document based on the second verification result in the following manner: present in the currently presented document the information viewed by the viewing user The content referenced by the target formula.
  • the information reference apparatus 1400 may further include: a sending unit (not shown in the figure).
  • the sending unit may send a target instruction to the target server in response to detecting that the user performs a target operation on a target formula, wherein the target operation includes a modification operation or a deletion operation, and the target instruction includes a target formula for the target operation. Modify an order or delete an order.
  • the information referencing apparatus 1400 may further include: a revocation unit (not shown in the figure).
  • the withdrawal unit may, in response to receiving the permission withdrawal instruction, use the identification token of the invalid target formula in the permission withdrawal instruction to withdraw the content referenced by the invalid target formula in the currently presented document, wherein the permission withdrawal
  • the instruction includes the identification token of the above-mentioned invalid target formula, and the above-mentioned authority withdrawal instruction is used to withdraw the reference authority of the above-mentioned invalid target formula.
  • the information referencing apparatus 1400 may further include: a third presentation unit (not shown in the figure).
  • the third presentation unit may present prompt information, where the prompt information is used to prompt to re-verify the reference authority of the invalid target formula.
  • the second target information may further include a synchronization style identifier, and the synchronization style identifier is used to indicate whether to synchronize the style of the reference region when the content of the reference region is referenced in the reference document.
  • the above-mentioned first verification result may include a verification result indicating whether the above-mentioned target user has the right to cite the content in the referenced document.
  • the first verification result may further include a verification result of the validity of the first target information.
  • the above-mentioned target formula includes a copy function, a table link, and an identification of the referenced area, wherein the above-mentioned copy function is used to copy the content in the referenced table to the reference table, and the above-mentioned table link is the above-mentioned referenced table. Links to citation forms.
  • the above-mentioned reference document or referenced document may include one of an electronic form document, an online form document, or an online database form document.
  • the present disclosure provides another embodiment of an information reference device.
  • This device embodiment corresponds to the method embodiment shown in FIG. 5 , and the device specifically It can be applied to various electronic devices.
  • the information reference apparatus 1500 of this embodiment includes: a determination unit 1501 , a generation unit 1502 , a presentation unit 1503 , an acquisition unit 1504 and an update unit 1505 .
  • the determining unit 1501 is configured to determine parameters of the target formula in response to creating the target formula, wherein the target formula is used for quoting content in the referenced document in the citing document, and the parameters include the identifier of the referenced document and the identifier of the referenced area;
  • the generating unit 1502 is configured to generate an identification token of the target formula by using the first target information, wherein the first target information includes the user ID of the target user, the ID of the referencing document, the ID of the referenced document, and the ID of the referenced area, and the target user For the user who creates the target formula;
  • the presentation unit 1503 is used to present the content of the reference area in the reference document based on the identification token and the first target information;
  • the acquisition unit 1504 is used to obtain the latest referenced by the target formula in
  • the present disclosure provides another embodiment of an information reference device.
  • This device embodiment corresponds to the method embodiment shown in FIG. 6 , and the device specifically It can be applied to various electronic devices.
  • the information reference apparatus 1600 of this embodiment includes: a first checking unit 1601 and a first returning unit 1602 .
  • the first verification unit 1601 is configured to, in response to receiving the identification token and target information of the target formula sent by the user terminal, use the identification token and target information of the target formula to check the reference authority of the target formula to obtain the first A verification result, wherein, the target formula is used to quote the content in the referenced document in the referencing document, and the target information includes the user ID of the target user, the ID of the referencing document, the ID of the referenced document, and the ID of the referenced area, and the target user It is the user who creates the target formula; the first returning unit 1602 is used to return the first verification result to the user terminal.
  • step 501 and step 502 in the embodiment corresponding to FIG. 6 .
  • the information reference apparatus 1600 may include: a storage unit (not shown in the figure). If the first verification result indicates that the verification is successful, the first verification result includes the area content of the referenced area in the cited document.
  • the above-mentioned storage unit may be used for associating and storing the identification token of the above-mentioned target formula and the above-mentioned target information.
  • the information reference apparatus 1600 may include: a query unit (not shown in the figure) and a first sending unit (not shown in the figure).
  • the query unit may be configured to, in response to receiving a modification instruction for the reference area sent by the user terminal, query the corresponding identification of the document to be modified and the target to be updated by using the identification of the document to be modified and the modification area in the modification instruction.
  • the identification token of the formula; the above-mentioned first sending unit can be used to send an update instruction to the first target user terminal by using the identification of the above-mentioned document to be changed, wherein the document currently presented by the above-mentioned first target user terminal is the above-mentioned document to be changed
  • the user terminal of the above-mentioned updating instruction includes the identification token of the above-mentioned target formula to be updated.
  • the information referencing apparatus 1600 may include: a second checking unit (not shown in the figure) and a second returning unit (not shown in the figure).
  • the second verification unit may be configured to perform verification using the user identification of the viewing user and the identification token of the target formula viewed in response to receiving the user identification of the viewing user and the identification token of the target formula viewed A second verification result is obtained, wherein the second verification result indicates whether the viewing user has the authority to view the content referenced by the target formula being viewed; the second returning unit can be used to convert the second verification result to Return to the user terminal used by the above-mentioned viewing user.
  • the above-mentioned second verification result indicates that the above-mentioned viewing user has the right to view the content referenced by the viewed target formula
  • the above-mentioned second verification result includes the target formula viewed by the above-mentioned viewing user Quoted content.
  • the information reference apparatus 1600 may include: a setting unit (not shown in the figure) and a second sending unit (not shown in the figure).
  • the above-mentioned setting unit may be configured to set the identification token of the target formula targeted by the above-mentioned target instruction as invalid in response to receiving the target instruction for the target formula sent by the user terminal, wherein the above-mentioned target instruction includes a modification instruction or a deletion instruction;
  • the second sending unit may be configured to send an authority withdrawal instruction to the second target user terminal, wherein the authority withdrawal instruction includes an identification token of the invalid target formula, and the authority withdrawal instruction is used to refer to the invalid target formula For withdrawal, the second target user terminal is the user terminal whose document currently presented is the document where the invalid target formula is located.
  • the target information further includes a synchronization style identifier, and the synchronization style identifier is used to indicate whether to synchronize the style of the reference region when the content of the reference region is referenced in the reference document.
  • the above-mentioned first verification result may include a verification result indicating whether the above-mentioned target user has the right to cite the content in the referenced document.
  • the first verification result further includes a verification result of the validity of the target information.
  • the above-mentioned target formula includes a copy function, a table link, and an identification of the referenced area, wherein the above-mentioned copy function is used to copy the content in the referenced table to the reference table, and the above-mentioned table link is the above-mentioned referenced table. Links to citation forms.
  • the above-mentioned reference document or referenced document may include one of an electronic form document, an online form document, or an online database form document.
  • FIG. 17 it shows a schematic structural diagram of an electronic device (such as the server or terminal device in FIG. 1 ) 1700 suitable for implementing the embodiments of the present disclosure.
  • the terminal equipment in the embodiments of the present disclosure may include but not limited to mobile phones, notebook computers, digital broadcast receivers, PDAs (Personal Digital Assistants), PADs (Tablet Computers), PMPs (Portable Multimedia Players), vehicle-mounted terminals ( Mobile terminals such as car navigation terminals) and stationary terminals such as digital TVs, desktop computers and the like.
  • the electronic device shown in FIG. 17 is only an example, and should not limit the functions and scope of use of the embodiments of the present disclosure.
  • an electronic device 1700 may include a processing device (such as a central processing unit, a graphics processing unit, etc.) 1701, which may be randomly accessed according to a program stored in a read-only memory (ROM) 1702 or loaded from a storage device 1708.
  • a processing device such as a central processing unit, a graphics processing unit, etc.
  • RAM memory
  • various appropriate actions and processes are executed by programs in the memory (RAM) 1703 .
  • RAM 1703 various programs and data necessary for the operation of the electronic device 1700 are also stored.
  • the processing device 1701, ROM 1702, and RAM 1703 are connected to each other through a bus 1704.
  • An input/output (I/O) interface 1705 is also connected to the bus 1704 .
  • the following devices can be connected to the I/O interface 1705: input devices 1706 including, for example, a touch screen, touchpad, keyboard, mouse, camera, microphone, accelerometer, gyroscope, etc.; including, for example, a liquid crystal display (LCD), speaker, vibration an output device 1707 such as a computer; a storage device 1708 including, for example, a magnetic tape, a hard disk, etc.; and a communication device 1709.
  • the communication means 1709 may allow the electronic device 1700 to perform wireless or wired communication with other devices to exchange data. While FIG. 17 shows electronic device 1700 having various means, it is to be understood that implementing or having all of the means shown is not a requirement. More or fewer means may alternatively be implemented or provided. Each block shown in FIG. 17 may represent one device, or may represent multiple devices as required.
  • embodiments of the present disclosure include a computer program product, which includes a computer program carried on a computer-readable medium, where the computer program includes program codes for executing the methods shown in the flowcharts.
  • the computer program may be downloaded and installed from a network via communication means 1709, or from storage means 1708, or from ROM 1702.
  • the processing device 1701 When the computer program is executed by the processing device 1701, the above-mentioned functions defined in the methods of the embodiments of the present disclosure are performed.
  • the computer-readable medium described in the embodiments of the present disclosure may be a computer-readable signal medium or a computer-readable storage medium, or any combination of the above two.
  • a computer readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples of computer-readable storage media may include, but are not limited to, electrical connections with one or more wires, portable computer diskettes, hard disks, random access memory (RAM), read-only memory (ROM), erasable Programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage device, magnetic storage device, or any suitable combination of the above.
  • a computer-readable storage medium may be any tangible medium containing or storing a program that can be used by or in conjunction with an instruction execution system, apparatus, or device.
  • a computer-readable signal medium may include a data signal propagated in baseband or as part of a carrier wave, carrying computer-readable program code therein. Such propagated data signals may take many forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the foregoing.
  • a computer-readable signal medium may also be any computer-readable medium other than a computer-readable storage medium, which can transmit, propagate, or transmit a program for use by or in conjunction with an instruction execution system, apparatus, or device .
  • Program code embodied on a computer readable medium may be transmitted by any appropriate medium, including but not limited to wires, optical cables, RF (radio frequency), etc., or any suitable combination of the above.
  • the above-mentioned computer-readable medium may be included in the above-mentioned electronic device, or may exist independently without being incorporated into the electronic device.
  • the above-mentioned computer-readable medium carries one or more programs, and when the above-mentioned one or more programs are executed by the electronic device, the electronic device: in response to creating a target formula, determines parameters of the target formula, wherein the target formula is used for Citing the content in the referenced document in the citing document, the parameters include the identifier of the referenced document and the identifier of the referenced area; use the first target information to generate the identification token of the target formula, wherein the first target information includes the user of the target user ID, the ID of the referenced document, the ID of the referenced document, and the ID of the referenced area, the target user is the user who created the target formula; receive the first verification result returned based on the second target information, wherein the second target information includes the identification command The card and the first target information; based on the first verification result, information presentation
  • the electronic device is further caused to: determine the parameters of the target formula in response to creating the target formula, wherein the target formula is used for citing content in the referenced document in the citing document,
  • the parameters include the ID of the referenced document and the ID of the referenced area; using the first target information, an ID token of the target formula is generated, wherein the first target information includes the user ID of the target user, the ID of the referenced document, and the ID of the referenced document and the identification of the reference area, the target user is the user who created the target formula; based on the identification token and the first target information, present the content of the reference area in the reference document; in response to detecting an update instruction, obtain the latest data referenced by the target formula, Wherein, the update command is used to update the content of the reference area; the latest data is used to update the content referenced by the target formula.
  • the electronic device in response to receiving the identification token and target information of the target formula sent by the user terminal, using the identification token and target information of the target formula, to The citation authority of the target formula is verified to obtain the first verification result, wherein the target formula is used to cite the content in the referenced document in the citing document, and the target information includes the user ID of the target user, the ID of the citing document, and the referenced document and the reference area, and the target user is the user who created the target formula; the first verification result is returned to the user terminal.
  • Computer program code for carrying out operations of embodiments of the present disclosure may be written in one or more programming languages, or combinations thereof, including object-oriented programming languages—such as Java, Smalltalk, C++, Also included are conventional procedural programming languages - such as the "C" language or similar programming languages.
  • the program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server.
  • the remote computer can be connected to the user computer through any kind of network, including a local area network (LAN) or a wide area network (WAN), or it can be connected to an external computer (for example, using an Internet service provider to connected via the Internet).
  • LAN local area network
  • WAN wide area network
  • Internet service provider for example, using an Internet service provider to connected via the Internet.
  • each block in a flowchart or block diagram may represent a module, program segment, or portion of code that contains one or more logical functions for implementing specified executable instructions.
  • the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or they may sometimes be executed in the reverse order, depending upon the functionality involved.
  • each block of the block diagrams and/or flowchart illustrations, and combinations of blocks in the block diagrams and/or flowchart illustrations can be implemented by a dedicated hardware-based system that performs the specified functions or operations , or may be implemented by a combination of dedicated hardware and computer instructions.
  • the units involved in the embodiments described in the present disclosure may be implemented by software or by hardware.
  • the described units can also be set in a processor, for example, it can be described as: a processor includes a determining unit, a generating unit, a first receiving unit, and a first presentation unit, and it can also be described as: a processor includes a first A verification unit and a first return unit.
  • a processor includes a first A verification unit and a first return unit.
  • the names of these units do not constitute a limitation on the unit itself under certain circumstances, for example, the first presentation unit can also be described as “a unit that presents information in the referenced document based on the first verification result” .

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Physics & Mathematics (AREA)
  • Health & Medical Sciences (AREA)
  • General Health & Medical Sciences (AREA)
  • Computational Linguistics (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Artificial Intelligence (AREA)
  • Computer Security & Cryptography (AREA)
  • Bioethics (AREA)
  • Computer Hardware Design (AREA)
  • Software Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Document Processing Apparatus (AREA)

Abstract

本公开实施例公开了信息引用方法、系统、装置和电子设备。方法的一具体实施方式包括：响应于创建目标公式，确定目标公式的参数（201）；利用第一目标信息，生成目标公式的标识令牌（202），其中，第一目标信息包括目标用户的用户标识、引用文档的标识、被引用文档的标识和引用区域的标识，目标用户为创建目标公式的用户；接收基于第二目标信息返回的第一校验结果（203），其中，第二目标信息包括标识令牌和第一目标信息；基于第一校验结果，在引用文档中进行信息呈现（204）。

Description

信息引用方法、系统、装置和电子设备
相关申请的交叉引用
本公开要求于2021年7月6日提交的申请号为202110765142.7、发明名称为“信息引用方法、系统、装置和电子设备”的中国专利申请的优先权，其至少部分内容通过引用结合在本公开中。
技术领域
本公开实施例涉及计算机技术领域，具体涉及信息引用方法、系统、装置和电子设备。
背景技术
在线电子表格中，用户经常需要复制一个数据源表格中的内容再将其粘贴到引用该数据源的其他表格中，当数据源表格发生更改时，用户需要再次针对数据源执行复制粘贴操作以更新其他数据。这会导致数据更新不及时，重复劳动等不友好的用户体验。因此，如何能方便地引用数据源，并在数据源变动时实时更新其他表格是一个亟待解决的问题。
发明内容
提供该公开内容部分以便以简要的形式介绍构思，这些构思将在后面的具体实施方式部分被详细描述。该公开内容部分并不旨在标识要求保护的技术方案的关键特征或必要特征，也不旨在用于限制所要求的保护的技术方案的范围。
第一方面，本公开实施例提供了一种信息引用方法，包括：响应于创建目标公式，确定目标公式的参数，其中，目标公式用于在引用文档中引用被引用文档中的内容，参数包括被引用文档的标识和引用区域的标识；利用第一目标信息，生成目标公式的标识令牌，其中， 第一目标信息包括目标用户的用户标识、引用文档的标识、被引用文档的标识和引用区域的标识，目标用户为创建目标公式的用户；接收基于第二目标信息返回的第一校验结果，其中，第二目标信息包括标识令牌和第一目标信息；基于第一校验结果，在引用文档中进行信息呈现。
第二方面，本公开实施例提供了一种信息引用方法，包括：响应于创建目标公式，确定目标公式的参数，其中，目标公式用于在引用文档中引用被引用文档中的内容，参数包括被引用文档的标识和引用区域的标识；利用第一目标信息，生成目标公式的标识令牌，其中，第一目标信息包括目标用户的用户标识、引用文档的标识、被引用文档的标识和引用区域的标识，目标用户为创建目标公式的用户；基于标识令牌和第一目标信息，在引用文档中呈现引用区域的内容；响应于检测到更新指令，获取目标公式引用的最新数据，其中，更新指令用于对引用区域的内容进行更新；利用最新数据，对目标公式所引用的内容进行更新。
第三方面，本公开实施例提供了一种信息引用方法，包括：响应于接收到用户终端发送的目标公式的标识令牌和目标信息，利用目标公式的标识令牌和目标信息，对目标公式的引用权限进行校验得到第一校验结果，其中，目标公式用于在引用文档中引用被引用文档中的内容，目标信息包括目标用户的用户标识、引用文档的标识、被引用文档的标识和引用区域的标识，目标用户为创建目标公式的用户；将第一校验结果返回给用户终端。
第四方面，本公开实施例提供了一种信息引用系统，包括：用户终端，用于响应于创建目标公式，确定目标公式的参数，利用第一目标信息，生成目标公式的标识令牌，将第二目标信息发送给服务器，接收服务器返回的第一校验结果，以及基于第一校验结果，在引用文档中进行信息呈现，其中，目标公式用于在引用文档中引用被引用文档中的内容，参数包括被引用文档的标识和引用区域的标识，第一目标信息包括目标用户的用户标识、引用文档的标识、被引用文档的标识和引用区域的标识，目标用户为创建目标公式的用户，第二目标信 息包括标识令牌和第一目标信息；服务器，用于响应于接收到第二目标信息，利用第二目标信息，对目标公式的引用权限进行校验得到第一校验结果，将第一校验结果返回给用户终端。
第五方面，本公开实施例提供了一种信息引用装置，包括：确定单元，用于响应于创建目标公式，确定目标公式的参数，其中，目标公式用于在引用文档中引用被引用文档中的内容，参数包括被引用文档的标识和引用区域的标识；生成单元，用于利用第一目标信息，生成目标公式的标识令牌，其中，第一目标信息包括目标用户的用户标识、引用文档的标识、被引用文档的标识和引用区域的标识，目标用户为创建目标公式的用户；第一接收单元，用于接收基于第二目标信息返回的第一校验结果，其中，第二目标信息包括标识令牌和第一目标信息；第一呈现单元，用于基于第一校验结果，在引用文档中进行信息呈现。
第六方面，本公开实施例提供了一种信息引用装置，包括：确定单元，用于响应于创建目标公式，确定目标公式的参数，其中，目标公式用于在引用文档中引用被引用文档中的内容，参数包括被引用文档的标识和引用区域的标识；生成单元，用于利用第一目标信息，生成目标公式的标识令牌，其中，第一目标信息包括目标用户的用户标识、引用文档的标识、被引用文档的标识和引用区域的标识，目标用户为创建目标公式的用户；呈现单元，用于基于标识令牌和第一目标信息，在引用文档中呈现引用区域的内容；获取单元，用于响应于检测到更新指令，获取目标公式引用的最新数据，其中，更新指令用于对引用区域的内容进行更新；更新单元，用于利用最新数据，对目标公式所引用的内容进行更新。
第七方面，本公开实施例提供了一种信息引用装置，包括：校验单元，用于响应于接收到用户终端发送的目标公式的标识令牌和目标信息，利用目标公式的标识令牌和目标信息，对目标公式的引用权限进行校验得到第一校验结果，其中，目标公式用于在引用文档中引用被引用文档中的内容，目标信息包括目标用户的用户标识、引用文档的标识、被引用文档的标识和引用区域的标识，目标用户为创建目标 公式的用户；返回单元，用于将第一校验结果返回给用户终端。
第八方面，本公开实施例提供了一种电子设备，包括：一个或多个处理器；存储装置，用于存储一个或多个程序，当所述一个或多个程序被所述一个或多个处理器执行，使得所述一个或多个处理器实现如第一方面、第二方面和第三方面所述的信息引用方法。
第九方面，本公开实施例提供了一种计算机可读介质，其上存储有计算机程序，该程序被处理器执行时实现如第一方面、第二方面和第三方面所述的信息引用方法的步骤。
附图说明
结合附图并参考以下具体实施方式，本公开各实施例的上述和其他特征、优点及方面将变得更加明显。贯穿附图中，相同或相似的附图标记表示相同或相似的元素。应当理解附图是示意性的，原件和元素不一定按照比例绘制。
图1是本公开的各个实施例可以应用于其中的示例性系统架构图；
图2是根据本公开的信息引用方法的一个实施例的流程图；
图3是根据本公开的信息引用方法中更新引用内容的一个实施例的流程图；
图4是根据本公开的信息引用方法中查看目标公式的一个实施例的流程图；
图5是根据本公开的信息引用方法的又一个实施例的流程图；
图6是根据本公开的信息引用方法的另一个实施例的流程图；
图7是根据本公开的信息引用方法中更新引用内容的又一个实施例的流程图；
图8是根据本公开的信息引用方法中校验查看用户的查看权限的一个实施例的流程图；
图9是根据本公开的信息引用方法中撤回目标公式的引用权限的一个实施例的流程图；
图10是根据本公开的信息引用系统的一个实施例的时序图；
图11是根据本公开的信息引用系统中更新引用内容的一个实施例的时序图；
图12是根据本公开的信息引用系统中查看目标公式的一个实施例的时序图；
图13是根据本公开的信息引用系统中撤回目标公式的引用权限的一个实施例的时序图；
图14是根据本公开的信息引用装置的一个实施例的结构示意图；
图15是根据本公开的信息引用装置的又一个实施例的结构示意图；
图16是根据本公开的信息引用装置的另一个实施例的结构示意图；
图17是适于用来实现本公开实施例的电子设备的计算机系统的结构示意图。
具体实施方式
下面将参照附图更详细地描述本公开的实施例。虽然附图中显示了本公开的某些实施例，然而应当理解的是，本公开可以通过各种形式来实现，而且不应该被解释为限于这里阐述的实施例，相反提供这些实施例是为了更加透彻和完整地理解本公开。应当理解的是，本公开的附图及实施例仅用于示例性作用，并非用于限制本公开的保护范围。
应当理解，本公开的方法实施方式中记载的各个步骤可以按照不同的顺序执行，和/或并行执行。此外，方法实施方式可以包括附加的步骤和/或省略执行示出的步骤。本公开的范围在此方面不受限制。
本文使用的术语“包括”及其变形是开放性包括，即“包括但不限于”。术语“基于”是“至少部分地基于”。术语“一个实施例”表示“至少一个实施例”；术语“另一实施例”表示“至少一个另外的实施例”；术语“一些实施例”表示“至少一些实施例”。其他术语的相关定义将在下文描述中给出。
需要注意，本公开中提及的“第一”、“第二”等概念仅用于对不同 的装置、模块或单元进行区分，并非用于限定这些装置、模块或单元所执行的功能的顺序或者相互依存关系。
需要注意，本公开中提及的“一个”、“多个”的修饰是示意性而非限制性的，本领域技术人员应当理解，除非在上下文另有明确指出，否则应该理解为“一个或多个”。
本公开实施方式中的多个装置之间所交互的消息或者信息的名称仅用于说明性的目的，而并不是用于对这些消息或信息的范围进行限制。
图1示出了可以应用本公开的信息引用方法的实施例的示例性系统架构100。
如图1所示，系统架构100可以包括终端设备1011、1012、1013，网络102和服务器103。网络102用以在终端设备1011、1012、1013和服务器103之间提供通信链路的介质。网络102可以包括各种连接类型，例如有线、无线通信链路或者光纤电缆等等。
用户可以使用终端设备1011、1012、1013通过网络102与服务器103交互，以发送或接收消息等，例如，终端设备1011、1012、1013可以向服务器103发送目标公式的标识令牌和目标信息。终端设备1011、1012、1013上可以安装有各种通讯客户端应用，例如文档编辑类应用、图形编辑类应用、即时通讯软件和企业协作平台。
终端设备1011、1012、1013可以响应于创建目标公式，确定上述目标公式的参数；之后，可以利用包括目标用户的用户标识、上述引用文档的标识、上述被引用文档的标识和上述引用区域的标识的第一目标信息，生成上述目标公式的标识令牌；而后，可以将包括上述标识令牌和上述第一目标信息的第二目标信息发送给服务器103，接收服务器103返回的第一校验结果；最后，可以基于上述第一校验结果，在上述引用文档中进行信息呈现。
终端设备1011、1012、1013可以是硬件，也可以是软件。当终端设备1011、1012、1013为硬件时，可以是具有显示屏并且支持信息交互的各种电子设备，包括但不限于智能手机、平板电脑、膝上型便携计算机等。当终端设备1011、1012、1013为软件时，可以安装在上述 所列举的电子设备中。其可以实现成多个软件或软件模块(例如用来提供分布式服务的多个软件或软件模块)，也可以实现成单个软件或软件模块。在此不做具体限定。
服务器103可以是提供各种服务的服务器。例如，可以是对终端设备1011、1012、1013发送的目标公式的标识令牌和目标信息进行处理，将得到的校验结果发送给终端设备1011、1012、1013的服务器。服务器103可以首先响应于接收到终端设备1011、1012、1013发送的目标公式的标识令牌和目标信息，利用上述目标公式的标识令牌和上述目标信息，对上述目标公式的引用权限进行校验得到第一校验结果；之后，可以将上述第一校验结果返回给终端设备1011、1012、1013。
需要说明的是，服务器103可以是硬件，也可以是软件。当服务器103为硬件时，可以实现成多个服务器组成的分布式服务器集群，也可以实现成单个服务器。当服务器103为软件时，可以实现成多个软件或软件模块(例如用来提供分布式服务)，也可以实现成单个软件或软件模块。在此不做具体限定。
还需要说明的是，本公开实施例所提供的信息引用方法可以由终端设备1011、1012、1013执行，则信息引用装置可以设置于终端设备1011、1012、1013中。本公开实施例所提供的信息引用方法也可以由服务器103执行，则信息引用装置也可以设置于服务器103中。
应该理解，图1中的终端设备、网络和服务器的数目仅仅是示意性的。根据实现需要，可以具有任意数目的终端设备、网络和服务器。
继续参考图2，示出了根据本公开的信息引用方法的一个实施例的流程200。该信息引用方法通常应用于用户终端，该信息引用方法包括以下步骤：
步骤201，响应于创建目标公式，确定目标公式的参数。
在本实施例中，信息引用方法的执行主体(例如图1所示的终端设备)可以检测用户是否在文档中创建目标公式。上述目标公式也可以称为跨表引用公式，可以用于在引用文档中引用被引用文档中的内容。
作为一种示例，用户可以通过如下方式创建目标公式：文档中可 以呈现跨表引用选择面板，用户可以在当前显示的文档(引用文档)中的跨表引用选择面板中选择文档作为被引用文档，以及选择被引用文档中的区域作为引用区域，之后，点击“确认”图标，此时目标公式创建成功。
作为另一种示例，用户还可以通过如下方式创建目标公式：用户可以在目标公式的编辑框中输入被引用文档的标识(例如，url)和引用区域的范围，以创建目标公式。
之后，若检测到创建目标公式，上述执行主体可以确定目标公式的参数。上述参数可以包括上述被引用文档的标识和引用区域。
作为一种示例，若创建的目标公式为IMPORTRANGE(“xxx.com”，“A1”)，则上述执行主体可以确定目标公式的被引用文档的标识为“xxx.com”，引用区域的标识为“A1”这一区域。
作为另一种示例，若创建的目标公式为IMPORTRANGE(A1，B1)，则上述执行主体可以从当前呈现的文档中的A1这一单元格中获取被引用文档的标识，以及从当前呈现的文档中的B1这一单元格中获取引用区域的标识。
步骤202，利用第一目标信息，生成目标公式的标识令牌。
在本实施例中，上述执行主体可以利用第一目标信息，生成上述目标公式的标识令牌(token)。目标公式的标识令牌通常用于唯一标识目标公式，可以表征为字符串。上述第一目标信息通常包括目标用户的用户标识、上述引用文档(当前呈现的文档)的标识、上述被引用文档(数据源文档)的标识和上述引用区域的标识，上述目标用户可以为创建上述目标公式的用户。
在这里，上述执行主体可以利用预设的加密算法(如，MD5(MD5Message-Digest Algorithm，MD5信息摘要算法)对上述目标用户的用户标识、上述引用文档的标识、上述被引用文档的标识和上述引用区域的标识进行加密，得到上述目标公式的标识令牌。
步骤203，接收基于第二目标信息返回的第一校验结果。
在本实施例中，上述执行主体可以接收基于第二目标信息返回的第一校验结果。在这里，上述第二目标信息可以包括上述标识令牌和 上述第一目标信息。
步骤204，基于第一校验结果，在引用文档中进行信息呈现。
在本实施例中，上述执行主体可以基于上述第一校验结果，在上述引用文档中进行信息呈现。若上述第一校验结果表征验证失败，则上述执行主体可以在上述引用文档中呈现验证失败的信息，例如，上述表征验证失败的信息可以包括错误码，一种错误码对应一种验证失败原因。
本公开的上述实施例提供的方法通过这种创建文档之间信息引用关系的方式，相比于用户执行从一个文档复制内容粘贴到另一个文档中的操作，实现了一种更加简洁高效的跨表引用实现方案。
在一些可选的实现方式中，上述执行主体可以通过如下方式接收基于第二目标信息返回的第一校验结果：上述执行主体可以将第二目标信息发送给目标服务器。上述目标服务器可以是针对目标公式进行权限验证的服务器，例如，可以是对用户是否具有对被引用文档中的引用区域的内容进行引用的权限进行验证的服务器。上述目标服务器可以基于上述第二目标信息，生成以及返回第一校验结果。用户执行一个操作(action)之后，上述执行主体通常会向上述目标服务器发送操作指令，在这里，用户执行setcell action(编辑单元格指令)之后，可以将上述第二目标信息添加到操作指令，并发送给上述目标服务器。
在一些可选的实现方式中，若上述第一校验结果表征校验成功，则上述第一校验结果可以包括上述被引用文档中上述引用区域的区域内容。上述执行主体可以通过如下方式基于上述第一校验结果，在上述引用文档中进行信息呈现：若上述第一校验结果表征校验成功，上述执行主体可以在上述引用文档中呈现上述区域内容。
在一些可选的实现方式中，上述执行主体可以检测用户是否针对目标公式执行目标操作。上述目标操作可以包括修改操作或删除操作，即上述执行主体可以检测用户是否针对目标公式执行修改操作或者删除操作。若检测到用户针对目标公式执行上述目标操作，上述执行主体可以向上述目标服务器发送目标指令。上述目标指令可以包括对上述目标操作所针对的目标公式的修改指令或删除指令。
在一些可选的实现方式中，上述执行主体可以确定是否接收到上述目标服务器发送的权限撤回指令。在这里，上述权限撤回指令通常是上述目标服务器接收到用户终端发送的针对目标公式的修改指令或删除指令之后向上述执行主体发送的。上述权限撤回指令可以包括失效的目标公式的标识令牌，上述权限撤回指令用于对上述失效的目标公式的引用权限进行撤回。若接收到上述权限撤回指令，则上述执行主体可以利用上述权限撤回指令中失效的目标公式的标识令牌，对当前呈现的文档中上述失效的目标公式所引用的内容进行撤回，即不在当前呈现的文档中展示上述失效的目标公式所引用的内容。通过这种方式使得修改或删除的目标公式的标识令牌失效且无法再被恢复，可以防止通过失效的标识令牌非法获取数据，保证了数据的安全性。
在一些可选的实现方式中，在对当前呈现的文档中上述失效的目标公式所引用的内容进行撤回之后，上述执行主体可以呈现提示信息，上述提示信息可以用于提示重新对上述失效的目标公式的引用权限进行校验。
在一些可选的实现方式中，上述第二目标信息还可以包括同步样式标识，上述同步样式标识可以用于表征在上述引用文档中引用上述引用区域的内容时是否对上述引用区域的样式进行同步。若同步样式标识为“1”或“T”，则可以表征在上述引用文档中引用上述引用区域的内容时对上述引用区域的样式进行同步。若同步样式标识为“0”或“F”，则可以表征在上述引用文档中引用上述引用区域的内容时不对上述引用区域的样式进行同步。上述引用区域的样式可以包括但不限于以下至少一项：引用区域的字体、引用区域的字号、引用区域的字体颜色、引用区域的是否突出显示颜色、引用区域的是否加粗、引用区域的是否倾斜、引用区域的是否添加下划线、引用区域的段落格式和引用区域的背景颜色。
在一些可选的实现方式中，上述第一校验结果可以包括表征上述目标用户是否具有对被引用文档中的内容进行引用的权限的校验结果。若校验出上述目标用户具有对被引用文档中的内容进行引用的权限，则上述第一检验结果可以表征为1或者T。若校验出上述目标用 户不具有对被引用文档中的内容进行引用的权限，则上述第一检验结果可以表征为0或者F。
在一些可选的实现方式中，上述第一校验结果还可以包括对上述第一目标信息的合法性的校验结果。上述第一目标信息通常包括目标用户的用户标识、上述引用文档的标识、上述被引用文档的标识和上述引用区域的标识。上述目标服务器可以通过如下方式校验上述第一目标信息的合法性：上述目标服务器可以校验上述被引用文档的标识是否存在，也可以校验上述引用区域的标识所指示的引用区域是否超出上述被引用文档的文档区域。若上述被引用文档的标识存在且上述引用区域的标识所指示的引用区域未超出上述被引用文档的文档区域，则可以说明校验成功。若上述被引用文档的标识不存在或者上述引用区域的标识所指示的引用区域超出上述被引用文档的文档区域，则可以说明校验失败。
在一些可选的实现方式中，上述目标公式可以包括复制函数、表格链接和引用区域的标识，其中，上述复制函数用于将被引用表格中的内容复制到引用表格中，上述表格链接为上述被引用表格的链接。上述目标公式的形式可以是IMPORTRANGE(String spreadsheet_url,String range_string,(Optional)Boolean if_sync_formatting)，其中，IMPORTRANGE函数为复制函数，可以将一个表格中的内容复制到另一个表格中，spreadsheet_url通常指的表格链接，是数据源表格的url(Uniform Resource Locator，统一资源定位器)链接，range_string通常指的是引用的区域字符串，即引用区域的标识，if_sync_formatting通常指的是是否同步样式，是否同步样式这一参数是可选参数，是否同步样式表示的是在一个表格中引用数据源表格中的内容时是否对引用区域的样式进行同步，引用区域的样式可以包括但不限于以下至少一项：引用区域的字体、引用区域的字号、引用区域的字体颜色、引用区域的是否突出显示颜色、引用区域的是否加粗、引用区域的是否倾斜、引用区域的是否添加下划线、引用区域的段落格式和引用区域的背景颜色。
在一些可选的实现方式中，上述引用文档或被引用文档可以包括 电子表格文档、在线表格文档、或在线数据库表格文档中的一种。
继续参考图3，示出了根据本公开的信息引用方法中更新引用内容的一个实施例的流程300。该更新引用内容的方法通常应用于用户终端，该更新引用内容的方法，包括以下步骤：
步骤301，响应于检测到更新指令，利用更新指令中的待更新的目标公式的标识令牌，获取待更新的目标公式引用的最新数据。
在本实施例中，信息引用方法的执行主体(例如图1所示的终端设备)可以确定是否检测到更新指令。上述更新指令可以用于对当前呈现的文档中目标公式所引用的内容进行更新。上述更新指令中通常包括待更新的目标公式的标识令牌。
若检测到更新指令，上述执行主体可以利用上述更新指令中的待更新的目标公式的标识令牌，从目标服务器中获取待更新的目标公式引用的最新数据。
在这里，当一个目标公式被创建时，目标服务器中通常会维护目标公式的引用关系链(即引用文档与被引用文档之间的对应关系)。当被引用文档的引用区域中的内容发生变更时，目标服务器通常会获取到内容变更通知，并通过上述引用关系链查找到需要进行内容变更的文档作为待通知文档。目标服务器可以向打开上述待通知文档的用户终端发送更新指令。
步骤302，利用最新数据，对当前呈现的文档中待更新的目标公式所引用的内容进行更新。
在本实施例中，上述执行主体可以利用上述最新数据，对当前呈现的文档中待更新的目标公式所引用的内容进行更新，从而可以在当前呈现的文档中展示引用区域更新后的内容。
本公开的上述实施例提供的方法通过在被引用文档中的引用区域的内容发生变更时，获取最新数据对引用文档中的引用区域的内容进行更新，从而保证数据实时更新。
在一些可选的实现方式中，上述更新指令可以是通过如下方式生成的：响应于检测到当前时间为预设时间，上述执行主体可以生成更新指令。若当前呈现的文档中存在目标公式，上述执行主体可以设置 定时器，若当前时间为设置的定时时间时，可以向上述目标服务器请求当前呈现的文档中的目标公式的最新数据，从而可以保证数据更新地及时性和有效性。
继续参考图4，示出了根据本公开的信息引用方法中查看目标公式的一个实施例的流程400。该查看目标公式的方法通常应用于用户终端，该查看目标公式的方法，包括以下步骤：
步骤401，响应于检测到对当前呈现的文档中的目标公式引用的内容进行查看，获取查看用户的用户标识和所查看的目标公式的标识令牌。
在本实施例中，信息引用方法的执行主体(例如图1所示的终端设备)可以检测用户是否对当前呈现的文档中的目标公式引用的内容进行查看。
作为一种示例，若上述执行主体检测到用户打开了一个文档且该文档中存在目标公式，则可以确定用户对当前呈现的文档中的目标公式引用的内容进行查看。
作为另一种示例，若上述执行主体检测到用户对当前呈现的文档进行浏览且浏览的区域为目标公式引用的区域，则可以确定用户对当前呈现的文档中的目标公式引用的内容进行查看。
若检测到对当前呈现的文档中的目标公式引用的内容进行查看，则上述执行主体可以获取查看用户的用户标识和所查看的目标公式的标识令牌。
需要说明的是，若将检测到用户打开了一个文档且该文档中存在目标公式，判定为用户对当前呈现的文档中的目标公式引用的内容进行查看，上述执行主体可以获取打开的文档中的所有目标公式的标识令牌。
步骤402，向目标服务器发送查看用户的用户标识和所查看的目标公式的标识令牌，接收目标服务器返回的第二校验结果。
在本实施例中，上述执行主体可以向目标服务器发送查看用户的用户标识和所查看的目标公式的标识令牌。上述目标服务器可以利用上述查看用户的用户标识和上述所查看的目标公式的标识令牌，校验 上述查看用户是否具有对上述所查看的目标公式引用的内容进行查看的权限。
具体地，上述目标服务器可以利用上述所查看的目标公式的标识令牌查询可以对上述所查看的目标公式的所引用的内容进行查看的用户的用户标识集合。而后，可以确定上述查看用户的用户标识是否存在于上述用户标识集合中。若上述查看用户的用户标识存在于上述用户标识集合中，则上述目标服务器可以确定上述查看用户具有对上述所查看的目标公式引用的内容进行查看的权限，此时，上述目标服务器可以生成表征上述查看用户具有对所查看的目标公式引用的内容进行查看的权限的校验结果。若上述查看用户的用户标识不存在于上述用户标识集合中，则上述目标服务器可以确定上述查看用户不具有对上述所查看的目标公式引用的内容进行查看的权限，此时，上述目标服务器可以生成表征上述查看用户不具有对所查看的目标公式引用的内容进行查看的权限的校验结果。
之后，上述执行主体可以接收上述目标服务器返回的第二校验结果。
步骤403，基于第二校验结果，在当前呈现的文档中进行信息呈现。
在本实施例中，上述执行主体可以基于上述第二校验结果，在当前呈现的文档中进行信息呈现。在这里，若上述第二校验结果表征上述查看用户不具有对所查看的目标公式引用的内容进行查看的权限，则上述执行主体可以在当前呈现的文档中呈现用于表征用户不具有查看权限的信息。
本公开的上述实施例提供的方法通过对查看目标公式所引用的内容的查看用户的查看权限进行校验，并基于校验结果，在当前呈现的文档中进行信息呈现，从而保证了数据的安全性。
在一些可选的实现方式中，若上述第二校验结果表征上述查看用户具有对所查看的目标公式引用的内容进行查看的权限，此时，上述第二校验结果可以包括上述查看用户所查看的目标公式引用的内容。上述执行主体可以通过如下方式基于上述第二校验结果，在上述当前 呈现的文档中进行信息呈现：上述执行主体可以在上述当前呈现的文档中呈现上述查看用户所查看的目标公式引用的内容。
进一步参考图5，示出了根据本公开的信息引用方法的又一个实施例的流程500。该信息引用方法通常应用于用户终端，该信息引用方法包括以下步骤：
步骤501，响应于创建目标公式，确定目标公式的参数。
在本实施例中，信息引用方法的执行主体(例如图1所示的终端设备)可以检测用户是否在文档中创建目标公式。上述目标公式也可以称为跨表引用公式，可以用于在引用文档中引用被引用文档中的内容。上述目标公式的形式可以是IMPORTRANGE(String spreadsheet_url,String range_string,(Optional)Boolean if_sync_formatting)，其中，IMPORTRANGE函数可以将一个表格中的内容复制到另一个表格中，spreadsheet_url通常指的是数据源表格的url链接，range_string通常指的是引用的区域字符串，if_sync_formatting通常指的是是否同步样式，是否同步样式这一参数是可选参数，是否同步样式表示的是在一个表格中引用数据源表格中的内容时是否对引用区域的样式进行同步，引用区域的样式可以包括但不限于以下至少一项：引用区域的字体、引用区域的字号、引用区域的字体颜色、引用区域的是否突出显示颜色、引用区域的是否加粗、引用区域的是否倾斜、引用区域的是否添加下划线、引用区域的段落格式和引用区域的背景颜色。
作为一种示例，用户可以通过如下方式创建目标公式：文档中可以呈现跨表引用选择面板，用户可以在当前显示的文档(引用文档)中的跨表引用选择面板中选择文档作为被引用文档，以及选择被引用文档中的区域作为引用区域，之后，点击“确认”图标，此时目标公式创建成功。
作为另一种示例，用户还可以通过如下方式创建目标公式：用户可以在目标公式的编辑框中输入被引用文档的标识和引用区域的范围，以创建目标公式。
之后，若检测到创建目标公式，上述执行主体可以确定目标公式 的参数。上述参数可以包括上述被引用文档的标识和引用区域。
作为一种示例，若创建的目标公式为IMPORTRANGE(“xxx.com”，“A1”)，则上述执行主体可以确定目标公式的被引用文档的标识为“xxx.com”，引用区域的标识为“A1”这一区域。
作为另一种示例，若创建的目标公式为IMPORTRANGE(A1，B1)，则上述执行主体可以从当前呈现的文档中的A1这一单元格中获取被引用文档的标识，以及从当前呈现的文档中的B1这一单元格中获取引用区域的标识。
步骤502，利用第一目标信息，生成目标公式的标识令牌。
在本实施例中，上述执行主体可以利用第一目标信息，生成上述目标公式的标识令牌。目标公式的标识令牌通常用于唯一标识目标公式，可以表征为字符串。上述第一目标信息通常包括目标用户的用户标识、上述引用文档(当前呈现的文档)的标识、上述被引用文档(数据源文档)的标识和上述引用区域的标识，上述目标用户可以为创建上述目标公式的用户。
在这里，上述执行主体可以利用预设的加密算法对上述目标用户的用户标识、上述引用文档的标识、上述被引用文档的标识和上述引用区域的标识进行加密，得到上述目标公式的标识令牌。
步骤503，基于标识令牌和第一目标信息，在引用文档中呈现引用区域的内容。
在本实施例中，上述执行主体可以基于上述标识令牌和上述第一目标信息，在上述引用文档中呈现上述引用区域的内容。
在这里，上述执行主体可以接收基于上述标识令牌和上述第一目标信息返回的第一校验结果。在这里，上述第一校验结果可以包括表征上述目标用户是否具有对被引用文档中的内容进行引用的权限的校验结果。若校验出上述目标用户具有对被引用文档中的内容进行引用的权限，则上述第一检验结果可以表征为1或者T。
若上述第一校验结果表征校验成功，则上述第一校验结果可以包括上述被引用文档中上述引用区域的区域内容，上述执行主体可以在上述引用文档中呈现上述区域内容。
步骤504，响应于检测到更新指令，获取目标公式引用的最新数据。
在本实施例中，上述执行主体可以确定是否检测到更新指令。上述更新指令可以用于对上述引用区域的内容进行更新。
若检测到更新指令，上述执行主体可以从目标服务器中获取上述目标公式引用的最新数据。
在这里，当一个目标公式被创建时，目标服务器中通常会维护目标公式的引用关系链(即引用文档与被引用文档之间的对应关系)。当被引用文档的引用区域中的内容发生变更时，目标服务器通常会获取到内容变更通知，并通过上述引用关系链查找到需要进行内容变更的文档作为待通知文档。目标服务器可以向打开上述待通知文档的用户终端发送更新指令。
步骤505，利用最新数据，对目标公式所引用的内容进行更新。
在本实施例中，上述执行主体可以利用上述最新数据，对上述目标公式所引用的内容进行更新，从而可以在当前呈现的文档中展示上述引用区域更新后的内容。
本公开的上述实施例提供的方法通过在当前呈现的文档中的引用区域的内容发生变更时，获取最新数据对当前呈现的文档中的引用区域的内容进行更新，从而保证数据实时更新。
进一步参考图6，示出了根据本公开的信息引用方法的另一个实施例的流程600。该信息引用方法通常应用于服务器，该信息引用方法包括以下步骤：
步骤601，响应于接收到用户终端发送的目标公式的标识令牌和目标信息，利用目标公式的标识令牌和目标信息，对目标公式的引用权限进行校验得到第一校验结果。
在本实施例中，信息引用方法的执行主体(例如图1所示的服务器)可以确定是否接收到用户终端发送的目标公式的标识令牌和目标信息。上述目标公式可以用于在引用文档中引用被引用文档中的内容。上述目标公式的标识令牌通常用于唯一标识目标公式，可以表征为字符串。上述目标信息通常包括目标用户的用户标识、上述引用文档(当 前呈现的文档)的标识、上述被引用文档(数据源文档)的标识和上述引用区域的标识，上述目标用户可以为创建上述目标公式的用户。
若接收到上述用户终端发送的目标公式的标识令牌和目标信息，则上述执行主体可以利用上述目标公式的标识令牌和上述目标信息，对目标公式的引用权限进行校验得到第一校验结果。
步骤602，将第一校验结果返回给用户终端。
在本实施例中，上述执行主体可以将在步骤601中得到的第一校验结果返回给上述用户终端。在接收到上述第一校验结果之后，上述用户终端可以基于上述第一校验结果，在上述引用文档中进行信息呈现。若上述第一校验结果表征验证失败，则上述执行主体可以在上述引用文档中呈现验证失败的信息，例如，上述表征验证失败的信息可以包括错误码，一种错误码对应一种验证失败原因。
本公开的上述实施例提供的方法通过利用用户终端发送的目标公式的标识令牌和目标信息，对目标公式的引用权限进行校验，并将校验结果返回给用户终端，以使得用户终端基于接收到的校验结果，在引用文档中进行信息呈现，从而实现了一种更加简洁高效的跨表引用实现方案。
在一些可选的实现方式中，若上述第一校验结果表征校验成功，上述第一校验结果可以包括上述被引用文档中上述引用区域的区域内容。上述执行主体可以将上述目标公式的标识令牌与上述目标信息进行关联存储，即将上述目标公式的标识令牌、上述目标用户的用户标识、上述引用文档(当前呈现的文档)的标识、上述被引用文档(数据源文档)的标识和上述引用区域的标识这五项进行关联存储。
在一些可选的实现方式中，上述目标信息还可以包括同步样式标识，上述同步样式标识可以用于表征在上述引用文档中引用上述引用区域的内容时是否对上述引用区域的样式进行同步。若同步样式标识为“1”或“T”，则可以表征在上述引用文档中引用上述引用区域的内容时对上述引用区域的样式进行同步。若同步样式标识为“0”或“F”，则可以表征在上述引用文档中引用上述引用区域的内容时不对上述引用区域的样式进行同步。上述引用区域的样式可以包括但不限于以下 至少一项：引用区域的字体、引用区域的字号、引用区域的字体颜色、引用区域的是否突出显示颜色、引用区域的是否加粗、引用区域的是否倾斜、引用区域的是否添加下划线、引用区域的段落格式和引用区域的背景颜色。
在一些可选的实现方式中，上述第一校验结果可以包括表征上述目标用户是否具有对被引用文档中的内容进行引用的权限的校验结果。上述执行主体中可以存储有文档的标识与具有对该文档的内容进行引用的引用权限的用户的用户标识之间的对应关系的对应关系表，上述执行主体可以在上述对应关系表中查询上述目标用户的用户标识与上述被引用文档的标识是否存在对应关系。若存在对应关系，则可以确定上述目标用户具有对上述被引用文档中的内容进行引用的权限，此时，可以生成表征上述目标用户具有对被引用文档中的内容进行引用的权限的第一校验结果，该第一校验结果可以表征为1或者T。若不存在对应关系，则可以确定上述目标用户不具有对上述被引用文档中的内容进行引用的权限，此时，可以生成表征上述目标用户不具有对被引用文档中的内容进行引用的权限的第一校验结果，该第一校验结果可以表征为0或者F。
在一些可选的实现方式中，上述第一校验结果还可以包括对上述目标信息的合法性的校验结果。上述目标信息通常包括上述目标用户的用户标识、上述引用文档的标识、上述被引用文档的标识和上述引用区域的标识。上述执行主体可以通过如下方式校验上述第一目标信息的合法性：上述执行主体可以校验上述被引用文档的标识是否存在，也可以校验上述引用区域的标识所指示的引用区域是否超出上述被引用文档的文档区域。若上述被引用文档的标识存在且上述引用区域的标识所指示的引用区域未超出上述被引用文档的文档区域，则可以说明校验成功。若上述被引用文档的标识不存在或者上述引用区域的标识所指示的引用区域超出上述被引用文档的文档区域，则可以说明校验失败。
在一些可选的实现方式中，上述目标公式可以包括复制函数、表格链接和引用区域的标识，其中，上述复制函数用于将被引用表格中 的内容复制到引用表格中，上述表格链接为上述被引用表格的链接。上述目标公式的形式可以是IMPORTRANGE(String spreadsheet_url,String range_string,(Optional)Boolean if_sync_formatting)，其中，IMPORTRANGE函数为复制函数，可以将一个表格中的内容复制到另一个表格中，spreadsheet_url通常指的表格链接，是数据源表格的url(Uniform Resource Locator，统一资源定位器)链接，range_string通常指的是引用的区域字符串，即引用区域的标识，if_sync_formatting通常指的是是否同步样式，是否同步样式这一参数是可选参数，是否同步样式表示的是在一个表格中引用数据源表格中的内容时是否对引用区域的样式进行同步，引用区域的样式可以包括但不限于以下至少一项：引用区域的字体、引用区域的字号、引用区域的字体颜色、引用区域的是否突出显示颜色、引用区域的是否加粗、引用区域的是否倾斜、引用区域的是否添加下划线、引用区域的段落格式和引用区域的背景颜色。
在一些可选的实现方式中，上述引用文档或被引用文档可以包括电子表格文档、在线表格文档、或在线数据库表格文档中的一种。
继续参考图7，示出了根据本公开的信息引用方法中更新引用内容的又一个实施例的流程700。该更新引用内容的方法通常应用于服务器，该更新引用内容的方法，包括以下步骤：
步骤701，响应于接收到用户终端发送的针对引用区域的更改指令，利用更改指令中的更改的文档的标识和更改区域，查询对应的待变更文档的标识和待更新的目标公式的标识令牌。
在本实施例中，信息引用方法的执行主体(例如图1所示的服务器)可以确定是否接收到用户终端发送的针对引用区域的更改指令。当一个目标公式被创建时，上述执行主体中通常会维护目标公式的引用关系链(即引用文档与被引用文档之间的对应关系)。当被引用文档的引用区域中的内容发生变更时，上述执行主体通常会接收到用户终端发送的针对引用区域的更改指令，上述更改指令中可以包括更改的文档的标识和更改区域。之后，上述执行主体可以利用上述更改指令中的更改的文档的标识和更改区域，通过上述引用关系链查询对应的 待变更文档的标识和待更新的目标公式的标识令牌。
步骤702，利用待变更文档的标识，向第一目标用户终端发送更新指令。
在本实施例中，上述执行主体可以利用上述待变更文档的标识，向第一目标用户终端发送更新指令。上述第一目标用户终端可以为当前呈现的文档为上述待变更文档的标识所指示的待变更文档的用户终端，上述更新指令包括上述待更新的目标公式的标识令牌。
上述第一目标用户终端在接收到更新指令之后，可以利用上述更新指令中的待更新的目标公式的标识令牌，从上述执行主体中获取待更新的目标公式引用的最新数据；之后，上述第一目标用户终端可以利用上述最新数据，对当前呈现的文档中待更新的目标公式所引用的内容进行更新，从而可以在当前呈现的文档中展示引用区域更新后的内容。
本公开的上述实施例提供的方法通过在被引用文档中的引用区域的内容发生变更时，查询与被引用文档中的引用区域关联的文档，以向这些文档所在的用户终端发送更新指令，从而可以保证数据实时更新。
继续参考图8，示出了根据本公开的信息引用方法中校验查看用户的查看权限的一个实施例的流程800。该校验查看用户的查看权限的方法通常应用于服务器，该校验查看用户的查看权限的方法，包括以下步骤：
步骤801，响应于接收到查看用户的用户标识和所查看的目标公式的标识令牌，利用查看用户的用户标识和所查看的目标公式的标识令牌进行校验得到第二校验结果。
在本实施例中，信息引用方法的执行主体(例如图1所示的服务器)可以确定是否接收到查看用户的用户标识和所查看的目标公式的标识令牌。
若用户终端检测到用户对当前呈现的文档中的目标公式引用的内容进行查看，则上述用户终端可以获取查看用户的用户标识和所查看的目标公式的标识令牌，以及将获取到的查看用户的用户标识和所查 看的目标公式的标识令牌发送给上述执行主体。
作为一种示例，若上述用户终端检测到用户打开了一个文档且该文档中存在目标公式，则上述用户终端可以确定用户对当前呈现的文档中的目标公式引用的内容进行查看。
作为另一种示例，若上述用户终端检测到用户对当前呈现的文档进行浏览且浏览的区域为目标公式引用的区域，则上述用户终端可以确定用户对当前呈现的文档中的目标公式引用的内容进行查看。
若接收到查看用户的用户标识和所查看的目标公式的标识令牌，则上述执行主体可以利用上述查看用户的用户标识和上述所查看的目标公式的标识令牌进行校验得到第二校验结果。上述第二校验结果可以表征上述查看用户是否具有对所查看的目标公式引用的内容进行查看的权限。
具体地，上述执行主体可以利用上述所查看的目标公式的标识令牌查询可以对上述所查看的目标公式的所引用的内容进行查看的用户的用户标识集合。而后，可以确定上述查看用户的用户标识是否存在于上述用户标识集合中。若上述查看用户的用户标识存在于上述用户标识集合中，则上述执行主体可以确定上述查看用户具有对上述所查看的目标公式引用的内容进行查看的权限，此时，上述执行主体可以生成表征上述查看用户具有对所查看的目标公式引用的内容进行查看的权限的校验结果。若上述查看用户的用户标识不存在于上述用户标识集合中，则上述执行主体可以确定上述查看用户不具有对上述所查看的目标公式引用的内容进行查看的权限，此时，上述执行主体可以生成表征上述查看用户不具有对所查看的目标公式引用的内容进行查看的权限的校验结果。
步骤802，将第二校验结果返回给查看用户所使用的用户终端。
在本实施例中，上述执行主体可以将上述第二校验结果返回给上述查看用户所使用的用户终端。上述用户终端在接收到上述第二校验结果之后，可以基于上述第二校验结果，在当前呈现的文档中进行信息呈现。在这里，若上述第二校验结果表征上述查看用户不具有对所查看的目标公式引用的内容进行查看的权限，则上述用户终端可以在 当前呈现的文档中呈现用于表征用户不具有查看权限的信息。
本公开的上述实施例提供的方法通过对查看目标公式所引用的内容的查看用户的查看权限进行校验，并将校验结果返回给查看用户所使用的用户终端，从而保证了数据的安全性。
在一些可选的实现方式中，若上述第二校验结果表征上述查看用户具有对所查看的目标公式引用的内容进行查看的权限，则上述第二校验结果可以包括上述查看用户所查看的目标公式引用的内容。上述用户终端可以通过如下方式基于上述第二校验结果，在上述当前呈现的文档中进行信息呈现：上述用户终端可以在上述当前呈现的文档中呈现上述查看用户所查看的目标公式引用的内容。
继续参考图9，示出了根据本公开的信息引用方法中撤回目标公式的引用权限的一个实施例的流程900。该撤回目标公式的引用权限的方法通常应用于服务器，该撤回目标公式的引用权限的方法，包括以下步骤：
步骤901，响应于接收到用户终端发送的针对目标公式的目标指令，将目标指令所针对的目标公式的标识令牌设置为失效。
在本实施例中，信息引用方法的执行主体(例如图1所示的服务器)可以确定是否接收到用户终端发送的针对目标公式的目标指令。上述目标指令可以包括修改指令或删除指令。上述目标指令通常是上述用户终端检测到用户针对目标公式执行目标操作所生成的，上述目标操作可以包括修改操作或删除操作。
若接收到上述用户终端发送的针对目标公式的目标指令，则上述执行主体可以将上述目标指令所针对的目标公式的标识令牌设置为失效。
步骤902，向第二目标用户终端发送权限撤回指令。
在本实施例中，上述执行主体可以向第二目标用户终端发送权限撤回指令。上述权限撤回指令可以包括失效的目标公式的标识令牌，上述权限撤回指令通常用于对上述失效的目标公式的引用权限进行撤回。上述第二目标用户终端可以为当前呈现的文档为上述失效的目标公式所在的文档的用户终端。
若上述第二目标用户终端接收到上述权限撤回指令，则上述第二目标用户终端可以利用上述权限撤回指令中失效的目标公式的标识令牌，对当前呈现的文档中上述失效的目标公式所引用的内容进行撤回，即不在当前呈现的文档中展示上述失效的目标公式所引用的内容。
本公开的上述实施例提供的方法通过接收到目标公式被修改或删除的指令，可以将该目标公式的标识令牌设置为失效，并向当前呈现的文档为上述失效的目标公式所在的文档的用户终端发送权限撤回指令。通过这种方式使得修改或删除的目标公式的标识令牌失效且无法再被恢复，可以防止通过失效的标识令牌非法获取数据，保证了数据的安全性。
继续参考图10，示出了根据本公开的信息引用系统的一个实施例的时序图。
本实施例的信息引用系统包括：用户终端和服务器。其中，用户终端，用于响应于创建目标公式，确定目标公式的参数，利用第一目标信息，生成目标公式的标识令牌，将第二目标信息发送给服务器，接收服务器返回的第一校验结果，以及基于第一校验结果，在引用文档中进行信息呈现，其中，目标公式用于在引用文档中引用被引用文档中的内容，参数包括被引用文档的标识和引用区域的标识，第一目标信息包括目标用户的用户标识、引用文档的标识、被引用文档的标识和引用区域的标识，目标用户为创建目标公式的用户，第二目标信息包括标识令牌和第一目标信息，第一校验结果包括表征目标用户是否具有对被引用文档中的内容进行引用的权限的校验结果；服务器，用于响应于接收到第二目标信息，利用第二目标信息，对目标公式的引用权限进行校验得到第一校验结果，将第一校验结果返回给用户终端。
如图10所示，在步骤1001中，用户终端响应于创建目标公式，确定目标公式的参数。
在本实施例中，用户终端可以检测用户是否在文档中创建目标公式。上述目标公式也可以称为跨表引用公式，可以用于在引用文档中引用被引用文档中的内容。上述目标公式的形式可以是 IMPORTRANGE(String spreadsheet_url,String range_string,(Optional)Boolean if_sync_formatting)，其中，IMPORTRANGE函数可以将一个表格中的内容复制到另一个表格中，spreadsheet_url通常指的是数据源表格的url链接，range_string通常指的是引用的区域字符串，if_sync_formatting通常指的是是否同步样式，是否同步样式这一参数是可选参数，是否同步样式表示的是在一个表格中引用数据源表格中的内容时是否对引用区域的样式进行同步，引用区域的样式可以包括但不限于以下至少一项：引用区域的字体、引用区域的字号、引用区域的字体颜色、引用区域的是否突出显示颜色、引用区域的是否加粗、引用区域的是否倾斜、引用区域的是否添加下划线、引用区域的段落格式和引用区域的背景颜色。
作为一种示例，用户可以通过如下方式创建目标公式：文档中可以呈现跨表引用选择面板，用户可以在当前显示的文档(引用文档)中的跨表引用选择面板中选择文档作为被引用文档，以及选择被引用文档中的区域作为引用区域，之后，点击“确认”图标，此时目标公式创建成功。
作为另一种示例，用户还可以通过如下方式创建目标公式：用户可以在目标公式的编辑框中输入被引用文档的标识(例如，url)和引用区域的范围，以创建目标公式。
之后，若检测到创建目标公式，用户终端可以确定目标公式的参数。上述参数可以包括上述被引用文档的标识和引用区域。
作为一种示例，若创建的目标公式为IMPORTRANGE(“xxx.com”，“A1”)，则用户终端可以确定目标公式的被引用文档的标识为“xxx.com”，引用区域的标识为“A1”这一区域。
作为另一种示例，若创建的目标公式为IMPORTRANGE(A1，B1)，则用户终端可以从当前呈现的文档中的A1这一单元格中获取被引用文档的标识，以及从当前呈现的文档中的B1这一单元格中获取引用区域的标识。
在步骤1002中，用户终端利用第一目标信息，生成目标公式的标识令牌。
在本实施例中，用户终端可以利用第一目标信息，生成上述目标公式的标识令牌。目标公式的标识令牌通常用于唯一标识目标公式，可以表征为字符串。上述第一目标信息通常包括目标用户的用户标识、上述引用文档(当前呈现的文档)的标识、上述被引用文档(数据源文档)的标识和上述引用区域的标识，上述目标用户可以为创建上述目标公式的用户。
在这里，用户终端可以利用预设的加密算法对上述目标用户的用户标识、上述引用文档的标识、上述被引用文档的标识和上述引用区域的标识进行加密，得到上述目标公式的标识令牌。
在步骤1003中，用户终端将第二目标信息发送给服务器。
在本实施例中，用户终端可以将上述第二目标信息发送给服务器。在这里，上述第二目标信息可以包括上述标识令牌和上述第一目标信息。用户执行一个操作之后，用户终端通常会向上述服务器发送操作指令，在这里，用户执行setcell action之后，可以将上述第二目标信息添加到操作指令，并发送给上述服务器。
在步骤1004中，服务器响应于接收到第二目标信息，利用第二目标信息，对目标公式的引用权限进行校验得到第一校验结果。
在本实施例中，服务器可以确定是否接收到用户终端发送的第二目标信息。若接收到上述用户终端发送的目标公式的标识令牌和第一目标信息，则上述执行主体可以利用上述目标公式的标识令牌和上述第一目标信息，对目标公式的引用权限进行校验得到第一校验结果。
在步骤1005中，服务器将第一校验结果返回给用户终端。
在本实施例中，服务器可以将步骤1004中得到的第一校验结果返回给上述用户终端。
在步骤1006中，用户终端基于第一校验结果，在引用文档中进行信息呈现。
在本实施例中，用户终端可以基于上述第一校验结果，在上述引用文档中进行信息呈现。若上述第一校验结果表征验证失败，则用户终端可以在上述引用文档中呈现验证失败的信息，例如，上述表征验证失败的信息可以包括错误码，一种错误码对应一种验证失败原因。
本公开的上述实施例提供的系统通过这种创建文档之间信息引用关系的方式，相比于用户执行从一个文档复制内容粘贴到另一个文档中的操作，实现了一种更加简洁高效的跨表引用实现方案。
在一些可选的实现方式中，上述用户终端可以确定是否检测到更新指令。上述更新指令可以用于对当前呈现的文档中目标公式所引用的内容进行更新。上述更新指令中通常包括待更新的目标公式的标识令牌。若检测到更新指令，上述用户终端可以利用上述更新指令中的待更新的目标公式的标识令牌，从上述服务器中获取待更新的目标公式引用的最新数据。在这里，当一个目标公式被创建时，上述服务器中通常会维护目标公式的引用关系链。当被引用文档的引用区域中的内容发生变更时，上述服务器通常会获取到内容变更通知，并通过上述引用关系链查找到需要进行内容变更的文档作为待通知文档。上述服务器可以向打开上述待通知文档的用户终端发送更新指令。上述用户终端可以利用上述最新数据，对当前呈现的文档中待更新的目标公式所引用的内容进行更新，从而可以在当前呈现的文档中展示引用区域更新后的内容。
在一些可选的实现方式中，上述更新指令可以是通过如下方式生成的：响应于检测到当前时间为预设时间，上述用户终端可以生成更新指令。若当前呈现的文档中存在目标公式，上述用户终端可以设置定时器，若当前时间为设置的定时时间时，可以向上述服务器请求当前呈现的文档中的目标公式的最新数据，从而可以保证数据更新地及时性和有效性。
在一些可选的实现方式中，若上述第一校验结果表征校验成功，则上述第一校验结果可以包括上述被引用文档中上述引用区域的区域内容。上述用户终端可以通过如下方式基于上述第一校验结果，在上述引用文档中进行信息呈现：若上述第一校验结果表征校验成功，上述用户终端可以在上述引用文档中呈现上述区域内容。
在一些可选的实现方式中，上述第二目标信息还可以包括同步样式标识，上述同步样式标识可以用于表征在上述引用文档中引用上述引用区域的内容时是否对上述引用区域的样式进行同步。若同步样式 标识为“1”或“T”，则可以表征在上述引用文档中引用上述引用区域的内容时对上述引用区域的样式进行同步。若同步样式标识为“0”或“F”，则可以表征在上述引用文档中引用上述引用区域的内容时不对上述引用区域的样式进行同步。上述引用区域的样式可以包括但不限于以下至少一项：引用区域的字体、引用区域的字号、引用区域的字体颜色、引用区域的是否突出显示颜色、引用区域的是否加粗、引用区域的是否倾斜、引用区域的是否添加下划线、引用区域的段落格式和引用区域的背景颜色。
在一些可选的实现方式中，上述第一校验结果还可以包括对上述第一目标信息的合法性的校验结果。上述第一目标信息通常包括目标用户的用户标识、上述引用文档的标识、上述被引用文档的标识和上述引用区域的标识。上述服务器可以通过如下方式校验上述第一目标信息的合法性：上述服务器可以校验上述被引用文档的标识是否存在，也可以校验上述引用区域的标识所指示的引用区域是否超出上述被引用文档的文档区域。若上述被引用文档的标识存在且上述引用区域的标识所指示的引用区域未超出上述被引用文档的文档区域，则可以说明校验成功。若上述被引用文档的标识不存在或者上述引用区域的标识所指示的引用区域超出上述被引用文档的文档区域，则可以说明校验失败。
在一些可选的实现方式中，上述第一校验结果可以包括表征上述目标用户是否具有对被引用文档中的内容进行引用的权限的校验结果。服务器中可以存储有文档的标识与具有对该文档的内容进行引用的引用权限的用户的用户标识之间的对应关系的对应关系表，服务器可以在上述对应关系表中查询上述目标用户的用户标识与上述被引用文档的标识是否存在对应关系。若存在对应关系，则可以确定上述目标用户具有对上述被引用文档中的内容进行引用的权限，此时，可以生成表征上述目标用户具有对被引用文档中的内容进行引用的权限的第一校验结果，该第一校验结果可以表征为1或者T。若不存在对应关系，则可以确定上述目标用户不具有对上述被引用文档中的内容进行引用的权限，此时，可以生成表征上述目标用户不具有对被引用文 档中的内容进行引用的权限的第一校验结果，该第一校验结果可以表征为0或者F。
在一些可选的实现方式中，若上述第一校验结果表征校验成功，上述第一校验结果可以包括上述被引用文档中上述引用区域的区域内容。上述服务器可以将上述目标公式的标识令牌与上述目标信息进行关联存储，即将上述目标公式的标识令牌、上述目标用户的用户标识、上述引用文档(当前呈现的文档)的标识、上述被引用文档的标识和上述引用区域的标识这五项进行关联存储。
在一些可选的实现方式中，上述目标公式可以包括复制函数、表格链接和引用区域的标识，其中，上述复制函数用于将被引用表格中的内容复制到引用表格中，上述表格链接为上述被引用表格的链接。上述目标公式的形式可以是IMPORTRANGE(String spreadsheet_url,String range_string,(Optional)Boolean if_sync_formatting)，其中，IMPORTRANGE函数为复制函数，可以将一个表格中的内容复制到另一个表格中，spreadsheet_url通常指的表格链接，是数据源表格的url(Uniform Resource Locator，统一资源定位器)链接，range_string通常指的是引用的区域字符串，即引用区域的标识，if_sync_formatting通常指的是是否同步样式，是否同步样式这一参数是可选参数，是否同步样式表示的是在一个表格中引用数据源表格中的内容时是否对引用区域的样式进行同步，引用区域的样式可以包括但不限于以下至少一项：引用区域的字体、引用区域的字号、引用区域的字体颜色、引用区域的是否突出显示颜色、引用区域的是否加粗、引用区域的是否倾斜、引用区域的是否添加下划线、引用区域的段落格式和引用区域的背景颜色。
在一些可选的实现方式中，上述引用文档或被引用文档可以包括电子表格文档、在线表格文档、或在线数据库表格文档中的一种。
继续参考图11，示出了根据本公开的信息引用系统中更新引用内容的一个实施例的时序图。
本实施例的信息引用系统还包括：其他用户终端，其中，其他用户终端包括除上述用户终端之外的用户终端。上述其他用户终端用于 向服务器发送针对被引用文档中的引用区域的更改指令。
如图11所示，在步骤1101中，其他用户终端向服务器发送针对引用区域的更改指令。
在本实施例中，其他用户终端可以向服务器发送针对引用区域的更改指令。当用户对其他用户终端上呈现的被引用文档的引用区域中的内容进行更改时，可以向服务器发送针对引用区域的更改指令。上述更改指令可以包括更改的文档的标识和更改区域。
在步骤1102中，服务器响应于接收到针对引用区域的更改指令，利用更改指令中的更改的文档的标识和更改区域，查询对应的待变更文档的标识和待更新的目标公式的标识令牌。
在本实施例中，服务器可以确定是否接收到其他用户终端发送的针对引用区域的更改指令。当一个目标公式被创建时，上述执行主体中通常会维护目标公式的引用关系链(即引用文档与被引用文档之间的对应关系)。当被引用文档的引用区域中的内容发生变更时，服务器通常会接收到用户终端发送的针对引用区域的更改指令，上述更改指令可以包括更改的文档的标识和更改区域。之后，服务器可以利用上述更改指令中的更改的文档的标识和更改区域，通过上述引用关系链查询对应的待变更文档的标识和待更新的目标公式的标识令牌。
在步骤1103中，服务器利用待变更文档的标识，向用户终端发送更新指令。
在本实施例中，服务器可以利用上述待变更文档的标识，向用户终端发送更新指令。上述用户终端当前呈现的文档为上述待变更文档的标识所指示的待变更文档。除了向上述用户终端发送更新指令，上述服务器还可以向当前呈现的文档为上述待变更文档的标识所指示的待变更文档的其他第一目标用户终端发送上述更新指令。上述更新指令包括上述待更新的目标公式的标识令牌。
在步骤1104中，用户终端响应于检测到更新指令，利用更新指令中的待更新的目标公式的标识令牌，获取待更新的目标公式引用的最新数据。
在本实施例中，用户终端可以确定是否检测到更新指令。上述更 新指令可以用于对当前呈现的文档中目标公式所引用的内容进行更新。上述更新指令中通常包括待更新的目标公式的标识令牌。
若检测到更新指令，用户终端可以利用上述更新指令中的待更新的目标公式的标识令牌，从上述服务器中获取待更新的目标公式引用的最新数据。
在步骤1105中，用户终端利用最新数据，对当前呈现的文档中待更新的目标公式所引用的内容进行更新。
在本实施例中，用户终端可以利用上述最新数据，对当前呈现的文档中待更新的目标公式所引用的内容进行更新，从而可以在当前呈现的文档中展示引用区域更新后的内容。
本公开的上述实施例提供的系统通过在被引用文档中的引用区域的内容发生变更时，获取最新数据对引用文档中的引用区域的内容进行更新，从而保证数据实时更新。
继续参考图12，示出了根据本公开的信息引用系统中查看目标公式的一个实施例的时序图。
如图12所示，在步骤1201中，用户终端响应于检测到对当前呈现的文档中的目标公式引用的内容进行查看，获取查看用户的用户标识和所查看的目标公式的标识令牌。
在本实施例中，用户终端可以检测用户是否对当前呈现的文档中的目标公式引用的内容进行查看。
作为一种示例，若用户终端检测到用户打开了一个文档且该文档中存在目标公式，则可以确定用户对当前呈现的文档中的目标公式引用的内容进行查看。
作为另一种示例，若用户终端检测到用户对当前呈现的文档进行浏览且浏览的区域为目标公式引用的区域，则可以确定用户对当前呈现的文档中的目标公式引用的内容进行查看。
若检测到对当前呈现的文档中的目标公式引用的内容进行查看，则用户终端可以获取查看用户的用户标识和所查看的目标公式的标识令牌。
需要说明的是，若将检测到用户打开了一个文档且该文档中存在 目标公式判定为用户对当前呈现的文档中的目标公式引用的内容进行查看，用户终端可以获取打开的文档中的所有目标公式的标识令牌。
在步骤1202中，用户终端向服务器发送查看用户的用户标识和所查看的目标公式的标识令牌。
在本实施例中，用户终端可以向服务器发送查看用户的用户标识和所查看的目标公式的标识令牌。
在步骤1203中，服务器响应于接收到查看用户的用户标识和所查看的目标公式的标识令牌，利用查看用户的用户标识和所查看的目标公式的标识令牌进行校验得到第二校验结果。
在本实施例中，服务器可以确定是否接收到查看用户的用户标识和所查看的目标公式的标识令牌。若接收到查看用户的用户标识和所查看的目标公式的标识令牌，则服务器可以利用上述查看用户的用户标识和上述所查看的目标公式的标识令牌进行校验得到第二校验结果。上述第二校验结果可以表征上述查看用户是否具有对所查看的目标公式引用的内容进行查看的权限。
具体地，服务器可以利用上述所查看的目标公式的标识令牌查询可以对上述所查看的目标公式的所引用的内容进行查看的用户的用户标识集合。而后，可以确定上述查看用户的用户标识是否存在于上述用户标识集合中。若上述查看用户的用户标识存在于上述用户标识集合中，则服务器可以确定上述查看用户具有对上述所查看的目标公式引用的内容进行查看的权限，此时，服务器可以生成表征上述查看用户具有对所查看的目标公式引用的内容进行查看的权限的校验结果。若上述查看用户的用户标识不存在于上述用户标识集合中，则服务器可以确定上述查看用户不具有对上述所查看的目标公式引用的内容进行查看的权限，此时，服务器可以生成表征上述查看用户不具有对所查看的目标公式引用的内容进行查看的权限的校验结果。
在步骤1204中，服务器将第二校验结果返回给查看用户所使用的用户终端。
在本实施例中，服务器可以将上述第二校验结果返回给查看用户所使用的用户终端。
在步骤1205中，用户终端基于第二校验结果，在当前呈现的文档中进行信息呈现。
在本实施例中，用户终端在接收到上述第二校验结果之后，可以基于上述第二校验结果，在当前呈现的文档中进行信息呈现。在这里，若上述第二校验结果表征上述查看用户不具有对所查看的目标公式引用的内容进行查看的权限，则用户终端可以在当前呈现的文档中呈现用于表征用户不具有查看权限的信息。
本公开的上述实施例提供的系统通过对查看目标公式所引用的内容的查看用户的查看权限进行校验，并基于校验结果，在当前呈现的文档中进行信息呈现，从而保证了数据的安全性。
在一些可选的实现方式中，若上述第二校验结果表征上述查看用户具有对所查看的目标公式引用的内容进行查看的权限，此时，上述第二校验结果可以包括上述查看用户所查看的目标公式引用的内容。上述用户终端可以通过如下方式基于上述第二校验结果，在上述当前呈现的文档中进行信息呈现：上述用户终端可以在上述当前呈现的文档中呈现上述查看用户所查看的目标公式引用的内容。
继续参考图13，示出了根据本公开的信息引用系统中撤回目标公式的引用权限的一个实施例的时序图。
如图13所示，在步骤1301中，用户终端响应于检测到用户针对目标公式执行目标操作，向服务器发送目标指令。
在本实施例中，用户终端可以检测用户是否针对目标公式执行目标操作。上述目标操作可以包括修改操作或删除操作，即用户终端可以检测用户是否针对目标公式执行修改操作或者删除操作。若检测到用户针对目标公式执行上述目标操作，用户终端可以向服务器发送目标指令。上述目标指令可以包括对上述目标操作所针对的目标公式的修改指令或删除指令。
在步骤1302中，服务器响应于接收到目标指令，将目标指令所针对的目标公式的标识令牌设置为失效。
在本实施例中，服务器可以确定是否接收到用户终端发送的针对目标公式的目标指令。若接收到上述用户终端发送的针对目标公式的 目标指令，则服务器可以将上述目标指令所针对的目标公式的标识令牌设置为失效。
在步骤1303中，服务器向用户终端发送权限撤回指令。
在本实施例中，服务器可以向上述用户终端发送权限撤回指令。上述权限撤回指令可以包括失效的目标公式的标识令牌，上述权限撤回指令通常用于对上述失效的目标公式的引用权限进行撤回。上述用户终端上当前呈现的文档为上述失效的目标公式所在的文档。需要说明的是，服务器除了向上述用户终端发送权限撤回指令，通常还需要向当前呈现的文档为上述失效的目标公式所在的文档的其他第二目标用户终端发送权限撤回指令。
在步骤1304中，用户终端响应于接收到权限撤回指令，利用权限撤回指令中失效的目标公式的标识令牌，对当前呈现的文档中失效的目标公式所引用的内容进行撤回。
在本实施例中，用户终端可以确定是否接收到上述服务器发送的权限撤回指令。若接收到上述权限撤回指令，则用户终端可以利用上述权限撤回指令中失效的目标公式的标识令牌，对当前呈现的文档中上述失效的目标公式所引用的内容进行撤回，即不在当前呈现的文档中展示上述失效的目标公式所引用的内容。
本公开的上述实施例提供的系统通过接收到目标公式被修改或删除的指令，可以将该目标公式的标识令牌设置为失效，并向当前呈现的文档为上述失效的目标公式所在的文档的用户终端发送权限撤回指令。通过这种方式使得修改或删除的目标公式的标识令牌失效且无法再被恢复，可以防止通过失效的标识令牌非法获取数据，保证了数据的安全性。
在一些可选的实现方式中，在对当前呈现的文档中上述失效的目标公式所引用的内容进行撤回之后，上述用户终端可以呈现提示信息，上述提示信息可以用于提示重新对上述失效的目标公式的引用权限进行校验。
进一步参考图14，作为对上述各图所示方法的实现，本公开提供了一种信息引用装置的一个实施例，该装置实施例与图2所示的方法 实施例相对应，该装置具体可以应用于各种电子设备中。
如图14所示，本实施例的信息引用装置1400包括：确定单元1401、生成单元1402、第一接收单元1403和第一呈现单元1404。其中，确定单元1401用于响应于创建目标公式，确定目标公式的参数，其中，目标公式用于在引用文档中引用被引用文档中的内容，参数包括被引用文档的标识和引用区域的标识；生成单元1402用于利用第一目标信息，生成目标公式的标识令牌，其中，第一目标信息包括目标用户的用户标识、引用文档的标识、被引用文档的标识和引用区域的标识，目标用户为创建目标公式的用户；第一接收单元1403用于接收基于第二目标信息返回的第一校验结果，其中，第二目标信息包括标识令牌和第一目标信息，第一校验结果包括表征目标用户是否具有对被引用文档中的内容进行引用的权限的校验结果；第一呈现单元1404用于基于第一校验结果，在引用文档中进行信息呈现。
在本实施例中，信息引用装置1400的确定单元1401、生成单元1402、第一接收单元1403和第一呈现单元1404的具体处理可以参考图2对应实施例中的步骤201、步骤202、步骤203和步骤204。
在一些可选的实现方式中，上述信息引用装置1400还可以包括：第一获取单元(图中未示出)和更新单元(图中未示出)。上述第一获取单元可以用于响应于检测到更新指令，利用上述更新指令中的待更新的目标公式的标识令牌，获取上述待更新的目标公式引用的最新数据，其中，上述更新指令用于对当前呈现的文档中目标公式所引用的内容进行更新；上述更新单元可以用于利用上述最新数据，对当前呈现的文档中上述待更新的目标公式所引用的内容进行更新。
在一些可选的实现方式中，上述更新指令可以是通过如下方式生成的：响应于检测到当前时间为预设时间，生成更新指令。
在一些可选的实现方式中，若上述第一校验结果表征校验成功，上述第一校验结果包括上述被引用文档中上述引用区域的区域内容；以及上述呈现单元1404可以进一步用于通过如下方式基于上述第一校验结果，在上述引用文档中进行信息呈现：在上述引用文档中呈现上述区域内容。
在一些可选的实现方式中，上述第一接收单元1403可以进一步用于通过如下方式接收基于第二目标信息返回的第一校验结果：上述第一接收单元1403可以将第二目标信息发送给目标服务器，其中，上述目标服务器基于上述第二目标信息，生成以及返回第一校验结果。
在一些可选的实现方式中，上述信息引用装置1400还可以包括：第二获取单元(图中未示出)、第二接收单元(图中未示出)和第二呈现单元(图中未示出)。上述第二获取单元可以用于响应于检测到对当前呈现的文档中的目标公式引用的内容进行查看，获取查看用户的用户标识和所查看的目标公式的标识令牌；上述第二接收单元可以用于向上述目标服务器发送上述查看用户的用户标识和上述所查看的目标公式的标识令牌，接收上述目标服务器返回的校验结果作为第二校验结果，其中，上述第二校验结果表征上述查看用户是否具有对所查看的目标公式引用的内容进行查看的权限；上述第二呈现单元可以用于基于上述第二校验结果，在上述当前呈现的文档中进行信息呈现。
在一些可选的实现方式中，若上述第二校验结果表征上述查看用户具有对所查看的目标公式引用的内容进行查看的权限，上述第二校验结果包括上述查看用户所查看的目标公式引用的内容；以及上述第二呈现单元可以进一步用于通过如下方式基于上述第二校验结果，在上述当前呈现的文档中进行信息呈现：在上述当前呈现的文档中呈现上述查看用户所查看的目标公式引用的内容。
在一些可选的实现方式中，上述信息引用装置1400还可以包括：发送单元(图中未示出)。上述发送单元可以响应于检测到用户针对目标公式执行目标操作，向上述目标服务器发送目标指令，其中，上述目标操作包括修改操作或删除操作，上述目标指令包括对上述目标操作所针对的目标公式的修改指令或删除指令。
在一些可选的实现方式中，上述信息引用装置1400还可以包括：撤回单元(图中未示出)。上述撤回单元可以响应于接收到权限撤回指令，利用上述权限撤回指令中失效的目标公式的标识令牌，对当前呈现的文档中上述失效的目标公式所引用的内容进行撤回，其中，上述权限撤回指令包括上述失效的目标公式的标识令牌，上述权限撤回指 令用于对上述失效的目标公式的引用权限进行撤回。
在一些可选的实现方式中，上述信息引用装置1400还可以包括：第三呈现单元(图中未示出)。上述第三呈现单元可以呈现提示信息，上述提示信息用于提示重新对上述失效的目标公式的引用权限进行校验。
在一些可选的实现方式中，上述第二目标信息还可以包括同步样式标识，上述同步样式标识用于表征在上述引用文档中引用上述引用区域的内容时是否对上述引用区域的样式进行同步。
在一些可选的实现方式中，上述第一校验结果可以包括表征上述目标用户是否具有对被引用文档中的内容进行引用的权限的校验结果。
在一些可选的实现方式中，上述第一校验结果还可以包括对上述第一目标信息的合法性的校验结果。
在一些可选的实现方式中，上述目标公式包括复制函数、表格链接和引用区域的标识，其中，上述复制函数用于将被引用表格中的内容复制到引用表格中，上述表格链接为上述被引用表格的链接。
在一些可选的实现方式中，上述引用文档或被引用文档可以包括电子表格文档、在线表格文档、或在线数据库表格文档中的一种。
进一步参考图15，作为对上述各图所示方法的实现，本公开提供了一种信息引用装置的又一个实施例，该装置实施例与图5所示的方法实施例相对应，该装置具体可以应用于各种电子设备中。
如图15所示，本实施例的信息引用装置1500包括：确定单元1501、生成单元1502、呈现单元1503、获取单元1504和更新单元1505。其中，确定单元1501用于响应于创建目标公式，确定目标公式的参数，其中，目标公式用于在引用文档中引用被引用文档中的内容，参数包括被引用文档的标识和引用区域的标识；生成单元1502用于利用第一目标信息，生成目标公式的标识令牌，其中，第一目标信息包括目标用户的用户标识、引用文档的标识、被引用文档的标识和引用区域的标识，目标用户为创建目标公式的用户；呈现单元1503用于基于标识令牌和第一目标信息，在引用文档中呈现引用区域的内容；获取单元 1504用于响应于检测到更新指令，获取目标公式引用的最新数据，其中，更新指令用于对引用区域的内容进行更新；更新单元1505用于利用最新数据，对目标公式所引用的内容进行更新。
进一步参考图16，作为对上述各图所示方法的实现，本公开提供了一种信息引用装置的另一个实施例，该装置实施例与图6所示的方法实施例相对应，该装置具体可以应用于各种电子设备中。
如图16所示，本实施例的信息引用装置1600包括：第一校验单元1601和第一返回单元1602。其中，第一校验单元1601用于响应于接收到用户终端发送的目标公式的标识令牌和目标信息，利用目标公式的标识令牌和目标信息，对目标公式的引用权限进行校验得到第一校验结果，其中，目标公式用于在引用文档中引用被引用文档中的内容，目标信息包括目标用户的用户标识、引用文档的标识、被引用文档的标识和引用区域的标识，目标用户为创建目标公式的用户；第一返回单元1602用于将第一校验结果返回给用户终端。
在本实施例中，信息引用装置1600的第一校验单元1601和第一返回单元1602的具体处理可以参考图6对应实施例中的步骤501和步骤502。
在一些可选的实现方式中，上述信息引用装置1600可以包括：存储单元(图中未示出)。若上述第一校验结果表征校验成功，上述第一校验结果包括上述被引用文档中上述引用区域的区域内容。上述存储单元可以用于将上述目标公式的标识令牌与上述目标信息进行关联存储。
在一些可选的实现方式中，上述信息引用装置1600可以包括：查询单元(图中未示出)和第一发送单元(图中未示出)。上述查询单元可以用于响应于接收到用户终端发送的针对上述引用区域的更改指令，利用上述更改指令中的更改的文档的标识和更改区域，查询对应的待变更文档的标识和待更新的目标公式的标识令牌；上述第一发送单元可以用于利用上述待变更文档的标识，向第一目标用户终端发送更新指令，其中，上述第一目标用户终端为当前呈现的文档为上述待变更文档的用户终端，上述更新指令包括上述待更新的目标公式的标 识令牌。
在一些可选的实现方式中，上述信息引用装置1600可以包括：第二校验单元(图中未示出)和第二返回单元(图中未示出)。上述第二校验单元可以用于响应于接收到查看用户的用户标识和所查看的目标公式的标识令牌，利用上述查看用户的用户标识和上述所查看的目标公式的标识令牌进行校验得到第二校验结果，其中，上述第二校验结果表征上述查看用户是否具有对所查看的目标公式引用的内容进行查看的权限；上述第二返回单元可以用于将上述第二校验结果返回给上述查看用户所使用的用户终端。
在一些可选的实现方式中，若上述第二校验结果表征上述查看用户具有对所查看的目标公式引用的内容进行查看的权限，上述第二校验结果包括上述查看用户所查看的目标公式引用的内容。
在一些可选的实现方式中，上述信息引用装置1600可以包括：设置单元(图中未示出)和第二发送单元(图中未示出)。上述设置单元可以用于响应于接收到用户终端发送的针对目标公式的目标指令，将上述目标指令所针对的目标公式的标识令牌设置为失效，其中，上述目标指令包括修改指令或删除指令；上述第二发送单元可以用于向第二目标用户终端发送权限撤回指令，其中，上述权限撤回指令包括失效的目标公式的标识令牌，上述权限撤回指令用于对上述失效的目标公式的引用权限进行撤回，上述第二目标用户终端为当前呈现的文档为上述失效的目标公式所在的文档的用户终端。
在一些可选的实现方式中，上述目标信息还包括同步样式标识，上述同步样式标识用于表征在上述引用文档中引用上述引用区域的内容时是否对上述引用区域的样式进行同步。
在一些可选的实现方式中，上述第一校验结果可以包括表征上述目标用户是否具有对被引用文档中的内容进行引用的权限的校验结果。
在一些可选的实现方式中，上述第一校验结果还包括对上述目标信息的合法性的校验结果。
在一些可选的实现方式中，上述目标公式包括复制函数、表格链 接和引用区域的标识，其中，上述复制函数用于将被引用表格中的内容复制到引用表格中，上述表格链接为上述被引用表格的链接。
在一些可选的实现方式中，上述引用文档或被引用文档可以包括电子表格文档、在线表格文档、或在线数据库表格文档中的一种。
下面参考图17，其示出了适于用来实现本公开的实施例的电子设备(例如图1中的服务器或终端设备)1700的结构示意图。本公开的实施例中的终端设备可以包括但不限于诸如移动电话、笔记本电脑、数字广播接收器、PDA(个人数字助理)、PAD(平板电脑)、PMP(便携式多媒体播放器)、车载终端(例如车载导航终端)等等的移动终端以及诸如数字TV、台式计算机等等的固定终端。图17示出的电子设备仅仅是一个示例，不应对本公开的实施例的功能和使用范围带来任何限制。
如图17所示，电子设备1700可以包括处理装置(例如中央处理器、图形处理器等)1701，其可以根据存储在只读存储器(ROM)1702中的程序或者从存储装置1708加载到随机访问存储器(RAM)1703中的程序而执行各种适当的动作和处理。在RAM 1703中，还存储有电子设备1700操作所需的各种程序和数据。处理装置1701、ROM 1702以及RAM 1703通过总线1704彼此相连。输入/输出(I/O)接口1705也连接至总线1704。
通常，以下装置可以连接至I/O接口1705：包括例如触摸屏、触摸板、键盘、鼠标、摄像头、麦克风、加速度计、陀螺仪等的输入装置1706；包括例如液晶显示器(LCD)、扬声器、振动器等的输出装置1707；包括例如磁带、硬盘等的存储装置1708；以及通信装置1709。通信装置1709可以允许电子设备1700与其他设备进行无线或有线通信以交换数据。虽然图17示出了具有各种装置的电子设备1700，但是应理解的是，并不要求实施或具备所有示出的装置。可以替代地实施或具备更多或更少的装置。图17中示出的每个方框可以代表一个装置，也可以根据需要代表多个装置。
特别地，根据本公开的实施例，上文参考流程图描述的过程可以被实现为计算机软件程序。例如，本公开的实施例包括一种计算机程 序产品，其包括承载在计算机可读介质上的计算机程序，该计算机程序包含用于执行流程图所示的方法的程序代码。在这样的实施例中，该计算机程序可以通过通信装置1709从网络上被下载和安装，或者从存储装置1708被安装，或者从ROM 1702被安装。在该计算机程序被处理装置1701执行时，执行本公开的实施例的方法中限定的上述功能。需要说明的是，本公开的实施例所述的计算机可读介质可以是计算机可读信号介质或者计算机可读存储介质或者是上述两者的任意组合。计算机可读存储介质例如可以是——但不限于——电、磁、光、电磁、红外线、或半导体的系统、装置或器件，或者任意以上的组合。计算机可读存储介质的更具体的例子可以包括但不限于：具有一个或多个导线的电连接、便携式计算机磁盘、硬盘、随机访问存储器(RAM)、只读存储器(ROM)、可擦式可编程只读存储器(EPROM或闪存)、光纤、便携式紧凑磁盘只读存储器(CD-ROM)、光存储器件、磁存储器件、或者上述的任意合适的组合。在本公开的实施例中，计算机可读存储介质可以是任何包含或存储程序的有形介质，该程序可以被指令执行系统、装置或者器件使用或者与其结合使用。而在本公开的实施例中，计算机可读信号介质可以包括在基带中或者作为载波一部分传播的数据信号，其中承载了计算机可读的程序代码。这种传播的数据信号可以采用多种形式，包括但不限于电磁信号、光信号或上述的任意合适的组合。计算机可读信号介质还可以是计算机可读存储介质以外的任何计算机可读介质，该计算机可读信号介质可以发送、传播或者传输用于由指令执行系统、装置或者器件使用或者与其结合使用的程序。计算机可读介质上包含的程序代码可以用任何适当的介质传输，包括但不限于：电线、光缆、RF(射频)等等，或者上述的任意合适的组合。
上述计算机可读介质可以是上述电子设备中所包含的；也可以是单独存在，而未装配入该电子设备中。上述计算机可读介质承载有一个或者多个程序，当上述一个或者多个程序被该电子设备执行时，使得该电子设备：响应于创建目标公式，确定目标公式的参数，其中，目标公式用于在引用文档中引用被引用文档中的内容，参数包括被引 用文档的标识和引用区域的标识；利用第一目标信息，生成目标公式的标识令牌，其中，第一目标信息包括目标用户的用户标识、引用文档的标识、被引用文档的标识和引用区域的标识，目标用户为创建目标公式的用户；接收基于第二目标信息返回的第一校验结果，其中，第二目标信息包括标识令牌和第一目标信息；基于第一校验结果，在引用文档中进行信息呈现。
当上述一个或者多个程序被该电子设备执行时，还使得该电子设备：响应于创建目标公式，确定目标公式的参数，其中，目标公式用于在引用文档中引用被引用文档中的内容，参数包括被引用文档的标识和引用区域的标识；利用第一目标信息，生成目标公式的标识令牌，其中，第一目标信息包括目标用户的用户标识、引用文档的标识、被引用文档的标识和引用区域的标识，目标用户为创建目标公式的用户；基于标识令牌和第一目标信息，在引用文档中呈现引用区域的内容；响应于检测到更新指令，获取目标公式引用的最新数据，其中，更新指令用于对引用区域的内容进行更新；利用最新数据，对目标公式所引用的内容进行更新。
当上述一个或者多个程序被该电子设备执行时，还使得该电子设备：响应于接收到用户终端发送的目标公式的标识令牌和目标信息，利用目标公式的标识令牌和目标信息，对目标公式的引用权限进行校验得到第一校验结果，其中，目标公式用于在引用文档中引用被引用文档中的内容，目标信息包括目标用户的用户标识、引用文档的标识、被引用文档的标识和引用区域的标识，目标用户为创建目标公式的用户；将第一校验结果返回给用户终端。
可以以一种或多种程序设计语言或其组合来编写用于执行本公开的实施例的操作的计算机程序代码，所述程序设计语言包括面向对象的程序设计语言—诸如Java、Smalltalk、C++，还包括常规的过程式程序设计语言—诸如“C”语言或类似的程序设计语言。程序代码可以完全地在用户计算机上执行、部分地在用户计算机上执行、作为一个独立的软件包执行、部分在用户计算机上部分在远程计算机上执行、或者完全在远程计算机或服务器上执行。在涉及远程计算机的情形中， 远程计算机可以通过任意种类的网络——包括局域网(LAN)或广域网(WAN)——连接到用户计算机，或者，可以连接到外部计算机(例如利用因特网服务提供商来通过因特网连接)。
附图中的流程图和框图，图示了按照本公开各种实施例的系统、方法和计算机程序产品的可能实现的体系架构、功能和操作。在这点上，流程图或框图中的每个方框可以代表一个模块、程序段、或代码的一部分，该模块、程序段、或代码的一部分包含一个或多个用于实现规定的逻辑功能的可执行指令。也应当注意，在有些作为替换的实现中，方框中所标注的功能也可以以不同于附图中所标注的顺序发生。例如，两个接连地表示的方框实际上可以基本并行地执行，它们有时也可以按相反的顺序执行，这依所涉及的功能而定。也要注意的是，框图和/或流程图中的每个方框、以及框图和/或流程图中的方框的组合，可以用执行规定的功能或操作的专用的基于硬件的系统来实现，或者可以用专用硬件与计算机指令的组合来实现。
描述于本公开的实施例中所涉及到的单元可以通过软件的方式实现，也可以通过硬件的方式来实现。所描述的单元也可以设置在处理器中，例如，可以描述为：一种处理器包括确定单元、生成单元、第一接收单元和第一呈现单元，还可以描述为：一种处理器包括第一校验单元和第一返回单元。其中，这些单元的名称在某种情况下并不构成对该单元本身的限定，例如，第一呈现单元还可以被描述为“基于第一校验结果，在引用文档中进行信息呈现的单元”。
以上描述仅为本公开的较佳实施例以及对所运用技术原理的说明。本领域技术人员应当理解，本公开的实施例中所涉及的发明范围，并不限于上述技术特征的特定组合而成的技术方案，同时也应涵盖在不脱离上述发明构思的情况下，由上述技术特征或其等同特征进行任意组合而形成的其它技术方案。例如上述特征与本公开的实施例中公开的(但不限于)具有类似功能的技术特征进行互相替换而形成的技术方案。

Claims (48)

  1. 一种信息引用方法，其特征在于，包括：
    响应于创建目标公式，确定所述目标公式的参数，其中，所述目标公式用于在引用文档中引用被引用文档中的内容，所述参数包括所述被引用文档的标识和引用区域的标识；
    利用第一目标信息，生成所述目标公式的标识令牌，其中，所述第一目标信息包括目标用户的用户标识、所述引用文档的标识、所述被引用文档的标识和所述引用区域的标识，所述目标用户为创建所述目标公式的用户；
    接收基于第二目标信息返回的第一校验结果，其中，所述第二目标信息包括所述标识令牌和所述第一目标信息；
    基于所述第一校验结果，在所述引用文档中进行信息呈现。
  2. 根据权利要求1所述的方法，其特征在于，所述方法还包括：
    响应于检测到更新指令，利用所述更新指令中的待更新的目标公式的标识令牌，获取所述待更新的目标公式引用的最新数据，其中，所述更新指令用于对当前呈现的文档中目标公式所引用的内容进行更新；
    利用所述最新数据，对当前呈现的文档中所述待更新的目标公式所引用的内容进行更新。
  3. 根据权利要求2所述的方法，其特征在于，所述更新指令是通过如下方式生成的：
    响应于检测到当前时间为预设时间，生成更新指令。
  4. 根据权利要求1所述的方法，其特征在于，若所述第一校验结果表征校验成功，所述第一校验结果包括所述被引用文档中所述引用区域的区域内容；以及
    所述基于所述第一校验结果，在所述引用文档中进行信息呈现， 包括：
    在所述引用文档中呈现所述区域内容。
  5. 根据权利要求1所述的方法，其特征在于，所述接收基于第二目标信息返回的第一校验结果，包括：
    将第二目标信息发送给目标服务器，其中，所述目标服务器基于所述第二目标信息，生成以及返回第一校验结果。
  6. 根据权利要求5所述的方法，其特征在于，所述方法还包括：
    响应于检测到对当前呈现的文档中的目标公式引用的内容进行查看，获取查看用户的用户标识和所查看的目标公式的标识令牌；
    向所述目标服务器发送所述查看用户的用户标识和所述所查看的目标公式的标识令牌，接收所述目标服务器返回的第二校验结果，其中，所述第二校验结果表征所述查看用户是否具有对所查看的目标公式引用的内容进行查看的权限；
    基于所述第二校验结果，在所述当前呈现的文档中进行信息呈现。
  7. 根据权利要求6所述的方法，其特征在于，若所述第二校验结果表征所述查看用户具有对所查看的目标公式引用的内容进行查看的权限，所述第二校验结果包括所述查看用户所查看的目标公式引用的内容；以及
    所述基于所述第二校验结果，在所述当前呈现的文档中进行信息呈现，包括：
    在所述当前呈现的文档中呈现所述查看用户所查看的目标公式引用的内容。
  8. 根据权利要求5所述的方法，其特征在于，所述方法还包括：
    响应于检测到用户针对目标公式执行目标操作，向所述目标服务器发送目标指令，其中，所述目标操作包括修改操作或删除操作，所述目标指令包括对所述目标操作所针对的目标公式的修改指令或删除 指令。
  9. 根据权利要求1所述的方法，其特征在于，所述方法还包括：
    响应于接收到权限撤回指令，利用所述权限撤回指令中失效的目标公式的标识令牌，对当前呈现的文档中所述失效的目标公式所引用的内容进行撤回，其中，所述权限撤回指令包括所述失效的目标公式的标识令牌，所述权限撤回指令用于对所述失效的目标公式的引用权限进行撤回。
  10. 根据权利要求9所述的方法，其特征在于，在所述对当前呈现的文档中所述失效的目标公式所引用的内容进行撤回之后，所述方法还包括：
    呈现提示信息，所述提示信息用于提示重新对所述失效的目标公式的引用权限进行校验。
  11. 根据权利要求1所述的方法，其特征在于，所述第二目标信息还包括同步样式标识，所述同步样式标识用于表征在所述引用文档中引用所述引用区域的内容时是否对所述引用区域的样式进行同步。
  12. 根据权利要求1所述的方法，其特征在于，所述第一校验结果包括表征所述目标用户是否具有对被引用文档中的内容进行引用的权限的校验结果。
  13. 根据权利要求1所述的方法，其特征在于，所述第一校验结果还包括对所述第一目标信息的合法性的校验结果。
  14. 根据权利要求1所述的方法，其特征在于，所述目标公式包括复制函数、表格链接和引用区域的标识，其中，所述复制函数用于将被引用表格中的内容复制到引用表格中，所述表格链接为所述被引用表格的链接。
  15. 根据权利要求1所述的方法，其特征在于，所述引用文档或被引用文档包括电子表格文档、在线表格文档、或在线数据库表格文档中的一种。
  16. 一种信息引用方法，其特征在于，包括：
    响应于创建目标公式，确定所述目标公式的参数，其中，所述目标公式用于在引用文档中引用被引用文档中的内容，所述参数包括所述被引用文档的标识和引用区域的标识；
    利用第一目标信息，生成所述目标公式的标识令牌，其中，所述第一目标信息包括目标用户的用户标识、所述引用文档的标识、所述被引用文档的标识和所述引用区域的标识，所述目标用户为创建所述目标公式的用户；
    基于所述标识令牌和所述第一目标信息，在所述引用文档中呈现所述引用区域的内容；
    响应于检测到更新指令，获取所述目标公式引用的最新数据，其中，所述更新指令用于对所述引用区域的内容进行更新；
    利用所述最新数据，对所述目标公式所引用的内容进行更新。
  17. 一种信息引用方法，其特征在于，包括：
    响应于接收到用户终端发送的目标公式的标识令牌和目标信息，利用所述目标公式的标识令牌和所述目标信息，对所述目标公式的引用权限进行校验得到第一校验结果，其中，所述目标公式用于在引用文档中引用被引用文档中的内容，所述目标信息包括目标用户的用户标识、所述引用文档的标识、所述被引用文档的标识和引用区域的标识，所述目标用户为创建所述目标公式的用户；
    将所述第一校验结果返回给所述用户终端。
  18. 根据权利要求17所述的方法，其特征在于，若所述第一校验结果表征校验成功，所述第一校验结果包括所述被引用文档中所述引 用区域的区域内容；以及
    所述方法还包括：
    将所述目标公式的标识令牌与所述目标信息进行关联存储。
  19. 根据权利要求17所述的方法，其特征在于，所述方法还包括：
    响应于接收到用户终端发送的针对所述引用区域的更改指令，利用所述更改指令中的更改的文档的标识和更改区域，查询对应的待变更文档的标识和待更新的目标公式的标识令牌；
    利用所述待变更文档的标识，向第一目标用户终端发送更新指令，其中，所述第一目标用户终端为当前呈现的文档为所述待变更文档的用户终端，所述更新指令包括所述待更新的目标公式的标识令牌。
  20. 根据权利要求17所述的方法，其特征在于，所述方法还包括：
    响应于接收到查看用户的用户标识和所查看的目标公式的标识令牌，利用所述查看用户的用户标识和所述所查看的目标公式的标识令牌进行校验得到第二校验结果，其中，所述第二校验结果表征所述查看用户是否具有对所查看的目标公式引用的内容进行查看的权限；
    将所述第二校验结果返回给所述查看用户所使用的用户终端。
  21. 根据权利要求20所述的方法，其特征在于，若所述第二校验结果表征所述查看用户具有对所查看的目标公式引用的内容进行查看的权限，所述第二校验结果包括所述查看用户所查看的目标公式引用的内容。
  22. 根据权利要求17所述的方法，其特征在于，所述方法还包括：
    响应于接收到用户终端发送的针对目标公式的目标指令，将所述目标指令所针对的目标公式的标识令牌设置为失效，其中，所述目标指令包括修改指令或删除指令；
    向第二目标用户终端发送权限撤回指令，其中，所述权限撤回指令包括失效的目标公式的标识令牌，所述权限撤回指令用于对所述失 效的目标公式的引用权限进行撤回，所述第二目标用户终端为当前呈现的文档为所述失效的目标公式所在的文档的用户终端。
  23. 根据权利要求17所述的方法，其特征在于，所述目标信息还包括同步样式标识，所述同步样式标识用于表征在所述引用文档中引用所述引用区域的内容时是否对所述引用区域的样式进行同步。
  24. 根据权利要求17所述的方法，其特征在于，所述第一校验结果包括表征所述目标用户是否具有对被引用文档中的内容进行引用的权限的校验结果。
  25. 根据权利要求17所述的方法，其特征在于，所述第一校验结果还包括对所述目标信息的合法性的校验结果。
  26. 根据权利要求17所述的方法，其特征在于，所述目标公式包括复制函数、表格链接和引用区域的标识，其中，所述复制函数用于将被引用表格中的内容复制到引用表格中，所述表格链接为所述被引用表格的链接。
  27. 根据权利要求17所述的方法，其特征在于，所述引用文档或被引用文档包括电子表格文档、在线表格文档、或在线数据库表格文档中的一种。
  28. 一种信息引用系统，其特征在于，所述系统包括：
    用户终端，用于响应于创建目标公式，确定所述目标公式的参数，利用第一目标信息，生成所述目标公式的标识令牌，将第二目标信息发送给服务器，接收所述服务器返回的第一校验结果，以及基于所述第一校验结果，在所述引用文档中进行信息呈现，其中，所述目标公式用于在引用文档中引用被引用文档中的内容，所述参数包括所述被引用文档的标识和引用区域的标识，所述第一目标信息包括目标用户 的用户标识、所述引用文档的标识、所述被引用文档的标识和所述引用区域的标识，所述目标用户为创建所述目标公式的用户，所述第二目标信息包括所述标识令牌和所述第一目标信息；
    所述服务器，用于响应于接收到所述第二目标信息，利用所述第二目标信息，对所述目标公式的引用权限进行校验得到第一校验结果，将所述第一校验结果返回给所述用户终端。
  29. 根据权利要求28所述的系统，其特征在于，
    所述用户终端，还用于响应于检测到更新指令，利用所述更新指令中的待更新的目标公式的标识令牌，获取所述待更新的目标公式引用的最新数据，以及利用所述最新数据，对当前呈现的文档中所述待更新的目标公式所引用的内容进行更新。
  30. 根据权利要求29所述的系统，其特征在于，所述更新指令是通过如下方式生成的：
    响应于检测到当前时间为预设时间，生成更新指令。
  31. 根据权利要求28所述的系统，其特征在于，若所述第一校验结果表征校验成功，所述第一校验结果包括所述被引用文档中所述引用区域的区域内容；以及
    所述用户终端，还用于在所述引用文档中呈现所述区域内容。
  32. 根据权利要求28所述的系统，其特征在于，
    所述用户终端，还用于响应于检测到对当前呈现的文档中的目标公式引用的内容进行查看，获取查看用户的用户标识和所查看的目标公式的标识令牌，向所述服务器发送所述查看用户的用户标识和所述所查看的目标公式的标识令牌，接收所述服务器返回的第二校验结果，以及基于所述第二校验结果，在所述当前呈现的文档中进行信息呈现，其中，所述第二校验结果表征所述查看用户是否具有对所查看的目标公式引用的内容进行查看的权限；
    所述服务器，还用于响应于接收到所述查看用户的用户标识和所述所查看的目标公式的标识令牌，利用所述查看用户的用户标识和所述所查看的目标公式的标识令牌进行校验得到第二校验结果，以及将所述第二校验结果返回给所述查看用户所使用的用户终端。
  33. 根据权利要求32所述的系统，其特征在于，若所述第二校验结果表征所述查看用户具有对所查看的目标公式引用的内容进行查看的权限，所述第二校验结果包括所述查看用户所查看的目标公式引用的内容；以及
    所述用户终端，还用于在所述当前呈现的文档中呈现所述查看用户所查看的目标公式引用的内容。
  34. 根据权利要求28所述的系统，其特征在于，
    所述用户终端，还用于响应于检测到用户针对目标公式执行目标操作，向所述服务器发送目标指令，其中，所述目标操作包括修改操作或删除操作，所述目标指令包括对所述目标操作所针对的目标公式的修改指令或删除指令；
    所述服务器，还用于响应于接收到所述目标指令，将所述目标指令所针对的目标公式的标识令牌设置为失效，向第二目标用户终端发送权限撤回指令，其中，所述权限撤回指令包括失效的目标公式的标识令牌，所述权限撤回指令用于对所述失效的目标公式的引用权限进行撤回，所述第二目标用户终端为当前呈现的文档为所述失效的目标公式所在的文档的用户终端。
  35. 根据权利要求28所述的系统，其特征在于，
    所述用户终端，还用于响应于接收到权限撤回指令，利用所述权限撤回指令中失效的目标公式的标识令牌，对当前呈现的文档中所述失效的目标公式所引用的内容进行撤回，其中，所述权限撤回指令包括所述失效的目标公式的标识令牌，所述权限撤回指令用于对所述失效的目标公式的引用权限进行撤回。
  36. 根据权利要求35所述的系统，其特征在于，
    所述用户终端，还用于呈现提示信息，所述提示信息用于提示重新对所述失效的目标公式的引用权限进行校验。
  37. 根据权利要求28所述的系统，其特征在于，所述第二目标信息还包括同步样式标识，所述同步样式标识用于表征在所述引用文档中引用所述引用区域的内容时是否对所述引用区域的样式进行同步。
  38. 根据权利要求28所述的系统，其特征在于，所述第一校验结果包括表征所述目标用户是否具有对被引用文档中的内容进行引用的权限的校验结果。
  39. 根据权利要求28所述的系统，其特征在于，所述第一校验结果还包括对所述第一目标信息的合法性的校验结果。
  40. 根据权利要求28所述的系统，其特征在于，若所述第一校验结果表征校验成功，所述第一校验结果包括所述被引用文档中所述引用区域的区域内容；以及
    所述服务器，还用于将所述目标公式的标识令牌与所述目标信息进行关联存储。
  41. 根据权利要求28所述的系统，其特征在于，
    所述服务器，还用于响应于接收到用户终端发送的针对所述引用区域的更改指令，利用所述更改指令中的更改的文档的标识和更改区域，查询对应的待变更文档的标识和待更新的目标公式的标识令牌，以及利用所述待变更文档的标识，向第一目标用户终端发送更新指令，其中，所述第一目标用户终端为当前呈现的文档为所述待变更文档的用户终端，所述更新指令包括所述待更新的目标公式的标识令牌。
  42. 根据权利要求28所述的系统，其特征在于，所述目标公式包括复制函数、表格链接和引用区域的标识，其中，所述复制函数用于将被引用表格中的内容复制到引用表格中，所述表格链接为所述被引用表格的链接。
  43. 根据权利要求28所述的系统，其特征在于，所述引用文档或被引用文档包括电子表格文档、在线表格文档、或在线数据库表格文档中的一种。
  44. 一种信息引用装置，其特征在于，包括：
    确定单元，用于响应于创建目标公式，确定所述目标公式的参数，其中，所述目标公式用于在引用文档中引用被引用文档中的内容，所述参数包括所述被引用文档的标识和引用区域的标识；
    生成单元，用于利用第一目标信息，生成所述目标公式的标识令牌，其中，所述第一目标信息包括目标用户的用户标识、所述引用文档的标识、所述被引用文档的标识和所述引用区域的标识，所述目标用户为创建所述目标公式的用户；
    第一接收单元，用于接收基于第二目标信息返回的第一校验结果，其中，所述第二目标信息包括所述标识令牌和所述第一目标信息；
    第一呈现单元，用于基于所述第一校验结果，在所述引用文档中进行信息呈现。
  45. 一种信息引用装置，其特征在于，包括：
    确定单元，用于响应于创建目标公式，确定所述目标公式的参数，其中，所述目标公式用于在引用文档中引用被引用文档中的内容，所述参数包括所述被引用文档的标识和引用区域的标识；
    生成单元，用于利用第一目标信息，生成所述目标公式的标识令牌，其中，所述第一目标信息包括目标用户的用户标识、所述引用文档的标识、所述被引用文档的标识和所述引用区域的标识，所述目标用户为创建所述目标公式的用户；
    呈现单元，用于基于所述标识令牌和所述第一目标信息，在所述引用文档中呈现所述引用区域的内容；
    获取单元，用于响应于检测到更新指令，获取所述目标公式引用的最新数据，其中，所述更新指令用于对所述引用区域的内容进行更新；
    更新单元，用于利用所述最新数据，对所述目标公式所引用的内容进行更新。
  46. 一种信息引用装置，其特征在于，包括：
    第一校验单元，用于响应于接收到用户终端发送的目标公式的标识令牌和目标信息，利用所述目标公式的标识令牌和所述目标信息，对所述目标公式的引用权限进行校验得到第一校验结果，其中，所述目标公式用于在引用文档中引用被引用文档中的内容，所述目标信息包括目标用户的用户标识、所述引用文档的标识、所述被引用文档的标识和引用区域的标识，所述目标用户为创建所述目标公式的用户；
    第一返回单元，用于将所述第一校验结果返回给所述用户终端。
  47. 一种电子设备，其特征在于，包括：
    一个或多个处理器；
    存储装置，其上存储有一个或多个程序，
    当所述一个或多个程序被所述一个或多个处理器执行，使得所述一个或多个处理器实现如权利要求1-15、16、17-27中任一所述的方法。
  48. 一种计算机可读介质，其上存储有计算机程序，其特征在于，该程序被处理器执行时实现如权利要求1-15、16、17-27中任一所述的方法。
PCT/CN2022/103826 2021-07-06 2022-07-05 信息引用方法、系统、装置和电子设备 Ceased WO2023280145A1 (zh)

Priority Applications (1)

Application Number Priority Date Filing Date Title
US18/518,048 US20240086632A1 (en) 2021-07-06 2023-11-22 Methods, system, apparatuses and electronic device for information referencing

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN202110765142.7A CN113361231B (zh) 2021-07-06 2021-07-06 信息引用方法、系统、装置和电子设备
CN202110765142.7 2021-07-06

Related Child Applications (1)

Application Number Title Priority Date Filing Date
US18/518,048 Continuation US20240086632A1 (en) 2021-07-06 2023-11-22 Methods, system, apparatuses and electronic device for information referencing

Publications (1)

Publication Number Publication Date
WO2023280145A1 true WO2023280145A1 (zh) 2023-01-12

Family

ID=77538432

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2022/103826 Ceased WO2023280145A1 (zh) 2021-07-06 2022-07-05 信息引用方法、系统、装置和电子设备

Country Status (3)

Country Link
US (1) US20240086632A1 (zh)
CN (1) CN113361231B (zh)
WO (1) WO2023280145A1 (zh)

Families Citing this family (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113361231B (zh) * 2021-07-06 2024-05-28 北京字跳网络技术有限公司 信息引用方法、系统、装置和电子设备
CN114417789B (zh) * 2021-12-23 2026-04-24 武汉金山办公软件有限公司 一种数据引用方法、装置、电子设备及存储介质
CN114997832A (zh) * 2022-06-15 2022-09-02 平安银行股份有限公司 金融数据线下采集方法、计算机设备及存储介质
CN115658105A (zh) * 2022-10-21 2023-01-31 平安科技（深圳）有限公司 数据关联更新的方法、装置、计算机设备和存储介质
CN115544981A (zh) * 2022-10-31 2022-12-30 北京字跳网络技术有限公司 文档处理方法、装置、电子设备、存储介质及程序产品

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20050034060A1 (en) * 2000-06-21 2005-02-10 Microsoft Corporation User interface for integrated spreadsheets and word processing tables
US20080172597A1 (en) * 2007-01-16 2008-07-17 Siemens Medical Solutions Usa, Inc. Data Field Referencing Text Processing System
CN109684616A (zh) * 2018-12-13 2019-04-26 山东浪潮通软信息科技有限公司 动态报表公式组装填报的方法及系统
CN109829144A (zh) * 2018-12-28 2019-05-31 陈德芹 一种在线表格跨表引用方法及装置
CN113032633A (zh) * 2021-04-15 2021-06-25 内蒙古金财信息技术有限公司 一种利用引用数据项自定义表格的方法
CN113361231A (zh) * 2021-07-06 2021-09-07 北京字跳网络技术有限公司 信息引用方法、系统、装置和电子设备

Family Cites Families (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH06110763A (ja) * 1992-09-30 1994-04-22 Toshiba Corp ファイルシステム
JP2001051905A (ja) * 1999-08-16 2001-02-23 Hitachi Ltd 秘密文書の複写を制限するシステム
JP3857078B2 (ja) * 2001-06-29 2006-12-13 富士通株式会社 情報提供方法及び情報提供装置
CN101226573B (zh) * 2007-01-16 2011-01-12 北京书生国际信息技术有限公司 一种控制电子文档的访问权限的方法
CN101030857A (zh) * 2007-04-10 2007-09-05 华东师范大学 细粒度的文档加密保护控制方法
CN101561826B (zh) * 2009-05-18 2011-03-16 汤胤 基于节点粒度语义的在线非结构化文档共享协同方法及其应用
US9606972B2 (en) * 2011-11-09 2017-03-28 Microsoft Technology Licensing, Llc Document collaboration with collaboration context data
CN103578073A (zh) * 2013-11-25 2014-02-12 方正国际软件有限公司 信息引用装置和信息引用方法
US10275430B2 (en) * 2015-06-29 2019-04-30 Microsoft Technology Licensing, Llc Multimodal sharing of content between documents
US11030390B2 (en) * 2016-01-11 2021-06-08 Microsoft Technology Licensing, Llc Sharing content between electronic documents
JP7153725B2 (ja) * 2017-12-03 2022-10-14 スタフラ，トーマス スプレッドシートに基づくソフトウェアアプリケーションの開発
CN111858518B (zh) * 2020-07-09 2022-10-25 北京字节跳动网络技术有限公司 一种引用文档的更新方法、装置、电子设备及存储介质
CN112528595B (zh) * 2020-12-15 2023-05-09 北京字跳网络技术有限公司 文档处理方法、装置和电子设备

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20050034060A1 (en) * 2000-06-21 2005-02-10 Microsoft Corporation User interface for integrated spreadsheets and word processing tables
US20080172597A1 (en) * 2007-01-16 2008-07-17 Siemens Medical Solutions Usa, Inc. Data Field Referencing Text Processing System
CN109684616A (zh) * 2018-12-13 2019-04-26 山东浪潮通软信息科技有限公司 动态报表公式组装填报的方法及系统
CN109829144A (zh) * 2018-12-28 2019-05-31 陈德芹 一种在线表格跨表引用方法及装置
CN113032633A (zh) * 2021-04-15 2021-06-25 内蒙古金财信息技术有限公司 一种利用引用数据项自定义表格的方法
CN113361231A (zh) * 2021-07-06 2021-09-07 北京字跳网络技术有限公司 信息引用方法、系统、装置和电子设备

Also Published As

Publication number Publication date
CN113361231B (zh) 2024-05-28
CN113361231A (zh) 2021-09-07
US20240086632A1 (en) 2024-03-14

Similar Documents

Publication Publication Date Title
WO2023280145A1 (zh) 信息引用方法、系统、装置和电子设备
US12339965B2 (en) Malware detection and content item recovery
KR102182906B1 (ko) 동기화 통신에서의 서버 인증서 에러의 보안 처리 기법
US9141711B2 (en) Persisting annotations within a cobrowsing session
US12474923B2 (en) Model construction method and apparatus, and medium and electronic device
US10362013B2 (en) Out of box experience application API integration
US8200962B1 (en) Web browser extensions
KR102556741B1 (ko) 서로 다른 파티들 사이에서 객체들을 추적하는 기법
US20130054976A1 (en) Lightweight document access control using access control lists in the cloud storage or on the local file system
CN112131181B (zh) 存储路径的展示方法、装置以及电子设备
CN110555293A (zh) 用于保护数据的方法、装置、电子设备和计算机可读介质
CN110502488A (zh) 在线文档的处理方法、装置、终端及存储介质
US12361152B2 (en) Information processing method and apparatus, terminal, and storage medium
US20140164773A1 (en) Offline data access using trusted hardware
CN115712597A (zh) 信息处理方法、装置、电子设备和存储介质
CN116244022A (zh) 评论处理方法、装置、电子设备和存储介质
CN120743252A (zh) 一种基于mcp的模型工具调用的可视化编排方法
CN112181975B (zh) 用于在数据仓库中创建数据库的方法和装置
CN119377976A (zh) 数据处理方法、设备及计算机存储介质
CN118690400A (zh) 数据处理方法、装置、计算机设备、存储介质及产品
CN113950677B (zh) 子范围同步
CN115934640B (zh) 一种数据存储方法、系统、电子设备及存储介质
CN115079873A (zh) 信息显示方法、装置、电子设备和存储介质
CN111814063B (zh) 基于区块链的媒介信息处理方法、装置、设备和介质
CN119783168A (zh) 基于Web Restful API的数据交换方法

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 22836896

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 22836896

Country of ref document: EP

Kind code of ref document: A1