Microsoft Technology Licensing, LLC

Roy Simkhay

Charles David Ellis

David Francis Gainer

Daniel Cory

Andrew James Becker

Matthew John Androski

Alexander A Babanov

Simon Loftus Peyton Jones

Jeremy R Pankratz

Monica McAmis

Benjamin C Chamberlain

Tom Hoke

Paavany Jayanty

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

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

Growing community of inventors

Seattle, WA, United States of America

Roy Simkhay