Date picker in excel

Patent metadata

Field	Value
Publication number	US-2017192944-A1
Application number	US-201715465206-A
Country	US
Kind code	A1
Filing date	Mar 21, 2017
Priority date	Sep 20, 2013
Publication date	Jul 6, 2017
Grant date	—

Abstract

In various embodiments, methods, systems, and non-transitory computer-readable media are disclosed that allow developers to place date pickers on columns, rows, and cells using a desktop integration framework. The date picker can be tied to components, forms, or model metadata. In one aspect, date picker metadata is provided separately from the document to which one or more date pickers will eventually be added.

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 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 date picker with the user interface element, wherein the client component provides an expression builder that includes a date picker property for the user interface element such that when the user interface is associated with the content, the date picker is automatically associated with the user interface element; and code for defining date attributes for the date picker 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 date attributes.

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 date attributes 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 date attributes at runtime.

4 . 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.

5 . 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 date picker with the user interface element.

6 . The non-transitory computer-readable medium of claim 5 , 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.

7 . The non-transitory computer-readable medium of claim 6 , 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.

8 . The non-transitory computer-readable medium of claim 7 , 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 date attributes.

9 . The non-transitory computer-readable medium of claim 8 , wherein the code for rendering the document comprises code for generating functionality that displays an interface in response to a user interaction that includes the date picker.

10 . 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 date picker with the user interface element, wherein the client component provides an expression builder that includes a date picker properly for the user interface element such that when the user interface is associated with the content, the date picker is automatically associated with the user interface element; and defining, by the computer system, date attributes for the date picker 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 date attributes.

11 . The method of claim 10 , 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 date picker with the user interface element.

12 . The method of claim 11 , 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.

13 . The method of claim 12 , 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.

14 . The method of claim 13 , 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 date attributes.

15 . The method of claim 14 , wherein the rendering the document comprises generating functionality that displays an interface in response to a user interaction that includes the date picker.

16 . 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 component of the application development framework and at least a portion of the content is linked with data associated with data models of as web-based application that are accessible by a server component of the application deve

Assignees

• Oracle Int Corp

Inventors

• Davis Edmund Alexander
• Jin Yuandi

Classifications

• 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

• G06F40/103

  Formatting, i.e. changing of presentation of documents (automatic justification G06F40/189; automatic line break hyphenation G06F40/191) · CPC title

• G06F40/18 Primary

  of spreadsheets (form-filling G06F40/174) · CPC title

• G06F16/90324

  using system suggestions · CPC title