Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: A method and mechanism for automatically patching software implementations such as applications as they are installed from an external source. A patch program is run for a software implementation that is advertised as available, or is otherwise available, though not yet installed (or fully installed). The mechanism maintains the patch information for that software implementation. Whenever the software implementation is installed, the mechanism determines that the software implementation has the patch information maintained therefor. The mechanism automatically applies the patch as part of the on-demand installation process. The patch may change the files, the values of registry entries and/or the installation logic associated with the software implementation.

Abstract: 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.

Abstract: 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.

Abstract: A method and mechanism for automatically patching software implementations such as applications as they are installed from an external source. A patch program is run for a software implementation that is advertised as available, or is otherwise available, though not yet installed (or fully installed). The mechanism maintains the patch information for that software implementation. Whenever the software implementation is installed, the mechanism determines that the software implementation has the patch information maintained therefor. The mechanism automatically applies the patch as part of the on-demand installation process. The patch may change the files, the values of registry entries and/or the installation logic associated with the software implementation.

Abstract: A system, method and computer-readable medium for creating patch rollback scripts for operations performed by an installer program module. A patch 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 patch operations. In performing patch operations, the installer program module typically generates patch installation script records of specific actions that are to be performed to a particular machine with regard to patch installation data. During the processing of each patch installation script record, an inverse record is created, known as a patch rollback script record. When installing or modifying a file, if there is no file with the same name in the same location stored on the machine, a patch rollback script record describing how to delete the file is stored.

Abstract: A system and method for patching an installed application program and making an installer program aware that an application has been patched is disclosed. The system and method recognizes that a patch has been launched to update the application, the patch including an identifier for the application and information related to a desired change to the application. In response, the installer program accesses a first information store containing information related to a series of functions for installing the application. The installer program also accesses a second information store containing information related to the installed state of the application. Then, the installer program modifies the first information store in accordance with the desired change to the application such that the modified first information store includes additional functions for applying the patch to the application.

Abstract: A method repairing an installed and patched application program if a patched resource needed by the application program becomes inadvertently deleted or otherwise unavailable to the application program is disclosed. Briefly described, the present invention makes possible a system for verifying the existence of a resource needed to support a feature of the application program. The system may respond to a request from the application program to make use of the resource by first verifying the existence of the resource at an expected location. If the resource does not exist at the expected location, rather than returning an error to the application program, the system reinstalls the missing resource without interrupting the normal operation of the application program. If the resource has been patched since its original installation, the system reapplies the patch to the resource subsequent to reinstalling the resource.

Abstract: A method and computer-readable-medium for installing a patch to a computer application program based on the criticality of the patch and the execution format of the computer application are disclosed. An installer program installs application programs. The installer program also-stores related information, including an execution format, in a configuration database. The execution format is either Run-Locally or Run-From-Source. If the execution format is Run-From-Source, the application or features that are designated as Run-From-Source are read-only and are executed from a source, such as from a CD-ROM. Since Run-From-Source executions run from a read-only source, patches cannot be directly applied. When a patch is authored, information as to the criticality of the patch is stored with the patch. Preferably, the criticality is specified based on a feature. When an installer program applies a patch, the installer program queries the execution format. Any features that are Run-Locally can be patched.

Abstract: A system and method for managing locations of patch program files via a patch source list. The needed patch program files are identified. A list of alternative patch program file locations is referenced repeatedly until a valid alternative patch program file location is found or until each alternative patch program file location on the patch source list has been referenced. If a valid alternative patch program file location is found, the patch program file is retrieved from that location. New alternative patch program file locations may be added to the patch source list when a user identifies those new locations. The patch source list is continually maintained.