CN112784558A

CN112784558A - Spreadsheet application method, device, server, client and communication system

Info

Publication number: CN112784558A
Application number: CN202010108758.2A
Authority: CN
Inventors: 朱军行; 陈嘉丰
Original assignee: Beijing Kingsoft Office Software Inc; Zhuhai Kingsoft Office Software Co Ltd
Current assignee: Beijing Kingsoft Office Software Inc; Zhuhai Kingsoft Office Software Co Ltd
Priority date: 2020-02-21
Filing date: 2020-02-21
Publication date: 2021-05-11

Abstract

The embodiment of the invention provides an electronic form application method, a device, a server, a client and a communication system, wherein the client sends a processing strategy to the server after receiving the processing strategy aiming at a designated cell in an electronic form input by a user logging in the client, once the server obtains the data of the designated cell, the data of the designated cell is processed according to the processing strategy, and a processing result and the processing strategy are sent to the designated client, and the designated client displays the processing strategy and the processing result by detecting whether the user currently logging in the client has the authority or not under the condition of determining that the user currently logging in the client has the authority. Therefore, through data transmission between the client and the server, the processing strategy and the processing result of the designated cells can be automatically transmitted, and the spreadsheet does not need to be repeatedly transmitted among the clients, so that the efficiency of collaborative editing of the spreadsheet is improved.

Description

Spreadsheet application method, device, server, client and communication system

Technical Field

The invention relates to the technical field of computers, in particular to a spreadsheet application method, a spreadsheet application device, a spreadsheet application server, a spreadsheet application client and a communication system.

Background

The application of the electronic forms in various industries is more and more extensive, and with continuous progress and development of society, the requirements of remote office and cloud office are more and more, after a user edits and modifies the electronic forms through office software, if the user needs to share the electronic forms with other people, the traditional mode is that the electronic forms are sent to the other party as attachments by logging in a client side such as a mailbox, a chat tool and the like.

However, if the spreadsheet is shared in this way and the collaborative editing of the spreadsheet is to be realized, the first client needs to edit the spreadsheet, send the spreadsheet to the next client again for editing, and then repeatedly send the spreadsheet among different clients to transfer the spreadsheet, which results in extremely low efficiency of collaborative editing of the spreadsheet.

Disclosure of Invention

The embodiment of the invention aims to provide an electronic form application method, an electronic form application device, a server, a client and a communication system, so as to improve the efficiency of collaborative editing of an electronic form. The specific technical scheme is as follows:

in a first aspect, an embodiment of the present invention provides a spreadsheet application method, which is applied to a server in a communication system, where the communication system includes the server and multiple clients, and the method includes:

acquiring a processing strategy for a specified cell in the spreadsheet and data of the specified cell;

processing the data of the designated cells according to the processing strategy to obtain a processing result;

and sending the processing strategy and the processing result to the appointed client so that the appointed client displays the processing strategy and the processing result under the condition that the user currently logging in the client has the authority.

Optionally, the step of obtaining the processing policy for the specified cell in the spreadsheet and the data of the specified cell includes:

receiving a processing strategy aiming at a designated cell in an electronic form, wherein the processing strategy is sent by a first client, and the processing strategy is input by a user logging in the first client which is any one of a plurality of clients;

and receiving data of the designated cells sent by a second client, wherein the data of the designated cells are input by a user logging in the second client, and the second client is any one of the plurality of clients.

Optionally, the step of sending the processing policy and the processing result to the specified client includes:

if the first client and the second client are the same client, sending the processing strategy and the processing result to other clients except the first client;

and if the first client and the second client are different clients, sending the processing strategy to other clients except the first client, and sending the processing result to each client in the plurality of clients.

Optionally, the step of processing the data according to the processing policy to obtain a processing result includes:

compiling the processing strategy to obtain a compiling result;

processing the data of the specified cells according to the compiling result to obtain a processing result;

the step of sending the processing strategy and the processing result to the appointed client comprises the following steps:

and sending the compiling result and the processing result to the appointed client so that the appointed client performs decompiling on the compiling result under the condition that the user currently logging in the client has the authority, so as to obtain a processing strategy, and displaying the processing strategy and the processing result.

In a second aspect, an embodiment of the present invention provides a spreadsheet application method, applied to a client in a communication system, where the communication system includes a server and multiple clients, and the method includes:

receiving a processing strategy aiming at the specified cells in the spreadsheet and a processing result of the specified cells sent by the server;

detecting whether a user currently logging in the client side has the authority or not;

and if the user has the authority, displaying the processing strategy and the processing result.

Optionally, after the step of detecting whether the user currently logged in the client has the right, the method further includes:

and if the user has no authority, only displaying the processing result.

Optionally, the received processing policy is a compiling result obtained by compiling the obtained processing policy by the server;

before the step of displaying the processing strategy and the processing result, the method further comprises the following steps:

and performing decompiling on the compiling result to obtain a processing strategy.

Optionally, the method further includes:

if a processing strategy aiming at a designated cell in the spreadsheet and input by a user logging in the client is received, the processing strategy is sent to a server;

and if the data of the specified cell input by the user logging in the client is received, the data of the specified cell is sent to the server.

Optionally, before the step of sending the processing policy to the server, the method further includes:

compiling the processing strategy to obtain a compiling result;

the step of sending the processing policy to the server includes:

and if the processing strategy is determined to be legal according to the compiling result, sending the processing strategy to the server.

In a third aspect, an embodiment of the present invention provides a spreadsheet application method, which is applied to a communication system, where the communication system includes a server and multiple clients, and the method includes:

any client sends a processing strategy to a server after receiving the processing strategy aiming at the appointed cells in the spreadsheet and input by a user logging in the client;

the server receives a processing strategy sent by any client, acquires data of a designated cell, processes the data according to the processing strategy to obtain a processing result, and sends the processing strategy and the processing result to the designated client;

and the appointed client detects whether the user currently logging in the client has the authority, and if the user has the authority, the processing strategy and the processing result are displayed.

In a fourth aspect, an embodiment of the present invention provides a spreadsheet application method, applied to a server in a communication system, where the communication system includes the server and multiple clients, and the method includes:

acquiring a processing strategy for a designated cell in the spreadsheet, data of the designated cell and user authority information of currently logged-in clients;

and aiming at any client, if the user is determined to have the authority according to the user authority information currently logged in the client, sending the processing strategy and the processing result to the client so that the client displays the processing strategy and the processing result.

Optionally, for any client, if it is determined that the user has the right according to the user right information currently logging in the client, the step of sending the processing policy and the processing result to the client includes:

for any client except the first client, if the user has the authority according to the user authority information of the current login client, sending a processing strategy and a processing result to the client;

and if the first client and the second client are different clients, sending the processing result to the first client.

compiling the processing strategy to obtain a compiling result;

aiming at any client, if the user is determined to have the authority according to the user authority information currently logging in the client, the step of sending the processing strategy and the processing result to the client comprises the following steps:

and for any client, if the user is determined to have the authority according to the user authority information currently logged in the client, sending a compiling result and a processing result obtained by compiling to the client so that the client performs decompiling on the compiling result to obtain a processing strategy, and displaying the processing strategy and the processing result.

In a fifth aspect, an embodiment of the present invention provides a spreadsheet application method, which is applied to a client in a communication system, where a user currently logging in the client has a right, the communication system includes a server and multiple clients, and the method includes:

receiving a processing strategy and a processing result which are sent by a server and aim at the designated cells in the spreadsheet;

and displaying the processing strategy and the processing result.

Optionally, the method further includes:

compiling the processing strategy to obtain a compiling result;

the step of sending the processing policy to the server includes:

In a sixth aspect, an embodiment of the present invention provides a spreadsheet application method, which is applied to a communication system, where the communication system includes a server and multiple clients, and the method includes:

the server receives a processing strategy sent by the client, acquires data of a designated cell and user authority information of currently logged-in clients, processes the data according to the processing strategy to obtain a processing result, and if the user has authority according to the user authority information of the currently logged-in client, sends the processing strategy and the processing result to the client;

and after receiving the processing strategy and the processing result sent by the server, the client displays the processing strategy and the processing result.

A seventh aspect of the present invention provides an electronic form application apparatus, which is applied to a server in a communication system, where the communication system includes the server and multiple clients, and the apparatus includes:

the acquisition module is used for acquiring a processing strategy for a specified cell in the spreadsheet and data of the specified cell;

the processing module is used for processing the data of the specified cell according to the processing strategy to obtain a processing result;

and the sending module is used for sending the processing strategy and the processing result to the appointed client so that the appointed client displays the processing strategy and the processing result under the condition of determining that the user currently logging in the client has the authority.

Optionally, the obtaining module is specifically configured to:

Optionally, the sending module is specifically configured to:

Optionally, the apparatus further comprises:

the compiling module is used for compiling the processing strategy to obtain a compiling result;

the processing module is specifically configured to: processing the data of the specified cells according to the compiling result to obtain a processing result;

a sending module, specifically configured to: and sending the compiling result and the processing result to the appointed client so that the appointed client performs decompiling on the compiling result under the condition that the user currently logging in the client has the authority, so as to obtain a processing strategy, and displaying the processing strategy and the processing result.

