FreshPatents.com Logo
stats FreshPatents Stats
n/a views for this patent on FreshPatents.com
Updated: April 14 2014
newTOP 200 Companies filing patents this week


    Free Services  

  • MONITOR KEYWORDS
  • Enter keywords & we'll notify you when a new patent matches your request (weekly update).

  • ORGANIZER
  • Save & organize patents so you can view them later.

  • RSS rss
  • Create custom RSS feeds. Track keywords without receiving email.

  • ARCHIVE
  • View the last few months of your Keyword emails.

  • COMPANY DIRECTORY
  • Patents sorted by company.

AdPromo(14K)

Follow us on Twitter
twitter icon@FreshPatents

Variable formatting of values

last patentdownload pdfdownload imgimage previewnext patent


20120324328 patent thumbnailZoom

Variable formatting of values


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.

Browse recent Microsoft Corporation patents - Redmond, WA, US
Inventors: Benjamin C. Chamberlain, Bruce C. Jones, Christopher M. Street, David F. Gainer, Eric B. Vigesaa
USPTO Applicaton #: #20120324328 - Class: 715217 (USPTO) - 12/20/12 - Class 715 


view organizer monitor keywords


The Patent Description & Claims data below is from USPTO Patent Application 20120324328, Variable formatting of values.

last patentpdficondownload pdfimage previewnext patent

RELATED APPLICATIONS

This application is a continuation of and claims priority under 35 U.S.C. §120, to application Ser. No. 12/547,760, filed Aug. 26, 2009, entitled VARIABLE FORMATTING OF CELLS, which is a continuation of and claims priority to application Ser. No. 11/260,520, filed Oct. 27, 2005, entitled VARIABLE FORMATTING OF CELLS, now issued as U.S. Pat. No. 7,627,812, on Dec. 1, 2009, all which are hereby incorporated by reference in their entirety.

BACKGROUND

Data visualization techniques enable users of data to scan and quickly comprehend large quantities of information. Such techniques may also aid in alerting users to anomalies and other data of interest. Visualization tools can include charts, graphs, and reports that collect, summarize, and/or otherwise transform data into meaningful shapes, colors, and patterns. Closer to the source, data visualization has also included the use of conditional formatting in spreadsheets, which frequently serve as receptacles of raw data.

Conditional formatting has enabled users to modify the look of data in place, changing the appearance of individual spreadsheet or table cells based on the content of the cell (or some other determining condition). FIG. 2 depicts a prior art range of cells 201 in a spreadsheet, the cells of which have been conditionally formatted. Here, cell A1 provides an example of the default or unformatted version of a cell. Cell A2 provides an example of a first conditionally formatted cell, and cell A4 provides an example of a second conditionally formatted cell. Cells A2 and A4 have automatically received new formatting based on a condition associated with the cells.

FIG. 3 depicts a prior art dialog 301 where formats conditioned upon values being within certain ranges have been selected. The two conditions supplied here (and applied to the range of cells 201) format cells in a particular fashion when the value contained within each is evaluated as being between a certain range (10 and 20 for condition 1, 15 and 30 for condition 2). The conditions utilized in conditional formats are limited to two possible Boolean outputs, TRUE or FALSE. If the condition supplied evaluates to TRUE, then the format is applied. If the condition supplied evaluates to FALSE, then the format is not applied.

Dialog 301 demonstrates that, while useful, conditional formatting can be limiting as to certain available formats (e.g., font, cell color, borders). Furthermore, a given range of cells is provided a maximum number of conditional formats that can be applied, certainly no more than three conditions, each providing no more than one possible format when evaluating to TRUE. These limitations prevent conditionally formatted cells from fully realizing their potential as analysis and reporting tools.

There is a need in the art for the ability to vary cell formats in tables and spreadsheets and to apply advanced formats. Such formatting should not be restricted to a limited set of formats based on Boolean conditions.

SUMMARY

One or more embodiments enable variable formatting, which provides methods for applying a varying format to a range of cells in a spreadsheet, table, or other electronic document. Formats are applied which vary based on the cell value (or an associated value). Examples include a variable format command being applied to a range of cells that varies the background color of the cell along a color scale varying with a value in the cell. Additional examples include varying the size (or other aspect) of a shape such as a data bar that is placed in the cell, and varying the selection of an in-cell icon based on a value associated with a cell.

Additional embodiments provide systems that may implement variable formatting, systems that include a display, processor, and memory storing instructions to execute on the processor.

BRIEF DESCRIPTION OF THE DRAWINGS

The patent or application file contains at least one drawing executed in color. Copies of this patent or patent application publication with color drawing(s) will be provided by the Office upon request and payment of the necessary fee.

The foregoing brief summary of the invention, as well as the following detailed description, is better understood when read in conjunction with the accompanying drawings, which are included by way of example, and not by way of limitation with regard to the claimed invention. In the accompanying drawings, the same or similar elements are labeled with the same reference numbers.

FIG. 1 depicts an exemplary operating environment in which one or more embodiments may be implemented.

FIG. 2 depicts a prior art example of a range of conditionally formatted cells in a spreadsheet.

FIG. 3 depicts a prior art example of a dialog for conditionally formatting cells.

FIG. 4A depicts a range of cells formatted using color scale style variable formatting according to one or more embodiments.

FIG. 4B depicts an input dialog with which a user may specify the variable formatting parameters for FIG. 4A according to one or more embodiments.

FIG. 5A depicts a range of cells formatted using data bar style variable formatting according to one or more embodiments.

FIG. 5B depicts an input dialog with which a user may specify the variable formatting parameters for FIG. 5A according to one or more embodiments.

FIG. 6A depicts a range of cells formatted using icon style variable formatting according to one or more embodiments.

FIG. 6B depicts an input dialog with which a user may specify the variable formatting parameters for FIG. 6A according to one or more embodiments.



Download full PDF for full patent description/claims.

Advertise on FreshPatents.com - Rates & Info


You can also Monitor Keywords and Search for tracking patents relating to this Variable formatting of values patent application.
###
monitor keywords



Keyword Monitor How KEYWORD MONITOR works... a FREE service from FreshPatents
1. Sign up (takes 30 seconds). 2. Fill in the keywords to be monitored.
3. Each week you receive an email with patent applications related to your keywords.  
Start now! - Receive info on patent apps like Variable formatting of values or other areas of interest.
###


Previous Patent Application:
Integrated adaptive url-shortening functionality
Next Patent Application:
Presentation of tabular information
Industry Class:
Data processing: presentation processing of document
Thank you for viewing the Variable formatting of values patent info.
- - - Apple patents, Boeing patents, Google patents, IBM patents, Jabil patents, Coca Cola patents, Motorola patents

Results in 0.58436 seconds


Other interesting Freshpatents.com categories:
Qualcomm , Schering-Plough , Schlumberger , Texas Instruments , -g2-0.2029
     SHARE
  
           

FreshNews promo


stats Patent Info
Application #
US 20120324328 A1
Publish Date
12/20/2012
Document #
13595791
File Date
08/27/2012
USPTO Class
715217
Other USPTO Classes
International Class
06F3/01
Drawings
10



Follow us on Twitter
twitter icon@FreshPatents