Microsoft Technology Licensing, LLC

David Francis Gainer

Charles David Ellis

Bruce Cordell Jones

Benjamin C Chamberlain

Samuel C Radakovitz

Eric Barber Vigesaa

Christopher M Street

Dave McDonald

Matthew John Androski

Roy Simkhay

Yonghong Zeng

George G Robertson

Curtis Glenn Wong

Bongshin Lee

Roland Lucas Fernandez

Murali R Krishnan

Daniel Cory

Andrew James Becker

Christian Olaf Abeln

Stella Yick Chan

Alexander A Babanov

Benjamin L Chronister

Ian Michael Dunmore

Alexandre Gorev

Jeremy R Pankratz

Monica McAmis

Simon Loftus Peyton Jones

Thomas Michael Casey

Matthew Jay Kotler

Danyel Aharon Fisher

Greg D Schechter

Chad B Rothschiller

Brian Scott Ruble

Jason Joseph Weber

Howard J Dickerman

Brandon G Weber

Morten Holm-Petersen

Jeffrey James Duzak

Alexander Martynov

Duane Campbell

Barry James Givens

Morten Holm-Peterson

Ahmed K Kamal

Jonathan M Sigler

Tom Hoke

Paavany Jayanty

Yonghong Zhen

Kelley T Maves

Gregory D Schechter

Variable formatting for cells in computer spreadsheets, tables, and other documents is provided. For a selected range of cells, cell formats vary with the value in each cell (or an associated value). Formats can include color-scale backgrounds, in-cell elements (e.g., icons and data bars), and other cell formats that can be varied with a value.

Variable formatting of values

The present invention comprises methods and user interfaces for organizing data displayed within a data application. Specifically, the present invention provides methods and systems for arranging the display of the data by a format applied to one or more portions of the data. The formats comprise different visual characteristics of the displayed data. In exemplary embodiments, the data application organizes the data by the fill color of the cell, the font color of the data within the cell, or the type of icon inserted into the cell. The organizations comprise any type of rearrangement of the data. In exemplary embodiments, the data application sorts or filters the displayed data according to the format.

Filter and sort by format

A spreadsheet application or other application supporting formulaic cells that automatically provides support for a number of diverse formulaic functions. The automatically provided diverse formulaic functions include a function returning the value of the formula logic if the logic can be evaluated without an error. Another function finds a value in a formulaic cell that is in the same row as a particular value from the first column and the same column as a particular value in the first row. Other functions allow a selection of a set of multiple lookup rows and columns for matching the values used as variables in the function. The spreadsheet application is further configured to automatically supply other functions in addition to those described.

System and method for a spreadsheet application supporting diverse formulaic functions

The claimed subject matter relates to an architecture that can support a declarative model-based approach to designing, constructing, and rendering visualizations. By complying with a declarative descriptor, components can be readily customized by way of modifications to the model&#x2014;declaratively specifying suitable features, behaviors, appearances and so forth. The descriptors that conform to the model can also facilitate connecting to various data sources and performing data transformation operations. Moreover, the descriptors that conform to the model can declaratively specify relationships based upon a scene layout. Accordingly, the architecture can further describe the scene layout and provide features based upon the layout.

Declarative approach for visualization

Sorting spreadsheet data by format

Table styles provide a way to format an entire spreadsheet table quickly and easily. According to described implementations, table styles can be created and customized for repeated use in a spreadsheet application. As a result, a user does not have to manually modify multiple formatting options for each table included in one or more spreadsheets. A graphical user interface is also described that provides simple user access to existing table styles that can be modified according to the user's requirements.

Customizable spreadsheet table styles

Variable formatting of cells

An autocomplete method and system provides suggested completions for partial data entries based upon predefined coordinates, operands and/or commands. In one embodiment, the partial data entry may be in an active cell of a spreadsheet and the predefined coordinates may be queried from a separate, preconfigured, multi-dimensional database linked to the active cell or the spreadsheet.

Autocompleting with queries to a database

The claimed subject matter relates to an architecture that can construct a map for summarizing analyses with respect to data included in a database. In addition, the architecture can display the map in a special canvas area. Generally, the map is a hub-and-spoke-style map in which a hub is associated with an entity (e.g., a related set of records) included in a database. Likewise, the spokes are typically representative of operations (e.g., filter, join, transform) that act upon the hub/entity from which it extends. The map can aid with open-ended analysis on complex databases by recording and ordering competing hypotheses and can also further collaborative efforts with respect to analysis.

Canvas approach for analytics

A 'new sheet button' is provided in a program, such as a spreadsheet, that utilizes a collection of tabbed sheets or a 'workbook.' The new sheet button is located adjacent the sheet tabs so that a user may add a new sheet to the workbook with a single button press. The new sheet may be added to the end of the workbook or immediately adjacent an active sheet within the workbook, among other options. Selecting the new sheet button with a default operation (such as a left mouse click) adds a blank sheet to the workbook. Selecting the new sheet button with a non-default activation (such as a right-click) generates a menu listing options for creating the new sheet, such as copying the contents of the active sheet.

Button for adding a new tabbed sheet

Filter and sort by color

Growing community of inventors

Redmond, WA, United States of America

David Francis Gainer