Apple Inc.

Matthew Ross Lehrian

Christopher Douglas Weeldreyer

Jay Christopher Capela

Roger Rock Rosner

Yaniv Gur

Edward Patrick Hogan

Zachariah N Paine

Marek Rastislav Telgarsky

Ryan Michael Olshavsky

Shawn Patrick Flisakowski

Edward P A Hogan

Tsurishaddai Williamson

Joe Randall Howard

Peter William Rapp

Peter Berger

Alan Eyzaguirre

Jonathan Robert Speicher

Peter Su

Michael Jeremy Coblenz

Yik Shing Yip

Anukul Kapoor

Jesse Chapman

Mark Bernstein

Jane H Chronis

Providing an infinite or seemingly infinite canvas as a workspace is disclosed. In some embodiments, an ability to add to a displayed canvas and view simultaneously one or more table objects, each of which has associated with it an ability to define the content of a first cell by reference to one or more other cells such that the content of the first cell is updated automatically and without further human intervention if the content of one or more of the one or more other cells is changed, is provided.

Infinite canvas

In some embodiments, an option to lock one or more associated cells is provided with respect to each different group of cells in a single sheet of a spreadsheet application. One or more locked cells of a group of cells do not scroll out of view at least while a portion of the group of cells is viewable in a given display view.

Locking spreadsheet cells

Systems, methods, and devices for tracking spreadsheet table cells from a base table to an organized table/organized table view, and updating of a formula reference based on the tracked cells are provided. In some embodiments, cells may be tracked to convert a first range of cells in the base table into a second range of cells in the organized table/organized table view, such that the second range of cells includes the same cells as the first range of cells, despite any reorganization of rows and columns. In some embodiments, a summary reference cell that provides a sub-group summary based upon the grouping within the organized table/organized table view may also be provided.

Exploded-range references

Features associated with smart tables are disclosed. In some embodiments, address tabs associated with a table are provided on-demand in response to receiving an indication of interest in the table. In some embodiments, controls for modifying the number of rows and/or columns of a table are provided on-demand when an indication of interest in the table is received. In some embodiments, in response to a passive indication of interest in an address tab associated with a row or column of a table, a set of one or more options associated with the row or column and/or associated table are made available.

Smart tables

Methods and systems for providing input to a computing device based on a toggle gesture performed during a drag gesture are provided. A drag gesture can be performed on a touch screen to manipulate a user interface object. For example, the drag gesture can move the user interface object or resize the user interface object. Such manipulation commands may have alternate modes or options. For example, a user may want to place a copy of the user interface object rather than simply moving it. Accordingly, a toggle gesture can be performed during the drag gesture to choose an alternate manipulation command. For example, a drag gesture can be performed to move an object, and a toggle gesture can be performed during the drag gesture to copy the object instead of moving it.

Toggle gesture during drag gesture

Embodiments are disclosed in which an algorithm that updates or rewrites one or more formulas when a table is transposed in an application. In certain embodiments the formula is rewritten so as to preserve the functionality of the formula with respect to the transposed table. In certain embodiments, a notification may be provided that a formula is changed or not changed in response to the table transposition event.

Updating formulas in response to table transposition

Approaches are disclosed for maintaining spatial relationships (i.e., a layout) between a table object and other objects placed on a virtual canvas of an application work space. In certain implementations, offsets between the other objects and the table object are initially determined and are used to maintain the spatial relationships when the table object is resized. In certain implementations, the movement of the objects in response to a resize of the table object is dynamic from the user's perspective and can be easily undone.

Modifying positions of on-canvas objects

Automatic generation of custom palettes based on an image selected by a user is disclosed. In various embodiments, automatic palette generation may involve generating one or more than one palette based on the color or shading content of the image provided by the user. The generated palette may include a variety of colors (or shadings) that can be automatically mapped to and applied to various distinct features within a composite graphic construct to be customized.

Palette generation using user-selected images

The present disclosure relates to the resizing of tables elements, such as rows or columns of a table. In one embodiment, a user selects two or more rows or columns to be resized and performs a column or row manipulation corresponding to the desired resize event, such as be interacting with an edge of one of the selected rows or columns. In an implementation, the user may toggle between the use of different resizing algorithms to see the effects of the different resizing algorithms.

User interface for visualizing resizing of table elements

Including multiple types of objects on a canvas is disclosed. In some embodiments, an ability to include on a displayed canvas simultaneously a set of objects comprising one or more objects of two or more different types, including a first type of object having associated with it an ability to define the content of a first cell by reference to one or more other cells such that the content of the first cell is updated automatically and without further human intervention if the content of one or more of the one or more other cells is changed and a second type of object not having said ability associated with it, is provided.

Multiple object types on a canvas

Approaches are disclosed for generating a menu that may be used to provide a set of bounded options for populating associated cells of a table. In certain embodiments, the menu is automatically generated based at least in part on the initial content of one or more cells to be associated with the menu. In certain embodiments, the options listed in the menu may be edited by a user or reformatted based on logic associated with the menu generation process.

Growing community of inventors

Pittsburgh, PA, United States of America

Matthew Ross Lehrian