Microsoft Technology Licensing, LLC

Microsoft Corporation

Benjamin C Chamberlain

Eric Barber Vigesaa

Bruce Cordell Jones

Christopher M Street

David Francis Gainer

John C Delo

Malcolm S Haar

Darrin N Hatakeda

Chetan A Parulekar

David E Gonzalez

Tracy D Ferrier

David R Mckinnis

Charles David Ellis

Robert C Collie

D Gordon Hardy

Daniel C Battagin

Johnny S Campbell

Brandon G Weber

Aaron Lamar Wilson

Gitika Gupta

Prashant Anand Shirolkar

Roy Simkhay

Paavany Jayanty

Tom Hoke

David E Gainer

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

Suggestions are automatically displayed in response to an event. For example, suggestions may be automatically displayed in response to a receiving an indication from a user to enter content (e.g. receiving a selection of a content entry area). The suggestions may be displayed before a user enters any characters and before an input device is displayed and/or used (e.g. keyboard, Software Input Panel (SIP), and the like. Suggestions may also be automatically displayed in response to detecting a pause while a user is entering content. For example, when a user is actively entering content, suggestions are not automatically displayed but when a user pauses a predetermined amount while entering content, suggestions are automatically displayed. The suggestions may be determined from content that may be seen on a display and/or hidden from view (e.g. hidden rows in a spreadsheet).

Automatically displaying suggestions for entry

A data cell included in a document supporting cell structured data is conditionally formatted according to data that is stored in a separate location from the document. A user is allowed to select from a drop-down menu of related data sets a particular data set for conditionally formatting the data cell. The data cell is formatted according to the data set and the condition without requiring that the data set be stored locally in the document.

System and method for formatting a cell in response to data stored in a separate location

Generally described, embodiments of the present invention provide the ability to utilize dynamic thresholds and dynamic threshold values when generating variable formatting rules to be applied to a range of cells. Dynamic thresholds include, but are not limited to, 'Highest Value,' 'Middle Value,' &#x201c;Lowest Value,&#x201d; &#x201c;Number,&#x201d; &#x201c;Percent,&#x201d; &#x201c;Percentile,&#x201d; and &#x201c;Formula.&#x201d; When using a dynamic threshold, dynamic threshold values are determined based on values contained in a selected range of cells.

Dynamic thresholds for conditional formats

Generally described, embodiments of the present invention relate to applying and evaluating conditional formatting rules to a given range of cells. Additionally, multiple conditional formatting rules may be evaluated to TRUE for the same cell contained in a user interface and multiple formats applied to that cell.

For a given cell in a spreadsheet, evaluating an unlimited number of conditional formatting rules and applying multiple corresponding formats to the cell

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

A scrolling speed controlling system including a personal computer, a human interface device, an executable application, and a scroll speed adapter component. A user choosing to scroll an application window quickly may experience reduced readability of the information in the window because the speed at which the window is scrolling is too great to allow the user to identify or comprehend the information in the application window. A scroll speed adapter component make use of predetermined areas of interest to the user to control the scroll speed in such a way as to slow down scrolling as the area of interest approaches and speed up scrolling as the area of interest moves away.

Controlling scroll speed to improve readability

Variable formatting of cells

A method of conditionally formatting a display of data is disclosed that involves providing a preliminary display automatically showing the intended consequences of the condition applied to the data prior to making the condition actually apply to the data. This is especially useful in analysis of spreadsheet data by conditionally formatting certain data. The method involves identifying one or more parameters of the data to be conditionally formatted on the display, selecting a predetermined condition; and automatically applying temporarily the predetermined condition to the parameter(s), displaying a temporary preview on the display of the predetermined condition applied to data that meet the predetermined condition. The method also provides the capability to preliminarily change the conditions and parameters applied to the data and automatically provide appropriate previews of the effect of such application of changed conditions on the displayed data.

One click conditional formatting method and system for software programs

Generally described, embodiments of the present invention relate to applying and evaluating an unlimited number of conditional formatting rules to a given range of cells. Additionally, multiple conditional formatting rules may be evaluated to TRUE for the same cell contained in a user interface and multiple formats applied to that cell.

Multiple conditional formatting

A method and computer-readable medium for upgrading an application program, and making an installer program aware that an application has been upgraded is disclosed. The method recognizes that an upgrade to the application has been initiated. The upgrade includes an identifier for the application to be upgraded, as well as information required for the installer to perform the upgrade. The installer program accesses the upgrade information, which includes instructions necessary for installing the upgrade. The installer program also accesses information related to the installed state of the application and related applications. The installer program determines whether or not the upgrade should be performed. If the upgrade should be performed, the installer program performs the upgrade and stores the fact that the application has been upgraded. If the application should not be upgraded, the installer program stores information reflecting the fact that the upgrade is available but not installed.

Growing community of inventors

Redmond, WA, United States of America

Benjamin C Chamberlain