In an eighth aspect, an embodiment of the present invention provides an electronic form application apparatus, which is applied to a client in a communication system, where the communication system includes a server and multiple clients, and the apparatus includes:

the receiving module is used for receiving the processing strategy aiming at the specified cells in the spreadsheet and the processing result of the specified cells, which are sent by the server;

the detection module is used for detecting whether a user currently logging in the client side has the authority;

and the display module is used for displaying the processing strategy and the processing result if the user has the authority.

Optionally, the display module is further configured to display only the processing result if the user does not have the right.

the device also includes:

and the decompiling module is used for decompiling the compiling result to obtain a processing strategy.

Optionally, the apparatus further comprises:

the sending module is used for sending the processing strategy to the server if the processing strategy aiming at the appointed cells in the spreadsheet and input by a user logging in the client is received; and if the data of the specified cell input by the user logging in the client is received, the data of the specified cell is sent to the server.

Optionally, the apparatus further comprises:

and the sending module is specifically used for sending the processing strategy to the server if the processing strategy is determined to be legal according to the compiling result.

In a ninth aspect, an embodiment of the present invention provides an electronic form application apparatus, applied to a server in a communication system, where the communication system includes the server and a plurality of clients, and the apparatus includes:

the acquisition module is used for acquiring a processing strategy aiming at the specified cells in the spreadsheet, data of the specified cells and user authority information of currently logged-in clients;

and the sending module is used for sending the processing strategy and the processing result to any client side if the user has the authority according to the user authority information currently logged in the client side, so that the client side can display the processing strategy and the processing result.

Optionally, the obtaining module is specifically configured to:

Optionally, the sending module is specifically configured to:

Optionally, the apparatus further comprises:

the processing module is specifically used for processing the data of the specified cell according to the compiling result to obtain a processing result;

and the sending module is specifically used for sending the compiling result and the processing result obtained by compiling to any client side if the user has the authority according to the user authority information currently logged in the client side, so that the client side can perform decompiling on the compiling result to obtain a processing strategy and display the processing strategy and the processing result.

In a tenth aspect, an embodiment of the present invention provides an electronic form application apparatus, which is applied to a client in a communication system, where a user currently logging in the client has an authority, the communication system includes a server and a plurality of clients, and the apparatus includes:

the receiving module is used for receiving the processing strategy and the processing result which are sent by the server and aim at the designated cells in the spreadsheet;

and the display module is used for displaying the processing strategy and the processing result.

the device also includes:

Optionally, the apparatus further comprises:

In an eleventh aspect, an embodiment of the present invention provides a server, including a processor, a communication interface, a memory, and a communication bus, where the processor, the communication interface, and the memory complete communication with each other through the communication bus;

a memory for storing a computer program;

a processor, configured to implement the method provided in the first aspect or the fourth aspect of the embodiments of the present invention when executing the computer program stored in the memory.

In a twelfth aspect, an embodiment of the present invention provides a client, including a processor, a communication interface, a memory, and a communication bus, where the processor, the communication interface, and the memory complete mutual communication through the communication bus;

a memory for storing a computer program;

and a processor, configured to implement the method provided in the second aspect or the fifth aspect of the embodiments of the present invention when executing the computer program stored in the memory.

In a thirteenth aspect, the present invention provides a computer-readable storage medium, in which a computer program is stored, and when the computer program is executed by a processor, the computer program implements the method provided in the first, second, fourth, or fifth aspect of the present invention.

In a fourteenth aspect, an embodiment of the present invention provides a computer program product including instructions, which, when run on a server, causes the server to perform the method provided in the first, second, fourth or fifth aspect of the embodiment of the present invention.

In a fifteenth aspect, an embodiment of the present invention provides a communication system, where the communication system includes a server and multiple clients:

any one of the plurality of clients is used for sending a processing strategy to the server after receiving the processing strategy aiming at the appointed cells in the spreadsheet and input by a user logging in the client;

the server is used for receiving the processing strategy sent by any client, acquiring the data of the designated cell, processing the data according to the processing strategy to obtain a processing result, and sending the processing strategy and the processing result to the designated client;

and the appointed client is used for detecting whether the user currently logging in the client has the authority, and if the user has the authority, displaying the processing strategy and the processing result.

In a sixteenth aspect, an embodiment of the present invention provides a communication system, where the communication system includes a server and multiple clients:

the server is used for receiving the processing strategy sent by the client, acquiring data of the specified cells and user authority information of currently logged-in clients, processing the data of the specified cells according to the processing strategy to obtain a processing result, and if the user is determined to have authority according to the user authority information of the currently logged-in client, sending the processing strategy and the processing result to the client aiming at any client;

and the client side which receives the processing strategy and the processing result sent by the server is used for displaying the processing strategy and the processing result.

The communication system comprises a server and a plurality of clients, any client receives a processing strategy for a designated cell in an electronic form input by a user logging in the client, the processing strategy is sent to the server, the server receives the processing strategy sent by the client and acquires data of the designated cell, the data of the designated cell is processed according to the processing strategy to obtain a processing result, the processing strategy and the processing result are sent to the designated client, the designated client detects whether the user currently logging in the client has authority, and if the user has the authority, the processing strategy and the processing result are displayed.

The method comprises the steps that after a client receives a processing strategy aiming at a designated cell in an electronic form and input by a user logging in the client, the processing strategy is sent to a server, once the server obtains data of the designated cell, the data of the designated cell are processed according to the processing strategy, a processing result and the processing strategy are sent to the designated client, and the designated client displays the processing strategy and the processing result by detecting whether the user currently logging in the client has the authority or not under the condition that the user currently logging in the client is determined to have the authority. Therefore, through data transmission between the client and the server, the processing strategy and the processing result of the designated cells can be automatically transmitted, and the spreadsheet does not need to be repeatedly transmitted among the clients, so that the efficiency of collaborative editing of the spreadsheet is improved.

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 flowchart illustrating a spreadsheet application method applied to a server according to an embodiment of the present invention;

FIG. 2 is a flowchart illustrating a spreadsheet application method applied to a server according to another embodiment of the present invention;

FIG. 3 is a flowchart illustrating a spreadsheet application method applied to a client according to an embodiment of the present invention;

FIG. 4 is a flowchart illustrating a spreadsheet application method applied to a client according to another embodiment of the present invention;

FIG. 5 is a flowchart illustrating a spreadsheet application method applied in the communication system according to an embodiment of the present invention;

FIG. 6 is a schematic diagram illustrating an interaction flow of a spreadsheet application method according to an embodiment of the present invention;

FIG. 7 is a flowchart illustrating a spreadsheet application method applied to a server according to another embodiment of the present invention;

FIG. 8 is a flowchart illustrating a spreadsheet application method applied to a server according to another embodiment of the present invention;

FIG. 9 is a flowchart illustrating a spreadsheet application method applied to a client according to another embodiment of the present invention;

FIG. 10 is a flowchart illustrating a spreadsheet application method applied to a client according to another embodiment of the present invention;

FIG. 11 is a flowchart illustrating a spreadsheet application method applied to a communication system according to another embodiment of the present invention;

FIG. 12 is an interaction flow diagram of a spreadsheet application method according to another embodiment of the present invention;

FIG. 13 is a diagram illustrating an exemplary spreadsheet application device applied to a server according to an embodiment of the present invention;

FIG. 14 is a diagram illustrating an exemplary spreadsheet application device applied to a client according to an embodiment of the present invention;

FIG. 15 is a schematic structural diagram of a spreadsheet application apparatus applied to a server according to another embodiment of the present invention;

FIG. 16 is a schematic structural diagram of a spreadsheet application device applied to a client according to another embodiment of the present invention;

FIG. 17 is a block diagram of a server according to an embodiment of the present invention;

FIG. 18 is a schematic structural diagram of a client according to an embodiment of the present invention;

fig. 19 is a schematic structural diagram of a communication system according to an embodiment of the present invention;

fig. 20 is a schematic structural diagram of a communication system according to another 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 improve the efficiency of collaborative editing of an electronic form, the embodiment of the invention provides an electronic form application method, an electronic form application device, a server, a client and a communication system.

First, a spreadsheet application method provided by an embodiment of the present invention will be described. The spreadsheet application method is applied to a communication system, wherein the communication system comprises a server and a plurality of clients, the server refers to a back-end device with data processing capability and control function, the client refers to a front-end device for a user to log in, such as a mobile phone, a personal computer, a tablet personal computer and the like, and specifically refers to a browser, an application program and the like on the front-end device. The spreadsheet application method provided by the embodiments of the present invention will be described from several perspectives, namely, from the server side, the client side, and the internal interaction of the communication system.

As shown in fig. 1, the spreadsheet application method provided by the embodiment of the present invention, applied to the server in the communication system, may include the following steps.

S101, acquiring a processing strategy aiming at the specified cell in the spreadsheet and data of the specified cell.

And S102, processing the data of the designated cells according to the processing strategy to obtain a processing result.

