|Publication number||US7934151 B1|
|Application number||US 11/141,933|
|Publication date||Apr 26, 2011|
|Filing date||May 31, 2005|
|Priority date||May 31, 2005|
|Publication number||11141933, 141933, US 7934151 B1, US 7934151B1, US-B1-7934151, US7934151 B1, US7934151B1|
|Inventors||Adam Castrucci, Gavin F. Mckenzie|
|Original Assignee||Adobe Systems Incorporated|
|Export Citation||BiBTeX, EndNote, RefMan|
|Patent Citations (26), Non-Patent Citations (11), Referenced by (5), Classifications (6), Legal Events (4)|
|External Links: USPTO, USPTO Assignment, Espacenet|
Typically, tables include a collection of rows with cells. The cells of a table are formatted so that all cells in a row have a uniform height and all cells in a column have a uniform width. Currently, such tables need to be rigidly defined. There is no allowance for tables to contain objects that are not rows and that do not adhere to formatting associated with the cells of the table. However, it may be desirable to have both row objects and “non-row” objects with arbitrary formatting included in the same table. As such, specifying other types of objects within a table would be useful.
The specification of a table that includes one or more cells, each of which is associated with a row and a column, as well as one or more objects with arbitrary formatting is disclosed. In some embodiments, a common formatting is inferred and/or applied to the cells of the table but not to any objects with arbitrary formatting included in the table.
Various embodiments of the invention are disclosed in the following detailed description and the accompanying drawings.
The invention can be implemented in numerous ways, including as a process, an apparatus, a system, a composition of matter, a computer readable medium such as a computer readable storage medium or a computer network wherein program instructions are sent over optical or electronic communication links. In this specification, these implementations, or any other form that the invention may take, may be referred to as techniques. A component such as a processor or a memory described as being configured to perform a task includes both a general component that is temporarily configured to perform the task at a given time or a specific component that is manufactured to perform the task. In general, the order of the steps of disclosed processes may be altered within the scope of the invention.
A detailed description of one or more embodiments of the invention is provided below along with accompanying figures that illustrate the principles of the invention. The invention is described in connection with such embodiments, but the invention is not limited to any embodiment. The scope of the invention is limited only by the claims and the invention encompasses numerous alternatives, modifications and equivalents. Numerous specific details are set forth in the following description in order to provide a thorough understanding of the invention. These details are provided for the purpose of example and the invention may be practiced according to the claims without some or all of these specific details. For the purpose of clarity, technical material that is known in the technical fields related to the invention has not been described in detail so that the invention is not unnecessarily obscured.
Specification of tables containing objects is disclosed. In some embodiments, a table object contains one or more row objects as well as one or more objects with arbitrary (i.e. non-row) formatting. Common row and/or column formatting may be inferred and applied to objects associated with rows but not to objects associated with arbitrary formatting. In some embodiments, such a table may be implemented using XFA (XML Forms Architecture), an application of XML (Extensible Markup Language) developed by Adobe Systems Incorporated.
XFA provides the grammar to model and build electronic forms and the specific requirements for applications that use the forms. To an end user of a form, the form represents something to be filled out, for example, by entering data into fields, selecting radio buttons, checking boxes, etc. To a designer of a form, the form represents a means for capturing, rendering, and/or manipulating data. Consequently, the form designer is concerned with issues such as layout, interaction, and processing. The form designer creates a template that specifies the rules that will apply to all form instances created from that template.
The content of a form is enclosed within container objects. Containers determine the layout and formatting of the form content and may include draw, field, area, and subform objects. As used herein, the term “object” refers to an object, container, or other similar structure. A draw object is associated with the boilerplate of the form. A field object represents a data entry region. Draw and field objects are containers for static and dynamic content, respectively. As instances of forms are created from a common template, the static content is generally the same across all instances while the dynamic content is likely to change from instance to instance. An area object is a grouping of container objects that provides a form designer means for organizing a subset of objects on a form, so that they may be moved or manipulated as a whole. Similar to an area object, a subform object is a grouping of container objects. A form (or form template) is a collection of subforms, each of which represents a distinct section or subsection of the form. An area object is a static container of other containers while a subform object is a dynamic container of other containers.
The formatting strategy of child objects (or containers) contained within a parent subform container may be specified by a layout attribute associated with the parent subform container. Examples of values the layout attribute may take include “tb” (top-bottom), “lr-tb” (left-right top-bottom), “rl-tb” (right-left top-bottom), “position”, “table”, and “row”. The child objects of a parent subform container are flowed in a direction proceeding from top to bottom if the layout attribute associated with the parent subform container is “tb”. The child objects of a parent subform container are flowed in a direction proceeding from left to right and top to bottom if the layout attribute associated with the parent subform container is “lr-tb”. Likewise, the child objects of a parent subform container are flowed in a direction proceeding from right to left and top to bottom if the layout attribute associated with the parent subform container is “rl-tb”. If the layout attribute is “position”, a child object of a parent subform container may be positioned according to an offset vector (an (x,y) pair) associated with the child object that determines the location of the contained object with respect to its container. If the layout attribute of the parent subform container is “table”, child objects contained within the parent subform container that are inferred to be cells of the table may be automatically aligned or formatted into rows and columns. A table subform represents an entire table and contains everything in the table. The child objects of a table subform are typically, but not limited to be as described hereinafter, row subforms. Thus, a subform with layout attribute “row” specifies a child object of a table subform. The row subform represents one row of a table and contains everything in the row. If a row subform is not found nested inside a table subform, it may be treated as a one-row table.
A form may include one or more tables. In XFA, a table is hierarchically defined and may include one or more row subforms, each of which is a child subform of the parent table subform, as described above. Each row subform contains child objects (or containers) which correspond to the cells or columns of the table within the given row. In some embodiments, the cells are explicitly declared. In some embodiments, one or more geometric properties associated with the table are explicitly defined by the designer. In some embodiments, the actual structure and size of the table may be inferred from the set of rows and the set of objects nested within the rows and, thus, may be left underspecified by the form designer. Therefore, geometric properties of the table such as table size, number of rows, number of columns, row heights, column widths, etc., are not required to be pre-determined and explicitly defined by the form designer. Rather, such table properties can be inferred, for example, from the contents that populate the table. A designer hierarchically declares a table subform with one or more row subforms nested within the table subform and one or more objects (e.g., draw, field, area, subform with positioned or flowed layout, etc.) nested within each row subform. The objects nested within each row subform are automatically inferred as cells of the row without an explicit cell declaration by the designer. The dimensions of the inferred cells may be adaptive and dynamic based on the content that is used to populate the cells, e.g., content retrieved from one or more associated databases. In some embodiments, the dimensions of the cells are automatically formatted, so that the parent table has aligned rows and columns. Specifically, all cells in a row are formatted to have a uniform height, and all cells in a column are formatted to have a uniform width. In some embodiments, formatting other than row and/or column formatting is applied to the cells of the table, if applicable.
The number of rows within a table is inferred from the total number of child row subforms contained within the parent table subform. The objects (i.e. cells) nested within each row subform are used to infer other implied tabular information, and all cells are formatted accordingly. Specifically, the number of columns in the table is equal to the maximum number of cells in any row. The height of each row is equal to the maximum cell height in that row. If not pre-specified with the table subform declaration, the width of each column is equal to the width of the widest nth object in each row.
The designer may optionally supply a list of column widths with the table subform declaration using the columnWidths attribute. The columnWidths attribute is a space delimited list of measurements wherein the nth entry represents the width of the nth column. Column widths may be specified using a placeholder value such as “−1” (e.g., columnWidths=“1 in −1 −1 2 in”) that indicates that the width of the corresponding column is automatically formatted to the maximum cell width in that column. If no list of column widths is supplied, all columns widths default to “−1”. Similarly, the widths of any columns that are not present in the list (that is, beyond the length of the list) default to “−1”.
When defining a table, different rows may have different numbers of cells (i.e. columns). It is possible to make an individual cell of a row span more than one column using the colSpan attribute. The colSpan attribute specifies the number of columns spanned by an object (i.e. cell) contained within a row subform and has a default value of “1” (i.e. one column). For example, if colSpan is set to a positive integer, the cell spans that many columns. Alternatively, colSpan may be set to a predetermined value such as “−1” that indicates that the cell spans all the remaining columns of the table, and if additional cells follow after that cell, the subsequent cells are not displayed. If a column is unconstrained (i.e. a column width for that column is not specified using the columnWidths attribute of the table subform), the table is well-defined if one cell in the unconstrained column does not span multiple columns. However, if any given unconstrained column contains only cells that span multiple columns, the table is not well-defined and the resulting layout may depend on the implementation.
In a table, the rows are vertically laid out in the order in which they are declared from first to last, and the cells in each row are horizontally laid out in the order in which they are declared from first to last. Cell sizes are adjusted to align the table. For each row, cells are vertically expanded to the height of the tallest cell in the row, resulting in vertical alignment of the row. Cells in each column are horizontally expanded to a designated width if specified in the columnWidths attribute of the table subform. If a placeholder (e.g., “−1”) is specified in the columnWidths attribute and/or in the absence of a columnWidths attribute, the cells in each column are horizontally expanded to the width of the widest cell in the column. All cells in a column assume a uniform column width. A cell may assume multiple column widths as dictated by a colSpan attribute associated with the cell. If a row does not have as many cells as other rows, an empty region may exist to the right of that row.
Tables are typically defined as a collection of rows with cells (columns). In some embodiments, the table subform in XFA includes one or more non-row child subform(s) that is/are exempt from the formatting rules associated with the rows and columns of the parent table. Tables containing objects with arbitrary (i.e. non-row) formatting is disclosed herein.
In XFA, child objects (or containers) nested within a parent table object (or container) are not constrained to be of layout type “row”. In some embodiments, a table subform contains arbitrarily nested child subforms with non-row layout types, e.g., “tb”, “lr-tb”, “rl-tb, “position”. The non-row subforms are part of the overall table flow and may be declared anywhere within the table definition. As such, non-row subforms may be inserted before and/or after row subforms of the table. However, unlike the objects contained in row subforms, objects contained in non-row subforms are not inferred as cells of the parent table and, therefore, are not subjected to alignment in height and/or width. Rather, these objects are formatted independently from the cells of the table based on the value assigned to the layout attribute associated with the non-row subform in which they are contained. For example, the objects contained in a non-row subform may be positioned, flowed top-bottom, flowed left-right top-bottom, or flowed right-left top-bottom if the layout attribute of the non-row subform is “position”, “tb”, “lr-tb”, or “rl-tb”, respectively. The non-row subforms contained in a table subform may be arbitrarily sized and consequently may be shorter or longer than the rows in the table. The non-row subforms contained in the table allow for flexible, non-standard entries inside the table such as information sections, disclaimers, etc. Although they are immune from conforming to any row heights and/or column widths, the objects associated with non-row subforms are still considered part of the outer table object, e.g., for hit-testing, table bounds, z-ordering, tagging (accessibility), etc. In XFA, tables may also be nested. A table may be a direct child of another table subform, or a table can be nested within a row or non-row subform and/or a descendent of a row or non-row subform.
The objects contained in the non-row portions of table 100 (i.e. 104, 108, and 112) do not conform to the row and column alignment that the rest of the cells of table 100 are subjected to. Moreover, these objects are immune to subsequent formatting changes made to the cells of the table. For example, if the width of the third column of table 100 is increased, the widths of the cells in the third column of all rows of table 100 are accordingly increased while the objects associated with the non-row portions of the table remain unaffected.
<subform layout=“row” name=“row1”>
Lines 3, 4, and 5 define the second, third and fourth rows of table 100, respectively. Each of these rows contains three cells as depicted in
<(subform layout=“row” name=“row4”)>
Portion 104 of
<subform layout=“position” name=“information”>
The fifth and sixth rows of table 100, which correspond to portion 106 of
<subform layout=“tb” name=“detail”>
The seventh and eighth rows of table 100, which correspond to portion 110 of
<subform layout=“lr-tb” name=“data”>
The ninth row of table 100, which corresponds to portion 114 of
As described herein, hierarchical tables may be defined to contain both row and non-row objects. Table properties, such as number of rows, number of columns, row heights, column widths, etc., may be inferred from the row objects and the set of objects nested within the rows. Only the objects associated with rows (i.e., the cells) are subjected to common row and/or column formatting so that all cells in a row have a uniform height and all cells in a column have a uniform width. The objects associated with non-row objects remain immune to such formatting. Non-row objects are still part of the table object and flow amongst the rows of the table.
Although the foregoing embodiments have been described in some detail for purposes of clarity of understanding, the invention is not limited to the details provided. There are many alternative ways of implementing the invention. The disclosed embodiments are illustrative and not restrictive.
|Cited Patent||Filing date||Publication date||Applicant||Title|
|US5280575 *||Feb 19, 1992||Jan 18, 1994||Digital Equipment Corporation||Apparatus for cell format control in a spread sheet|
|US5367619 *||Jan 10, 1994||Nov 22, 1994||Eaton Corporation||Electronic data entry system employing an expert system to facilitate generation of electronic data forms with complex interrelationships between fields and subforms|
|US5613131 *||Jan 29, 1993||Mar 18, 1997||Microsoft Corporation||Auto-formatting of tables in a spreadsheet program|
|US6611840 *||Jan 21, 2000||Aug 26, 2003||International Business Machines Corporation||Method and system for removing content entity object in a hierarchically structured content object stored in a database|
|US6613099 *||Aug 20, 1999||Sep 2, 2003||Apple Computer, Inc.||Process and system for providing a table view of a form layout for a database|
|US6922807 *||Jan 28, 2000||Jul 26, 2005||Canon Kabushiki Kaisha||Object editing apparatus and method, and recording medium storing computer-readable program|
|US6968504 *||Jun 29, 2001||Nov 22, 2005||Microsoft Corporation||Automated document formatting tool|
|US6976212 *||Sep 10, 2001||Dec 13, 2005||Xerox Corporation||Method and apparatus for the construction and use of table-like visualizations of hierarchic material|
|US7117433 *||Sep 29, 1998||Oct 3, 2006||International Business Machines Corporation||HTML mapping substitution graphical user interface for display of elements mapped to HTML files|
|US7117435 *||Jun 21, 2000||Oct 3, 2006||Microsoft Corporation||Spreadsheet fields in text|
|US7120866 *||Oct 8, 2004||Oct 10, 2006||Microsoft Corporation||Spreadsheet fields in text|
|US7143339 *||Sep 20, 2001||Nov 28, 2006||Sap Aktiengesellschaft||Method and apparatus for dynamically formatting and displaying tabular data in real time|
|US7155667 *||Jun 21, 2000||Dec 26, 2006||Microsoft Corporation||User interface for integrated spreadsheets and word processing tables|
|US7328400 *||Dec 1, 2003||Feb 5, 2008||International Business Machines Corporation||Table column spanning|
|US7350141 *||Sep 16, 2004||Mar 25, 2008||Microsoft Corporation||User interface for integrated spreadsheets and word processing tables|
|US7430711 *||Feb 17, 2004||Sep 30, 2008||Microsoft Corporation||Systems and methods for editing XML documents|
|US7581169 *||Jan 14, 2005||Aug 25, 2009||Nicholas James Thomson||Method and apparatus for form automatic layout|
|US7617219 *||Jun 22, 2006||Nov 10, 2009||International Business Machines Corporation||Enhanced handling of repeated information in a web form|
|US7870478 *||Oct 31, 2005||Jan 11, 2011||Adobe Systems Incorporated||Repurposing subsections and/or objects|
|US20030071848 *||Oct 12, 1999||Apr 17, 2003||Michael Carroll||System and method for presenting tables in selectable portions|
|US20030084046 *||Oct 25, 2001||May 1, 2003||Abm Systems Ltd.||Versatile database interface system|
|US20050066265 *||Oct 8, 2004||Mar 24, 2005||Microsoft Corporation||Spreadsheet fields in text|
|US20060136808 *||Dec 20, 2004||Jun 22, 2006||Microsoft Corporation||Block properties and calculated columns in a spreadsheet application|
|US20060136810 *||Feb 9, 2005||Jun 22, 2006||Sap Aktiengesellschaft||Electronic form generator|
|US20060200779 *||Apr 9, 2004||Sep 7, 2006||Taylor Steve D||Cell based end user interface having action cells|
|US20060218483 *||Mar 25, 2005||Sep 28, 2006||Weitzman Louis M||System, method and program product for tabular data with dynamic visual cells|
|1||*||Change the column width and row height; Microsoft Office Excel 2003 (help); http://office.microsoft.com/en-us/excel/HP051988131033.aspx.|
|2||*||Introducing Microsoft® Office InfoPath(TM) 2003; By: Roger Jennings; Publisher: Microsoft Press; Pub. Date: Jun. 9, 2004; Print ISBN-13: 978-0-7356-1952-4; Relevant passages sent to applicant.|
|3||*||Introducing Microsoft® Office InfoPath™ 2003; By: Roger Jennings; Publisher: Microsoft Press; Pub. Date: Jun. 9, 2004; Print ISBN-13: 978-0-7356-1952-4; Relevant passages sent to applicant.|
|4||*||Microsoft Word 2003; Form Template included with program; MS Form-Job Description-Exhibit A.pdf.|
|5||*||Microsoft Word 2003; Form Template included with program; MS Form—Job Description—Exhibit A.pdf.|
|6||*||Microsoft® Office Access 2003 Inside Track; By: John Pierce; Paul Pardi; Publisher: Microsoft Press; Pub. Date: Jan. 7, 2004; Print ISBN-13: 978-0-7356-1976-0.|
|7||*||MS Access 2003-Project Plan and Performance Review.pdf-Exhibit B.|
|8||*||MS Access 2003—Project Plan and Performance Review.pdf—Exhibit B.|
|9||*||Special Edition Using Microsoft® Office Access 2003; By: Roger Fennings; Publisher: Que; Pub. Date: Sep. 11, 2003; Print ISBN-10: 0-7897-2952-0.|
|10||*||XFA-Template Version 1.0-Gavin F. McKenzie; http://www.w3.org/1999/05/XFA/xfa-template.html; W3C-xfa-template.pdf.|
|11||*||XFA-Template Version 1.0—Gavin F. McKenzie; http://www.w3.org/1999/05/XFA/xfa-template.html; W3C—xfa-template.pdf.|
|Citing Patent||Filing date||Publication date||Applicant||Title|
|US8140962 *||Apr 10, 2008||Mar 20, 2012||International Business Machines Corporation||Dynamically selecting properties to display in a table based user interface|
|US8291313 *||Aug 26, 2009||Oct 16, 2012||Adobe Systems Incorporated||Generation of a container hierarchy from a document design|
|US9106660||Mar 10, 2014||Aug 11, 2015||Dillon Software Services, Llc||Data store interface that facilitates distribution of application functionality across a multi-tier client-server architecture|
|US20090259930 *||Apr 10, 2008||Oct 15, 2009||International Business Machines Corporation||Dynamically Selecting Properties to Display in a Table Based User Interface|
|US20110179090 *||Jul 21, 2011||Siemens Product Lifecycle Management Software Inc.||Product Lifecycle Management Using a Sparsely Populated Table|
|U.S. Classification||715/222, 715/221, 715/234|
|May 31, 2005||AS||Assignment|
Owner name: ADOBE SYSTEMS INCORPORATED, CALIFORNIA
Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:CASTRUCCI, ADAM;MCKENZIE, GAVIN F.;REEL/FRAME:016652/0014
Effective date: 20050531
|Dec 5, 2014||REMI||Maintenance fee reminder mailed|
|Apr 26, 2015||LAPS||Lapse for failure to pay maintenance fees|
|Jun 16, 2015||FP||Expired due to failure to pay maintenance fee|
Effective date: 20150426