One click conditional formatting method and system for software programs

• US 7,933,862 B2
• Filed: 09/27/2004
• Issued: 04/26/2011
• Est. Priority Date: 09/27/2004
• Status: Active Grant

• Current Assignee: KLS Martin GmbH & Co, Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Ellis, Charles D., Chamberlain, Benjamin C., Street, Christopher M., Gainer, David E., Weber, Brandon G., Vigesaa, Eric B., Jones, Bruce Cordell
• Primary Examiner(s): Ali; Mohammad
• Assistant Examiner(s): Ruiz; Angelica
• Application Number:
  US10/951,468
• Publication Number:
  US 20060074866A1
• Time in Patent Office: 2,402 Days
• Field of Search: 707/100, 707/102, 707/104.1, 715/212, 715/217, 715/219
• US Class Current: 707/602
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

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.

Claims

1. A method of conditionally formatting a display of data comprising:

selecting a portion of the display of data from a spreadsheet for applying the conditional formatting, wherein the selected portion of the display of data has not been predefined for receiving the conditional formatting;

selecting a conditional template object from a set of displayed conditional template objects;

displaying a set of predetermined conditional options of the selected conditional template object;

selecting a predetermined conditional option from the set of predetermined conditional options, wherein the predetermined conditional option comprises a predetermined format that provides data bars corresponding to relative magnitudes of data within the selected portion of the display of data;

as an automatic result of selecting the predetermined conditional option;

automatically applying temporarily the predetermined format to a first portion of the selected portion of the display of data from the spreadsheet that meets a default parameter associated with the predetermined conditional option and leaving a second portion of the selected portion that does not meet the default parameter in an original format; and

automatically displaying a temporary preview within the spreadsheet on the display of the predetermined format applied to the first portion that meets the default parameter and displaying the second portion that does not meet the default parameter in the original format, wherein the data bars are displayed in association with the first portion that meets the default parameter.

2. The method as defined in claim 1 wherein the method is performed by a computer operating system.

3. The method as defined in claim 1 wherein the display of data is spreadsheet data.

4. A tangible computer program product embodied in a storage medium readable by a computer system and tangibly embodying a program of instructions executable by the computer system to perform the method of claim 1.

5. A tangible computer program product embodied in a storage medium readable by a computer and encoding instructions for executing a computer process for displaying spreadsheet data on a display using conditional formatting, the process comprising:

selecting a portion of spreadsheet data from a spreadsheet to be conditionally formatted on the display, wherein one or more cells containing the selected portion of spreadsheet data have not been predefined for receiving the conditional formatting; and

selecting a predetermined condition, wherein the predetermined condition comprises a predetermined format that provides data bars corresponding to relative magnitudes of cells in the selected portion of spreadsheet data;

as a result of selecting the predetermined condition;

automatically applying temporarily the predetermined format within the spreadsheet to an active cell of the selected portion of spreadsheet data and to additional cells of the selected portion of spreadsheet data that match a content of the active cell, and leaving a remainder of cells of the selected portion of spreadsheet data that do not match the active cell in an original format of the selected portion of spreadsheet data; and

automatically displaying a temporary preview on the display of the predetermined format applied to the active cell and to the additional cells that match the content of the active cell, wherein the data bars are displayed in association with the active cell and with the additional cells that match the content of the active cell, and displaying the remainder of cells of the selected portion of spreadsheet data that do not match the content of the active cell in the original format of the selected portion of spreadsheet data.

6. The tangible computer program product as defined in claim 5 wherein the predetermined condition is selected from a predetermined set of conditions.

7. The tangible computer program product as defined in claim 5 wherein the conditional formatting is selected from a predetermined set of display formats.

8. A graphical user interface operable by a processor in a memory of a computer system, the graphical user interface having a display module for displaying data on a display device, said graphical user interface comprising:

a selection module operable by the processor in the memory of the computer system for receiving a selection of data from a spreadsheet displayed on the display device to be conditionally formatted on the display device, wherein the selection of data has not been predefined for receiving the conditional formatting;

a condition module operable by the processor in the memory of the computer system for providing a set of predetermined conditions that are displayed on the display device;

a format module operable by the processor in the memory of the computer system for displaying the set of predetermined formats on the display device, wherein one of the set of predetermined formats comprises data bars corresponding to relative magnitudes of data within the selection of data;

a preview module operable by the processor in the memory of the computer system for automatically applying temporarily the one of the set of predetermined formats to a first portion of data of the selection of data from the spreadsheet that matches a content of an active cell or that meets a default parameter, leaving a second portion of data of the selection of data that does not match the content of the active cell or that does not meet the default parameter in an original format of the selection of data;

wherein as an automatic result of selecting a one of the set of predetermined conditions, the preview module automatically displays a temporary preview within the spreadsheet on the display device of the selection of data using the one of the set of predetermined formats applied to the first portion of data that matches the content of the active cell or meets the default parameter, wherein the data bars are displayed in association with the first portion of data, and displaying the second portion of data that does not meet the content of the active cell or that does not meet the default parameter in the original format of the selection of data.

9. The graphical user interface as defined in claim 8 wherein the predetermined condition is selected from a predetermined set of conditions.

10. The graphical user interface as defined in claim 8 wherein if one of the set of predetermined conditions is met by the data, then the predetermined format is applied to the data and displayed on the display.

11. The graphical user interface as defined in claim 8 further comprising a condition dialog module for permitting a modification of the predetermined condition to be made after preview and prior to a conditional formatting acceptance.

12. The graphical user interface as defined in claim 8 further comprising a formatting dialog module for permitting a modification of the predetermined format to be made after preview and prior to a conditional formatting acceptance.