S103, the processing strategy and the processing result are sent to the appointed client, so that the appointed client displays the processing strategy and the processing result under the condition that the user currently logging in the client has the authority.

The processing strategy and the processing result can be simultaneously sent to the appointed client by the server or asynchronously sent to the appointed client by the server.

The processing policies in steps S101, S102, and S103 may be the same or different in data format. The processing policy in step S101 is a processing policy in an original format, and is used for transmission; the processing policy in step S102 is a processed processing policy, for example, a compiled processing policy, which facilitates data processing by the server; the processing policy sent by the server to the designated client in step S103 may be a processed processing policy or a processing policy for display, and the designated client finally displays a processing policy convenient for the user to view intuitively.

The step of the designated client detecting whether the user currently logging in the client has the authority can be performed as long as the detection is performed before the processing strategy and the processing result are displayed. This step is not necessarily performed when step S103 is performed, that is, when the server transmits the processing policy and the processing result to the specified client.

By applying the embodiment of the invention, the client sends the processing strategy to the server after receiving the processing strategy aiming at the appointed cell in the spreadsheet and input by the user logging in the client, once the server obtains the data of the appointed cell, the server processes the data of the appointed cell according to the processing strategy and sends the processing result and the processing strategy to the appointed client, and the appointed client displays the processing strategy and the processing result by detecting whether the user currently logging in the client has the authority under the condition of determining that the user currently logging in the client has the authority. Therefore, through data transmission between the client and the server, the processing strategy and the processing result of the designated cells can be automatically transmitted, and the spreadsheet does not need to be repeatedly transmitted among the clients, so that the efficiency of collaborative editing of the spreadsheet is improved; and each client can be subjected to rights management, has personalized setting and enhances the confidentiality.

When a user designs a processing strategy in an electronic form to process a plurality of cells in the electronic form, some cells are hidden for the sake of confidentiality, or the detailed contents of the processing strategy are hidden, so that some cells are invisible to other users, and the processing strategy contents of some cells are invisible. In order to apply the application scenario, the setting and editing authority of the processing policy needs to be controlled in only a few hands, because once the processing policy is set incorrectly or tampered maliciously, the electronic form is invalid. For the situation that a spreadsheet needs to be shared by a client which logs in a mailbox, a chat tool and the like and sends the spreadsheet to a client of an opposite side, some spreadsheet editing software different from the specific embodiment of the invention is used for realizing multi-user real-time editing of the spreadsheet, but the spreadsheet editing software cannot realize effective authority control, so that the problem in the application scene cannot be solved well.

In the embodiment of the invention, after receiving a processing strategy aiming at a designated cell in an electronic form and input by a user logging in the client, the client sends the processing strategy to a server, once the server obtains the data of the designated cell, the server processes the data of the designated cell by using the processing strategy and sends a processing result and the processing strategy to the designated client, and the designated client displays the processing strategy and the processing result by detecting whether the user currently logging in the client has the right or not and when determining that the user currently logging in the client has the right. If the user who logs in a certain client at present has the authority, the client can display the processing strategy and the processing result to the user in time, and the user can judge whether the processing strategy is maliciously tampered, whether the setting is wrong or not and the like by checking the processing strategy and the processing result, so that the effectiveness of the electronic form is ensured.

In the embodiment of the present invention, the processing policy refers to a preset specific manner for processing data of a certain cell or a plurality of cells in the spreadsheet, and the processing policy may specifically be a calculation formula, a logic statement, and the like. The preset means that after the user of the initiator performs the setting, the server obtains the setting result of the user as a processing strategy preset by the user. Taking the processing strategy as an example of a calculation formula, the calculation formula is a mathematical expression, or may be referred to as a mathematical function, and specifically may be an expression of mathematical operations such as addition, subtraction, multiplication, division, and absolute value, for example, which is SUM (C1, C4). The processing strategy is set for a certain cell or a certain number of cells. For example, if the calculation formula "SUM (a1, B1)" is set in the cell C1, the processing policy set for the cell C1 is represented as: adding the data of the cell A1 and the data of the cell B1 to obtain the data of the cell C1; for another example, if the calculation formula "MAX (C1: C10)" is set in the cell D1, the processing policy set for the cell D1 is: the largest data is selected from the cells C1 through C10 as the data of cell D1. The logic statement may be a specific arithmetic function, a programming statement, or the like, for example, a logic statement "IF (D1>5) is set in the cell E1, E1 is 1; ELSE E1 ═ 0 ", indicating that the processing policy set for cell E1 is: it is determined whether the data of the cell D1 is greater than 5, and if greater than 5, the data of the cell E1 is 1, and if not greater than 5, the data of the cell E1 is 0.

The processing policy may be received by the server from the client, or may be set by a technician directly on the server. The method comprises the steps that an electronic form is stored in a server in advance, after a user logs in a client, the server sends the electronic form to the client, then the user who logs in the client adds a processing strategy aiming at a specified cell in the electronic form, and after receiving the processing strategy input by the user, the client codes the processing strategy and sends the processing strategy to the server; the server and each client can also store the same electronic form in advance, record the mark of the same electronic form, and after receiving the processing strategy input by the user logging in the client, the client sends the processing strategy to the server and carries the mark of the electronic form, so that the server can know which electronic form the processing strategy is set for the designated cell. For convenience of description, in the embodiment of the present invention, the processing policy is generally referred to as a processing policy regardless of the data format, and may be, for example, source code, object code, encrypted code, or the like.

The data specifying the cells may be received by the server from the client or may be entered directly on the server by a technician. When a user has a data processing requirement, the data can be directly input into the corresponding cell in the spreadsheet displayed by the logged-in client, and the client receives the data input by the user and sends the data to the server.

Optionally, S101 may specifically be: receiving a processing strategy aiming at a designated cell in an electronic form, wherein the processing strategy is sent by a first client, and the processing strategy is input by a user logging in the first client which is any one of a plurality of clients; receiving data of a designated cell sent by a second client, wherein the spreadsheet comprises a plurality of cells; the designated cells are positioned in the spreadsheet and are determined by the server according to the user designation; the data specifying the cell is input by a user logging in a second client, which is any one of the plurality of clients.

The processing strategy for the designated cell and the data of the designated cell can be input by a user logging in one client or different users logging in different clients, so that only a small part of users are allowed to set and modify the processing strategy, and the other part of users can only input the data of the cell to obtain a processing result, but cannot directly set and modify the processing strategy.

After acquiring the processing policy for the designated cell and the data of the designated cell, the server may process the data of the designated cell by using the processing policy, for example, if the server receives that the processing policy for the cell C1 sent by the client 1 is "SUM (a1, B1)", and receives that the data of the cell a1 sent by the client 2 is 5 and the data of the cell B1 is 20, the data of the cell C1 is 25 by the processing, and the obtained data of the cell C1 is the processing result.

After obtaining the processing result, the server sends both the processing policy and the processing result for the specified cell to the specified client, where the specified client may be each client in the communication system, or some specific clients in the communication system (for example, the clients other than the client sending the processing policy are specific clients), or clients that are specified in advance by a user or a technician (that is, only a user who wants to log in some clients knows the processing policy and the processing result). The server locally stores the spreadsheet after processing the processing policy so that the user or technician can call directly from the server.

After receiving the processing strategy and the processing result, the appointed client detects whether a user currently logging in the client has the authority, if so, the processing strategy and the processing result are displayed, and if not, only the processing result is displayed according to a traditional mode. The client generally has a display screen, and displays the processing strategy and the processing result to the user through the display screen, specifically, formats the processing strategy and the processing result into a character string for display.

Optionally, in a scenario of receiving a processing policy for a specified cell in the spreadsheet and data of the specified cell sent by the second client, S103 may specifically be: if the first client and the second client are the same client, sending the processing strategy and the processing result to other clients except the first client; and if the first client and the second client are different clients, sending the processing strategy to other clients except the first client, and sending the processing result to each client in the plurality of clients.

If the first client and the second client are the same client, that is, the processing strategy for the specified cell and the data of the specified cell are both sent to the server by the first client, the processing result can be directly obtained locally because the first client knows the processing strategy and the data of the specified cell, the server does not need to feed back the processing strategy and the processing result to the first client, the interactive data amount is reduced, and the first client does not need to repeatedly send and receive data. If the first client and the second client are different clients, the first client knows the processing strategy, does not need to send the processing strategy to the first client any more, only needs to feed back the processing result to the first client, can feed back the processing strategy and the processing result for other clients, and can also reduce the interactive data volume, and the first client does not need to repeatedly send and receive the processing strategy.

Based on the embodiment shown in fig. 1, an embodiment of the present invention further provides a spreadsheet application method, which is applied to the server in the communication system, as shown in fig. 2, and may include the following steps.

S201, acquiring a processing strategy aiming at the specified cells in the spreadsheet and data of the specified cells.

S202, compiling the processing strategy to obtain a compiling result.

And S203, processing the data of the specified cell according to the compiling result to obtain a processing result.

And S204, sending the compiling result and the processing result to the specified client, so that the specified client performs decompiling on the compiling result under the condition that the user currently logging in the client has the authority, so as to obtain a processing strategy, and displaying the processing strategy and the processing result.

In an implementation manner of the embodiment of the present invention, in order to facilitate the server to process the data of the designated cell, after the processing policy for the designated cell is obtained, the processing policy is compiled first, the processing policy is compiled into a manner more convenient for the server to identify and calculate, and then the data of the designated cell is processed according to a compiling result obtained after compiling, so as to obtain a processing result. In order to enhance the privacy of data, when the server sends the processing strategy and the processing result to the specified client, the specific sending can be the compiling result and the processing result, so that the specified client performs decompiling on the compiling result under the condition of determining that the user currently logging in the client has the authority, obtains the processing strategy, and then displays the processing strategy and the processing result.

In order to more clearly illustrate the process of compiling and decompiling the processing policy, the following description will take the processing policy as an example of a calculation formula. The compiling process of the calculation formula comprises the following steps: first, a calculation formula is subjected to word segmentation processing, for example, the calculation formula is "═ a1+ B1", and after word segmentation, the calculation formula becomes "═ a1", "+", "B1"; then, each participle is converted into a token type, namely an operator, a reference A1, an operator +, a reference B1; then, syntax analysis is carried out, whether the token type calculation formula is legal or not is analyzed, if the token type calculation formula is legal, the sequence of tokens in the formula is exchanged, the token is converted into an expression of a characteristic type, for example, the formula is converted into an inverse Polish expression, the expression refers to A1, the formula refers to B1 and an operator +, through expression conversion, when a calculation engine carries out calculation, the token value of the expression is popped from the beginning until the operator or a function name is popped, parameters corresponding to the operator are popped out before, and the structure is very simple and easy to understand for a server, so that the calculation of the server is facilitated; finally, the reference is turned into relative offset according to the coordinate of the cell C1 in which the calculation formula is located, namely, the coordinate of the cell C1 is (0,0), the reference "A1" can be (0, -2), and the reference "B1" can be (0, -1), so that recording is performed, and because the relative position is recorded, the compiling result does not need to be changed if a row and a column are inserted in front.

Similarly, the decompiling process is the reverse process of the compiling process, that is, the relative offset is processed according to the coordinates of the cell C1 where the calculation formula is located to obtain the citation and the operator, for example, the citation a1, the citation B1 and the operator +; analyzing an expression of the token type according to the obtained expression, wherein the expression is an operator, a quotation A1, an operator and a quotation B1; according to the token type expression, the splicing results in the calculation formula ═ a1+ B1 ".

As shown in fig. 3, the spreadsheet application method provided by the embodiment of the present invention, applied to the client in the communication system, may include the following steps.

S301, receiving a processing strategy for the designated cell in the spreadsheet and a processing result of the designated cell sent by the server.

S302, detecting whether the user currently logging in the client side has the authority.

And S303, if the user has the authority, displaying the processing strategy and the processing result.

By applying the embodiment of the invention, after receiving the processing strategy aiming at the specified cell and the processing result aiming at the specified cell sent by the server, the client needs to detect whether the user currently logging in the client has the authority, and the processing strategy and the processing result can be displayed to the user under the condition that the user currently logging in the client has the authority. Therefore, through data transmission between the client and the server, the processing strategy and the processing result of the designated cells can be automatically transmitted, and the spreadsheet does not need to be repeatedly transmitted among the clients, so that the efficiency of collaborative editing of the spreadsheet is improved. Moreover, only the user with the authority can check the processing strategy and the processing result, and can judge whether the processing strategy is maliciously tampered, whether the setting is wrong and the like, so that the effectiveness of the electronic form is ensured.

The purpose of the client detecting whether the user currently logging in the client has the authority is to judge whether the client needs to display a processing strategy and a processing result or only display the processing result.

Different authorities are preset for different users, and for the users to use the electronic form, the electronic form is divided into an authority possessing mode and an authority lacking mode, and the users possessing the authorities can see detailed contents of the electronic form, including data of each cell in the electronic form, detailed information of processing strategies and the like. The client can judge whether the user who logs in the client currently has the authority or not by identifying and matching the marks. The method for the client to detect whether the user currently logging in the client has the right specifically may be: the method comprises the steps that a user sends a login request (comprising a login account number, a password and the like) to a client, the client responds to the login request, if the login account number and the password are matched, the detailed information of the user is read based on the login account number, the authority identification of the user is extracted from the detailed information, the read authority identification is matched with a preset authority identification, if the authority identification is matched with the preset authority identification, the user is proved to have authority, and if the authority identification is not matched with the preset authority identification, the user does not have the authority.

And if the client determines that the user currently logging in the client has the authority, displaying the processing strategy and the processing result to the user through a display screen, specifically formatting the processing strategy and the processing result into a character string for displaying.

Optionally, if the client determines that the user currently logging in the client has no right, only the processing result is displayed.

For a user without permission, the user can only see the processing result, cannot know the specific content of the processing strategy, hides the content of the processing strategy, and can meet the requirements of user privatization and customization.

Based on the embodiment shown in fig. 3, an embodiment of the present invention further provides a spreadsheet application method, which is applied to the client in the communication system, as shown in fig. 4, and may include the following steps.

S401, receiving a compiling result of the processing strategy aiming at the designated cell in the spreadsheet and a processing result of the designated cell sent by the server.

S402, detecting whether the user currently logging in the client side has the authority.

And S403, if the user has the authority, performing decompiling on the compiling result to obtain a processing strategy, and displaying the processing strategy and the processing result.

In an implementation manner of the embodiment of the present invention, in order to facilitate the server to process the data of the designated cell, after the processing policy for the designated cell is obtained, the processing policy is compiled first, the processing policy is compiled into a manner more convenient for the server to identify and calculate, and then the data of the designated cell is processed according to a compiling result obtained after compiling, so as to obtain a processing result. In order to enhance the privacy of data, when the server sends the processing strategy and the processing result to the specified client, the specific sending can be the compiling result and the processing result, so that the specified client performs decompiling on the compiling result under the condition of determining that the user currently logging in the client has the authority, obtains the processing strategy, and then displays the processing strategy and the processing result. The decompilation process is detailed in the embodiment shown in fig. 2, and is not described here again.

Optionally, the method of the embodiment shown in fig. 3 and 4 may further include the following steps:

if a processing strategy aiming at a designated cell in the spreadsheet and input by a user logging in the client is received, the processing strategy is sent to a server; and if the data of the specified cell input by the user logging in the client is received, the data of the specified cell is sent to the server.

Optionally, before sending the processing policy to the server, the method may further include the following steps: and compiling the processing strategy to obtain a compiling result. Correspondingly, the step of sending the processing policy to the server may specifically be: and if the processing strategy is determined to be legal according to the compiling result, sending the processing strategy to the server.

For a client, if the client receives a processing strategy for a specified cell in a spreadsheet, which is input by a user logging in the client, the processing strategy is sent to a server; and if the client receives the data of the specified cell input by the user logging in the client, the data of the specified cell is sent to the server. Moreover, in order to ensure the validity of the processing policy sent to the server, the processing policy needs to be compiled before sending the processing policy to obtain a compilation result, and if the processing policy is determined to be valid according to the compilation result, the processing policy is sent to the server, and the specific compilation process and validity judgment are detailed in the embodiment shown in fig. 2 and will not be described herein again.

As shown in fig. 5, the spreadsheet application method provided by the embodiment of the present invention, applied to the above communication system, may include the following steps.

S501, after receiving a processing strategy aiming at a designated cell in the spreadsheet and input by a user logging in the client, any client sends the processing strategy to a server.

S502, the server receives the processing strategy sent by any client, acquires the data of the designated cell, processes the data of the designated cell according to the processing strategy to obtain a processing result, and sends the processing strategy and the processing result to the designated client.

S503, the appointed client detects whether the user currently logging in the client has the authority, and if the user has the authority, the processing strategy and the processing result are displayed.

By applying the embodiment of the invention, the client sends the processing strategy to the server after receiving the processing strategy aiming at the appointed cell in the spreadsheet and input by the user logging in the client, once the server obtains the data of the appointed cell, the server processes the data of the appointed cell according to the processing strategy and sends the processing result and the processing strategy to the appointed client, and the appointed client displays the processing strategy and the processing result by detecting whether the user currently logging in the client has the authority under the condition of determining that the user currently logging in the client has the authority. Therefore, through data transmission between the client and the server, the processing strategy and the processing result of the designated cells can be automatically transmitted, and the spreadsheet does not need to be repeatedly transmitted among the clients, so that the efficiency of collaborative editing of the spreadsheet is improved. If the user who logs in a certain client at present has the authority, the client can display the processing strategy and the processing result to the user in time, and the user can judge whether the processing strategy is maliciously tampered, whether the setting is wrong or not and the like by checking the processing strategy and the processing result, so that the effectiveness of the electronic form is ensured. And moreover, processing tasks such as user permission detection and judgment whether to display a processing strategy are distributed to the client, so that the pressure of the server is relieved.

