Workday, Inc.

Open Text S.a.

Open Text Corporation

Open Text Ulc

Leonard Karpel

Terry Michael Olkin

Brian Sean Morris

Sayan Chakraborty

Ronald E Schneider

David Glazer

Keith Deutsch

Michael Nordman

William James Murphy

Ronald Schneider

A system includes an interface configured to receive a paste-to data cell. The system includes a processor configured to: determine whether there is an exact match key for a copy-from data set; in response to there not being the exact match key for the copy-from data set, determine whether there is a smart formula for the copy-from data set; and in response to there being the smart formula for the copy-from data set, provide the smart formula for the copy-from data set to a formula cell. The system includes a memory coupled to the processor and configured to provide the processor with instructions.

Copy-paste triggered formula generation

A system includes an interface configured to receive a user input string for a data cell and a processor configured to: determine a lexicon from data related to the data cell; determine an efficient formula from the lexicon; and provide the efficient formula to a formula cell. The system further includes a memory coupled to the processor and configured to provide the processor with instructions.

Formula generation by example

A system for spreadsheet region and cell sharing includes an interface and a processor. The interface is to provide a display interface data for a spreadsheet document; receive a selected region of the spreadsheet document; and receive an access descriptor. The processor is to determine whether to enable access to the selected region based at least in part on the access descriptor.

User interface for region and cell sharing

A system for time zone intelligent spreadsheets includes a server with a processor. The server is to host a spreadsheet document. The processor of the server is to interpret a time/date data of the spreadsheet document based at least in part on a time zone setting.

Time zone intelligent spreadsheets

A system for spreadsheet region and cell sharing includes an interface and a processor. The interface is to receive an indication to modify a first cell of a first document, wherein a first user is associated with the first document and with a first set of user access descriptors. The processor is to determine whether the first user has write permission for the first cell based on the first set of user access descriptors; and in the event that the first user has write permission: indicate a modification to a location in a database storage location referenced by a pointer formula associated with the first cell; and modify a second cell in a second document based on a dependency graph, wherein the second document is associated with a second user different from the first user.

Spreadsheet region and cell sharing

A system for spreadsheet region and cell sharing using formula templates includes a processor and an interface. The processor is to parse a formula of a first cell of a first spreadsheet document for a second cell, the first spreadsheet document being associated with a first user having a set of user access descriptors and to determine, based on the set of user access descriptors, whether the first user has access to one or more canonical names referenced in the formula. The interface is to provide display information to the first user either the canonical name in the event that the first user has access to the canonical name or an opaque identifier in the event that the first user does not have access to the canonical name.

Spreadsheet shared region and cell formula templating

A system for spreadsheet region and cell sharing permissions includes an interface and a processor. An interface is to receive a request to display a subset of a spreadsheet document. A processor is to: determine whether to enable display access to the subset of the spreadsheet document based at least in part on a set of user access descriptors; in the event that display access is enabled, provide data associated with the subset of the spreadsheet document for display; and in the event that display access is not enabled, provide an indication of access denial for display.

Spreadsheet shared region and cell permissions

The invention includes structures and schema for organizing and inter-relating objects, data, or files, including relational, network, hierarchical, and entity-relationship models, among others, that are dynamic, that is changing with time. This includes manipulating structures by conversion, compression, compaction, and compilation, for various purposes. Also included is generating structures for storing, organizing, and managing dynamic objects for retrieval and presentation. A discussion group for collaborative participants is also provided. A time-based dynamic object within a plurality of stored dynamic objects is stored. Each dynamic objects comprises a plurality of predefined attribute fields. Requested dynamic objects are assembled in real time so that the requested dynamic objects are displayed on the basis of the start-time attribute field of each requested dynamic object. A different threaded discussion associated with the each displayed requested dynamic object is provided with each displayed requested dynamic object based on the displayed requested dynamic object's start time.

Method, system, apparatus and content model for the creation, management, storage, and presentation of dynamic objects

The invention includes structures and schema for organizing and inter-relating objects, data, or files, including relational, network, hierarchical, and entity-relationship models, among others, that are dynamic, that is changing with time. This includes manipulating structures by conversion, compression, compaction, and compilation, for various purposes. Also included is generating structures for storing, organizing, and managing dynamic objects for retrieval and presentation.

Growing community of inventors

Lyons, CO, United States of America

Leonard Karpel