Model-driven tooltips in excel

• US 10,073,825 B2
• Filed: 12/02/2016
• Issued: 09/11/2018
• Est. Priority Date: 09/20/2013
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Davis, Edmund Alexander, Bafuka, Freddy Nole
• Primary Examiner(s): TAPP, AMELIA L
• Application Number:
  US15/368,421
• Publication Number:
  US 20170083503A1
• Time in Patent Office: 648 Days
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 16/86 Mapping to a database
• CPC Class Codes: G06F 16/90324 using system suggestions
• CPC Class Codes: G06F 3/04817 using icons graphical or visual programming using iconic symbols G06F8/34
• CPC Class Codes: G06F 3/0484 for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
• 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/18 of spreadsheets form-filling G06F40/174

Abstract

In various embodiments, methods, systems, and non-transitory computer-readable media are disclosed that allow developers to place tooltips on components and columns headers using a desktop integration framework. The tooltips can be tied to translatable resources or model metadata. In one aspect, the tool tip metadata is provided separately from the document to which the tool tip will eventually be tied.

Claims

1. A non-transitory computer-readable medium storing code that when executed by one or more processors associated with one or more computer systems configures the one or more processors for creating a document of a desktop application that acts as a user interface for a web based application, the non-transitory computer-readable medium comprising:

code for associating a user interface element with content of the document in a native application format associated with the desktop application, wherein the desktop application includes or is in communication with a client component of an application development framework, wherein the associating the user interface element with the content includes recording an association between the user interface element and the content in metadata associated with the document which allows the client component to determine that the user interface element is to be added to the document during rendering of the document, and wherein the document acts as the user interface for the web-based application and the user interface element is a part of the user interface for the web-based application;

code for mapping the user interface element to one or more data models of the web-based application, wherein the data models are accessible by a server component of the application development framework, wherein the server component is in communication with the client component, and wherein the server component exposes the one or more data models to the client component which allows the user interface element to contribute data associated with the one or more data models to the document based on the mapping;

code for associating a tooltip with the user interface element, wherein the client component provides an expression builder that includes a tooltip property for the user interface element and when the user interface element is associated with the content, a tooltip is automatically associated with the user interface element; and

code for defining tooltip information for the tooltip property based on an attribute of the one or more data models, wherein the tooltip property is recorded in the metadata associated with the document which allows the client component to determine the tooltip information is to be added to the user interface element, and wherein the server component exposes the one or more data models to the client component which allows the client component to cause the attribute of the one or more data models to be rendered as the tooltip information for the user interface element during the rendering of the document.

2. The non-transitory computer-readable medium of claim 1, wherein the code for mapping the user interface element to the one or more data models comprises code for configuring the user interface element to provide the tooltip information based on a type of the data associated with the one or more data models determined at runtime.

3. The non-transitory computer-readable medium of claim 1, wherein the code for mapping the user interface element to the one or more data models comprises code for configuring the user interface element with specific functionality allowing a user to interact with the tooltip information at runtime.

4. The non-transitory computer-readable medium of claim 1, wherein the code for mapping the user interface element to the one or more data models comprises code for configuring the user interface element to provide hints derived from an entity modeled by the one or more data models at runtime.

5. The non-transitory computer-readable medium of claim 1, wherein the code for mapping the user interface element to the one or more data models comprises code for configuring the user interface element to provide a help interface enabling a user to review the tooltip information.

6. The non-transitory computer-readable medium of claim 1, wherein the content of the document comprises a text box, label, button, list, table, radio button, checkbox, input widget, or output widget.

7. The non-transitory computer-readable medium of claim 1, further comprising code for generating the metadata associated with the document based on the associating of the user interface element with the content of the document, the mapping of the user interface element to the one or more data models, and the associating the tooltip with the user interface element.

8. The non-transitory computer-readable medium of claim 7, further comprising code for initializing the document in the desktop application with the user interface and the user interface element using the client component, the server component, and the metadata at runtime.