In this method, the specific implementation of the server and the client is the same as that in the above embodiments of fig. 1 to 4, and is not described here again.

For ease of understanding, the spreadsheet application method provided by the embodiments of the present invention is described below with reference to the detailed description.

As shown in fig. 6, the client 1 receives a formula input by a user who logs in to the client: cell C1 inputs "═ a1+ B1"; the client 1 compiles the formula and checks whether the formula is valid; if the formula is checked to be valid, the client 1 sends the formula ═ a1+ B1 "to the server; a formula compiling module of the server compiles the formula and writes a compiling result into a local kernel (processing unit) of the server; the server calculates the acquired data of the cell A1 and the cell B1 by using the compiling result to obtain a calculation result; the server sends the calculation result and the compiling result to the client 2 and the client 3; the client 2 learns that the user 2 currently logging in the client 2 is a viewing party with all editing authorities by detecting whether the user currently logging in the client has the authority, formats a calculation result into a character string display and decompiles a formula compiling result into the character string display; the client 3 detects whether the user currently logging in the client has the authority to check the formula content, and only checks the calculation result of the formula, and formats the calculation result into a character string for display.

The compiling process comprises the following steps: the formula of a is 1+ B1 ", and the formula is changed into a formula of a, a1, a + and a B1; converting each participle into a token type, namely an operator, a reference A1, an operator +, a reference B1; performing syntactic analysis, determining the legality of the token type formula, and exchanging the sequence of tokens in the formula to obtain an inverse Polish expression: reference a1, reference B1, operator +; the reference is turned into a relative offset according to the coordinate of the cell C1 in which the calculation formula is located, i.e. the coordinate of the cell C1 is (0,0), the reference "A1" can be (0, -2), and the reference "B1" can be (0, -1).

The decompilation process is as follows: processing relative offset according to the coordinates of the cell C1 where the calculation formula is located to obtain a reference and an operator, and obtaining a reference A1, a reference B1 and an operator +; analyzing an expression of the token type according to the obtained expression, wherein the expression is an operator, a quotation A1, an operator and a quotation B1; according to the token type expression, the splicing results in the calculation formula ═ a1+ B1 ".

As shown in fig. 7, the spreadsheet application method provided by the embodiment of the present invention, applied to the server in the communication system, may include the following steps.

S701, acquiring a processing strategy for the specified cells in the spreadsheet, data of the specified cells and user authority information of currently logged-in clients.

And S702, processing the data of the designated cells according to the processing strategy to obtain a processing result.

S703, aiming at any client, if the user is determined to have the authority according to the user authority information currently logged in the client, the processing strategy and the processing result are sent to the client, so that the processing strategy and the processing result are displayed by the client.

By applying the embodiment of the invention, after receiving the processing strategy aiming at the appointed cell in the spreadsheet and input by the user logging in the client, the client sends the processing strategy to the server, once the server acquires the data of the appointed cell, the server processes the data of the appointed cell according to the processing strategy, sends the processing result and the processing strategy to the client with the authority owned by the user according to the acquired user authority information of the current logging in each client, and displays the processing strategy and the processing result by the client. Therefore, through data transmission between the client and the server, the processing strategy and the processing result of the designated cells can be automatically transmitted, and the spreadsheet does not need to be repeatedly transmitted among the clients, so that the efficiency of collaborative editing of the spreadsheet is improved. If the user who logs in a certain client at present has the authority, the client can display the processing strategy and the processing result to the user in time, and the user can judge whether the processing strategy is maliciously tampered, whether the setting is wrong or not and the like by checking the processing strategy and the processing result, so that the effectiveness of the electronic form is ensured.

The processing strategy and the processing result can be simultaneously sent to the client by the server or asynchronously sent to the client by the server.

The processing policies in steps S701, S702, and S703 may be the same or different in data format. The processing policy in step S701 is a processing policy in an original format, and is used for transmission; the processing policy in step S702 is a processed processing policy, for example, a compiled processing policy, which facilitates data processing by the server; in step S703, the processing policy sent by the server to the designated client may be a processed processing policy or a processing policy for display, and the designated client finally displays the processing policy that is convenient for the user to view intuitively.

In the embodiment of the present invention, the processing policy refers to a preset specific manner for processing data of a certain cell or a plurality of cells in the spreadsheet, and the processing policy may specifically be a calculation formula, a logic statement, and the like. Taking the processing strategy as an example of a calculation formula, the calculation formula is a mathematical expression, or may be called a mathematical function, and specifically may be an expression of mathematical operations such as addition, subtraction, multiplication, division, and absolute value. The processing strategy is set for a certain cell or a certain number of cells. For example, if the calculation formula "SUM (a1, B1)" is set in the cell C1, the processing policy set for the cell C1 is represented as: adding the data of the cell A1 and the data of the cell B1 to obtain the data of the cell C1; for another example, if the calculation formula "MAX (C1: C10)" is set in the cell D1, the processing policy set for the cell D1 is: the largest data is selected from the cells C1 through C10 as the data of cell D1. The logic statement may be a specific arithmetic function, a programming statement, or the like, for example, a logic statement "IF (D1>5) is set in the cell E1, E1 is 1; ELSE E1 ═ 0 ", indicating that the processing policy set for cell E1 is: it is determined whether the data of the cell D1 is greater than 5, and if greater than 5, the data of the cell E1 is 1, and if not greater than 5, the data of the cell E1 is 0.

Optionally, the step of acquiring the processing policy for the specified cell in the spreadsheet and the data of the specified cell in S701 may specifically be: receiving a processing strategy aiming at a designated cell in an electronic form, wherein the processing strategy is sent by a first client, and the processing strategy is input by a user logging in the first client which is any one of a plurality of clients; receiving data of a designated cell sent by a second client, wherein the spreadsheet comprises a plurality of cells; the designated cells are positioned in the spreadsheet and are determined by the server according to the user designation; the data specifying the cell is input by a user logging in a second client, which is any one of the plurality of clients.

The server may further obtain user right information sent by each client and currently logged in each client, where the user right information may specifically be a right identifier, right content, and the like of the user. The server can judge whether the user currently logging in each client side has the authority according to the user authority information.

Different authorities are preset for different users, and for the users to use the electronic form, the electronic form is divided into an authority possessing mode and an authority lacking mode, and the users possessing the authorities can see detailed contents of the electronic form, including data of each cell in the electronic form, detailed information of processing strategies and the like. The client side sends the marks of the current users to the server, and the server can judge whether the users currently logging in each client side have the authority through mark identification and matching. The method for the server to detect whether the user currently logging in each client has the right specifically may be: each client sends the authority identification of the user to the server, the server matches the authority identification with the preset authority identification, if the authority identification is matched with the preset authority identification, the user who logs in the client is proved to have the authority, and if the authority identification is not matched with the preset authority identification, the user who logs in the client does not have the authority.

After the server obtains the processing result, whether the user has the authority or not is judged according to the user authority information of the current login of each client, and if the user of a certain client has the authority, the processing strategy and the processing result are sent to the client. And after receiving the processing strategy and the processing result, the client directly displays the processing strategy and the processing result. The client generally has a display screen, and displays the processing strategy and the processing result to the user through the display screen, specifically, formats the processing strategy and the processing result into a character string for display.

Optionally, in a scenario of receiving a processing policy for a specified cell in the spreadsheet and data of the specified cell sent by the second client, the step S703 may specifically be: for any client except the first client, if the user has the authority according to the user authority information of the current login client, sending a processing strategy and a processing result to the client; and if the first client and the second client are different clients, sending the processing result to the first client.

Because the first client knows the processing strategy and does not need to send the processing strategy to the first client, when the processing strategy and the processing result are sent, whether the user has the authority or not is judged according to the user authority information of the current login client aiming at any client except the first client, and if the user has the authority, the processing strategy and the processing result are sent to the client. Aiming at a first client, only sending a processing result to the first client under the condition that the first client and a second client are different clients; under the condition that the first client and the second client are the same client, the server is not required to feed back the processing strategy and the processing result to the first client. By the method, the interactive data volume is reduced, and the first client does not need to repeatedly send and receive data.

Based on the embodiment shown in fig. 7, an embodiment of the present invention further provides a spreadsheet application method, which is applied to the server in the communication system, as shown in fig. 8, and may include the following steps.

S801, acquiring a processing strategy for a designated cell in the spreadsheet, data of the designated cell and user authority information of each currently logged-in client.

S802, compiling the processing strategy to obtain a compiling result.

And S803, processing the data of the specified cell according to the compiling result to obtain a processing result.

S804, aiming at any client, if the user is determined to have the authority according to the user authority information of the current login client, the compiling result and the processing result obtained by compiling are sent to the client, so that the client can perform decompiling on the compiling result to obtain a processing strategy, and the processing strategy and the processing result are displayed.

In an implementation manner of the embodiment of the present invention, in order to facilitate the server to process the data of the designated cell, after the processing policy for the designated cell is obtained, the processing policy is compiled first, the processing policy is compiled into a manner more convenient for the server to identify and calculate, and then the data of the designated cell is processed according to a compiling result obtained after compiling, so as to obtain a processing result. In order to enhance the privacy of data, when the server sends the processing strategy and the processing result to the specified client, the specific sending can be the compiling result and the processing result, so that after the specified client receives the compiling result and the processing result, the compiling result is decompiled to obtain the processing strategy, and then the processing strategy and the processing result are displayed.

