CN112307731A - Cross-form reference method and device, server and client device - Google Patents
Cross-form reference method and device, server and client device Download PDFInfo
- Publication number
- CN112307731A CN112307731A CN201910640628.0A CN201910640628A CN112307731A CN 112307731 A CN112307731 A CN 112307731A CN 201910640628 A CN201910640628 A CN 201910640628A CN 112307731 A CN112307731 A CN 112307731A
- Authority
- CN
- China
- Prior art keywords
- client
- server
- address information
- webpage client
- notification
- 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.)
- Granted
Links
- 238000007430 reference method Methods 0.000 title claims abstract description 24
- 238000000034 method Methods 0.000 claims abstract description 51
- 238000004891 communication Methods 0.000 claims description 31
- 238000004590 computer program Methods 0.000 claims description 14
- 230000003993 interaction Effects 0.000 description 13
- 238000010586 diagram Methods 0.000 description 6
- 230000008569 process Effects 0.000 description 6
- 230000009471 action Effects 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 238000001514 detection method Methods 0.000 description 2
- 238000004364 calculation method Methods 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000007257 malfunction Effects 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
Images
Landscapes
- Information Transfer Between Computers (AREA)
Abstract
The embodiment of the invention provides a cross-form reference method, a cross-form reference device, a server and client equipment, wherein the cross-form reference method is applied to the server, the server is communicated with the client equipment, a first webpage client and a second webpage client which correspond to the server are operated in the client equipment, the first webpage client is used for presenting a first online electronic form, and the second webpage client is used for presenting a second online electronic form; the method comprises the following steps: after receiving a first state notification which is sent by a first webpage client and used for indicating that a first online spreadsheet enters a formula editing state, sending a data reference notification to a second webpage client; receiving address information sent by a second webpage client; upon receiving a first switch notification indicating that the first online spreadsheet is switched to foreground operation, sending address information to the first webpage client. By the scheme, the problem of inconvenient operation when cross-form reference is carried out among online electronic forms in the prior art can be solved.
Description
Technical Field
The invention relates to the technical field of office software, in particular to a cross-form reference method, a cross-form reference device, a cross-form reference server and client equipment.
Background
The electronic form is a very important software in office automation, and data management is carried out by means of the electronic form, so that the processing and calculation of data are greatly facilitated.
Spreadsheets can be divided into client-side spreadsheets and online spreadsheets. In the process of using spreadsheets to make reports, situations are often encountered where it is necessary to reference other spreadsheet data, i.e., cross-form references. So-called cross-table references specifically refer to: and realizing data reference in the reference areas of other electronic forms by filling address information of the reference areas of other electronic forms in the cells of the current electronic form entering the editing state, wherein the reference areas are the cells in which the data to be referenced are located.
Existing client-side spreadsheets can implement cross-sheet referencing directly.
Take two client-side spreadsheets as an example, one of which is an original and complete staff information summary (hereinafter referred to as table 1), and the other is a prize-winning staff list summary (hereinafter referred to as table 2) to be made. In the process of making the table 2, if the data in the table 1 needs to be referred to, only the table 1 and the table 2 need to be opened at the same time; in the process of inputting the formula in the table 2, switching to the table 1, and selecting the cell where the data to be quoted is located in the table 1, namely the quoted area; and then switching back to the table 2, and automatically filling the address information of the reference area into the cursor position of the formula in the table 2 to realize cross-table reference.
However, existing online spreadsheets do not implement cross-form referencing in the manner described above. The reason is that each online spreadsheet is an independent webpage, and the online spreadsheet to be edited cannot know the states of other spreadsheets, and further cannot adjust the online spreadsheet to be edited according to the states of other spreadsheets.
Therefore, in the prior art, cross-form reference between online electronic forms can be realized only by manually inputting address information of a reference area. However, the address information of the reference area is a long string of characters, such as: the network address of the online spreadsheet, the name of the worksheet, and the cell number of the reference region, which clearly results in a very inconvenient operation.
Disclosure of Invention
The embodiment of the invention aims to provide a cross-form reference method, a cross-form reference device, a server and client equipment, so as to solve the problem of inconvenient operation when cross-form reference is carried out among online electronic forms in the prior art. The specific technical scheme is as follows:
in a first aspect, an embodiment of the present invention provides a cross-form reference method, which is applied to a server, where the server communicates with a client device, where a first web client and a second web client corresponding to the server run in the client device, the first web client is used to present a first online spreadsheet, and the second web client is used to present a second online spreadsheet; the method comprises the following steps:
after receiving a first state notification which is sent by the first webpage client and used for indicating that the first online electronic form enters a formula editing state, sending a data reference notification to the second webpage client so as to enable the second webpage client to be in foreground operation, determining a reference area in the second online electronic form, and sending address information of the reference area to the server; wherein the reference area is a cell in a selected state;
receiving the address information sent by the second webpage client;
and after receiving a first switching notification for indicating that the first webpage client is switched to the foreground operation, sending the address information to the first webpage client so that the first webpage client fills the address information in the cursor position in the first online electronic form.
Optionally, before the step of sending a data reference notification to the second web client, the method further comprises:
and detecting whether a second switching notification for indicating that the second webpage client is switched to foreground operation is received or not, and if so, executing the step of sending the data reference notification to the second webpage client.
Optionally, the step of receiving the address information sent by the second web client includes:
receiving a plurality of address information sent by the second webpage client;
the step of sending the address information to the first web page client after receiving a first switching notification indicating that the first web page client is switched to foreground operation includes:
and after receiving a first switching notification for indicating that the first webpage client is switched to the foreground operation, determining the last received address information from the received plurality of address information, and sending the last received address information to the first webpage client.
Optionally, after the step of sending the address information to the first web client, the method further includes:
and clearing the address information.
Optionally, after the step of clearing the address information, the method further includes:
and clearing the first state notification after receiving a second state notification which is sent by the first webpage client and used for indicating that the first online spreadsheet exits the formula editing state.
In a second aspect, an embodiment of the present invention provides another cross-form reference method, which is applied to a second web client, where the second web client and a first web client correspond to a server and are located in the same client device, the first web client is used to present a first online spreadsheet, and the second web client is used to present a second online spreadsheet; the method comprises the following steps:
receiving a data reference notification sent by the server, wherein the data reference notification is: the server sends a first state notification which is sent by a first webpage client and used for indicating that the first online spreadsheet enters a formula editing state;
after receiving the data reference notification sent by the server, when the second webpage client is in foreground operation, determining a reference area in the second online spreadsheet; wherein the reference area is a cell in a selected state;
sending address information of the reference area to the server, so that the server sends the address information to the first webpage client after receiving a first switching notification for indicating that the first webpage client is switched to a foreground for operation; and after receiving the address information, the first webpage client fills the address information in the cursor position in the first online electronic form.
Optionally, before the step of receiving the data reference notification sent by the server, the method further includes:
and when the second webpage client is switched to foreground operation, sending a second switching notification for indicating that the second webpage client is switched to foreground operation to the server, so that the server sends the data reference notification to the second webpage client if the second switching notification is detected after receiving the first state notification.
Optionally, before the step of sending the address information of the reference area to the server, the method further includes:
generating an information sending button on an interface of the second online electronic form after receiving the data reference notification sent by the server;
the step of sending the address information of the reference area to the server includes:
and when an information sending instruction sent by a user based on the information sending button is received, sending the address information to the server.
In a third aspect, an embodiment of the present invention provides a cross-form referencing apparatus, which is applied to a server, where the server is in communication with a client device, where a first web client and a second web client corresponding to the server run in the client device, the first web client is used to present a first online spreadsheet, and the second web client is used to present a second online spreadsheet; the device comprises:
a reference notification sending module, configured to send a data reference notification to the second web page client after receiving a first state notification that is sent by the first web page client and used to indicate that the first online spreadsheet enters a formula editing state, so that when the second web page client is in foreground operation, a reference area in the second online spreadsheet is determined, and address information of the reference area is sent to the server; wherein the reference area is a cell in a selected state;
the address information receiving module is used for receiving the address information sent by the second webpage client;
and the first address information sending module is used for sending the address information to the first webpage client after receiving a first switching notification for indicating that the first webpage client is switched to the foreground operation, so that the first webpage client fills the address information in the cursor position in the first online electronic form.
In a fourth aspect, an embodiment of the present invention further provides another cross-form referencing apparatus, which is applied to a second web client, where the second web client and the first web client correspond to a server and are located in the same client device, the first web client is used to present a first online spreadsheet, and the second web client is used to present a second online spreadsheet; the device comprises:
a reference notification receiving module, configured to receive a data reference notification sent by the server, where the data reference notification is: the server sends a first state notification which is sent by a first webpage client and used for indicating that the first online spreadsheet enters a formula editing state;
a reference area determination module, configured to determine, after receiving the data reference notification sent by the server, a reference area in the second online spreadsheet when the second webpage client is in foreground operation; wherein the reference area is a cell in a selected state;
a second address information sending module, configured to send address information of the reference region to the server, so that the server sends the address information to the first web page client after receiving a first switching notification indicating that the first web page client switches to foreground operation; and after receiving the address information, the first webpage client fills the address information in the cursor position in the first online electronic form.
In a fifth aspect, an embodiment of the present invention further provides a server, where the server includes a processor, a communication interface, a memory, and a communication bus, where the processor and the communication interface complete communication between the memory and the processor through the communication bus;
a memory for storing a computer program;
and the processor is used for realizing the cross-table reference method of the first aspect when executing the program stored in the memory.
In a sixth aspect, an embodiment of the present invention further provides a client device, where the client device includes a processor, a communication interface, a memory, and a communication bus, where the processor and the communication interface complete communication between the memory and the processor through the communication bus;
a memory for storing a computer program;
and the processor is used for realizing the cross-table reference method of the second aspect when executing the program stored in the memory.
In a seventh aspect, an embodiment of the present invention further provides a computer-readable storage medium, where a computer program is stored in the computer-readable storage medium, and when the computer program is executed by a processor, the cross-table referencing method according to the first aspect is implemented.
In an eighth aspect, the embodiment of the present invention further provides another computer-readable storage medium, where a computer program is stored in the computer-readable storage medium, and when the computer program is executed by a processor, the cross-table referencing method according to the second aspect is implemented.
In the scheme provided by the embodiment of the invention, when the first online spreadsheet enters a formula editing state, the first webpage client reports the state to the server; the server responds to the report state and sends a data reference notice to the second webpage client so as to enable the second webpage client to report the address information of the reference area specified by the user when the second webpage client is in foreground operation; and when the server knows that the first webpage client side is switched to the foreground operation, the server issues the address information to the first webpage client side, and the first webpage client side fills the address information in the cursor position in the first online electronic form to complete cross-form reference among the online electronic forms. Therefore, according to the scheme, a user can realize automatic cross-form reference between the online spreadsheets through the interaction between the first webpage client and the server and the interaction between the second webpage client and the server only by completing the switching operation between the online spreadsheets and the selection operation of the reference area. Therefore, the problem of inconvenient operation when cross-form reference is carried out among online electronic forms in the prior art can be solved through the scheme. In addition, because the address information of the area to be referred does not need to be manually input, the probability of reference errors can be greatly reduced.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a flow diagram of a cross-table referencing method provided from a server perspective by an embodiment of the invention;
FIG. 2 is a flowchart of a cross-table reference method provided by a client device perspective of an embodiment of the present invention;
FIG. 3 is a three-terminal interaction timing diagram of a cross-table reference method according to an embodiment of the present invention;
FIG. 4 is a schematic structural diagram of a cross-table referencing apparatus provided from a server perspective according to an embodiment of the present invention;
FIG. 5 is a schematic structural diagram of a cross-table referencing apparatus provided from the perspective of a client device according to an embodiment of the present invention;
fig. 6 is a schematic structural diagram of a server according to an embodiment of the present invention;
fig. 7 is a schematic structural diagram of a client device according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
In order to solve the problem of inconvenient operation when cross-table reference is performed among online electronic forms in the prior art, the embodiment of the invention provides a cross-table reference method, a cross-table reference device, a server and client equipment.
The following first introduces a cross-table reference method provided by the embodiment of the present invention.
From the perspective of a server, the embodiment of the invention provides a cross-table reference method.
The server is communicated with the client device, a first webpage client and a second webpage client corresponding to the server are operated in the client device, the first webpage client is used for presenting a first online spreadsheet, and the second webpage client is used for presenting a second online spreadsheet. In addition, the cross-form reference in the embodiment of the present invention is a reference between a first online electronic form and a second online electronic form, where the first online electronic form and the second online electronic form are managed by the same server, that is, the server described above, but are displayed by different web clients, where the first online electronic form is an electronic form that needs to reference contents of other forms, and the second online electronic form is a referenced form.
It is understood that the first web client and the second web client in the client device may be two different browser clients operating in the client device, or two different tab pages of the same browser client, which is reasonable. In addition, "first" in "first web client" and "second" in "second web client" are used only to distinguish different web clients from each other in name, and do not have any limiting meaning; similarly, "first" in "first online spreadsheet" and "second" in "second online spreadsheet" are used only to distinguish different spreadsheets by nomenclature and are not meant in any limiting sense.
As shown in fig. 1, from the perspective of a server, an embodiment of the present invention provides a cross-table reference method, which may include the following steps:
s101, after receiving a first state notification which is sent by the first webpage client and used for indicating that the first online spreadsheet enters a formula editing state, sending a data reference notification to the second webpage client so as to enable the second webpage client to be in foreground operation, determining a reference area in the second online spreadsheet, and sending address information of the reference area to the server; wherein the reference area is a cell in a selected state;
when a user double-clicks on a cell in a first online spreadsheet to enter an edit mode and enters a "═ sign in the cell, then the first online spreadsheet enters a formula edit state. Because there may be a reference to the contents of the second online spreadsheet while in the formula edit state, the first web client for presenting the first online spreadsheet may send a first state notification to the server indicating that the first online spreadsheet entered the formula edit state upon detecting that the first online spreadsheet entered the formula edit state. Correspondingly, after receiving the first state notification sent by the first web client, the server may send a data reference notification to the second web client.
When the user wants to quote the content of the second online spreadsheet, the second webpage client can be switched to the foreground for operation, cells are selected from the second online spreadsheet presented by the second webpage client, and the selected cells are used as a quote area; correspondingly, after receiving the data reference notification sent by the server, the second webpage client can send the address information of the reference area specified by the user on the second online spreadsheet to the server when detecting that the second webpage client is in foreground operation. In addition, it should be noted that, since there may be a case where the user selects the wrong cell, the user may perform multiple selection operations in the second online spreadsheet, so as to obtain the finally selected reference area. And after each time of executing the selection operation, the second webpage client can send the address information of the selected reference area to the server.
It is to be appreciated that the server can forward the first status notification to the second web client as a data reference notification; it is also reasonable that the server generates further notification information as a data reference notification to send to the second web client according to the received first status notification. In practical application, the data reference notification may be flexibly set according to actual needs, that is, the data reference notification may be the same as or different from the first status notification, and is not specifically limited herein. In addition, a second web client, the spreadsheet web client, is for presenting a second online spreadsheet; when the second webpage client is switched to the foreground for operation, the second online electronic form presented by the second webpage client is switched to the foreground. The first web client is similar to this, and will not be described in detail below.
It should be noted that the address information at least includes the network address of the second online spreadsheet in which the reference area is located, the worksheet name, and the cell number of the reference area.
For example: the address information is "[ https:// drive. wps/f _3254845674] Sheet 1'! $ F $6: $ J $19 ", where the network address is https:// drive. wps/F _3254845674, the worksheet name is Sheet1, and the cell number of the referenced region is $ F $6: $ J $ 19.
S102, receiving the address information sent by the second webpage client;
it is to be understood that, when the user selects a plurality of reference areas in the second online spreadsheet presented by the second web client, the step of receiving the address information sent by the second web client may include: receiving a plurality of address information sent by the second webpage client;
for example, if the rectangular region surrounded by cells with the upper left corner being a B2 cell and the lower right corner being a C4 cell is selected by the user as the first reference region, and the rectangular region surrounded by cells with the upper left corner being an F6 cell and the lower right corner being a J19 cell is selected by the user as the second reference region, the address information of the first reference region and the second reference region sent by the second web client is received.
It should be noted that, when receiving the plurality of pieces of address information sent by the second web client, the server may store the plurality of pieces of address information in different manners; one of the possible ways is to store all the address information in time sequence; another way that may be taken is to overwrite the address information received later with the address information received earlier, the final server only storing the last received address information.
And S103, after receiving a first switching notification for indicating that the first webpage client is switched to foreground operation, sending the address information to the first webpage client so that the first webpage client fills the address information in a cursor position in the first online electronic form.
After the user selects the required reference area, the first webpage client can be switched from the second webpage client, namely, the foreground operation of the second webpage client is adjusted to the foreground operation of the first webpage client. When the first online spreadsheet in the first webpage client is in a formula editing state and the first webpage client detects that the first webpage client switches to foreground operation, a first switching notification for indicating that the first webpage client switches to foreground operation can be reported to the server. Correspondingly, after receiving the first switching notification, the server may send the address information to the first web client, so that the first web client fills the address information in the cursor position in the first online electronic form, thereby completing one cross-form reference. It will be appreciated that by cross-form referencing, the first online spreadsheet may be enabled to reference the contents of the referenced area within the second online spreadsheet.
It should be noted that, when the second web page client sends a plurality of pieces of address information, after receiving a first switching notification indicating that the first online spreadsheet is switched to foreground operation, the last received address information is determined from the received plurality of pieces of address information, and the last received address information is sent to the first web page client.
It can be understood that the first switching notification for indicating that the first online spreadsheet is switched to the foreground operation may be sent by the first webpage client or sent by the second webpage client, which is not specifically limited and may be flexibly set according to the actual situation. The following selection of the handover notification transmission subject is the same and will not be described in detail.
In this embodiment, the server sends the data reference notification to the second web client, so that the second web client knows that the first web client enters the formula editing state, and then the second web client sends the address information of the reference area determined by the second web client to the first web client through the server, so that the first web client fills the address information in the cursor of the first online spreadsheet, and cross-form reference between different online spreadsheets is realized. Therefore, in the embodiment, a user can realize automatic cross-form reference between online spreadsheets through the interaction between the first webpage client and the server and the interaction between the second webpage client and the server only by completing the switching operation between the online spreadsheets and the selection operation of the reference area, so that the problem of inconvenient operation when the cross-form reference is performed between the online spreadsheets in the prior art is solved. In addition, compared with the existing mode of manually inputting reference to realize cross-form reference of the online electronic form, the method and the device do not need to manually input the address information of the area to be referenced, and can greatly reduce the probability of reference errors.
Based on the embodiment shown in fig. 1, in order to avoid the server from sending redundant data reference notifications to other web page clients that are not related to references, in another embodiment, the method provided in the embodiment of the present invention may further include, before the step of sending data reference notifications to the second web page client, the following steps:
and detecting whether a second switching notification for indicating that the second webpage client is switched to foreground operation is received or not, and if so, executing the step of sending the data reference notification to the second webpage client.
It can be understood that the server sends the data reference notification to the second web client only after the first or second web client sends the second switching notification to the server, so that the server is effectively prevented from sending redundant data reference notifications to other web clients unrelated to reference. That is to say, in this embodiment, after receiving the data reference notification sent by the first web page client, the server only sends the data reference notification to the second web page client switched to the foreground operation.
Based on the foregoing embodiment, in order to reduce the storage space occupation of the server and avoid the first state notification and the address information stored by the server from causing an error operation to the subsequent reference operation, in another embodiment, the method provided in the embodiment of the present invention may further include, after the step of sending the address information to the first web client, the following steps:
and clearing the address information.
And clearing the first state notification after receiving a second state notification which is sent by the first webpage client and used for indicating that the first online spreadsheet exits the formula editing state.
It can be understood that by adding the step of clearing the address information, after the previous cross-form reference is finished, when the current cross-form reference is carried out, the server can be fundamentally prevented from sending the address information stored in the previous time to the first webpage client again. Similarly, by adding the step of clearing the first state notification, after the previous table crossing reference is finished, when the next table crossing reference is carried out, the server can be fundamentally prevented from sending the first state notification stored in the previous time to the second webpage client by mistake, and the server is prevented from sending the address information determined by the second webpage client to the first webpage client in the previous time by mistake.
Corresponding to the foregoing method, from the perspective of the client device, an embodiment of the present invention further provides a cross-table reference method.
It should be noted that the cross-form referencing method provided in this embodiment is applied to a second web client, where the second web client and the first web client correspond to a server and are located in the same client device, the first web client is used to present a first online spreadsheet, and the second web client is used to present a second online spreadsheet.
As shown in fig. 2, a cross-table reference method provided in an embodiment of the present invention may include the following steps:
s201, receiving a data reference notification sent by the server, wherein the data reference notification is: the server sends a first state notification which is sent by a first webpage client and used for indicating that the first online spreadsheet enters a formula editing state;
s202, after receiving the data reference notification sent by the server, when the second webpage client is in foreground operation, determining a reference area in the second online electronic form; wherein the reference area is a cell in a selected state;
s203, sending the address information of the reference area to the server, so that the server sends the address information of the reference area to the first webpage client after receiving a first switching notification for indicating that the first webpage client is switched to foreground operation; and after receiving the address information, the first webpage client fills the address information in the cursor position in the first online electronic form.
It is understood that, after receiving the data reference notification sent by the server, the second web client automatically sends the address information of the reference area selected by the user to the server.
In this embodiment, the second web client receives the data reference notification sent by the server, so that it is known that the first web client enters the formula editing state, and then the second web client determines the reference area selected by the user on the second online electronic form, and sends the address information of the determined reference area to the first web client through the server, so that the first web client fills the address information in the cursor of the first online electronic form, and cross-form reference between different online electronic forms is realized. Therefore, according to the scheme, a user can realize automatic cross-form reference between the online spreadsheets through the interaction between the first webpage client and the server and the interaction between the second webpage client and the server only by completing the switching operation between the online spreadsheets and the selection operation of the reference area. Therefore, the problem of inconvenient operation when cross-form reference is carried out among online electronic forms in the prior art can be solved through the scheme. In addition, because the address information of the area to be referred does not need to be manually input, the probability of reference errors can be greatly reduced.
In the above embodiment, after receiving the data reference notification sent by the server, the second web client may automatically send the address information of the reference area selected by the user to the server. This automatic transmission method does not provide any indication, and there is a possibility that the address information of the reference area transmitted to the server is not the address information intended by the user when the user has a wrong operation. When the user fails to detect the malfunction, a reference error may be caused.
For example, a user selects an area to be referred to first, the information of the referred area is automatically sent to a server, however, a subsequent user selects a certain area by misoperation, the address information of the area is still automatically sent to the server, and when the user cannot detect the misoperation, the address information of the certain area is the address information of the area to be referred to finally, but the address information of the area to be referred to by the user is not the address information of the area to be referred to by the user, and the reference error finally occurs.
In this case, it is necessary to make the user know and more intuitively understand which address information of the area to be referred to is transmitted to the server. Based on the idea, as shown in fig. 4, an embodiment of the present invention further provides a cross-table reference method, which may include:
receiving a data reference notification sent by the server, wherein the data reference notification is: the server sends a first state notification which is sent by a first webpage client and used for indicating that the first online spreadsheet enters a formula editing state;
after receiving the data reference notification sent by the server, generating an information sending button on an interface of the second online electronic form, and determining a reference area in the second online electronic form when the second webpage client is in foreground operation; wherein the reference area is a cell in a selected state;
it is to be understood that the step of generating an information sending button at the interface of the second online electronic form may be before or after the step of determining the reference area in the second online electronic form. Of course, in order to avoid that the information sending button suddenly appears on the interface of the second online electronic form after the determination of the reference area, and at the same time, in order to facilitate the user operation, it is preferable that the step of generating the information sending button on the interface of the second online electronic form is placed before the step of determining the reference area in the second online electronic form.
When an information sending instruction sent by a user based on the information sending button is received, sending the address information of the reference area to the server, so that the server sends the address information to the first webpage client after receiving a first switching notification for indicating that the first webpage client is switched to a foreground for operation; and after receiving the address information, the first webpage client fills the address information in the cursor position in the first online electronic form.
It can be understood that, after receiving the data reference notification sent by the server, the second web client does not automatically send the address information to the server, but needs to obtain the information sending instruction of the user to send the address information to the server. Therefore, the user can be clearer and more clearly understand the area which the user wants to quote, a mode for sending the address information is additionally provided for the user, the user experience is enriched, and the requirement that the user needs to independently determine which quote the area address information to send is met.
Based on the above embodiment from the perspective of the client device, in order to avoid the server from sending redundant data reference notification information to other web page clients that are not related to reference, in another embodiment, the method provided in the embodiment of the present invention may further include, before the step of receiving the data reference notification sent by the server, the following steps:
and when the second webpage client is switched to foreground operation, sending a second switching notification for indicating that the second webpage client is switched to foreground operation to the server, so that the server sends the data reference notification to the second webpage client if the second switching notification is detected after receiving the first state notification.
It can be understood that, in this embodiment, only after the second web client sends the second switching notification to the server, the server sends the data reference notification to the second web client, so that the server is effectively prevented from sending redundant data reference notification information to other web clients unrelated to reference.
In order to better understand the technical solution of the present invention, how to implement cross-table reference by using the method provided by the embodiment of the present invention is described below with reference to fig. 3.
As shown in fig. 3, the cross-table referencing method provided by the embodiment of the present invention may include the following steps:
step 1) a first webpage client detects that a first online spreadsheet enters a formula editing state;
when a user double-clicks a certain cell in a first online spreadsheet presented by a first webpage client, the certain cell is enabled to enter an editing mode, and a ═ number is input into the cell, the first online spreadsheet enters a formula editing state; the first webpage client obtains information that the first online spreadsheet enters a formula editing state.
Step 2) the first webpage client side sends a first state notification for indicating that the first online spreadsheet enters a formula editing state;
the method comprises the steps that after a first webpage client detects that a first online spreadsheet enters a formula editing state, a first state notification used for indicating that the first online spreadsheet enters the formula editing state is sent to a server.
Step 3) the server detects whether a second switching notice for indicating that the second webpage client is switched to the foreground operation is received, and if so, the next step is executed;
when the user wishes to refer to the content of the second online spreadsheet, the second webpage client can be switched to the foreground for operation; when the second webpage client is switched to the foreground operation, the first webpage client or the second webpage client sends a second switching notification that the second webpage client is switched to the foreground operation to the server; if the server detects the second switching notification after receiving the first state notification, the next step is executed.
Step 4) the server sends a data reference notice for indicating that the first online spreadsheet enters a formula editing state to a second webpage client;
and after receiving a second switching notification for switching the second webpage client to the foreground operation, the server sends a data reference notification for indicating that the first online spreadsheet enters a formula editing state to the second webpage client.
It is to be appreciated that the server can forward the first status notification to the second web client as a data reference notification; it is also reasonable that the server generates further notification information as a data reference notification to send to the second web client according to the received first status notification. In practical application, the data reference notification may be flexibly set according to actual needs, that is, the data reference notification may be the same as or different from the first status notification, and is not specifically limited herein.
Step 5) the second webpage client determines a reference area in the second online spreadsheet;
when the user selects the cell in the second online spreadsheet presented by the second webpage client, the selected cell is the reference area, and the second webpage client determines the reference area.
In addition, it should be noted that, since there may be a case where the user selects the wrong cell, the user may perform multiple selection operations in the second online spreadsheet, so as to obtain multiple reference areas. And after each selection operation is executed, the second webpage client can determine the selected reference area.
Step 6), the second webpage client sends the address information of the reference area to the server;
the second webpage client sends the address information of the determined reference area to the server; and after the user executes the multi-selection operation, the second webpage client side sends the address information of the multi-selected reference area to the server.
Step 7) the server detects whether a first switching notice for indicating that the first webpage client switches to foreground operation is received, and if so, the next step is executed;
when a user switches a first webpage client to foreground operation, the first webpage client or a second webpage client sends a first switching notification that the first webpage client is switched to foreground operation to a server; if the server detects the first switching notification, executing the next step;
step 8) the server sends the address information to the first webpage client;
when the server detects the second switching notification, the server sends the address information to the first webpage client;
step 9) the first webpage client fills the address information in the cursor position in the first online electronic form;
and the first webpage client fills the received address information in the cursor position in the first online electronic form, namely cross-form reference is realized.
In the scheme provided by the embodiment of the invention, when the first online spreadsheet enters a formula editing state, the first webpage client reports the state to the server; the server responds to the report state and sends a data reference notice to the second webpage client so as to enable the second webpage client to report the address information of the reference area specified by the user when the second webpage client is in foreground operation; and when the server knows that the first webpage client side is switched to the foreground operation, the server issues the address information to the first webpage client side, and the first webpage client side fills the address information in the cursor position in the first online electronic form to complete cross-form reference among the online electronic forms. Therefore, according to the scheme, a user can realize automatic cross-form reference between the online spreadsheets through the interaction between the first webpage client and the server and the interaction between the second webpage client and the server only by completing the switching operation between the online spreadsheets and the selection operation of the reference area. Therefore, the problem of inconvenient operation when cross-form reference is carried out among online electronic forms in the prior art can be solved through the scheme. In addition, because the address information of the area to be referred does not need to be manually input, the probability of reference errors can be greatly reduced.
Corresponding to the method embodiment described above, from the perspective of the server, an embodiment of the present invention provides a cross-form referencing apparatus, which is applied to the server, where the server communicates with a client device, the client device runs a first web client and a second web client corresponding to the server, the first web client is used to present a first online spreadsheet, and the second web client is used to present a second online spreadsheet. As shown in fig. 4, the apparatus may include:
a reference notification sending module 401, configured to send a data reference notification to the second web page client after receiving a first state notification that is sent by the first web page client and used to indicate that the first online spreadsheet enters a formula editing state, so that when the second web page client is in foreground operation, a reference area in the second online spreadsheet is determined, and address information of the reference area is sent to the server; wherein the reference area is a cell in a selected state;
an address information receiving module 402, configured to receive the address information sent by the second web client;
a first address information sending module 403, configured to send the address information to the first web client after receiving a first switching notification indicating that the first web client switches to foreground operation, so that the first web client fills the address information in a cursor position in the first online electronic form.
In this embodiment, the server sends the data reference notification to the second web client, so that the second web client knows that the first web client enters the formula editing state, and then the second web client sends the address information of the reference area determined by the second web client to the first web client through the server, so that the first web client fills the address information in the cursor of the first online spreadsheet, and cross-form reference between different online spreadsheets is realized. Therefore, in the embodiment, a user can realize automatic cross-form reference between online spreadsheets through the interaction between the first webpage client and the server and the interaction between the second webpage client and the server only by completing the switching operation between the online spreadsheets and the selection operation of the reference area, so that the problem of inconvenient operation when the cross-form reference is performed between the online spreadsheets in the prior art is solved. In addition, compared with the existing mode of manually inputting reference to realize cross-form reference of the online electronic form, the method and the device do not need to manually input the address information of the area to be referenced, and can greatly reduce the probability of reference errors.
In a possible implementation manner of the present invention, the reference notification sending module 401 is further configured to detect whether a second switching notification indicating that the second web client switches to foreground operation is received before the step of sending the data reference notification to the second web client, and if a detection result is yes, execute the step of sending the data reference notification to the second web client.
In a possible implementation manner of the present invention, in the cross-table referencing apparatus provided in the embodiment of the present invention, the address information receiving module 402 is specifically configured to receive a plurality of pieces of address information sent by the second web client;
the first address information sending module 403 is specifically configured to, after receiving a first switching notification indicating that the first web page client switches to foreground operation, determine the last received address information from the received multiple address information, and send the last received address information to the first web page client.
In a possible implementation manner of the present invention, a cross-table referencing apparatus provided in an embodiment of the present invention may further include:
an address information clearing module, configured to clear the address information after the step of sending the address information to the first web client.
And after the step of clearing the address information, clearing the first state notification after receiving a second state notification which is sent by the first webpage client and used for indicating that the first online spreadsheet exits the formula editing state.
Corresponding to the method embodiment, from the perspective of the client device, an embodiment of the present invention provides a cross-form referencing apparatus, which is applied to a second web client, where the second web client and a first web client correspond to a server and are located in the same client device, the first web client is used to present a first online spreadsheet, and the second web client is used to present a second online spreadsheet. As shown in fig. 5, the apparatus may include:
a reference notification receiving module 501, configured to receive a data reference notification sent by the server, where the data reference notification is: the server sends a first state notification which is sent by a first webpage client and used for indicating that the first online spreadsheet enters a formula editing state;
a reference area determination module 502, configured to determine, after receiving the data reference notification sent by the server, a reference area in the second online spreadsheet when the second webpage client is in foreground operation; wherein the reference area is a cell in a selected state;
a second address information sending module 503, configured to send address information of the reference region to the server, so that the server sends the address information to the first web page client after receiving a first switching notification indicating that the first web page client switches to foreground operation; and after receiving the address information, the first webpage client fills the address information in the cursor position in the first online electronic form.
In this embodiment, the second web client receives the data reference notification sent by the server, so that it is known that the first web client enters the formula editing state, and then the second web client determines the reference area selected by the user on the second online electronic form, and sends the address information of the determined reference area to the first web client through the server, so that the first web client fills the address information in the cursor of the first online electronic form, and cross-form reference between different online electronic forms is realized. Therefore, according to the scheme, a user can realize automatic cross-form reference between the online spreadsheets through the interaction between the first webpage client and the server and the interaction between the second webpage client and the server only by completing the switching operation between the online spreadsheets and the selection operation of the reference area. Therefore, the problem of inconvenient operation when cross-form reference is carried out among online electronic forms in the prior art can be solved through the scheme. In addition, because the address information of the area to be referred does not need to be manually input, the probability of reference errors can be greatly reduced.
In a possible implementation manner of the present invention, a cross-table referencing apparatus provided in an embodiment of the present invention may further include:
a switching notification detection module, configured to, before the step of receiving the data reference notification sent by the server, send, to the server, a second switching notification indicating that the second web client is switched to foreground operation when the second web client is switched to foreground operation, so that after the server receives the first state notification, if the second switching notification is detected, the data reference notification is sent to the second web client.
In a possible implementation manner of the present invention, a cross-table referencing apparatus provided in an embodiment of the present invention may further include:
a button generating module, configured to generate an information sending button on an interface of the second online electronic form after receiving a data reference notification sent by the server before the step of sending the address information of the reference area to the server;
the second address information sending module 503 is specifically configured to send the address information to the server when receiving an information sending instruction sent by the user based on the information sending button.
As shown in fig. 6, in another embodiment provided by the present invention, a server is further provided, where the server includes a processor 601, a communication interface 602, a memory 603, and a communication bus 604, where the processor 601, the communication interface 602, and the memory 603 complete communication with each other through the communication bus 604;
a memory 603 for storing a computer program;
the processor 601 is configured to implement the cross-table reference method from the server perspective provided by the foregoing embodiment when executing the program stored in the memory 603.
As shown in fig. 7, in another embodiment provided by the present invention, a client device is further provided, where the client device includes a processor 701, a communication interface 702, a memory 703 and a communication bus 704, where the processor 701, the communication interface 702 and the memory 703 complete communication with each other through the communication bus 704;
a memory 703 for storing a computer program;
the processor 701 is configured to implement the cross-table referencing method from the perspective of the client device according to the foregoing embodiment when executing the program stored in the memory 703.
In another embodiment provided by the present invention, a computer-readable storage medium is further provided, in which a computer program is stored, and when the computer program is executed by a processor, the cross-table reference method from the perspective of a server provided by the above-mentioned embodiments is implemented.
In another embodiment provided by the present invention, another computer-readable storage medium is further provided, and a computer program is stored in the computer-readable storage medium, and when being executed by a processor, the computer program implements the cross-table reference method from the perspective of a client device provided by the foregoing embodiment.
It is noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
All the embodiments in the present specification are described in a related manner, and the same and similar parts among the embodiments may be referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for the system embodiment, since it is substantially similar to the method embodiment, the description is simple, and for the relevant points, reference may be made to the partial description of the method embodiment.
The above description is only for the preferred embodiment of the present invention, and is not intended to limit the scope of the present invention. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention shall fall within the protection scope of the present invention.
Claims (12)
1. A cross-form reference method is applied to a server, the server is communicated with a client device, a first webpage client and a second webpage client which correspond to the server run in the client device, the first webpage client is used for presenting a first online spreadsheet, and the second webpage client is used for presenting a second online spreadsheet; the method comprises the following steps:
after receiving a first state notification which is sent by the first webpage client and used for indicating that the first online electronic form enters a formula editing state, sending a data reference notification to the second webpage client so as to enable the second webpage client to be in foreground operation, determining a reference area in the second online electronic form, and sending address information of the reference area to the server; wherein the reference area is a cell in a selected state;
receiving the address information sent by the second webpage client;
and after receiving a first switching notification for indicating that the first webpage client is switched to the foreground operation, sending the address information to the first webpage client so that the first webpage client fills the address information in the cursor position in the first online electronic form.
2. The method of claim 1, wherein prior to the step of sending a data reference notification to the second web client, the method further comprises:
and detecting whether a second switching notification for indicating that the second webpage client is switched to foreground operation is received or not, and if so, executing the step of sending the data reference notification to the second webpage client.
3. The method according to claim 1 or 2,
the step of receiving the address information sent by the second webpage client includes:
receiving a plurality of address information sent by the second webpage client;
the step of sending the address information to the first web page client after receiving a first switching notification indicating that the first web page client is switched to foreground operation includes:
and after receiving a first switching notification for indicating that the first webpage client is switched to the foreground operation, determining the last received address information from the received plurality of address information, and sending the last received address information to the first webpage client.
4. The method of claim 1 or 2, wherein after the step of sending the address information to the first web client, the method further comprises:
and clearing the address information.
5. The method of claim 4, wherein after the step of clearing the address information, the method further comprises:
and clearing the first state notification after receiving a second state notification which is sent by the first webpage client and used for indicating that the first online spreadsheet exits the formula editing state.
6. A cross-form reference method is applied to a second webpage client, the second webpage client and a first webpage client correspond to a server and are positioned in the same client device, the first webpage client is used for presenting a first online spreadsheet, and the second webpage client is used for presenting a second online spreadsheet; the method comprises the following steps:
receiving a data reference notification sent by the server, wherein the data reference notification is: the server sends a first state notification which is sent by a first webpage client and used for indicating that the first online spreadsheet enters a formula editing state;
after receiving the data reference notification sent by the server, when the second webpage client is in foreground operation, determining a reference area in the second online spreadsheet; wherein the reference area is a cell in a selected state;
sending address information of the reference area to the server, so that the server sends the address information to the first webpage client after receiving a first switching notification for indicating that the first webpage client is switched to a foreground for operation; and after receiving the address information, the first webpage client fills the address information in the cursor position in the first online electronic form.
7. The method of claim 6, wherein prior to the step of receiving the data reference notification sent by the server, the method further comprises:
and when the second webpage client is switched to foreground operation, sending a second switching notification for indicating that the second webpage client is switched to foreground operation to the server, so that the server sends the data reference notification to the second webpage client if the second switching notification is detected after receiving the first state notification.
8. The method according to claim 6 or 7, wherein before the step of sending the address information of the referenced area to the server, the method further comprises:
generating an information sending button on an interface of the second online electronic form after receiving the data reference notification sent by the server;
the step of sending the address information of the reference area to the server includes:
and when an information sending instruction sent by a user based on the information sending button is received, sending the address information to the server.
9. A cross-form reference device is applied to a server, the server is communicated with a client device, a first webpage client and a second webpage client which correspond to the server run in the client device, the first webpage client is used for presenting a first online spreadsheet, and the second webpage client is used for presenting a second online spreadsheet; the device comprises:
a reference notification sending module, configured to send a data reference notification to the second web page client after receiving a first state notification that is sent by the first web page client and used to indicate that the first online spreadsheet enters a formula editing state, so that when the second web page client is in foreground operation, a reference area in the second online spreadsheet is determined, and address information of the reference area is sent to the server; wherein the reference area is a cell in a selected state;
the address information receiving module is used for receiving the address information sent by the second webpage client;
and the first address information sending module is used for sending the address information to the first webpage client after receiving a first switching notification for indicating that the first webpage client is switched to the foreground operation, so that the first webpage client fills the address information in the cursor position in the first online electronic form.
10. A cross-form quoting device is applied to a second webpage client, the second webpage client and a first webpage client correspond to a server and are positioned in the same client device, the first webpage client is used for presenting a first online spreadsheet, and the second webpage client is used for presenting a second online spreadsheet; the device comprises:
a reference notification receiving module, configured to receive a data reference notification sent by the server, where the data reference notification is: the server sends a first state notification which is sent by a first webpage client and used for indicating that the first online spreadsheet enters a formula editing state;
a reference area determination module, configured to determine, after receiving the data reference notification sent by the server, a reference area in the second online spreadsheet when the second webpage client is in foreground operation; wherein the reference area is a cell in a selected state;
a second address information sending module, configured to send address information of the reference region to the server, so that the server sends the address information to the first web page client after receiving a first switching notification indicating that the first web page client switches to foreground operation; and after receiving the address information, the first webpage client fills the address information in the cursor position in the first online electronic form.
11. A server is characterized by comprising a processor, a communication interface, a memory and a communication bus, wherein the processor and the communication interface are used for realizing the communication among the processors and the memory through the communication bus;
a memory for storing a computer program;
a processor for implementing the cross-table referencing method of any one of claims 1 to 5 when executing a program stored on a memory.
12. The client device is characterized by comprising a processor, a communication interface, a memory and a communication bus, wherein the processor, the communication interface and the memory are used for completing mutual communication through the communication bus;
a memory for storing a computer program;
a processor for implementing the cross-table referencing method of any one of claims 6 to 8 when executing a program stored on a memory.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910640628.0A CN112307731B (en) | 2019-07-16 | 2019-07-16 | Cross-table reference method and device, server and client device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910640628.0A CN112307731B (en) | 2019-07-16 | 2019-07-16 | Cross-table reference method and device, server and client device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112307731A true CN112307731A (en) | 2021-02-02 |
| CN112307731B CN112307731B (en) | 2023-11-28 |
Family
ID=74329291
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910640628.0A Active CN112307731B (en) | 2019-07-16 | 2019-07-16 | Cross-table reference method and device, server and client device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112307731B (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040064397A1 (en) * | 2002-09-27 | 2004-04-01 | Brian Lynn | System and method for online trading using an electronic spreadsheet |
| US6895437B1 (en) * | 2000-09-07 | 2005-05-17 | Usability Sciences Corporation | System for monitoring browsing activity of a visitor and decrementing a reference count upon a web page change for automatic unloading a client program |
| CN101454774A (en) * | 2006-03-31 | 2009-06-10 | 谷歌公司 | Collaborative online spreadsheet application |
| CN102929877A (en) * | 2011-08-08 | 2013-02-13 | 阿里巴巴集团控股有限公司 | Method and device for causing form data on webpage to be generated into form document |
| CN103034708A (en) * | 2011-12-08 | 2013-04-10 | 微软公司 | Browser spreadsheet integration |
| CN106202013A (en) * | 2016-06-25 | 2016-12-07 | 国云科技股份有限公司 | A kind of implementation method of webpage version EXCEL |
| CN107943777A (en) * | 2017-12-14 | 2018-04-20 | 北京久蓉科技有限公司 | A kind of collaborative editing, cooperative processing method, device, equipment and storage medium |
-
2019
- 2019-07-16 CN CN201910640628.0A patent/CN112307731B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6895437B1 (en) * | 2000-09-07 | 2005-05-17 | Usability Sciences Corporation | System for monitoring browsing activity of a visitor and decrementing a reference count upon a web page change for automatic unloading a client program |
| US20040064397A1 (en) * | 2002-09-27 | 2004-04-01 | Brian Lynn | System and method for online trading using an electronic spreadsheet |
| CN101454774A (en) * | 2006-03-31 | 2009-06-10 | 谷歌公司 | Collaborative online spreadsheet application |
| CN102929877A (en) * | 2011-08-08 | 2013-02-13 | 阿里巴巴集团控股有限公司 | Method and device for causing form data on webpage to be generated into form document |
| CN103034708A (en) * | 2011-12-08 | 2013-04-10 | 微软公司 | Browser spreadsheet integration |
| CN106202013A (en) * | 2016-06-25 | 2016-12-07 | 国云科技股份有限公司 | A kind of implementation method of webpage version EXCEL |
| CN107943777A (en) * | 2017-12-14 | 2018-04-20 | 北京久蓉科技有限公司 | A kind of collaborative editing, cooperative processing method, device, equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112307731B (en) | 2023-11-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10445114B2 (en) | Associating command surfaces with multiple active components | |
| US20170308617A1 (en) | Codeless sharing of spreadsheet objects | |
| CA2795367C (en) | Spin control user interface for selecting options | |
| WO2020124933A1 (en) | Comment information processing method and apparatus, and storage medium and electronic device | |
| CN110932981B (en) | Data exchange system supporting automatic routing | |
| CN111078695B (en) | Method and device for calculating association relation of metadata in enterprise | |
| US8707177B1 (en) | Resource guide generator for resource pages | |
| CN111949607B (en) | Method, system and device for monitoring UDT file | |
| US10261662B2 (en) | Context based selection of menus in contextual menu hierarchies | |
| US10877651B2 (en) | Displaying a series of reports within a single user interface | |
| CN103970773B (en) | A kind of method for updating pages and device of webpage | |
| CN112307731A (en) | Cross-form reference method and device, server and client device | |
| JP2017174248A (en) | Information processing device and information processing program | |
| CN111897661A (en) | Method and device for copying cell contents in spreadsheet and electronic equipment | |
| CN111949184A (en) | Method and device for creating new document | |
| CN115022285B (en) | Method and device for configuring one-key automatic internet communication equipment | |
| CN115277652B (en) | Streaming media processing method and device based on reasoning service and electronic equipment | |
| CN112433723B (en) | Personalized list development method and device | |
| US20240119420A1 (en) | Automated modeling of online job applications for facilitating job application completion | |
| JP2018181150A (en) | Control program, control method, and control apparatus | |
| US20210326949A1 (en) | Catalog creation support device, support screen display method, and catalog creation support method | |
| CN114327465A (en) | Page component generation method and device, electronic equipment and storage medium | |
| CN114254603A (en) | Spreadsheet processing method and device, electronic equipment and storage medium | |
| CN117785164A (en) | Method for generating service interface for low-code platform and related device | |
| CN115310016A (en) | Webpage interface display method, device, equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |