公开(公告)号：US09298688B1

公开(公告)日：2016-03-29

申请号：US13900270

申请日：2013-05-22

Applicant: Google Inc.

Inventor： Benjamin Wolfe Simon ,  Manuel Tragut ,  Zachary Erik Lloyd ,  Joshua Ari Danziger ,  Daniel Gundrum

IPC: G06F15/16 ,  G06F17/24

CPC classification number: G06F17/246 ,  G06Q10/10

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.

Abstract translation: 用于在协作电子表格上处理用户动作的系统和方法包括访问存储在服务器上的电子表格的未过滤的表单，以在客户端计算机上显示多个过滤器与未过滤的表单相关联，并且接收用户的选择 多个过滤器中的第一过滤器，用于未过滤的纸张。 过滤的纸张被显示给用户，其中通过将第一过滤器应用于未过滤的纸张而获得过滤的纸张。 接收由客户端计算机上的用户输入的用户操作，其引用未过滤的纸张的单元格。 用户操作将发送到服务器，并根据第一个过滤器进行转换。 基于变换的用户动作更新过滤纸张的显示。

公开(公告)号：US20150199327A1

公开(公告)日：2015-07-16

申请号：US13909655

申请日：2013-06-04

Applicant: Google Inc.

Inventor： Joshua Ari Danziger ,  Amod Karve ,  Yossi Kahlon ,  Benjamin Wolfe Simon ,  Zachary Erik Lloyd

IPC: G06F17/24

CPC classification number: G06F17/246 ,  G06Q10/101

Abstract: Mutations representing spreadsheet edit operations are received at a server from client computers of collaborators and also at a collaborator's client computer from other collaborators and the server. Different mutations may conflict, i.e., provide contradictory instructions on how a spreadsheet is to be edited. Techniques for representing sort operations, cut-and-paste operations, and operations to change cell properties as mutations, and operational transform techniques that can be used to resolve conflicts between such mutations, are disclosed herein. Further disclosed herein are techniques for identifying and processing computationally intensive types of mutations in a calculation thread which operates asynchronously with respect to a UI thread at a collaborator's client computer. The processing may include performing an operational transform on results of the calculation thread based on results obtained in the UI thread.