The specific process of processing policy compiling and decompiling is the same as that of the embodiment described in fig. 2, and is not described here again.

As shown in fig. 9, the method for applying a spreadsheet according to the embodiment of the present invention is applied to a client in the communication system, where a user currently logged in the client has a right, and may include the following steps.

S901, receiving a processing strategy and a processing result which are sent by a server and aim at the designated cells in the spreadsheet.

And S902, displaying the processing strategy and the processing result.

By applying the embodiment of the invention, when the user who logs in the client currently has the ownership right, the client displays the processing strategy and the processing result to the user after receiving the processing strategy aiming at the specified cell and the processing result of the specified cell sent by the server. Therefore, through data transmission between the client and the server, the processing strategy and the processing result of the designated cells can be automatically transmitted, and the spreadsheet does not need to be repeatedly transmitted among the clients, so that the efficiency of collaborative editing of the spreadsheet is improved. Moreover, only the user with the authority can check the processing strategy and the processing result, and can judge whether the processing strategy is maliciously tampered, whether the setting is wrong and the like, so that the effectiveness of the electronic form is ensured.

Based on the embodiment shown in fig. 9, an embodiment of the present invention further provides a spreadsheet application method, which is applied to the client in the communication system, as shown in fig. 10, and may include the following steps.

S1001, receiving a compiling result of the processing strategy aiming at the designated cell in the spreadsheet and a processing result of the designated cell sent by the server.

S1002, performing decompiling on the compiling result to obtain a processing strategy, and displaying the processing strategy and the processing result.

In an implementation manner of the embodiment of the present invention, in order to facilitate the server to process the data of the designated cell, after the processing policy for the designated cell is obtained, the processing policy is compiled first, the processing policy is compiled into a manner more convenient for the server to identify and calculate, and then the data of the designated cell is processed according to a compiling result obtained after compiling, so as to obtain a processing result. In order to enhance the privacy of data, when the server sends the processing strategy and the processing result to the specified client, the specific sending can be the compiling result and the processing result, so that after the specified client receives the compiling result and the processing result, the compiling result is decompiled to obtain the processing strategy, and then the processing strategy and the processing result are displayed. The decompilation process is detailed in the embodiment shown in fig. 2, and is not described here again.

Optionally, the method of the embodiment shown in fig. 9 and 10 may further include the following steps:

As shown in fig. 11, the spreadsheet application method provided by the embodiment of the present invention, applied to the above communication system, may include the following steps.

S1101, after receiving a processing strategy aiming at a designated cell in the spreadsheet and input by a user logging in the client, any client sends the processing strategy to a server.

And S1102, the server receives the processing strategy sent by the client, acquires the data of the specified cell and the user authority information of each currently logged client, processes the data of the specified cell according to the processing strategy to obtain a processing result, and if the user is determined to have the authority according to the user authority information of the currently logged client, the server sends the processing strategy and the processing result to the client.

And S1103, after receiving the processing strategy and the processing result sent by the server, the client displays the processing strategy and the processing result.

By applying the embodiment of the invention, after receiving the processing strategy aiming at the appointed cell in the spreadsheet and input by the user logging in the client, the client sends the processing strategy to the server, once the server acquires the data of the appointed cell, the server processes the data of the appointed cell according to the processing strategy, sends the processing result and the processing strategy to the client with the authority of the user according to the acquired user authority information of the current logging in each client, and displays the processing strategy and the processing result by the client. Therefore, through data transmission between the client and the server, the processing strategy and the processing result of the designated cells can be automatically transmitted, and the spreadsheet does not need to be repeatedly transmitted among the clients, so that the efficiency of collaborative editing of the spreadsheet is improved. If the user who logs in a certain client at present has the authority, the client can display the processing strategy and the processing result to the user in time, and the user can judge whether the processing strategy is maliciously tampered, whether the setting is wrong or not and the like by checking the processing strategy and the processing result, so that the effectiveness of the electronic form is ensured.

In this method, the specific implementation of the server and the client is the same as that in the above embodiment of fig. 7 to 10, and is not described again here.

As shown in fig. 12, the client 1 receives a formula input by a user who logs in to the client: cell C1 inputs "═ SUM (a1, B1)"; the client 1 compiles the formula and checks whether the formula is valid; checking that the formula is valid, the client 1 sends the formula ═ SUM (a1, B1) "to the server; a formula compiling module of the server compiles the formula and writes a compiling result into a local kernel (processing unit) of the server; the server calculates the acquired data of the cell A1 and the cell B1 by using the compiling result to obtain a calculation result; the server determines that the user 2 is a viewing party with all editing rights according to the received right identifier of the user 2 currently logging in the client 2, determines that the user 3 does not have the right to view formula contents according to the received user right identifier of the currently logging in client 3, and can only view the calculation result of the formula, so that the calculation result and the compiling result are sent to the client 2, the calculation result is formatted into a character string display by the client 2, the compiling result of the formula is decompiled into a character string display, the calculation result is sent to the client 3, and the calculation result is formatted into the character string display by the client 3.

The compiling process comprises the following steps: the formula "═ SUM (a1, B1)" is subjected to word segmentation processing, and becomes "═ SUM", "a1", "B1"; converting each participle into a token type, wherein the type is an operator, an operator SUM, a reference A1 and a reference B1; performing syntactic analysis, determining the legality of the token type formula, and exchanging the sequence of tokens in the formula to obtain an inverse Polish expression: reference a1, reference B1, operator SUM; the reference is turned into a relative offset according to the coordinate of the cell C1 in which the calculation formula is located, i.e. the coordinate of the cell C1 is (0,0), the reference "A1" can be (0, -2), and the reference "B1" can be (0, -1).

The decompilation process is as follows: processing relative offset according to the coordinates of the cell C1 where the calculation formula is located to obtain a reference and an operator to obtain a reference A1, a reference B1 and an operator SUM; analyzing the token type expression according to the obtained expression, wherein the token type expression is respectively an operator (SUM), an operator SUM, a citation A1 and a citation B1; according to token-type expressions, the concatenation yields the calculation formula "═ SUM (a1, B1)".

Based on the foregoing method embodiments, an embodiment of the present invention provides a spreadsheet application apparatus, which is applied to a server in a communication system, where the communication system includes the server and a plurality of clients, and as shown in fig. 13, the apparatus may include:

an obtaining module 1310 for obtaining a processing policy for a specified cell in the spreadsheet and data of the specified cell;

a processing module 1320, configured to process the data of the designated cell according to the processing policy, so as to obtain a processing result;

the sending module 1330 is configured to send the processing policy and the processing result to the specified client, so that the specified client displays the processing policy and the processing result under the condition that it is determined that the user currently logging in the client has the right.

Optionally, the obtaining module 1310 may be specifically configured to:

receiving data of a designated cell sent by a second client, wherein the spreadsheet comprises a plurality of cells; the designated cells are positioned in the spreadsheet and are determined by the server according to the user designation; the data specifying the cell is input by a user logging in a second client, which is any one of the plurality of clients.

Optionally, the sending module 1330 may be specifically configured to:

Optionally, the apparatus may further include:

the processing module 1320 may be specifically configured to: processing the data of the specified cells according to the compiling result to obtain a processing result;

the sending module 1330 may be specifically configured to: and sending the compiling result and the processing result to the appointed client so that the appointed client performs decompiling on the compiling result under the condition that the user currently logging in the client has the authority, so as to obtain a processing strategy, and displaying the processing strategy and the processing result.

By applying the embodiment of the invention, the client sends the processing strategy to the server after receiving the processing strategy aiming at the appointed cell in the spreadsheet and input by the user logging in the client, once the server obtains the data of the appointed cell, the data of the appointed cell is processed according to the processing strategy, the processing result and the processing strategy are sent to the appointed client, and the appointed client displays the processing strategy and the processing result by detecting whether the user currently logging in the client has the authority under the condition of determining that the user currently logging in the client has the authority. Therefore, through data transmission between the client and the server, the processing strategy and the processing result of the designated cells can be automatically transmitted, and the spreadsheet does not need to be repeatedly transmitted among the clients, so that the efficiency of collaborative editing of the spreadsheet is improved. If the user who logs in a certain client at present has the authority, the client can display the processing strategy and the processing result to the user in time, and the user can judge whether the processing strategy is maliciously tampered, whether the setting is wrong or not and the like by checking the processing strategy and the processing result, so that the effectiveness of the electronic form is ensured.

An embodiment of the present invention provides an electronic form application apparatus, which is applied to a client in a communication system, where the communication system includes a server and multiple clients, and as shown in fig. 14, the apparatus may include:

the receiving module 1410 is configured to receive the processing policy for the specified cell in the spreadsheet and the processing result of the specified cell, which are sent by the server;

the detecting module 1420 is configured to detect whether a user currently logging in the client has an authority;