9. The non-transitory computer-readable medium of claim 8, further comprising code for publishing the document and the metadata associated with the document to the web-based application such that the document becomes usable as the user interface to the web-based application.

10. The non-transitory computer-readable medium of claim 9, further comprising:

code for retrieving the document from the web-based application; and

code for rendering the document based on the document and the metadata associated with the document at runtime to determine the tooltip information.

11. The non-transitory computer-readable medium of claim 10, wherein the code for rendering the document comprises code for generating functionality that displays an interface in response to a user interaction that expands the tooltip information from a first view to a second view.

12. A method comprising:

associating, by a computer system, a user interface element with content of the document in a native application format associated with the desktop application, wherein the desktop application includes or is in communication with a client component of an application development framework, wherein the associating the user interface element with the content includes recording an association between the user interface element and the content in metadata of the document which allows the client component to determine that the user interface element is to be added to the document during rendering of the document, and wherein the document acts as the user interface for the web-based application and the user interface element is a part of the user interface for the web-based application;

mapping, by the computer system, the user interface element to one or more data models of the web-based application, wherein the data models are accessible by a server component of the application development framework, wherein the server component is in communication with the client component, and wherein the server component exposes the one or more data models to the client component which allows the user interface element to contribute data associated with the one or more data models to the document based on the mapping;

associating, by the computer system, a tooltip with the user interface element, wherein the client component provides an expression builder that includes a tooltip property for the user interface element and when the user interface element is associated with the content, a tooltip is automatically associated with the user interface element; and

defining, by the computer system, tooltip information for the tooltip property based on an attribute of the one or more data models, wherein the tooltip property is recorded in the metadata of the document which allows the client component to determine the tooltip information is to be added to the user interface element, and wherein the server component exposes the one or more data models to the client component which allows the client component to cause the attribute of the one or more data models to be rendered as the tooltip information for the user interface element during the rendering of the document.

13. The method of claim 12, further comprising generating, by the computer system, the metadata associated with the document based on the associating of the user interface element with the content of the document, the mapping of the user interface element to the one or more data models, and the associating the tooltip with the user interface element.

14. The method of claim 13, further comprising initializing, by the computer system, the document in the desktop application with the user interface and the user interface element using the client component, the server component, and the metadata at runtime.

15. The method of claim 14, further comprising publishing, by the computer system, the document and the metadata associated with the document to the web-based application such that the document becomes usable as the user interface to the web-based application.

16. The method of claim 15, further comprising:

retrieving, by the computer system, the document from the web-based application; and

rendering, by the computer system, the document based on the document and the metadata associated with the document at runtime to determine the tooltip information.

17. The method of claim 16, wherein the rendering the document comprises generating functionality that displays an interface in response to a user interaction that expands the tooltip information from a first view to a second view.

18. A system comprising:

a processor; and

a memory storing a set of instructions which when execute by the processor configure the processor to;

associate a user interface element with content of the document in a native application format associated with the desktop application, wherein the desktop application includes or is in communication with a client component of an application development framework, wherein the associating the user interface element with the content includes recording an association between the user interface element and the content in metadata of the document which allows the client component to determine that the user interface element is to be added to the document during rendering of the document, and wherein the document acts as the user interface for the web-based application and the user interface element is a part of the user interface for the web-based application;

map the user interface element to one or more data models of the web-based application, wherein the data models are accessible by a server component of the application development framework, wherein the server component is in communication with the client component, and wherein the server component exposes the one or more data models to the client component which allows the user interface element to contribute data associated with the one or more data models to the document based on the mapping;

associate a tooltip with the user interface element, wherein the client component provides an expression builder that includes a tooltip property for the user interface element and when the user interface element is associated with the content, a tooltip is automatically associated with the user interface element; and

define tooltip information for the tooltip property based on an attribute of the one or more data models, wherein the tooltip property is recorded in the metadata of the document which allows the client component to determine the tooltip information is to be added to the user interface element, and wherein the server component exposes the one or more data models to the client component which allows the client component to cause the attribute of the one or more data models to be rendered as the tooltip information for the user interface element during the rendering of the document.