Collaborative online spreadsheet application

• US 8,307,119 B2
• Filed: 03/31/2006
• Issued: 11/06/2012
• Est. Priority Date: 03/31/2006
• Status: Active Grant

• Current Assignee: Google LLC (Alphabet Inc.)
• Original Assignee: Google Inc. (Alphabet Inc.)
• Inventors: Rochelle, Jonathan, Lemonik, Micah, Khosrowshahi, Farzad, Danaher, John Stephen
• Primary Examiner(s): HOANG, HIEU T
• Application Number:
  US11/278,345
• Publication Number:
  US 20070233811A1
• Time in Patent Office: 2,412 Days
• Field of Search: 709/248, 709/225, 709/226, 709201-203
• US Class Current: 709/248
• CPC Class Codes: G06F 16/93 Document management systems
• CPC Class Codes: G06F 16/958 Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking
• CPC Class Codes: G06F 40/103 Formatting, i.e. changing of presentation of documents automatic justification G06F40/189; automatic line break hyphenation G06F40/191
• CPC Class Codes: G06F 40/106 Display of layout of documents; Previewing
• CPC Class Codes: G06F 40/174 Form filling; Merging
• CPC Class Codes: G06F 40/177 of tables; using ruled lines
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06F 8/34 Graphical or visual programming
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: H04L 67/01 Protocols

Abstract

A distributed spreadsheet application executes at a server and a client in a network. The networked spreadsheet application can generally be used without requiring a user to install any specific spreadsheet software prior to using the application. In one implementation, the spreadsheet application may include a client engine that executes within browser programs of a plurality of client computing devices and server logic. The server logic may be configured to distribute the client engines to the plurality of client computing devices of the spreadsheet application when requested through the browser programs of each of the plurality of client computing devices. The server logic synchronizes a single spreadsheet document that is simultaneously open at the plurality of client computing devices.

Claims

1. A method comprising:

receiving, by a server computing device, a request for a spreadsheet application from a browser program of a client computing device;

transmitting, in response to the request and from the server computing device, programming code for a first portion of the spreadsheet application to the browser program of the client computing device, the programming code for the first portion of the spreadsheet application locally processing requests, from a first user at the client computing device, relating to navigating or formatting a spreadsheet document of the spreadsheet application, where the first user has a first set of privileges for the spreadsheet document;

receiving, by the server computing device and from the client computing device, a formula entered into a cell of the spreadsheet document at the client computing device;

executing, by the server computing device, programming code for a second portion of the spreadsheet application, where executing the programming code for the second portion of the spreadsheet application includes calculating a function, associated with the received formula, to generate a result;

transmitting, from the server computing device and to the client computing device, the result of calculating the function, where

the client computing device has simultaneous access to the formula and the result, and

the result is located within the cell of the spreadsheet document; and

transmitting, from the server computing device and to another client computing device, the result of calculating the function, associated with the received formula, without sharing the formula with the other client computing device, where

the other client computing device is different from the client computing device from which the formula was received,

the other client computing device is associated with a second user that has a second set of privileges for the spreadsheet document, and

the other client computing device has access to only the result, located within the cell of the spreadsheet document, at substantially a same time that the client computing device has simultaneous access to the formula and the result.

2. The method of claim 1, further comprising:

transmitting the programming code for the first portion of the spreadsheet application to browser programs of a plurality of client computing devices; and

updating changes, to the spreadsheet document, made via the first portion of the spreadsheet application at one of the plurality of client computing devices, to spreadsheet documents at others of the plurality of client computing devices.

3. The method of claim 2, where the others of the plurality of client computing devices are updated in real-time.

4. The method of claim 2, where the first portion of the spreadsheet application displays a messaging area to display messages from users of the plurality of client computing devices.

5. The method of claim 4, where the messages are communicated between the users of the plurality of client computing devices in real-time.

6. The method of claim 1, further comprising:

