MODEL-DRIVEN TOOLTIPS IN EXCEL

• US 20170083503A1
• Filed: 12/02/2016
• Published: 03/23/2017
• 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
• Granted Patent: US 10,073,825 B2
• Time in Patent Office: 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 documents of desktop applications that act as user interfaces for web-based applications, the non-transitory computer-readable medium comprising:

code for associating a user interface element with content of a document in a native application format associated with an application that includes or is in communication with a client component of an application development framework, wherein the user interface element is a component of the application development framework and at least a portion of the content is linked with data associated with data models of a web-based application that are accessible by a server component of the application development framework;

code for mapping the user interface element to one or more of the data models of the web-based application;

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 such that when the user interface is associated with the content, a tooltip is automatically associated with the user interface element; and

code for defining tooltip information for the tooltip based on the mapping of the user interface element to the one or more of the data models of the web-based application, wherein the server component exposes the data models to the client component such that the user interface element contributes at least a portion of the data associated with the one or more data models to a user interface within the application at runtime to provide the tooltip information.

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 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 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 a 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 a document in a native application format associated with an application that includes or is in communication with a client component of an application development framework, wherein the user interface element is a component of the application development framework and at least a portion of the content is linked with data associated with data models of a web-based application that are accessible by a server component of the application development framework;

mapping, by the computer system, the user interface element to one or more of the data models of the web-based application;

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 such that when the user interface 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 based on the mapping of the user interface element to the one or more of the data models of the web-based application, wherein the server component exposes the data models to the client component such that the user interface element contributes at least a portion of the data associated with the one or more data models to a user interface within the application at runtime to provide the tooltip information.

13. The method of claim 12, further comprising generating, by the computer system, 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 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 a 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 a document in a native application format associated with an application that includes or is in communication with a client component of an application development framework, wherein the user interface element is a component of the application development framework and at least a portion of the content is linked with data associated with data models of a web-based application that are accessible by a server component of the application development framework;

map the user interface element to one or more of the data models of the web-based application;

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 such that when the user interface is associated with the content, a tooltip is automatically associated with the user interface element; and

define tooltip information for the tooltip based on the mapping of the user interface element to the one or more of the data models of the web-based application, wherein the server component exposes the data models to the client component such that the user interface element contributes at least a portion of the data associated with the one or more data models to a user interface within the application at runtime to provide the tooltip information.