Different gestures and actions are used to interact with spreadsheets. The gestures are used in manipulating the spreadsheet and performing other actions in the spreadsheet. For example, gestures may be used to move within the spreadsheet, select data, filter, sort, drill down/up, zoom, split rows/columns, perform undo/redo actions, and the like. Sensors that are associated with a device may also be used in interacting with spreadsheets. For example, an accelerometer may be used for moving and performing operations within the spreadsheet.

Natural input for spreadsheet actions

Gadgets integrate with spreadsheets and the spreadsheet calculation engine. A gadget is bound to a range of cells (one or more) within a sheet. When one or more of the cells of the bound range is accessed (e.g. selected, hovered over, edited, deleted, added), the gadget is notified. The gadget may use this information for updating a display rendered by the gadget and/or performing some other action. The gadget uses an Application Programming Interface (API) to create the binding, communicate with the spreadsheet, and perform actions in the spreadsheet. The gadget is a Named Item object within the spreadsheet such that the gadget may be viewed/displayed differently from other objects. Out of date requests from the gadget are attempted to be detected and prevented from being processed such that the gadget is not acting on the latest data.

Interaction between web gadgets and spreadsheets

The invention relates to a method and tool which allows users to create interactive representations of input and output data, and simulate the associated algorithms used to manipulate this data, that are used in spreadsheet applications and other similar software programs. The interactive simulation is visually represented by a customizable set of components which hereinafter will be referred to as a control pane. The control panels can consist of a variety of components which include user interface elements (such as sliders, buttons, and checkboxes), charts and maps. The underlying simulation is generated based on data sources within an application software program file (e.g., spreadsheet data cells) selected by the user during the control panel creation process.

Method and System for Creating Graphical and Interactive Representations of Input and Output Data

A computer system provides access to both an online transaction processing (OLTP) database server and an online analytics processing (OLAP) database server. The computer system includes a client application adapted to receive a query. According to (a) mode of operation (e.g., read or update) of the client application and (b) synchronization status of the OLAP database server, the client application redirects the query to the OLTP database server or to the OLAP database server. The client application redirects the query to the OLTP database server when the mode of operation is other than a read-only operation or the synchronization status is "unsynchronized". The client application redirects the query to the OLAP database server when the mode of operation is a read-only operation and the synchronization status is "synchronized". The computer system further includes an OLTP application server (e.g., Enovia V6) comprising an OLTP adapter and an OLAP adapter. The OLAP adapter is formed of a mapping component adapted to map data between OLTP semantics and OLAP semantics.

Computer method and system for combining OLTP database and OLAP database environments

A system for use in rendering a report for a client application, client server application or multi-tier applications. The system includes a report definition generator that is configured to generate a report definition using metadata located in a metadata store. A database in the application configured to receive a query and to provide a data set. A design engine is configured to render the report based on the report definition, parameters and the data set.

Report generation using metadata

A computer-readable medium includes executable instructions to analyze a repository of individual reports to generate a consolidated data set, where the consolidated data set includes data from different individual reports. The consolidated data set is augmented with metadata. The consolidated data set and metadata are inserted within an electronic document.

Apparatus and method for creating from discrete reports new reports with metadata

A computer-readable medium includes executable instructions to analyze a repository of individual reports to generate a first data set from a set of individual reports and a second data set from a set of individual reports. The first data set and the second data set are processed using comparative logic to produce a third data set.

Apparatus and method for creating from discrete reports new reports with differentiated data

The invention includes a computer readable memory with a consolidated data mart generator to generate a consolidated data mart based upon an analysis of a repository of individual reports. A report generation tool produces a report via access to the consolidated data mart.

Apparatus and method for creating new reports from a consolidated data mart

A computer readable storage medium includes computer executable instructions to provide a semantic domain with a plurality of semantic definitions associated with one or more subject areas to a community of users. A data input is received from a user within the community of users. A portion of the data in the data input is linked with a semantic definition from the plurality of semantic definitions to create a mapping. The data input and the mapping are evaluated. The data input is published to the community of users.

Apparatus and method for a collaborative semantic domain and data set based on combining data

Method for creating from individual reports a consolidated data set with metadata including information about the last presentation format of data within the individual reports

Ju Wu

Papers

Apparatus and method for creating from discrete reports new reports with metadata

Apparatus and method for creating from discrete reports new reports with differentiated data

Apparatus and method for creating new reports from a consolidated data mart

Apparatus and method for a collaborative semantic domain and data set based on combining data

Method for creating from individual reports a consolidated data set with metadata including information about the last presentation format of data within the individual reports