IP Library › Granted Patent US 9,626,349
Granted Patent B2
US 9,626,349 · App. 13/717,851 · Granted Apr 18, 2017

Dynamically manipulating tables based on a font

Inventors: Paul R. Bastide (Boxford, MA); Matthew E. Broomhall (Goffstown, NH); Robert E. Loredo (North Miami Beach, FL)
Assignee: International Business Machines Corporation
G06F17/246G06F17/245G06F17/247
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 9,626,349
App. No.
13/717,851
Granted
Apr 18, 2017
Kind
B2
Abstract

A computer system receives a request to combine tabular data of a first table with tabular data of a second table. The computer system creates a profile for the second table indicating organization of types of data within the second table. The computer system determines a placement for at least one data element of the tabular data of the first table, into the second table, such that the placement agrees, to at least a specified confidence level, with the organization of types of data within the second table indicated by the profile. The computer system adds the at least one data element to the second table based on the determined placement.

Claims (54)

1. A computer program product for combining tabular data, the computer program product comprising:

one or more non-transitory computer-readable storage media and program instructions stored on the one or more non-transitory computer-readable storage media, the program instructions comprising:

program instructions to receive a request to combine tabular data of a first table with tabular data of a second table;

program instructions to create a profile for the second table indicating organization of types of data within the second table, wherein the profile associates each data element of the second table with descriptive values including at least a font used for a particular column or row of the second table;

program instructions to determine a placement for at least one data element of the tabular data of the first table, into the second table, such that the placement agrees, to at least a specified confidence level, with the organization of types of data within the second table as indicated by the descriptive values of the profile;

program instructions to rearrange the tabular data of the first table to match the profile of the tabular data of the second table according to the organization of types of data within the second table, such that a rearranged column or row of the first table aligns with a placement of the particular column or row of the second table based on a font;

program instructions to display the rearranged tabular data of the first table;

program instructions to receive an indication a profile of the rearranged tabular data of the first table matches the profile of the tabular data of the second table; and

program instructions to add the at least one data element to the second table based on the determined placement, wherein a font of the at least one data element matches a font of a particular column or row of the determined placement.

2. The computer program product of claim 1 , wherein the program instructions to create the profile for the second table indicating the organization of types of data within the second table comprise:

program instructions to associate each of a plurality of the columns and rows in the second table with one or more attributes indicative of a type of data for the respective column or row.

3. The computer program product of claim 1 , wherein the program instructions to determine the placement for the at least one data element of the tabular data of the first table, into the second table comprise:

program instructions to determine one or more attributes of the at least one data element;

program instructions to determine a column or row of the second table that is associated with one or more of the one or more attributes, based on the profile; and

program instructions to determine to place the at least one data element in the determined column or row of the second table.

4. The computer program product of claim 3 , further comprising program instructions, stored on the one or more computer-readable storage media, to:

prior to determining to place the at least one data element in the determined column or row of the second table:

determine a second column or row of the second table that is associated with one or more of the one or more attributes;

indicate to a user that the at least one data element can be placed in either the determined column or row, or the second column or row; and

receive a selection of the determined column or row from the user.

5. The computer program product of claim 4 , wherein the program instructions to indicate to the user comprise:

program instructions to display a preview of the at least one data element placed into the determined column or row; and

program instructions to display a preview of the at least one data element placed into the second column or row.

6. The computer program product of claim 1 , further comprising program instructions, stored on the one or more computer-readable storage media, to indicate to a user that the at least one data element has been added to the second table based on the profile of the tabular data of the second table.

7. The computer program product of claim 1 , further comprising program instructions, stored on the one or more computer-readable storage media, to:

prior to determining the placement for the at least one data element of the tabular data of the first table, into the second table, receive, from a user, an indication of how tabular data of the first table corresponds to tabular data of the second table.

8. A system for combining tabular data, the system comprising:

one or more computer processors;

one or more non-transitory computer-readable storage media;

program instructions stored on at least one of the one or more non-transitory computer-readable storage media for execution by at least one of the one or more computer processors, the program instructions comprising:

program instructions to receive a request to combine tabular data of a first table with tabular data of a second table;

program instructions to create a profile for the second table indicating organization of types of data within the second table, wherein the profile associates each data element of the second table with descriptive values including at least a font used for a particular column or row of the second table;

program instructions to determine a placement for at least one data element of the tabular data of the first table, into the second table, such that the placement agrees, to at least a specified confidence level, with the organization of types of data within the second table as indicated by the descriptive values of the profile;

program instructions to rearrange the tabular data of the first table to match the profile of the tabular data of the second table according to the organization of types of data within the second table, such that a rearranged column or row of the first table aligns with a placement of the particular column or row of the second table based on a font;

program instructions to display the rearranged tabular data of the first table;

program instructions to receive an indication a profile of the rearranged tabular data of the first table matches the profile of the tabular data of the second table; and

program instructions to add the at least one data element to the second table based on the determined placement, wherein a font of the at least one data element matches a font of a particular column or row of the determined placement.

9. The system of claim 8 , wherein the program instructions to create the profile for the second table indicating the organization of types of data within the second table comprise:

program instructions to associate each of a plurality of the columns and rows in the second table with one or more attributes indicative of a type of data for the respective column or row.

10. The system of claim 8 , wherein the program instructions to determine the placement for the at least one data element of the tabular data of the first table, into the second table, comprise:

program instructions to determine one or more attributes of the at least one data element;

program instructions to determine a column or row of the second table that is associated with one or more of the one or more attributes, based on the profile; and

program instructions to determine to place the at least one data element in the determined column or row of the second table.

11. The system of claim 10 , further comprising program instructions, stored on at least one of the one or more computer-readable storage media for execution by at least one of the one or more computer processors, to:

prior to determining to place the at least one data element in the determined column or row of the second table:

determine a second column or row of the second table that is associated with one or more of the one or more attributes;

indicate to a user that the at least one data element can be placed in either the determined column or row, or the second column or row; and

receive a selection of the determined column or row from the user.

12. The system of claim 11 , wherein the program instructions to indicate to the user comprise:

program instructions to display a preview of the at least one data element placed into the determined column or row; and

program instructions to display a preview of the at least one data element placed into the second column or row.

13. The system of claim 8 , further comprising program instructions, stored on at least one of the one or more computer-readable storage media for execution by at least one of the one or more computer processors, to indicate to a user that the at least one data element has been added to the second table based on the profile of the tabular data of the second table.

14. The system of claim 8 , further comprising program instructions, stored on at least one of the one or more computer-readable storage media for execution by at least one of the one or more computer processors, to:

prior to determining the placement for the at least one data element of the tabular data of the first table, into the second table, receive, from a user, an indication of how tabular data of the first table corresponds to tabular data of the second table.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Dec 18, 2012
From: BASTIDE, PAUL R.; BROOMHALL, MATTHEW E.; LOREDO, ROBERT E.
To: INTERNATIONAL BUSINESS MACHINES CORPORATION
Reel/Frame 029487/0731 →
Continuity (1)
Related Publication 20140173402A1 · Jun 19, 2014