providing the function within the spreadsheet document, where the function was created by a user of the other client computing device.

7. The method of claim 1, further comprising:

receiving, from the client computing device, an instruction to make the spreadsheet document accessible by the other client computing device; and

making the spreadsheet document accessible to the other client computing device, in response to receiving the instruction.

8. The method of claim 1, where the cell of the spreadsheet document is visually distinguished to indicate an entry by the first user, at the client computing device, from one or more entries made by the second user, at the other client computing device.

9. A non-transitory computer-readable medium containing instructions comprising:

one or more instructions which, when executed by at least one processor of a server computing device, cause the at least one processor to transmit, to a browser program of a client computing device and in response to a request from the client computing device, programming code for a first portion of a spreadsheet application, the programming code for the first portion of the spreadsheet application locally executing requests, from a first user at the client computing device, relating to navigating or formatting a spreadsheet document of the spreadsheet application, where the first user has a first set of privileges for the spreadsheet document;

one or more instructions which, when executed by the at least one processor, cause the at least one processor to receive, from the client computing device, a formula entered into a cell of the spreadsheet document at the client computing device;

one or more instructions which, when executed by the at least one processor, cause the at least one processor to execute programming code for a second portion of the spreadsheet application, where when the programming instructions cause the computing device to execute the programming code for the second portion of the spreadsheet application, the programming instructions cause the server computing device to calculate a function, associated with the received formula to generate a result;

one or more instructions which, when executed by the at least one processor, cause the at least one processor to transmit, from the server computing device and to the client computing device, the result of calculating the function, where

the client computing device has simultaneous access to the formula and the result, and

the result is located within the cell of the spreadsheet document; and

one or more instructions which, when executed by the at least one processor, cause the at least one processor to transmit, to another client computing device, that is different from the client computing device from which the formula was received, the result of calculating the function, associated with the received the formula, without sharing internal details of the formula with the other client computing device, where

the other client computing device is associated with a second user that has a second set of privileges for the spreadsheet document, and

the other client computing device has access to only the result, located within the cell of the spreadsheet document, at substantially a same time that the client computing device has simultaneous access to the formula and the result.

10. The medium of claim 9, further comprising:

one or more instructions to update, in real-time, changes made, to the spreadsheet document at the client computing device, at one or more other client computing devices that are sharing the spreadsheet document with the client computing device.

11. The medium of claim 9, where the cell of the spreadsheet document is visually distinguished to indicate an entry by the first user, at the client computing device, from one or more entries made by the second user, at the other client computing device.

12. A device comprising:

a processor; and

a memory coupled to the processor, the memory storing instructions that, when executed by the processor, cause the processor to;

distribute a client engine to a plurality of client computing devices over a network, the client engine implementing a first portion of functionality, associated with a spreadsheet application and relating to navigating or formatting a spreadsheet document of the spreadsheet application, and being distributed to each of the plurality of client computing devices in response to requests from the plurality of client computing devices for the spreadsheet application, where a first user, associated with one of the plurality of client computing devices, has a first set of privileges for the spreadsheet document;

receive a formula, entered into a cell of the spreadsheet document, from the one of the plurality of client computing devices;

execute a spreadsheet server component that performs a second portion of the functionality associated with the spreadsheet application locally at the device, the spreadsheet server component performing one or more calculations, relating to the formula, that are performed on behalf of the one of the plurality of client computing devices, to generate a result;

transmit, to the one of the plurality of client computing devices, the result of calculating the formula, where

the one of the plurality of client computing devices has simultaneous access to the formula and the result, and

the result is located within the cell of the spreadsheet document; and

transmit, to one or more other client computing devices, of the plurality of client computing devices, the result of calculating the formula, without sharing the formula with the one or more other client computing devices, where

the one or more other client computing devices are different from the one of the plurality of client computing devices from which the formula was received,

the one or more other client computing devices are associated with one or more second users that each have a second set of privileges for the spreadsheet document, and