the display module 1430 is configured to display the processing policy and the processing result if the user has the right.

Optionally, the display module 1430 may be further configured to display only the processing result if the user does not have the right.

the apparatus may further include:

Optionally, the apparatus may further include:

By applying the embodiment of the invention, after receiving the processing strategy aiming at the specified cell and the processing result aiming at the specified cell sent by the server, the client needs to detect whether the user currently logging in the client has the authority, and displays the processing strategy and the processing result to the user under the condition of detecting that the user currently logging in the client has the authority. Therefore, through data transmission between the client and the server, the processing strategy and the processing result of the designated cells can be automatically transmitted, and the spreadsheet does not need to be repeatedly transmitted among the clients, so that the efficiency of collaborative editing of the spreadsheet is improved. Moreover, only the user with the authority can check the processing strategy and the processing result, and can judge whether the processing strategy is maliciously tampered, whether the setting is wrong and the like, so that the effectiveness of the electronic form is ensured.

An embodiment of the present invention provides an electronic form application apparatus, which is applied to a server in a communication system, where the communication system includes the server and a plurality of clients, and as shown in fig. 15, the apparatus may include:

an obtaining module 1510, configured to obtain a processing policy for a specified cell in the spreadsheet, data of the specified cell, and user right information of currently logged in each client;

the processing module 1520, configured to process the data of the designated cell according to the processing policy, to obtain a processing result;

the sending module 1530 is configured to, for any client, send the processing policy and the processing result to the client if it is determined that the user has the right according to the user right information currently logged in the client, so that the client displays the processing policy and the processing result.

Optionally, the obtaining module 1510 may be specifically configured to:

Optionally, the sending module 1530 may be specifically configured to:

Optionally, the apparatus may further include:

the processing module 1520, which may be specifically configured to process the data of the designated cell according to the compiling result to obtain a processing result;

the sending module 1530 may be specifically configured to, for any client, send the compiled result and the processing result obtained by the compiling to the client if it is determined that the user has the right according to the user right information currently logged in the client, so that the client performs decompiling on the compiled result to obtain the processing policy, and displays the processing policy and the processing result.

An embodiment of the present invention provides an electronic form application apparatus, which is applied to a client in a communication system, where a user currently logging in the client has an authority, the communication system includes a server and a plurality of clients, and as shown in fig. 16, the apparatus may include:

a receiving module 1610, configured to receive a processing policy and a processing result sent by a server for a specified cell in a spreadsheet;

the display module 1620 is configured to display the processing policy and the processing result.

the apparatus may further include:

Optionally, the apparatus may further include:

the sending module may be specifically configured to send the processing policy to the server if it is determined that the processing policy is legal according to the compiling result.

By applying the embodiment of the invention, under the condition that the user currently logging in the client side has the authority, the client side can display the processing strategy and the processing result to the user after receiving the processing strategy aiming at the specified cell and the processing result of the specified cell sent by the server. Therefore, through data transmission between the client and the server, the processing strategy and the processing result of the designated cells can be automatically transmitted, and the spreadsheet does not need to be repeatedly transmitted among the clients, so that the efficiency of collaborative editing of the spreadsheet is improved. Moreover, only the user with the authority can check the processing strategy and the processing result, and can judge whether the processing strategy is maliciously tampered, whether the setting is wrong and the like, so that the effectiveness of the electronic form is ensured.

The embodiment of the present invention further provides a server, as shown in fig. 17, including a processor 1701, a communication interface 1702, a memory 1703 and a communication bus 1704, where the processor 1701, the communication interface 1702 and the memory 1703 complete mutual communication through the communication bus 1704;

a memory 1703 for storing a computer program;

the processor 1701 is configured to implement the spreadsheet application method applied to the server according to the embodiment of the present invention when executing the computer program stored in the memory 1703.

An embodiment of the present invention further provides a client, as shown in fig. 18, including a processor 1801, a communication interface 1802, a memory 1803, and a communication bus 1804, where the processor 1801, the communication interface 1802, and the memory 1803 complete communication therebetween through the communication bus 1804;

a memory 1803 for storing a computer program;

the processor 1801 is configured to, when executing the computer program stored in the memory 1803, implement the spreadsheet application method applied to the client according to the embodiment of the present invention.

By applying the embodiment of the invention, the processing strategy and the processing result of the specified cell can be automatically transmitted through the data transmission between the client and the server, and the spreadsheet does not need to be repeatedly transmitted among the clients, thereby improving the efficiency of the collaborative editing of the spreadsheet. If the user who logs in a certain client at present has the authority, the client can display the processing strategy and the processing result to the user in time, and the user can judge whether the processing strategy is maliciously tampered, whether the setting is wrong or not and the like by checking the processing strategy and the processing result, so that the effectiveness of the electronic form is ensured.

The communication bus mentioned in the above server may be a Peripheral Component Interconnect (PCI) bus, an Extended Industry Standard Architecture (EISA) bus, or the like. The communication bus may be divided into an address bus, a data bus, a control bus, etc. For ease of illustration, only one thick line is shown, but this does not mean that there is only one bus or one type of bus.

The communication interface is used for communication between the server and other devices.

The Memory may include a Random Access Memory (RAM) or a Non-volatile Memory (NVM), such as at least one disk Memory. Optionally, the memory may also be at least one memory device located remotely from the processor.

The Processor may be a general-purpose Processor, and includes a Central Processing Unit (CPU), a Network Processor (NP), and the like; the device can also be a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA) or other Programmable logic device, a discrete Gate or transistor logic device, or a discrete hardware component.

In another embodiment of the present invention, a machine-readable storage medium is further provided, in which instructions are stored, and when the instructions are executed on a server, the server executes the spreadsheet application method applied to the server provided by the embodiment of the present invention.

In another embodiment of the present invention, a machine-readable storage medium is further provided, in which instructions are stored, and when the instructions are executed on a server, the server executes the spreadsheet application method applied to a client according to the embodiment of the present invention.

In still another embodiment provided by the present invention, there is also provided a computer program product containing instructions that, when run on a server, cause the server to execute the spreadsheet application method applied to the server provided by the embodiment of the present invention.

In yet another embodiment provided by the present invention, there is also provided a computer program product containing instructions that, when run on a server, cause the server to execute the spreadsheet application method applied to a client provided by an embodiment of the present invention.

In the above embodiments, the implementation may be wholly or partially realized by software, hardware, firmware, or any combination thereof. When implemented in software, may be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer instructions. When loaded and executed on a computer, cause the processes or functions described in accordance with the embodiments of the invention to occur, in whole or in part. The computer may be a general purpose computer, a special purpose computer, a network of computers, or other programmable device. The computer instructions may be stored on a computer readable storage medium or transmitted from one computer readable storage medium to another, for example, from one website, computer, server, or data center to another website, computer, server, or data center via wire (e.g., coaxial cable, fiber optic, Digital Subscriber Line (DSL)), or wireless (e.g., infrared, wireless, microwave, etc.). The computer-readable storage medium can be any available medium that can be accessed by a computer or a data storage device, such as a server, a data center, etc., that incorporates one or more of the available media. The usable medium may be a magnetic medium (e.g., a floppy Disk, a hard Disk, a magnetic tape), an optical medium (e.g., a Digital Versatile Disk (DVD)), or a semiconductor medium (e.g., a Solid State Disk (SSD)), etc.

An embodiment of the present invention further provides a communication system, as shown in fig. 19, the communication system includes a server 1901 and a plurality of clients 1902:

An embodiment of the present invention provides a communication system, as shown in fig. 20, the communication system includes a server 2001 and a plurality of clients 2002:

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 apparatus, the server, the client, the machine-readable storage medium, the computer program product containing the instructions, and the communication system embodiments, since they are substantially similar to the method embodiments, the description is relatively simple, and it is sufficient to refer to the partial description of the method embodiments in relation thereto.

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

1. A spreadsheet application method applied to a server in a communication system, the communication system comprising the server and a plurality of clients, the method comprising:

acquiring a processing strategy for a specified cell in a spreadsheet and data of the specified cell;

processing the data according to the processing strategy to obtain a processing result;

and sending the processing strategy and the processing result to a designated client so that the designated client displays the processing strategy and the processing result under the condition of determining that the user currently logging in the client has the authority.

2. The method of claim 1, wherein obtaining the processing policy for the specified cell in the spreadsheet and the data for the specified cell comprises:

receiving a processing strategy aiming at a designated cell in a spreadsheet, wherein the processing strategy is sent by a first client, the processing strategy is input by a user logging in the first client, and the first client is any one of a plurality of clients;

and receiving data of the designated cell sent by a second client, wherein the data is input by a user logging in the second client, and the second client is any one of the plurality of clients.

3. The method of claim 2, wherein sending the processing policy and the processing result to a specified client comprises:

4. The method of claim 1, wherein processing the data according to the processing policy to obtain a processing result comprises:

compiling the processing strategy to obtain a compiling result;

processing the data of the specified cell according to the compiling result to obtain a processing result;

the sending the processing strategy and the processing result to a specified client comprises:

and sending the compiling result and the processing result to a designated client so that the designated client performs decompiling on the compiling result under the condition of determining that the user currently logging in the client has the authority, so as to obtain the processing strategy, and displaying the processing strategy and the processing result.

5. A spreadsheet application method for a client in a communication system, the communication system comprising a server and a plurality of clients, the method comprising:

receiving a processing strategy for a specified cell in a spreadsheet and a processing result of the specified cell sent by the server;

6. The method of claim 5, wherein after the detecting whether the user currently logged on the client has the right, the method further comprises:

and if the user has no authority, only displaying the processing result.

7. The method according to claim 5, wherein the received processing policy is a compilation result obtained by compiling the obtained processing policy by the server;

before the displaying the processing strategy and the processing result, the method further comprises:

and performing decompiling on the compiling result to obtain the processing strategy.

8. The method of claim 5, further comprising:

if a processing strategy aiming at a designated cell in an electronic form and input by a user logging in the client is received, the processing strategy is sent to the server;

and if the data of the specified cell input by the user logging in the client is received, sending the data to the server.

9. The method of claim 8, wherein prior to said sending the processing policy to the server, the method further comprises:

compiling the processing strategy to obtain a compiling result;

the sending the processing policy to the server includes:

10. A spreadsheet application method applied to a communication system, the communication system comprising a server and a plurality of clients, the method comprising:

after receiving a processing strategy aiming at a designated cell in an electronic form, which is input by a user logging in the client, any client sends the processing strategy to the server;

the server receives the processing strategy sent by any client, acquires the data of the designated cell, processes the data according to the processing strategy to obtain a processing result, and sends the processing strategy and the processing result to the designated client;

the appointed client detects whether a user currently logging in the client has the authority, and if the user has the authority, the processing strategy and the processing result are displayed.

11. A spreadsheet application method applied to a server in a communication system, the communication system comprising the server and a plurality of clients, the method comprising:

acquiring a processing strategy for a designated cell in an electronic form, data of the designated cell and user authority information of currently logged-in clients;

and aiming at any client, if the user is determined to have the authority according to the user authority information currently logged in the client, the processing strategy and the processing result are sent to the client, so that the client displays the processing strategy and the processing result.

12. The method of claim 11, wherein obtaining the data for a specified cell in the spreadsheet for a processing policy for the specified cell comprises:

and receiving the data of the designated cell sent by a second client, wherein the data of the designated cell is input by a user logging in the second client, and the second client is any one of the plurality of clients.

13. The method of claim 12, wherein the sending the processing policy and the processing result to any client if the user has the right according to the user right information currently logged into the client for the client comprises:

for any client except the first client, if the user is determined to have the authority according to the user authority information of the current login client, the processing strategy and the processing result are sent to the client;

14. The method of claim 11, wherein processing the data according to the processing policy to obtain a processing result comprises:

compiling the processing strategy to obtain a compiling result;

for any client, if the user is determined to have the authority according to the user authority information currently logging in the client, the processing strategy and the processing result are sent to the client, and the method comprises the following steps:

and for any client, if the user is determined to have the authority according to the user authority information currently logged in the client, sending the compiling result and the processing result obtained by compiling to the client so that the client can decompile the compiling result to obtain the processing strategy, and displaying the processing strategy and the processing result.

15. A spreadsheet application method applied to a client in a communication system, wherein a user currently logging in the client has a right, the communication system comprises a server and a plurality of clients, and the method comprises:

receiving a processing strategy and a processing result which are sent by the server and aim at the designated cells in the spreadsheet;

and displaying the processing strategy and the processing result.

16. The method according to claim 15, wherein the received processing policy is a compilation result obtained by compiling the obtained processing policy by the server;

17. The method of claim 15, further comprising:

18. The method of claim 17, wherein prior to said sending the processing policy to the server, the method further comprises:

compiling the processing strategy to obtain a compiling result;

the sending the processing policy to the server includes:

19. A spreadsheet application method applied to a communication system, the communication system comprising a server and a plurality of clients, the method comprising:

the server receives the processing strategy sent by the client, acquires the data of the specified cells and the user authority information of the current login of each client, processes the data according to the processing strategy to obtain a processing result, and if the user is determined to have authority according to the user authority information of the current login of the client, the server sends the processing strategy and the processing result to the client;

20. An apparatus for spreadsheet application, applied to a server in a communication system, the communication system comprising the server and a plurality of clients, the apparatus comprising:

the system comprises an acquisition module, a processing module and a processing module, wherein the acquisition module is used for acquiring a processing strategy for a specified cell in a spreadsheet and data of the specified cell;

the processing module is used for processing the data according to the processing strategy to obtain a processing result;

and the sending module is used for sending the processing strategy and the processing result to a specified client so that the specified client displays the processing strategy and the processing result under the condition of determining that the user currently logging in the client has the authority.

21. The apparatus of claim 20, wherein the obtaining module is specifically configured to:

22. The apparatus of claim 21, wherein the sending module is specifically configured to:

23. The apparatus of claim 20, further comprising:

the processing module is specifically configured to: processing the data of the specified cell according to the compiling result to obtain a processing result;

the sending module is specifically configured to: and sending the compiling result and the processing result to a designated client so that the designated client performs decompiling on the compiling result under the condition of determining that the user currently logging in the client has the authority, so as to obtain the processing strategy, and displaying the processing strategy and the processing result.

24. An apparatus for spreadsheet application, applied to a client in a communication system, the communication system comprising a server and a plurality of clients, the apparatus comprising:

the receiving module is used for receiving the processing strategy aiming at the specified cell in the spreadsheet and the processing result of the specified cell, which are sent by the server;

25. The apparatus of claim 24, wherein the display module is further configured to display only the processing result if the user has no authority.

26. The apparatus according to claim 24, wherein the received processing policy is a compilation result obtained by compiling the obtained processing policy by the server;

the device further comprises:

and the decompiling module is used for decompiling the compiling result to obtain the processing strategy.

27. The apparatus of claim 24, further comprising:

the sending module is used for sending the processing strategy to the server if the processing strategy aiming at the appointed cells in the spreadsheet and input by a user logging in the client is received; and if the data of the specified cell input by the user logging in the client is received, sending the data to the server.

28. The apparatus of claim 27, further comprising:

the sending module is specifically configured to send the processing policy to the server if it is determined that the processing policy is legal according to the compiling result.

29. An apparatus for spreadsheet application, applied to a server in a communication system, the communication system comprising the server and a plurality of clients, the apparatus comprising:

the system comprises an acquisition module, a storage module and a processing module, wherein the acquisition module is used for acquiring a processing strategy aiming at a specified cell in an electronic form, data of the specified cell and user authority information of each current login client;

and the sending module is used for sending the processing strategy and the processing result to any client side if the user is determined to have the authority according to the user authority information currently logged in the client side so as to enable the client side to display the processing strategy and the processing result.

30. The apparatus of claim 29, wherein the obtaining module is specifically configured to:

31. The apparatus of claim 30, wherein the sending module is specifically configured to:

32. The apparatus of claim 29, further comprising:

the processing module is specifically configured to process the data of the specified cell according to the compiling result to obtain a processing result;

the sending module is specifically configured to send the compiling result and the processing result obtained by compiling to the client if the user has the authority according to the user authority information currently logged in the client for any client, so that the client performs decompiling on the compiling result to obtain the processing policy, and displays the processing policy and the processing result.

33. An apparatus for spreadsheet application, applied to a client in a communication system, wherein a user currently logged in to the client has a right, the communication system comprises a server and a plurality of clients, the apparatus comprises:

the receiving module is used for receiving the processing strategy and the processing result which are sent by the server and aim at the specified cells in the spreadsheet;

34. The apparatus according to claim 33, wherein the received processing policy is a compilation result obtained by compiling the obtained processing policy by the server;

the device further comprises:

35. The apparatus of claim 33, further comprising:

36. The apparatus of claim 35, further comprising:

37. A server 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 communicated with each other through the communication bus;

the memory is used for storing a computer program;

the processor, when executing a computer program stored on the memory, implementing the method of any of claims 1-4 or 11-14.

38. The client 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 communicated with each other through the communication bus;

the memory is used for storing a computer program;

the processor, when executing a computer program stored on the memory, implementing the method of any of claims 5-9 or 15-19.

39. A computer-readable storage medium, in which a computer program is stored which, when being executed by a processor, carries out the method of any one of claims 1 to 4, or the method of any one of claims 5 to 9, or the method of any one of claims 11 to 14, or the method of any one of claims 15 to 19.

40. A communication system, comprising a server and a plurality of clients:

the appointed client is used for detecting whether a user currently logging in the client has the authority, and if the user has the authority, the processing strategy and the processing result are displayed.

41. A communication system, comprising a server and a plurality of clients:

the server is used for receiving the processing strategy sent by the client, acquiring the data of the specified cells and the user authority information of each client currently logged in, processing the data according to the processing strategy to obtain a processing result, and if the user has the authority according to the user authority information of the client currently logged in, sending the processing strategy and the processing result to the client for any client;