Spreadsheet formula translation of server calculation rules

A computer-readable storage device storing computer-executable instructions that, when executed, cause a server computer to perform a computer-implemented method for handling data, the method comprising:

• generating a dependency graph of cells finding dependent on input cells in a client spreadsheet application document of a client spreadsheet application;
• finding dependent cells based on the dependency graph, the dependent cells containing current values calculated via server calculation rules based on current data of the input cells in the client spreadsheet application document submitted to the server by the client spreadsheet application;
• translating the server calculation rules into client spreadsheet application formulae, the server calculation rules defining one or more server calculations performed on the current data in the input cells of the client spreadsheet application document which require data that is not present in the client spreadsheet application document to provide the current values for the dependent cells, the client spreadsheet application formulae reducing a server calculation which requires data that is not present in the client spreadsheet application document to a client-side calculation, the client-side calculation using the current data of one or more input cells and a constant representing required data that is not present in the client spreadsheet application document to provide the current value of a particular dependent cell, the constant derived from the current data of the one or more input cells and the current value of the particular dependent cell;
• and
• inserting the client spreadsheet application formulae into the client spreadsheet application document in association with cells of the client spreadsheet application document, the client spreadsheet application formulae for calculating an updated value for the particular dependent cell by performing the client-side calculation using updated data of the one or more input cells and the constant without the client spreadsheet application submitting the updated data of the one or more input cells to the server.

A computer-implemented method of handling data, comprising:

• generating, by a server computer, a dependency graph of cells dependent on input cells in a client spreadsheet application document of a client spreadsheet application;
• finding, by the server computer, dependent cells based on the dependency graph, the dependent cells containing current values calculated via server calculation rules based on current data of the input cells in the client spreadsheet application document submitted to the server computer by the client spreadsheet application;
• translating, by the server computer, the server calculation rules into client spreadsheet application formulae, the server calculation rules defining one or more server calculations performed on the current data in the input cells of the client spreadsheet application document which require data that is not present in the client spreadsheet application document to provide the current values for the dependent cells, the client spreadsheet application formulae reducing a server calculation which requires data that is not present in the client spreadsheet application document to a client-side calculation, the client-side calculation using the current data of one or more input cells and a constant representing required data that is not present in the client spreadsheet application document to provide the current value of a particular dependent cell, the constant derived from the current data of the one or more input cells and the current value of the particular dependent cell;
• and
• uploading, by the server computer, the client spreadsheet application formulae into the client spreadsheet application document in association with cells of the client spreadsheet application document, the client spreadsheet application formulae for calculating an updated value for the particular dependent cell by performing the client-side calculation using updated data of the one or more input cells and the constant without the client spreadsheet application submitting the updated data of the one or more input cells to the server.