the one or more other client computing devices have access to only the result, located within the cell of the spreadsheet document, at substantially a same time that the one of the plurality of client computing devices has simultaneous access to the formula and the result.

13. The device of claim 12, where the client engine is distributed to at least one of the plurality of client computing devices in response to an HTTP request made to the device by a web browser executing at one of the plurality of the client computing devices.

14. The device of claim 12, where one or more of the client engines, at the plurality of client computing devices, provide a user interface that includes a messaging area to display messages communicated between users of the plurality of client computing devices.

15. The device of claim 14, where the messages are communicated between the users of the plurality of client computing devices in real-time.

16. The device of claim 12, where the client engine is to display a user interface for the spreadsheet application as a spreadsheet user interface embedded within a browser window.

17. The device of claim 16, where the spreadsheet user interface is embedded in a frame of a web page.

18. The device of claim 12, where the first portion of functionality associated with the spreadsheet application is designed to locally handle requests, from users at the plurality of client computing devices, relating to navigating or formatting a spreadsheet document of the spreadsheet application, and the second portion of functionality associated with the spreadsheet application is designed to execute updates of functions in the spreadsheet.

19. The device of claim 12, further comprising:

a storage device to store spreadsheet documents created by the plurality of client computing devices.

20. The device of claim 12, where the cell of the spreadsheet document is visually distinguished to indicate an entry by the first user, at the one of the client computing device, from one or more entries made by the one or more second users, at the one or more other client computing devices.

21. A method comprising:

distributing a client engine to a plurality of client computing devices over a network, the client engine implementing a first portion of functionality, associated with a spreadsheet application and relating to navigating or formatting a spreadsheet document of the spreadsheet application, and being distributed to each of the plurality of client computing devices in response to requests from the plurality of client computing devices for the spreadsheet application, where a first user, associated with one of the plurality of client computing devices, has a first set of privileges for the spreadsheet document;

executing a spreadsheet server component that performs a second portion of the functionality, associated with the spreadsheet application, locally at a server device hosting the spreadsheet server component, the spreadsheet server component performing calculations of functions relating to formulas within a spreadsheet shared by the plurality of client computing devices, the spreadsheet server component updating, in real-time, changes, made to the spreadsheet at the one of the plurality of client computing devices, to other ones of the plurality of client computing devices;

receiving a formula, entered into a cell of the spreadsheet document, from the one of the plurality of client computing devices;

executing the received formula, using the spreadsheet server component, to generate a result;

transmitting, to the one of the plurality of client computing devices, the result of executing the formula, where

the one of the plurality of client computing devices has simultaneous access to the formula and the result, and

the result is located within the cell of the spreadsheet document; and

transmitting, to one or more other ones of the plurality of client computing devices, the result of executing the formula, without sharing the formula with the other ones of the plurality of client computing devices, where

the one or more other client computing devices are different from the one of the plurality of client computing devices from which the formula was received,

the one or more other client computing devices are associated with one or more second users that each have a second set of privileges for the spreadsheet document, and

the one or more other client computing devices have access to only the result, located within the cell of the spreadsheet document, at substantially a same time that the one of the plurality of client computing devices has simultaneous access to the formula and the result.

22. The method of claim 21, further comprising providing a user interface that includes a messaging area to display messages communicated between users of the plurality of client computing devices.

23. The method of claim 21, where the cell of the spreadsheet document is visually distinguished to indicate an entry by the first user, at the one of the plurality of client computing devices, from one or more entries made by the one or more second users, at the one or more other client computing devices.

24. A system for providing a distributed spreadsheet application to a plurality of users, the system comprising:

a client computing device to execute client instructions, using a first processor, within a browser program associated with each of a plurality of client computing devices, the client instructions relating to navigating or formatting a spreadsheet document; and

