Model-driven tooltips in excel

Patent metadata

Field	Value
Publication number	US-9524287-B2
Application number	US-201414333238-A
Country	US
Kind code	B2
Filing date	Jul 16, 2014
Priority date	Sep 20, 2013
Publication date	Dec 20, 2016
Grant date	Dec 20, 2016

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.

First claim

What is claimed is:

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 creating contents of a document in a native application format associated with an application that includes or is in communication with a view layer and a controller layer developed via an application development framework;
code for associating a user interface element with a portion of the contents of the document using the view layer and the controller layer, wherein the user interface element and the portion of the contents are components of the application development framework and the portion of the contents of the document is linked with data associated with data models of a web-based application in communication with a model layer developed via the application development framework;
code for mapping the user interface element to one or more of the data models of the web-based application using the view layer and the controller layer, wherein the model layer exposes the data models to the view layer and controller layer such that the user interface element contributes at least a portion of the data associated with the one or more data models of the web-based application to a user interface within the application at runtime to provide tooltip information;
code for generating metadata associated with the document based on the associating of the user interface element with the portion of the contents of the document and the mapping of the user interface element to the one or more data models of the web-based application;
code for initializing the document in the application with the user interface and the user interface element using the view layer, the controller layer, the model layer, and the metadata at runtime; and
code for sending and receiving updates to the data associated with the data models through the model layer using the view layer and the controller layer at runtime.

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 of the web-based application comprises code for configuring the user interface element to provide the tooltip information based on a type of the data associated with the 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 of the web-based application 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 of the web-based application 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 of the web-based application 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 the portion of the contents 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 wherein the code for creating the contents of the document in the native application format associated with the application comprises code for creating a spreadsheet using a spreadsheet desktop application.

8. The non-transitory computer-readable medium of claim 1 wherein the code for creating the contents of the document in the native application format associated with the application comprises code for creating a word processing document using a desktop publishing application.

9. The non-transitory computer-readable medium of claim 1 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 1 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:
creating, by a computer system, contents of a document in a native application format associated with application that includes or is in communication with a view layer and a controller layer developed via an application development framework;
associating, by a computer system, a user interface element with a portion of the contents of the document using the view layer and the controller layer, wherein the user interface element and the portion of the contents are components of the application development framework and the portion of the contents of the document is linked with data associated with data models of a web-based application in communication with a model layer developed via the application development framework;
mapping, by a computer system, the user interface element to one or more of the data models of the web-based application using the view layer and the controller layer, wherein the model layer exposes the data models to the view layer and controller layer such that the user interface element contributes at least a portion of the data associated with the one or more data models of the web-based application to a user interface within the application at runtime to provide tooltip information;
generating, by a computer system, metadata associated with the document based on the associating of the user interface element with the portion of the contents of the document and the mapping of the user interface element to the one or more data models of the web-based application;
code for initializing the document in the application with the user interface and the user interface element using the view layer, the controller layer, the model layer, and the metadata at runtime; and
code for sending and receiving updates to the data associated with the data models through the model layer using the view layer and the controller layer at runtime.

13. A system comprising:
a processor; and
a memory storing a set of instructions which when execute by the processor configure the processor to:
create contents of a document in a native application format associated with an application that includes or is in communication with a view layer and a controller layer developed via an application development framework;
associate a user interface element with a portion of the contents of the document using the view layer and the controller layer, wherein the user interface element and the portion of the contents are components of the application development framework and the portion of the contents of the docume

Assignees

• Oracle Int Corp

Inventors

• Davis Edmund Alexander
• Bafuka Freddy Nole

Classifications

• G06F16/90324

  using system suggestions · CPC title

• G06F3/04817

  using icons (graphical or visual programming using iconic symbols G06F8/34) · CPC title

• G06F16/86

  Mapping to a database · CPC title

• G06F16/245

  Query processing · CPC title

• G06F3/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 title