Auto-formatting of tables in a spreadsheet program

• US 5,613,131 A
• Filed: 01/29/1993
• Issued: 03/18/1997
• Est. Priority Date: 01/29/1993
• Status: Expired due to Term

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Moss, Ken A., Kwatinetz, Andrew
• Primary Examiner(s): Feild, Joseph H.
• Application Number:
  US08/011,305
• Time in Patent Office: 1,509 Days
• Field of Search: 395/148, 395/149, 395/61, 395/155, 395/600, 395/12, 395/3, 395/161, 395/1, 395/10
• US Class Current: 715/236
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

A number of predefined table formats are provided for formatting a table. A user converts a table into the predefined table format by selecting the range of cells for the table and then selecting the predefined table format to be applied to the range of cells of the table. The formatting is performed automatically by a data processing system. Heuristics are used to determine the structure of the table to be formatted. Separate parts of the table are then successively formatted in accordance with the selected predefined table format.

Claims

1. In a data processing system having a processor that runs a spreadsheet program, a method of identifying a table to be formatted in a spreadsheet composed of cells that may be empty or hold contents, said method comprising the computer-implemented steps of:

designating a cell as an active cell;

identifying the active cell as part of the table to be formatted;

iteratively identifying each cell that is immediately adjacent in a vertical direction to a cell that has already been identified as part of the table and that holds non-empty contents as part of the table to be formatted, such that said identifying identifies a selected column of cells composed of a number of cells that are part of the table to be formatted; and

iteratively identifying each column of cells, that has a number of cells equal to the selected column of cells and that is immediately adjacent to a column of cells that already has been identified as part of the table to be formatted and that includes at least one cell that holds non-empty contents, as part of the table to be formatted.

2. The method of claim 1 wherein the cells that have been identified to be part of the table include rows having a given number of cells, including a topmost row and a bottommost row and wherein the method further comprises the step of iteratively identifying each row of cells in the spreadsheet having the given number of cells that is immediately adjacent to the topmost row or the bottomost row and that has at least one cell that holds non-empty contents as part of the table to be formatted.

3. The method of claim 1, further comprising the step of formatting the table.

4. The method of claim 1 wherein the data processing system is a distributed system.