US20080005658A1 - Table column spanning - Google Patents
Table column spanning Download PDFInfo
- Publication number
- US20080005658A1 US20080005658A1 US11/855,600 US85560007A US2008005658A1 US 20080005658 A1 US20080005658 A1 US 20080005658A1 US 85560007 A US85560007 A US 85560007A US 2008005658 A1 US2008005658 A1 US 2008005658A1
- Authority
- US
- United States
- Prior art keywords
- headers
- header
- level
- dummy
- creating
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Abstract
Disclosed are a method and system for grouping columns of data into different levels for subsequent multiple level operations. The method comprises the steps of providing sub-columns within a single table column, said table columns and each of the sub-columns having an associated header; and using multiple dummy tables and displaying them separately on different locations, one of the dummy tables including one or more of the associated headers. The preferred embodiment of the invention uses a tool, referred to as the Jtable class, which is used to display and edit regular two-dimensional tables of cells. The present invention is able to support multilevel headers and column spanning by using multiple tables and displaying them separately. Preferably, this is done using another tool, GridBagLayout, which is associated with Jpanel tool.
Description
- 1. Field of the Invention
- This invention generally relates to the display of data tables, and more specifically, the invention relates to the display of tables having plural or multi-level headers.
- 2. Background Art
- It is often useful to represent data in the form of a data table. Conventionally, data tables include a plurality of cells arranged in horizontal rows and vertical columns. Each of the columns and/or rows typically contain a cell describing the content of the cells of the column and/or row, such as a parameter in a spreadsheet table, a time period, or geographical area in a table of a text or a presentation document.
- The cells describing the content of each of the columns of the data table are often arranged in one row located in the first row of the data table, although they can also be located at the last row of the data table or at some other position within each of the columns. The description of the content of each of the columns is termed the header inscription.
- A header inscription can take any of a variety of forms, such as alphabetic, numeric, alphanumeric, symbolic, or of some other form representative of the column contents. A header inscription can be of varying length, and is frequently of a different length from that of the contents of the cells within the column.
- One specific, common type of table found in a variety of hardware/software computer systems and applied in a variety of different contexts is the categorization table. A categorization table organizes data under successive and expandable levels of categorized headings. Such headings give relevant information to the user as to the nature of the underlying subheadings and/or data grouped under particular headings at a given level.
- With many conventional database management programs, it is difficult or time consuming to manage the data in data tables having multiple levels of headers. In part this is because the top, or first level, headers may have different numbers of columns beneath them.
- An object of this invention is to provide an improved method and system for displaying a table having plural or multi-levels of headers.
- Another object of the invention is to display multiple tables together so that they appear as one table.
- These and other objectives are attained with a method and system for grouping columns of data into different levels for subsequent multiple level operations. The method comprises the steps of providing sub-columns within a single table column, said table columns and each of the sub-columns having an associated header; and using multiple dummy tables and displaying them separately on different locations, one of the dummy tables including one or more of the associated headers.
- The preferred embodiment of the invention uses a tool, referred to as the Jtable class, which is used to display and edit regular two-dimensional tables of cells. The present invention is able to support multilevel headers and column spanning by using multiple tables and displaying them separately. Preferably, this is done using another tool, GridBagLayout, which is associated with Jpanel tool.
- Generally, in accordance with the preferred embodiment of this invention, a dummy table is created, which does not have data cells, to show only the header and the dummy table is placed in a location (x,y) on GridBagLayout. Then, a number of dummy tables are created and arranged in a required manner. Another table is created with the number of required cells which does not have header, and this table is located just below all of the headers. Then, the dummy header columns are mapped to the corresponding cell's columns, so the dummy table header will have the association to the table that has data. The sorting and other needed operations will preferably be done with this mapping.
- Further benefits and advantages of the invention will become apparent from a consideration of the following detailed description, given with reference to the accompanying drawings, which specify and show preferred embodiments of the invention.
-
FIG. 1 is a block diagram of a computer that provides an exemplary operating environment for the present invention. -
FIG. 2 illustrates a sample table which has multilevel headers. -
FIG. 3 is another example of plural header levels for a data table. -
FIG. 4 is a flow chart showing a procedure for presenting the table, having the headers ofFIG. 3 , as a group of tables displayed separately. -
FIG. 5 is a table display formed using the procedure ofFIG. 4 . -
FIG. 6 shows the table ofFIG. 5 and also includes indexes showing where the data in the table is stored. -
FIG. 7 shows the table ofFIG. 6 after re-ordering of the second header level. -
FIG. 8 shows the table ofFIG. 7 after re-ordering of the first header level. -
FIG. 1 and the following discussion are intended to provide a brief, general description of a suitable computing environment in which the invention may be implemented. While the invention will be described in the general context of an application program that runs on an operating system in conjunction with a personal computer, those skilled in the art will recognize that the invention also may be implemented in combination with other program modules. - Generally, program modules include routines, programs, components, data structures, etc, that perform particular tasks or implement particular abstract data types. Moreover, those skilled in the art will appreciate that the invention may be practiced with other computer system configurations, including hand-held devices, multiprocessor systems, microprocessor-based or programmable consumer electronics, minicomputers, mainframe computers, and the like.
- The invention may also be practiced in distributed computing environments where tasks are performed by remote processing devices that are linked through a communications network. In a distributed computing environment, program modules may be located in both local and remote memory storage devices.
- With reference to
FIG. 1 , an exemplary system for implementing the invention includes a conventionalpersonal computer 12, including aprocessing unit 14, asystem memory 16, and asystem bus 18 that couples the system memory to the processing unit. Thesystem memory 16 includes read only memory (ROM) 20 andrandom access memory 22. A basic input/output system 24 (BIOS), containing the basic routines that help to transfer information between elements within thepersonal computer 12, such as during start-up, is stored inROM 20. Thepersonal computer 12 further includes ahard disk drive 26, amagnetic disk drive 30 to read from or write to aremovable disk 32, and anoptical disk drive 36, e.g., for reading a CD-ROM disk 38 or to read from or write to other optical media. - The hard disk drive, magnetic disk drive, and optical disk drive are connected to the
system bus 18 by a harddisk drive interface 40, a magneticdisk drive interface 42 and anoptical drive interface 44, respectively. The drives and their associated computer-readable media provide nonvolatile storage for thepersonal computer 12. Although the description of computer-readable media above refers to a hard disk, a removable magnetic disk and a CD-ROM disk, it should be appreciated by those skilled in the art that other types of media which are readable by a computer, such as magnetic cassettes, flash memory cards, digital video disks, and the like, may also be used in the exemplary operating environment. - A number of program modules may be stored in the drives and RAM, including an operating system, one or more application programs, a word processor program module, program data, and other program modules (not shown). The word processor program module may also include a table drawing tool and a table erasing
tool program module 46 for adding tables to an electronic document and editing tables in an electronic document. - A user may enter commands and information into the
personal computer 12 through akeyboard 48 and pointing device, such as amouse 50. Other input devices (not shown) may include a microphone, joystick, game pad, satellite dish, scanner, or the like. These and other input devices are often connected to theprocessing unit 14 through a serial port interface 52 that is coupled to the system bus, but may be connected by other interfaces, such as a game port or a universal serial bus (USB). Amonitor 54 or other type of display device is also connected to the system bus via an interface, such as a video adapter. In addition to themonitor 54, personal computers typically include other peripheral output devices (not shown), such as speakers or printers. - The
personal computer 12 may operate in a networked environment using logical connections to one or more remote computers, such as aremote computer 56. Theremote computer 56 may be a server, a router, a peer device or other common network node, and typically includes many or all of the elements described relative to thepersonal computer 12, although only amemory storage device 58 has been illustrated inFIG. 1 . The logical connections depicted inFIG. 1 include a local area network (LAN) and a wide area network (WAN). Such networking environments are commonplace in offices, enterprise-wide computer networks, intranets and the Internet. - Having described an exemplary operating environment for the present invention, embodiments of this invention will be described below. In brief, the invention provides a method and system for presenting or re-presenting a table having plural or multiple header levels as a series of tables displayed separately.
-
FIG. 2 represents a sample table 60 which has multilevel headers. Header Level 1 (Hlevel1) has five columns. The H1COL4 and H1COL5 columns split into sub columns. Header Level 2 (Hlevel2) has 4 columns which are sub columns of H1COL4 and H1COL5. The H1COL4 column splits into three sub columns H2COL1, H2COL2 and H2COL3. The H1COL5 column splits into only one sub column H2COL4. - The table row data will be associated with the columns: {H1COL1; H1COL2, H1COL3, H1COLA, H1COL5}, {H2COL1, H2COL2, H2COL3} and {H2COL4}.
- The preferred embodiment of the invention uses a tool, referred to as the Jtable class, which is used to display and edit regular two-dimensional tables of cells, and which has many facilities that allow customized rendering and editing. The Jtable class will display a header followed by its two dimensional cells, but this tool does not support multilevel headers and column spanning.
- The present invention is able to support multilevel headers and column spanning by using multiple tables and displaying them separately. Preferably, this is done using another tool, GridBagLayout, which is associated with Jpanel tool. Jtable, it may be noted, allows headers and cells to be separated and to be displayed separately.
- Generally, in accordance with this invention, a dummy table is created, which does not have data cells, to show only the header and the dummy table is placed in a location (x,y) on GridBagLayout. Then, a number of dummy tables are created and arranged in a required manner. Another table is created with the number of required cells which does not have header, and this table is located just below all of the headers. Then, the dummy header columns are mapped to the corresponding cell's columns, so the dummy table header will have the association to the table that has data. The sorting and other needed operations will preferably be done with this mapping.
-
FIGS. 3 through 5 illustrate in greater detail a preferred method for implementing this invention. In particular,FIG. 3 shows aheader area 62 of a table,FIG. 4 is aflow chart 64 for transferring this table (header and data) into a multitude of separate, dummy tables, andFIG. 5 shows theresultant table display 66. - With reference to
FIGS. 3 through 5 , atstep 70, a dummy table is created with the columns “Grains,” “Fruit” and “Vegetables,” and the header is placed in GridBagLayut on the location (x:0,y:0). Atstep 72, another dummy table is created with a single column “Meat,” and the header is placed on the location (x:1,y:0). Atstep 74, another dummy table is created with a single column “Dairy,” and the header is placed on the location (x:2,y:0). These three dummy tables represent the Header Level 1 (Hlevel 1). - At
step 76 another dummy table is created with the columns “Pork,” “Chicken” and “Beef,” and the header is placed on the location (x:1,y:1) of GridBagLayout. This header represents the sub columns of “Meat.” At step 80, another dummy table is created with the single column “Cheese,” and the header is placed on the location (x:2,y:1) of GridBagLayout. This header represents the sub column of “Dairy.” These two dummy tables represent the Header Level2 (Hlevel2) that shows the sub columns of “Meat” and “Dairy.” Atstep 82, one more table is created with all number of columns that will display the row data. This will be placed without its header on the location (x:0,y:2) of GridBagLayout. This table represents all the table cells for data. - The multiple level headers provide the grouping that is desired to be maintained. The ability to re-order columns in a multi-column table is desirable when large amounts of data are displayed where the width of the columns may cause part of the table to go out of view. It also provides the ability to place columns near each other for easier comparisons.
- The reordering of columns is supported at two levels. The columns within a group—“pork,” “chicken,” “beef” under “meat” (in the above example)—can be reordered to be: “chicken,” “pork,” “beef,” as shown in
FIG. 7 . The reordering can be accomplished by mouse drag-and-drop or with keyboard support. Additionally, the user or customer can drag the header “Meat” and move it to the left of “Dairy,” dragging with the “Meat” header all three sub columns underneath it, as shown inFIG. 8 . - Preferably, normal or standard sorting and filtering of the rows is also supported. This function may be provided in any suitable way, such as by a multi-column, sortable, filterable table (MCSFT).
- When a column is moved from one location to another, software code determines the columns affected by determining the original location of the header selected. The code then determines if a single column is affected or multiple columns. If multiple columns are affected, the code also moves the headings in
header level 2 that are affected. - Next, the code determines the new location of the header and calculates the new column numbers for the columns in the data table. To improve performance, preferably, the data within the table is never moved around. Each column in the table has an index field, as shown at 84 in
FIGS. 6-8 , to indicate which column it should be displayed in. A column can also be hidden by specifying that it should not be displayed. The same algorithm applies to the rows when doing sorting and filtering. - The preferred embodiment of the invention, as described above in detail, provides a number of important advantages. For example, the invention provides improved usability to the customer by allowing the table to be manipulated within the boundaries established by the multiple header levels. This allows each user to customize their view of the data in the way that best suits their needs. Also, the invention achieves improved performance without actually manipulating the stored data table in any way. Instead, the improved performance is accomplished in how the data is displayed, not how it is stored.
- While it is apparent that the invention herein disclosed is well calculated to fulfill the objects previously stated, it will be appreciated that numerous modifications and embodiments may be devised by those skilled in the art, and it is intended that the appended claims cover all such modifications and embodiments as fall within the true spirit and scope of the present invention.
Claims (19)
1-18. (canceled)
19. A system for displaying a table including a plurality of headers and a multitude of data cells holding a multitude of data items, each of the headers identifying contents of a set of the data cells, the system comprising:
means for creating one or more header dummy tables including one or more of said headers, and for creating a data dummy table including one or more of said data cells holding said multitude of data items, and for creating a logical linkage relationship between the hierarchical levels of the columns and headers to enable the presentation of the data to be manipulated; and
means for displaying the header and data dummy tables together at the same time and side-by-side at separate locations on the same display screen to form a single composite table on said display screen; and
wherein the header and data dummy tables are separately movable and positionable on the display device, and said single composite table shows all of said plurality of headers and all of said multitude of data items.
20. A system according to claim 19 , wherein:
the plurality of headers includes a first level of headers and a second level of sub-headers;
at least one header of the first level of headers has at least one sub-header of the second level of headers; and
the means for creating header dummy tables includes means for creating a first header dummy table including headers of the first level of headers and for creating a second header dummy table including sub-headers of the second level of headers.
21. A system according to claim 20 , wherein the means for creating header dummy tables includes means for creating a respective one first header dummy table for each of the headers of the first level that has at least one sub-header.
22. A system according to claim 20 , wherein:
the first header dummy table includes only headers of the first level of headers; and
the second header dummy table includes only sub-headers of the second level of headers.
23. A system according to claim 22 , wherein the data dummy table includes only data cells.
24. A system according to claim 20 , wherein the means for creating header dummy tables includes means for creating, for each of the headers in the first level of headers that has one or more sub-headers in the second level of headers, a respective one second header dummy table to hold all of the sub-headers of said each of the headers of the first level of headers.
25. A program storage device readable by machine, tangibly embodying a program of instructions executable by the machine to perform method steps for displaying a table including a plurality of headers and a multitude of data cells holding a multitude of data items, each of the headers identifying contents of a set of the data cells, said method steps comprising:
creating one or more header dummy tables including one or more of said headers;
creating a data dummy table including one or more of said data cells holding said multitude of data items, and creating a logical linkage relationship between the hierarchical levels of the columns and headers to enable the presentation of the data to be manipulated; and
displaying the header and data dummy tables together at the same time and side-by-side at separate locations on the same display screen to form a single composite table on said display screen; and
wherein the header and data dummy tables are separately movable and positionable on the display device, and said single composite table shows all of said plurality of headers and all of said multitude of data items.
26. A program storage device according to claim 25 , wherein:
the plurality of headers includes a first level of headers and a second level of sub-headers;
at least one header of the first level of headers has at least one sub-header of the second level of headers; and
the step of creating header dummy tables includes the steps of creating a first header dummy table including headers of the first level of headers and creating a second header dummy table including sub-headers of the second level of headers.
27. A program storage device according to claim 26 , wherein the step of creating header dummy tables includes creating a respective one first header dummy table for each of the headers of the first level that has at least one sub-header.
28. A program storage device according to claim 26 , wherein:
the first header dummy table includes only headers of the first level of headers; and
the second header dummy table includes only sub-headers of the second level of headers.
29. A program storage device according to claim 28 , wherein the data dummy table includes only data cells.
30. A program storage device according to claim 26 , wherein the step of creating header dummy tables includes the step of creating, for each of the headers in the first level of headers that has one or more sub-headers in the second level of headers, a respective one second header dummy table to hold all of the sub-headers of said each of the headers of the first level of headers.
31. A method of displaying a table including a plurality of headers and a multitude of data cells holding a multitude of data items, each of the headers identifying contents of a set of the data cells, the method comprising the steps of:
creating one or more header dummy tables including one or more of said headers;
creating a data dummy table including one or more of said data cells holding said multitude of data items, and creating a logical linkage relationship between the hierarchical levels of the columns and headers to enable the presentation of the data to be manipulated;
displaying the header and data dummy tables together at the same time and side-by-side at separate locations on the same display screen to form a single composite table on said display screen; and
wherein the header and data dummy tables are separately movable and positionable on the display device, and said single composite table shows all of said plurality of headers and all of said multitude of data items.
32. A method according to claim 31 , wherein:
the plurality of headers includes a first level of headers and a second level of sub-headers;
at least one header of the first level of headers has at least one sub-header of the second level of headers; and
the step of creating header dummy tables includes the steps of creating a first header dummy table including headers of the first level of headers and creating a second header dummy table including sub-headers of the second level of headers.
33. A method according to claim 31 , wherein the step of creating header dummy tables includes creating a respective one first header dummy table for each of the headers of the first level that has at least one sub-header.
34. A method according to claim 31 , wherein:
the first header dummy table includes only headers of the first level of headers; and
the second header dummy table includes only sub-headers of the second level of headers.
35. A method according to claim 34 , wherein the data dummy table includes only data cells.
36. A method according to claim 31 , wherein the step of creating header dummy tables includes the step of creating, for each of the headers in the first level of headers that has one or more sub-headers in the second level of headers, a respective one second header dummy table to hold all of the sub-headers of said each of the headers of the first level of headers.
Priority Applications (3)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US11/855,600 US8214732B2 (en) | 2003-12-01 | 2007-09-14 | Table column spanning |
US13/465,506 US8938667B2 (en) | 2003-12-01 | 2012-05-07 | Table column spanning |
US14/598,367 US9645991B2 (en) | 2003-12-01 | 2015-01-16 | Table column spanning |
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US10/725,278 US7328400B2 (en) | 2003-12-01 | 2003-12-01 | Table column spanning |
US11/855,600 US8214732B2 (en) | 2003-12-01 | 2007-09-14 | Table column spanning |
Related Parent Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US10/725,278 Continuation US7328400B2 (en) | 2003-12-01 | 2003-12-01 | Table column spanning |
Related Child Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US13/465,506 Continuation US8938667B2 (en) | 2003-12-01 | 2012-05-07 | Table column spanning |
Publications (2)
Publication Number | Publication Date |
---|---|
US20080005658A1 true US20080005658A1 (en) | 2008-01-03 |
US8214732B2 US8214732B2 (en) | 2012-07-03 |
Family
ID=34620273
Family Applications (4)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US10/725,278 Expired - Fee Related US7328400B2 (en) | 2003-12-01 | 2003-12-01 | Table column spanning |
US11/855,600 Expired - Fee Related US8214732B2 (en) | 2003-12-01 | 2007-09-14 | Table column spanning |
US13/465,506 Expired - Fee Related US8938667B2 (en) | 2003-12-01 | 2012-05-07 | Table column spanning |
US14/598,367 Expired - Fee Related US9645991B2 (en) | 2003-12-01 | 2015-01-16 | Table column spanning |
Family Applications Before (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US10/725,278 Expired - Fee Related US7328400B2 (en) | 2003-12-01 | 2003-12-01 | Table column spanning |
Family Applications After (2)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US13/465,506 Expired - Fee Related US8938667B2 (en) | 2003-12-01 | 2012-05-07 | Table column spanning |
US14/598,367 Expired - Fee Related US9645991B2 (en) | 2003-12-01 | 2015-01-16 | Table column spanning |
Country Status (1)
Country | Link |
---|---|
US (4) | US7328400B2 (en) |
Cited By (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US9317711B2 (en) * | 2014-06-25 | 2016-04-19 | Sap Se | Privacy restrictions for columnar storage |
US20170043249A1 (en) * | 2012-10-05 | 2017-02-16 | Aaa Internet Publishing Inc. | Method of Using Cloud Infrastructure and Virtualization for Bandwidth-Efficient Remote Video Streaming of Software Application Operation by Executing Computer-Executable Instructions Stored On a Non-Transitory Computer-Readable Medium |
US20190050383A1 (en) * | 2017-08-11 | 2019-02-14 | Emro Co., Ltd. | Method of providing data management service capable of column grouping and service providing server for performing the same |
US20190114316A1 (en) * | 2016-08-25 | 2019-04-18 | Oracle International Corporation | Data grid components |
US10740550B1 (en) * | 2017-11-20 | 2020-08-11 | Amazon Technologies, Inc. | Network-accessible data management service with web-of-sheets data model |
US11586603B1 (en) | 2018-05-23 | 2023-02-21 | Amazon Technologies, Inc. | Index sheets for robust spreadsheet-based applications |
US11740877B2 (en) | 2017-12-12 | 2023-08-29 | Amazon Technologies, Inc. | Application authoring using web-of-sheets data model |
Families Citing this family (31)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7500186B2 (en) * | 2004-08-30 | 2009-03-03 | Microsoft Corporation | Systems and methods for efficiently generating table layouts using moveable items |
US11461077B2 (en) * | 2004-11-26 | 2022-10-04 | Philip K. Chin | Method of displaying data in a table with fixed header |
US20110289398A1 (en) * | 2004-11-26 | 2011-11-24 | Philip King Chin | Method of displaying data in a table with a fixed header |
US20080104091A1 (en) * | 2004-11-26 | 2008-05-01 | Chin Philip K | Method of displaying data in a table |
US20060117051A1 (en) * | 2004-11-26 | 2006-06-01 | Chin Philip K | Method of displaying data in a table |
US7685510B2 (en) * | 2004-12-23 | 2010-03-23 | Sap Ag | System and method for grouping data |
US7934151B1 (en) * | 2005-05-31 | 2011-04-26 | Adobe Systems Incorporated | Specification of tables including objects with arbitrary formatting |
US7668846B1 (en) | 2005-08-05 | 2010-02-23 | Google Inc. | Data reconstruction from shared update log |
US7567973B1 (en) * | 2005-08-05 | 2009-07-28 | Google Inc. | Storing a sparse table using locality groups |
CN100424700C (en) * | 2006-03-06 | 2008-10-08 | 阿里巴巴集团控股有限公司 | Method and system for realizing form local rolling-display in web-page |
US20080104498A1 (en) * | 2006-10-25 | 2008-05-01 | International Business Machines Corporation | Dynamically Merging Columns Within a Table |
US20090040240A1 (en) * | 2007-08-08 | 2009-02-12 | David Kirk Grotjohn | Hovering table headers |
US9501453B2 (en) * | 2007-12-23 | 2016-11-22 | Salesforce.Com Inc. | Method and system for a flexible-data column user interface |
US7549116B1 (en) | 2008-03-31 | 2009-06-16 | International Business Machines Corporation | Computer program product for displaying multiple row layouts in a table |
US20100070491A1 (en) * | 2008-09-18 | 2010-03-18 | International Business Machines Corporation | Dynamic Contextual Table Headers |
US9715487B2 (en) * | 2008-09-30 | 2017-07-25 | Apple Inc. | Multi-level naming of grouped data |
US8484351B1 (en) | 2008-10-08 | 2013-07-09 | Google Inc. | Associating application-specific methods with tables used for data storage |
US8312366B2 (en) * | 2009-02-11 | 2012-11-13 | Microsoft Corporation | Displaying multiple row and column header areas in a summary table |
US8786559B2 (en) * | 2010-01-06 | 2014-07-22 | Apple Inc. | Device, method, and graphical user interface for manipulating tables using multi-contact gestures |
US8773370B2 (en) * | 2010-07-13 | 2014-07-08 | Apple Inc. | Table editing systems with gesture-based insertion and deletion of columns and rows |
JP2013196565A (en) * | 2012-03-22 | 2013-09-30 | Toshiba Corp | Database processing method, and database processor |
US9665553B1 (en) * | 2013-01-10 | 2017-05-30 | Google Inc. | Techniques for determining a location of user interaction within a table of a web page |
US9436672B2 (en) * | 2013-12-11 | 2016-09-06 | Power Modes Pty. Ltd. | Representing and manipulating hierarchical data |
US10353927B2 (en) | 2014-07-10 | 2019-07-16 | Entit Software Llc | Categorizing columns in a data table |
US9760271B2 (en) | 2014-07-28 | 2017-09-12 | International Business Machines Corporation | Client-side dynamic control of visualization of frozen region in a data table |
US10120848B2 (en) * | 2014-12-09 | 2018-11-06 | Salesforce.Com, Inc. | Methods and systems for applying responsive design to subframes on a web page |
CN106845827A (en) * | 2017-01-17 | 2017-06-13 | 环境保护部卫星环境应用中心 | Support the comprehensive grading and stage division and device of customed automation |
US10509612B2 (en) | 2017-08-10 | 2019-12-17 | Td Ameritrade Ip Company, Inc. | Three-dimensional information system |
US11501062B1 (en) * | 2020-02-13 | 2022-11-15 | The Mathworks, Inc. | Systems and methods for displaying data including hierarchical headers |
JP7216680B2 (en) * | 2020-03-17 | 2023-02-01 | 株式会社東芝 | Information processing device, information processing method, and program |
US11436249B1 (en) * | 2021-03-26 | 2022-09-06 | International Business Machines Corporation | Transformation of composite tables into structured database content |
Citations (20)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5632009A (en) * | 1993-09-17 | 1997-05-20 | Xerox Corporation | Method and system for producing a table image showing indirect data representations |
US5752025A (en) * | 1996-07-12 | 1998-05-12 | Microsoft Corporation | Method, computer program product, and system for creating and displaying a categorization table |
US5883623A (en) * | 1992-04-08 | 1999-03-16 | Borland International, Inc. | System and methods for building spreadsheet applications |
US5970506A (en) * | 1997-01-20 | 1999-10-19 | Justsystem Corporation | Spreadsheet-calculating system and method |
US6085198A (en) * | 1998-06-05 | 2000-07-04 | Sun Microsystems, Inc. | Integrated three-tier application framework with automated class and table generation |
US6088808A (en) * | 1989-12-15 | 2000-07-11 | Hitachi, Ltd. | Low power consumption semiconductor integrated circuit device and microprocessor |
US6154756A (en) * | 1992-07-15 | 2000-11-28 | Apple Computer, Inc. | Computer system integrating different data types into a single environment |
US20010049699A1 (en) * | 1998-06-17 | 2001-12-06 | Christopher Hugh Pratley | Method and system for merging cells in a table and for adding an integrated header and a nested table to a table in an electronic document |
US20020038384A1 (en) * | 2000-06-16 | 2002-03-28 | Khan Umair A. | System, method and computer program product for transcoding tabular content for display on thin client devices by way of content addressing |
US6446063B1 (en) * | 1999-06-25 | 2002-09-03 | International Business Machines Corporation | Method, system, and program for performing a join operation on a multi column table and satellite tables |
US20020147725A1 (en) * | 2001-04-05 | 2002-10-10 | Sun Microsystems, Inc. | Method and apparatus for database table definition |
US20020158876A1 (en) * | 2001-04-30 | 2002-10-31 | Sun Microsystems, Inc. | Method and computer system for displaying a table with column header inscriptions having a reduced horizontal size |
US6544294B1 (en) * | 1999-05-27 | 2003-04-08 | Write Brothers, Inc. | Method and apparatus for creating, editing, and displaying works containing presentation metric components utilizing temporal relationships and structural tracks |
US20040103369A1 (en) * | 2002-11-26 | 2004-05-27 | Sonoco Development, Inc. | Method and apparatus for displaying data in a web page |
US20040199870A1 (en) * | 2003-04-03 | 2004-10-07 | International Business Machines Corporation | Automated conversion of CALS-compatible tables to accessible HTML tables |
US7054871B2 (en) * | 2000-12-11 | 2006-05-30 | Lucent Technologies Inc. | Method for identifying and using table structures |
US7089530B1 (en) * | 1999-05-17 | 2006-08-08 | Invensys Systems, Inc. | Process control configuration system with connection validation and configuration |
US7143339B2 (en) * | 2000-09-20 | 2006-11-28 | Sap Aktiengesellschaft | Method and apparatus for dynamically formatting and displaying tabular data in real time |
US7461077B1 (en) * | 2001-07-31 | 2008-12-02 | Nicholas Greenwood | Representation of data records |
US7624372B1 (en) * | 2003-04-16 | 2009-11-24 | The Mathworks, Inc. | Method for integrating software components into a spreadsheet application |
Family Cites Families (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6088708A (en) | 1997-01-31 | 2000-07-11 | Microsoft Corporation | System and method for creating an online table from a layout of objects |
US7162689B2 (en) | 1998-05-28 | 2007-01-09 | Oracle International Corporation | Schema evolution in replication |
US6567816B1 (en) * | 2000-03-07 | 2003-05-20 | Paramesh Sampatrai Desai | Method, system, and program for extracting data from database records using dynamic code |
-
2003
- 2003-12-01 US US10/725,278 patent/US7328400B2/en not_active Expired - Fee Related
-
2007
- 2007-09-14 US US11/855,600 patent/US8214732B2/en not_active Expired - Fee Related
-
2012
- 2012-05-07 US US13/465,506 patent/US8938667B2/en not_active Expired - Fee Related
-
2015
- 2015-01-16 US US14/598,367 patent/US9645991B2/en not_active Expired - Fee Related
Patent Citations (21)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6088808A (en) * | 1989-12-15 | 2000-07-11 | Hitachi, Ltd. | Low power consumption semiconductor integrated circuit device and microprocessor |
US5883623A (en) * | 1992-04-08 | 1999-03-16 | Borland International, Inc. | System and methods for building spreadsheet applications |
US6154756A (en) * | 1992-07-15 | 2000-11-28 | Apple Computer, Inc. | Computer system integrating different data types into a single environment |
US5632009A (en) * | 1993-09-17 | 1997-05-20 | Xerox Corporation | Method and system for producing a table image showing indirect data representations |
US5752025A (en) * | 1996-07-12 | 1998-05-12 | Microsoft Corporation | Method, computer program product, and system for creating and displaying a categorization table |
US5970506A (en) * | 1997-01-20 | 1999-10-19 | Justsystem Corporation | Spreadsheet-calculating system and method |
US6085198A (en) * | 1998-06-05 | 2000-07-04 | Sun Microsystems, Inc. | Integrated three-tier application framework with automated class and table generation |
US20010049699A1 (en) * | 1998-06-17 | 2001-12-06 | Christopher Hugh Pratley | Method and system for merging cells in a table and for adding an integrated header and a nested table to a table in an electronic document |
US6442575B2 (en) * | 1998-06-17 | 2002-08-27 | Microsoft Corporation | Method and system for merging cells in a table and for adding an integrated header and a nested table to a table in an electronic document |
US7089530B1 (en) * | 1999-05-17 | 2006-08-08 | Invensys Systems, Inc. | Process control configuration system with connection validation and configuration |
US6544294B1 (en) * | 1999-05-27 | 2003-04-08 | Write Brothers, Inc. | Method and apparatus for creating, editing, and displaying works containing presentation metric components utilizing temporal relationships and structural tracks |
US6446063B1 (en) * | 1999-06-25 | 2002-09-03 | International Business Machines Corporation | Method, system, and program for performing a join operation on a multi column table and satellite tables |
US20020038384A1 (en) * | 2000-06-16 | 2002-03-28 | Khan Umair A. | System, method and computer program product for transcoding tabular content for display on thin client devices by way of content addressing |
US7143339B2 (en) * | 2000-09-20 | 2006-11-28 | Sap Aktiengesellschaft | Method and apparatus for dynamically formatting and displaying tabular data in real time |
US7054871B2 (en) * | 2000-12-11 | 2006-05-30 | Lucent Technologies Inc. | Method for identifying and using table structures |
US20020147725A1 (en) * | 2001-04-05 | 2002-10-10 | Sun Microsystems, Inc. | Method and apparatus for database table definition |
US20020158876A1 (en) * | 2001-04-30 | 2002-10-31 | Sun Microsystems, Inc. | Method and computer system for displaying a table with column header inscriptions having a reduced horizontal size |
US7461077B1 (en) * | 2001-07-31 | 2008-12-02 | Nicholas Greenwood | Representation of data records |
US20040103369A1 (en) * | 2002-11-26 | 2004-05-27 | Sonoco Development, Inc. | Method and apparatus for displaying data in a web page |
US20040199870A1 (en) * | 2003-04-03 | 2004-10-07 | International Business Machines Corporation | Automated conversion of CALS-compatible tables to accessible HTML tables |
US7624372B1 (en) * | 2003-04-16 | 2009-11-24 | The Mathworks, Inc. | Method for integrating software components into a spreadsheet application |
Cited By (10)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20170043249A1 (en) * | 2012-10-05 | 2017-02-16 | Aaa Internet Publishing Inc. | Method of Using Cloud Infrastructure and Virtualization for Bandwidth-Efficient Remote Video Streaming of Software Application Operation by Executing Computer-Executable Instructions Stored On a Non-Transitory Computer-Readable Medium |
US9317711B2 (en) * | 2014-06-25 | 2016-04-19 | Sap Se | Privacy restrictions for columnar storage |
US20190114316A1 (en) * | 2016-08-25 | 2019-04-18 | Oracle International Corporation | Data grid components |
US10762290B2 (en) * | 2016-08-25 | 2020-09-01 | Oracle International Corporation | Data grid components |
US11347935B2 (en) | 2016-08-25 | 2022-05-31 | Oracle International Corporation | Expended data grid components |
US11769002B2 (en) | 2016-08-25 | 2023-09-26 | Oracle International Corporation | Extended data grid components with multi-level navigation |
US20190050383A1 (en) * | 2017-08-11 | 2019-02-14 | Emro Co., Ltd. | Method of providing data management service capable of column grouping and service providing server for performing the same |
US10740550B1 (en) * | 2017-11-20 | 2020-08-11 | Amazon Technologies, Inc. | Network-accessible data management service with web-of-sheets data model |
US11740877B2 (en) | 2017-12-12 | 2023-08-29 | Amazon Technologies, Inc. | Application authoring using web-of-sheets data model |
US11586603B1 (en) | 2018-05-23 | 2023-02-21 | Amazon Technologies, Inc. | Index sheets for robust spreadsheet-based applications |
Also Published As
Publication number | Publication date |
---|---|
US9645991B2 (en) | 2017-05-09 |
US7328400B2 (en) | 2008-02-05 |
US20050120293A1 (en) | 2005-06-02 |
US8214732B2 (en) | 2012-07-03 |
US20120221935A1 (en) | 2012-08-30 |
US8938667B2 (en) | 2015-01-20 |
US20150193419A1 (en) | 2015-07-09 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US9645991B2 (en) | Table column spanning | |
US20190114308A1 (en) | Optimizing a document based on dynamically updating content | |
JP3001460B2 (en) | Document classification device | |
US7350142B2 (en) | Method and system for creating a table version of a document | |
US20050232055A1 (en) | Multiple chart user interface | |
EP1255211A1 (en) | Method and computer system for displaying a table with column header inscriptions having a reduced horizontal size | |
US6313848B1 (en) | Folded tables: a method of viewing wide tables with reduced need for horizontal scrolling | |
JP3048330B2 (en) | Apparatus and method for extracting articles from documents | |
US7149967B2 (en) | Method and system for creating a table version of a document | |
US6804420B2 (en) | Information retrieving system and method | |
US20080007554A1 (en) | Two Dimensional User Interface For Multidimensional Data Analysis | |
US20090074303A1 (en) | Method and System for Creating a Form Template for a Form | |
JP2001092825A (en) | Device and method for processing information | |
US20060026508A1 (en) | Document creation system and related methods | |
WO2008070240A2 (en) | Data charting with adaptive learning | |
KR100309666B1 (en) | Method and apparatus for deriving association rule between data, and method and apparatus for segmenting rectilinear region | |
US6470337B1 (en) | Information retrieval system using a hierarchical index for narrowing a retrieval result and its method and storing medium with information retrieval program stored therein | |
US7937657B2 (en) | User specific error analysis | |
US20030222921A1 (en) | Automatic layout generation using algorithms | |
JPS6037945B2 (en) | How to display hierarchical tree-structured text in an ordered structure | |
JP4478579B2 (en) | System, method and computer program product for changing the graphical representation of data entities and relational database structures | |
US7627815B2 (en) | Object editing system | |
US8041688B2 (en) | Data search device, data search method, and recording medium | |
JPH08255160A (en) | Layout device and display device | |
WO2001057744A2 (en) | Improvements in or relating to spreadsheets |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
REMI | Maintenance fee reminder mailed | ||
LAPS | Lapse for failure to pay maintenance fees | ||
STCH | Information on status: patent discontinuation |
Free format text: PATENT EXPIRED DUE TO NONPAYMENT OF MAINTENANCE FEES UNDER 37 CFR 1.362 |
|
FP | Expired due to failure to pay maintenance fee |
Effective date: 20160703 |
|
AS | Assignment |
Owner name: AIRBNB, INC., CALIFORNIA Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:INTERNATIONAL BUSINESS MACHINES CORPORATION;REEL/FRAME:056427/0193 Effective date: 20210106 |