Non-collaborative filters in a collaborative document

• US 9,635,105 B2
• Filed: 05/31/2016
• Issued: 04/25/2017
• Est. Priority Date: 05/22/2013
• Status: Active Grant

• Current Assignee: Google LLC (Alphabet Inc.)
• Original Assignee: Google Inc. (Alphabet Inc.)
• Inventors: Simon, Benjamin Wolfe, Tragut, Manual, Lloyd, Zachary Erik, Danziger, Joshua Ari, Gundrum, Daniel
• Primary Examiner(s): Kells, Asher
• Application Number:
  US15/169,371
• Publication Number:
  US 20160277487A1
• Time in Patent Office: 329 Days
• Field of Search: None
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06Q 10/103 Workflow collaboration or project management
• CPC Class Codes: H04L 67/01 Protocols
• CPC Class Codes: H04L 67/02 based on web technology, e.g. hypertext transfer protocol [HTTP]
• CPC Class Codes: H04L 67/104 Peer-to-peer [P2P] networks

Abstract

Systems and methods for viewing filters on a collaborative spreadsheet stored on a cloud computing service include accessing, from each of a plurality of client computers, a first sheet of a spreadsheet stored on a cloud computing service, where a plurality of filters is associated with the first sheet. A first client computer in the plurality of client computers receives a command by a first user to apply a first filter in the plurality of filters to the first sheet, and applies the first filter to the first sheet on the first client computer. The filtered first sheet is displayed to the first user, and a second client computer in the plurality of client computers concurrently displays an unfiltered first sheet.

Claims

1. A method for processing user actions on a collaborative spreadsheet, the method comprising:

accessing, from each of a plurality of client computers, an unfiltered sheet of a spreadsheet stored on a server to display on a first client computer, wherein a plurality of filters is associated with the unfiltered sheet, and wherein each of the plurality of filters is concurrently selectable by each of the plurality of client computers;

receiving a selection by a first user, from the first client computer, of a first filter in the plurality of filters to be applied to the unfiltered sheet, wherein the first filter is created by a second user on a second client computer;

displaying a filtered sheet to the first user, wherein the filtered sheet is obtained by applying the first filter to the unfiltered sheet;

receiving a user action inputted by the first user on the first client computer, wherein the user action references cells of the unfiltered sheet;

sending the user action to the server;

transforming the user action against the first filter; and

updating the display of the filtered sheet based on the transformed user action.

2. The method of claim 1, wherein the first filter includes a command to sort one or more cells of the first sheet.

3. The method of claim 1, wherein the first filter includes a command to hide one or more cells of the first sheet.

4. The method of claim 1, wherein accessing the unfiltered sheet includes loading a copy of the first sheet and the plurality of filters onto the first client computer.

5. The method of claim 4, wherein displaying the filtered sheet comprises transforming the unfiltered sheet against the first filter.

6. The method of claim 1, wherein the filtered sheet is displayed on a web browser executing on the first client computer.

7. The method of claim 6, wherein the web browser displays a user interface for the first user to input the user action.

8. The method of claim 1, wherein the user action is a cell mutation.

9. The method of claim 1, wherein the user action is a cell presence activity.

10. A method for receiving collaborator actions on a collaborative spreadsheet, the method comprising:

accessing an unfiltered sheet of a spreadsheet stored on a server to display on a first client computer, wherein a plurality of filters is associated with the unfiltered sheet, and wherein each of the plurality of filters is concurrently selectable by each of a plurality of client computers;

receiving a selection by a first user, from the first client computer, of a first filter in the plurality of filters to be applied to the unfiltered sheet, wherein the first filter is created by a second user on a second client computer;

displaying a filtered sheet to the first user, wherein the filtered sheet is obtained by applying the first filter to the unfiltered sheet;

receiving a collaborator action from the server, wherein the collaborator action references cells of the unfiltered sheet;

transforming the collaborator action against the first filter; and

updating the display of the filtered sheet based on the transformed collaborator action.

11. The method of claim 10, wherein the first filter includes a command to sort one or more cells of the first sheet.

12. The method of claim 10, wherein the first filter includes a command to hide one or more cells of the first sheet.

13. The method of claim 10, wherein accessing the unfiltered sheet includes loading a copy of the first sheet and the plurality of filters onto the first client computer.

14. The method of claim 13, wherein displaying the filtered sheet comprises transforming the unfiltered sheet against the first filter.

15. The method of claim 10, wherein the filtered sheet is displayed on a web browser executing on the first client computer.

16. The method of claim 15, wherein the web browser displays a user interface for the first user to input the user action.

17. The method of claim 10, wherein the collaborator action is a cell mutation.

18. The method of claim 10, wherein the collaborator action is a cell presence activity.

19. The method of claim 10, the method further comprising updating the unfiltered sheet on the first client computer with the collaborator action.

20. A system for processing user actions on a collaborative spreadsheet, the system comprising:

a first client computer configured to;

communicate with a server hosting a cloud computing service through a communication connection;

access an unfiltered sheet of a spreadsheet stored on the server, wherein a plurality of filters is associated with the unfiltered sheet, and wherein each of the plurality of filters is concurrently selectable by each of a plurality of client computers;

receive a selection by a first user of a first filter in the plurality of filters to be applied to the unfiltered sheet, wherein the first filter is created by a second user on a second client computer;

display a filtered sheet to the first user, wherein the filtered sheet is obtained by applying the first filter to the unfiltered sheet;

receive a user action inputted by the first user on the client computer, wherein the user action references cells of the unfiltered sheet;

send the user action to the server;

transform the user action against the first filter; and

update the display of the filtered sheet based on the transformed user action.

21. The system of claim 20, wherein the client computer is further configured to:

receive a collaborator action from the server, wherein the collaborator action references cells of the unfiltered sheet;

transform the collaborator action against the first filter; and

update the display of the filtered sheet based on the transformed collaborator action.

22. The system of claim 20, wherein the first filter includes a command to sort one or more cells of the first sheet.

23. The system of claim 20, wherein the first filter includes a command to hide one or more cells of the first sheet.

24. The system of claim 20, wherein the client computer is further configured to load a copy of the first sheet and the plurality of filters onto the first client computer when accessing the first sheet from the server.

25. The system of claim 20, wherein the first client computer has a web browser that is configured to display the filtered sheet.

26. The system of claim 25, wherein the web browser displays a user interface for the first user to input the user action.