Apple Inc.

Edward Patrick Hogan

Matthew Ross Lehrian

Zachariah N Paine

Marek Rastislav Telgarsky

Anukul Kapoor

Shawn Patrick Flisakowski

Joe Randall Howard

Ryan Michael Olshavsky

Jonathan Robert Speicher

James Geisler

Michael Jeremy Coblenz

An article, apparatus and methods are disclosed. The device and related methods involve a computing device including a program, such as a word processing program or spreadsheet program, configured to organize, through primary and other designations, table data and display, or otherwise use, the table of data. The program also provides a mechanism whereby by rows and columns may be prioritized for display, particularly on a relatively smaller mobile display. The prioritization(s) are then used by a device, whether the same or different than used to create provide the designations, to use the prioritizations to display the prioritized information, with other information being nested and displayable upon an interaction from a user, such as touching a displayed primary column cell to cause a secondary nested and related column cell to be displayed. In some instances, table designations occur automatically based on some attribute of the table or table data.

Apparatus, system and method of presenting views of a user's data using summary tables

Systems, methods, and devices for modifying a summary cell for a set of organized cells are provided. In some embodiments, the summary cells may be modified by modification of the summary function, such that modification may include a function and/or text that is different than preexisting summary function options for a summary cell. In some embodiments, the modification of the summary cell for the set of organized cells may update summary cells for additional sets of organized cells using a corresponding function and/or text that is different than preexisting summary function.

Custom summarization in categories

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

Embodiments are disclosed in which a process generates, receives, or both, via a graphical user interface (GUI) of a spreadsheet application, an evaluation statement. The evaluation statement includes a cell identifier, and the cell identifier specifies a modal reference cell that provides an indication of a modal attribute to be used in the evaluation statement. The indication of the modal attribute comprises a textual indicator related to the modal attribute, but has a format that is different than the modal attribute. The process evaluates the textual indicator to be used by the evaluation statement to determine a corresponding modal attribute and calculates a solution to the evaluation statement using the corresponding modal attribute as the modal attribute of the evaluation statement. The process displays the solution via the GUI.

Evaluation of formulas via modal attributes

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.

Growing community of inventors

Pittsburgh, PA, United States of America

Edward Patrick Hogan