摘要:
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.
摘要:
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.
摘要:
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.
摘要:
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,” “Lowest Value,” “Number,” “Percent,” “Percentile,” and “Formula.” When using a dynamic threshold, dynamic threshold values are determined based on values contained in a selected range of cells.
摘要:
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.
摘要:
Spreadsheets are subdivided into formattable table elements that may include multiple table cells so that the multiple table cells can be formatted as a single element. As such, a gradient format can be applied across the range of multiple table cells instead of to individual table cells. A format property can be applied to a spreadsheet table to provide alternating table element formats that are automatically updated when cells or formattable table elements are added, deleted, hidden, shown or moved. As a result, when a table modification is made, the alternating format of the table is updated before the table is rendered on a display.
摘要:
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.
摘要:
A method and mechanism for automatically installing software implementations such as applications and COM classes as they are needed from an external source. When a software implementation is needed, the mechanism first looks to the local system (e.g., registry) for that software implementation, and if found, returns the information such as a local path needed to use the software implementation. If the implementation is not found, the mechanism looks to another source, such as a CD-ROM or a centralized class store of a network, to locate the needed implementation. When located, the implementation is downloaded and locally installed from the source, and a local path is returned in a manner that is essentially transparent to the user. Software implementations such as application products may be divided into features and components to improve on-demand installation thereof.
摘要:
A system and method for creating rollback scripts for operations performed by an installer program module. A rollback script may be used to reverse an action of an installer program module so that a user's machine is restored to its original state, i.e., the state before the installer program module began performing operations. In performing operations, the installer program module typically generates installation script records of specific actions that are to be performed to a particular machine with regard to installation data. During the processing of each installation script record, an inverse record is created, known as a rollback script record. When installing a file, if there is no file with the same name in the same location stored on the machine, then a rollback script record describing how to delete the file is stored. However, if an old file stored in the same location does exist, then the old file is backed up to another location and a rollback script record is saved describing how to copy the old file back to its prior location on the machine.
摘要:
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.