Non-collaborative filters in a collaborative document

Patent metadata

Field	Value
Publication number	US-9635105-B2
Application number	US-201615169371-A
Country	US
Kind code	B2
Filing date	May 31, 2016
Priority date	May 22, 2013
Publication date	Apr 25, 2017
Grant date	Apr 25, 2017

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.

First claim

What is claimed is:

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.

Assignees

• Google Inc

Inventors

• Simon Benjamin Wolfe
• Tragut Manual
• Lloyd Zachary Erik
• Danziger Joshua Ari
• Gundrum Daniel

Classifications

• H04L67/02

  based on web technology, e.g. hypertext transfer protocol [HTTP] · CPC title

• G06Q10/103

  Workflow collaboration or project management · CPC title

• H04L67/104 Primary

  Peer-to-peer [P2P] networks · CPC title

• G06F17/246

  Physics · mapped topic

• H04L67/42

  Electricity · mapped topic