Patents by Inventor David F. Gainer
David F. Gainer has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Patent number: 11295058Abstract: 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.Type: GrantFiled: July 28, 2016Date of Patent: April 5, 2022Assignee: Microsoft Technology Licensing, LLCInventors: Benjamin C. Chamberlain, Bruce C. Jones, Christopher M. Street, David F. Gainer, Eric B. Vigesaa
-
Patent number: 10169318Abstract: 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.Type: GrantFiled: November 8, 2016Date of Patent: January 1, 2019Assignee: Microsoft Technology Licensing, LLCInventors: Charles D. Ellis, David F. Gainer, Samuel C. Radakovitz, Yonghong Zeng, Dave McDonald
-
Patent number: 9792273Abstract: 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.Type: GrantFiled: April 15, 2014Date of Patent: October 17, 2017Assignee: MICROSOFT TECHNOLOGY LICENSING, LLCInventors: Roy Simkhay, Charles D. Ellis, Alexander Babanov, David F. Gainer, Daniel P. Cory, Matthew J. Androski, Andrew J. Becker, Jeremy R. Pankratz, Monica McAmis, Simon Loftus Peyton Jones
-
Publication number: 20170097924Abstract: 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.Type: ApplicationFiled: November 8, 2016Publication date: April 6, 2017Applicant: Microsoft Technology Licensing, LLCInventors: Charles D. Ellis, David F. Gainer, Samuel C. Radakovitz, Yonghong Zeng, Dave McDonald
-
Patent number: 9507496Abstract: 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.Type: GrantFiled: March 10, 2014Date of Patent: November 29, 2016Assignee: Microsoft Technology Licensing, LLCInventors: Charles D. Ellis, David F. Gainer, Samuel C. Radakovitz, Yonghong Zeng, Dave McDonald
-
Publication number: 20160335226Abstract: 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.Type: ApplicationFiled: July 28, 2016Publication date: November 17, 2016Applicant: Microsoft Technology Licensing, LLCInventors: Benjamin C. Chamberlain, Bruce C. Jones, Christopher M. Street, David F. Gainer, Eric B. Vigesaa
-
Patent number: 9424235Abstract: 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.Type: GrantFiled: August 27, 2012Date of Patent: August 23, 2016Assignee: MICROSOFT TECHNOLOGY LICENSING, LLCInventors: Benjamin C. Chamberlain, Bruce C. Jones, Christopher M. Street, David F. Gainer, Eric B. Vigesaa
-
Publication number: 20140229813Abstract: 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.Type: ApplicationFiled: April 15, 2014Publication date: August 14, 2014Applicant: MICROSOFT CORPORATIONInventors: Roy Simkhay, Charles D. Ellis, Alexander Babanov, David F. Gainer, Daniel P. Cory, Matthew J. Androski, Andrew J. Becker, Jeremy R. Pankratz, Monica McAmis, Simon Loftus Peyton Jones
-
Publication number: 20140195887Abstract: 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.Type: ApplicationFiled: March 10, 2014Publication date: July 10, 2014Applicant: Microsoft CorporationInventors: Charles D. Ellis, David F. Gainer, Samuel C. Radakovitz, Yonghong Zeng, Dave McDonald
-
Patent number: 8745482Abstract: 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.Type: GrantFiled: August 26, 2010Date of Patent: June 3, 2014Assignee: Microsoft CorporationInventors: Charles D. Ellis, David F. Gainer, Samuel C. Radakovitz, Yonghong Zeng, Dave McDonald
-
Patent number: 8726143Abstract: 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.Type: GrantFiled: January 14, 2005Date of Patent: May 13, 2014Assignee: Microsoft CorporationInventors: Roy Simkhay, Charles D. Ellis, Alexander Babanov, David F. Gainer, Daniel P. Cory, Matthew J. Androski, Andrew J. Becker, Jeremy R. Pankratz, Monica McAmis, Simon Loftus Peyton Jones
-
Publication number: 20130339832Abstract: 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.Type: ApplicationFiled: August 26, 2013Publication date: December 19, 2013Applicant: Microsoft CorporationInventors: Roy Simkhay, David F. Gainer, Tom J. Hoke, Benjamin C. Chamberlain, Paavany Jayanty, Charles D. Ellis
-
Patent number: 8549392Abstract: 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.Type: GrantFiled: August 30, 2005Date of Patent: October 1, 2013Assignee: Microsoft CorporationInventors: Roy Simkhay, David F. Gainer, Tom J. Hoke, Benjamin C. Chamberlain, Paavany Jayanty, Charles D. Ellis
-
Publication number: 20120324328Abstract: 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.Type: ApplicationFiled: August 27, 2012Publication date: December 20, 2012Applicant: MICROSOFT CORPORATIONInventors: Benjamin C. Chamberlain, Bruce C. Jones, Christopher M. Street, David F. Gainer, Eric B. Vigesaa
-
Patent number: 8286072Abstract: 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.Type: GrantFiled: August 26, 2009Date of Patent: October 9, 2012Assignee: Microsoft CorporationInventors: Benjamin C. Chamberlain, Bruce C. Jones, Christopher M. Street, David F. Gainer, Eric B. Vigesaa
-
Patent number: 8234293Abstract: 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.Type: GrantFiled: September 8, 2005Date of Patent: July 31, 2012Assignee: Microsoft CorporationInventors: Alexander Martynov, David F. Gainer, Howard J. Dickerman
-
Publication number: 20100325526Abstract: 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.Type: ApplicationFiled: August 26, 2010Publication date: December 23, 2010Applicant: Microsoft CorporationInventors: Charles D. Ellis, David F. Gainer, Samuel C. Radakovitz, Yonghong Zhen, Dave McDonald
-
Patent number: 7853868Abstract: 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.Type: GrantFiled: September 2, 2005Date of Patent: December 14, 2010Assignee: Microsoft CorporationInventors: Brandon G. Weber, David F. Gainer
-
Patent number: 7849395Abstract: 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.Type: GrantFiled: December 15, 2004Date of Patent: December 7, 2010Assignee: Microsoft CorporationInventors: Charles D. Ellis, David F. Gainer, Samuel C. Radakovitz, Yonghong Zhen, Dave McDonald
-
Publication number: 20100042913Abstract: 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.Type: ApplicationFiled: August 26, 2009Publication date: February 18, 2010Applicant: Microsoft CorporationInventors: Benjamin C. Chamberlain, Bruce C. Jones, Christopher M. Street, David F. Gainer, Eric B. Vigesaa