a server to transmit, using a second processor, the client instructions to the plurality of client computing devices when a spreadsheet application is requested through the browser programs of the plurality of client computing devices, the second processor performing calculations relating to formulas in the spreadsheet application in response to requests from the plurality of client computing devices, the second processor synchronizing the spreadsheet document that is simultaneously open at the plurality of client computing devices,

where the second processor is further to execute server instructions to;

receive a formula, entered into a cell of the spreadsheet document of the spreadsheet application, from one of the plurality of client computing devices, where a first user, associated with one of the plurality of client computing devices, has a first set of privileges for the spreadsheet document,

execute the received formula to generate a result,

transmit, to the one of the plurality of client computing devices, the result of executing the formula, where

the one of the plurality of client computing devices has simultaneous access to the formula and the result, and

the result is located within the cell of the spreadsheet document, and

transmit, to other ones of the plurality of client computing devices, the result of the executed formula, without sharing the formula with the other ones of the plurality of client computing devices, where

the other ones of the plurality of client computing devices are different from the one of the plurality of client computing devices from which the formula was received,

the other ones of the plurality of client computing devices are associated with one or more second users that each have a second set of privileges for the spreadsheet document, and

the other ones of the plurality of client computing devices have access to only the result, located within the cell of the spreadsheet document, at substantially a same time that the one of the plurality of client computing devices has simultaneous access to the formula and the result.

25. The system of claim 24, where the first processor is further to execute the client instructions to:

provide an interface between the browser program and the server; and

asynchronously handle communications between the browser program and the server.

26. The system of claim 24, where the second processor is further to execute the server instructions to:

provide users of the plurality of computing devices with a messaging sidebar implemented within an interface of the spreadsheet document of the spreadsheet application through which real-time messages, sent between users of the plurality of computing devices, are provided for display.

27. The system of claim 24, where the cell of the spreadsheet document is visually distinguished to indicate an entry by the first user, at the one of the plurality of client computing devices, from one or more entries made by the one or more second users, at the one or more other ones of the plurality of client computing devices.

28. A system comprising:

a client computing device to execute client logic, using a first processor, within a browser program of each of a plurality of client computing devices, the client logic including;

a user interface instructions to display a spreadsheet document to a respective one of the plurality of client computing devices, and

a client engine instructions to locally process requests, from a first user at the respective one of the plurality of client computing devices, relating to navigating or formatting the spreadsheet document, where the first user has a first set of privileges for the spreadsheet document; and

a server to transmit, using a second processor, the client logic to the plurality of client computing devices when requested through a browser program of each of the plurality of client computing devices, and to execute server logic for synchronizing the spreadsheet document that is simultaneously open at the plurality of client computing devices, the server logic including;

a front-end server instructions to provide a web interface to the plurality of client computing devices, and

a back-end instructions to;

execute a formula, entered into a cell of the spreadsheet document and received from the respective one of the plurality of client computing devices, to generate a result,

transmit, to the respective one of the plurality of client computing devices, the result of executing the formula, where

the respective one of the plurality of client computing devices has simultaneous access to the formula and the result, and

the result is located within the cell of the spreadsheet document, and

transmit, to other ones of the plurality of client computing devices, the result of the executed formula, without sharing internal details of the particular formula with the other ones of the plurality of client computing devices, where

the other ones of the plurality of client computing devices are different from the respective one of the plurality of client computing devices from which the formula was received,

the other ones of the plurality of client computing devices are associated with one or more second users that each have a second set of privileges for the spreadsheet document, and

the other ones of the plurality of client computing devices have access to only the result, located within the cell of the spreadsheet document, at substantially a same time that the respective one of the plurality of client computing devices has simultaneous access to the formula and the result.

29. The system of claim 28, where the server logic is further to:

update, in real-time, changes made, to the spreadsheet document, at the one of the plurality of client computing devices.

30. The system of claim 28, where the cell of the spreadsheet document is visually distinguished to indicate an entry by the first user, at the respective one of the plurality of client computing devices, from one or more entries made by the one or more second users, at the other ones of the plurality of client computing devices.