Dynamic column groups in excel

• US 10,127,206 B2
• Filed: 09/22/2015
• Issued: 11/13/2018
• Est. Priority Date: 07/16/2014
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Davis, Edmund Alexander, Logan, Shaun Thomas
• Primary Examiner(s): Augustine, Nicholas
• Application Number:
  US14/861,792
• Publication Number:
  US 20160085735A1
• Time in Patent Office: 1,148 Days
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/986 Document structures and storage, e.g. HTML extensions
• CPC Class Codes: G06F 40/103 Formatting, i.e. changing of presentation of documents automatic justification G06F40/189; automatic line break hyphenation G06F40/191
• CPC Class Codes: G06F 40/12 Use of codes for handling textual entities
• CPC Class Codes: G06F 40/134 Hyperlinking
• CPC Class Codes: G06F 40/146 Coding or compression of tree-structured data
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06F 8/38 for implementing user interfaces

Abstract

In various embodiments, methods, systems, and non-transitory computer-readable media are disclosed that allow developers to dynamically create columns headers using a desktop integration framework. Columns groups can be managed dynamically at runtime based on model-level metadata.

Claims

1. A method comprising:

receiving, at a computer system, a document and corresponding metadata from an application server;

opening, by the computer system, the document in a native application, wherein the document acts as a user interface for a web-based application that is in communication with the application server;

determining, by the computer system, a user interface component to be rendered in the document based on the metadata, wherein the metadata includes information utilized by a client side component of the native application to render the user interface component using at least data from a data model of the web-based application;

configuring, by the computer system, the document with columns for the user interface component based on the metadata and the data from the data model;

determining, by the computer system, at least one of the columns has a value for starting a column group based on the data from the data model;

rendering, by the computer system, an extra table header row for the user interface component based on the determination that at least one of the columns has the value for starting the column group;

evaluating, by the computer system, each of the columns based on the data from the data model in order to determine whether each column;

includes the value for starting the column group, includes a value for ending the column group, or is positioned between the column that includes the value for starting the column group and the column that includes the value for ending the column group; and

rendering, by the computer system, the column group within the document for the user interface component based on the evaluation,

wherein the column group is rendered by organizing;

(i) the column evaluated to include the value for starting the column group, (ii) the column evaluated to include the value for ending the column group, and (iii) the columns evaluated to be positioned between the column that includes the value for starting the column group and the column that includes the value for ending the column group, into the column group, obtaining a group header label, and inserting the group header label into an extra table header cell of the extra table header row for the column group.

2. The method of claim 1, wherein the evaluating is performed on an expression defined on a property of the user interface component.

3. The method of claim 1, wherein the evaluating is performed on an expression defined on a property of another user interface component.

4. The method of claim 1, wherein the rendering the column group comprises determining the group header label for the column group using a property defined on the user interface component.

5. The method of claim 1, wherein the rendering the column group comprises determining a visual style for the column group using a property defined on the user interface component.

6. A non-transitory computer-readable medium storing a computer program that when executed by a processor of a computer cause the processor to perform steps comprising:

receiving a document and corresponding metadata from an application server;

opening the document in a native application, wherein the document acts as a user interface for a web-based application that is in communication with the application server;

determining a user interface component to be rendered in the document based on the metadata, wherein the metadata includes information utilized by a client side component of the native application to render the user interface component using at least data from a data model of the web-based application;

configuring the document with a column for the user interface component based on the metadata and the data from the data model;

determining at least one of the columns has a value for starting a column group based on the data from the data model;

rendering an extra table header row for the user interface component based on the determination that at least one of the columns has the value for starting the column group;

evaluating each of the columns based on the data from the data model in order to determine whether each column;

includes the value for starting the column group, includes a value for ending the column group, or is positioned between the column that includes the value for starting the column group and the column that includes the value for ending the column group; and

rendering the column group within the document for the user interface component based on the evaluation,

wherein the column group is rendered by organizing;

(i) the column evaluated to include the value for starting the column group, (ii) the column evaluated to include the value for ending the column group, and (iii) the columns evaluated to be positioned between the column that includes the value for starting the column group and the column that includes the value for ending the column group, into the column group, obtaining a group header label, and inserting the group header label into an extra table header cell of the extra table header row for the column group.

7. The non-transitory computer-readable medium of claim 6, wherein the evaluating is performed on an expression defined on a property of the user interface component.

8. The non-transitory computer-readable medium of claim 6, the evaluating is performed on an expression defined on a property of another user interface component.

9. The non-transitory computer-readable medium of claim 6, wherein the rendering the column group comprises determining the group header label for the column group using a property defined on the user interface component.

10. The non-transitory computer-readable medium of claim 6, wherein the rendering the column group comprises determining a visual style for the column group using a property defined on the user interface component.

11. A system comprising:

a processor; and

a memory storing a set of instructions that when executed by the processor cause the processor to perform steps comprising;

receiving a document and corresponding metadata from an application server;

opening the document in a native application, wherein the document acts as a user interface for a web-based application that is in communication with the application server;

determining a user interface component to be rendered in the document based on the metadata, wherein the metadata includes information utilized by a client side component of the native application to render the user interface component using at least data from a data model of the web-based application;

configuring the document with a column for the user interface component based on the metadata and the data from the data model;

determining at least one of the columns has a value for starting a column group based on the data from the data model;

rendering an extra table header row for the user interface component based on the determination that at least one of the columns has the value for starting the column group;

evaluating each of the columns based on the data from the data model in order to determine whether each column;

includes the value for starting the column group, includes a value for ending the column group, or is positioned between the column that includes the value for starting the column group and the column that includes the value for ending the column group; and

rendering the column group within the document for the user interface component based on the evaluation,

wherein the column group is rendered by organizing;

(i) the column evaluated to include the value for starting the column group, (ii) the column evaluated to include the value for ending the column group, and (iii) the columns evaluated to be positioned between the column that includes the value for starting the column group and the column that includes the value for ending the column group, into the column group, obtaining a group header label, and inserting the group header label into an extra table header cell of the extra table header row for the column group.

12. The system of claim 11, wherein the evaluating is performed on an expression defined on a property of the user interface component.

13. The system of claim 11, wherein the evaluating is performed on an expression defined on a property of another user interface component.

14. The system of claim 11, wherein the rendering the column group comprises determining the group header label for the column group using a property defined on the user interface component.

15. The system of claim 11, wherein the rendering the column group comprises determining a visual style for the column group using a property defined on the user interface component.