Non-collaborative filters in a collaborative document

• US 9,298,688 B1
• Filed: 05/22/2013
• Issued: 03/29/2016
• 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, Manuel, Lloyd, Zachary Erik, Danziger, Joshua Ari, Gundrum, Daniel
• Primary Examiner(s): Baderman, Scott
• Assistant Examiner(s): Kells, Asher
• Application Number:
  US13/900,270
• Time in Patent Office: 1,042 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06Q 10/101 Collaborative creation, e.g. joint development of products or services

Abstract

Systems and methods for processing user actions on a collaborative spreadsheet include accessing an unfiltered sheet of a spreadsheet stored on a server to display on a client computer, where a plurality of filters is associated with the unfiltered sheet, and receiving a selection by a user of a first filter in the plurality of filters to be applied to the unfiltered sheet. A filtered sheet is displayed to the user, where the filtered sheet is obtained by applying the first filter to the unfiltered sheet. User actions inputted by a user on the client computer are received that reference cells of the unfiltered sheet. User actions are sent to the server and transformed against the first filter. The display of the filtered sheet is updated based on the transformed user action.

Claims

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

accessing an unfiltered sheet of a spreadsheet stored on a server to display on a client computer, wherein a plurality of filters is associated with the unfiltered sheet;

receiving a selection by a user of a first filter in the plurality of filters to be applied to the unfiltered sheet;

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

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

updating the display of the filtered sheet based on the user action;

transforming the user action against an inverse of the first filter; and

sending the transformed user action to the server.

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

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

4. The method of claim 1, wherein accessing the unfiltered sheet includes loading a copy of the unfiltered sheet and the plurality of filters onto the 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 client computer.

7. The method of claim 6, wherein the web browser displays a user interface for the 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.