Abstract: Methods, systems and computer program products are provided for visually indicating relationships among cells in a spreadsheet. Each of a first graphical linking element extending between cells in a first branch of a dependency tree of a root cell and a second graphical linking element extending between cells in a second branch of the dependency tree of the root cell is independently displayed and hidden.

Abstract: Dashboard files such as dashboard structure files and spreadsheet files are converted into text-based, language-independent data interchange format files (such as JSON files) to allow dashboards to be rendered using varying web technologies such as HTML5 and JavaScript. Related apparatus, systems, techniques and articles are also described.

Abstract: A spreadsheet file and a dashboard structure file characterizing a dashboard are received. These files are then analyzed to determine dependencies. Subsequently, for each determined dependency, an event listener is registered for a dependent component that corresponds to the determined dependency. These event listeners are notified of an event from an event source when a corresponding dependee is changed. Dependent components are then updated using data from a corresponding dependee in response to event notifications so that each updated dependent component can be rendered within the dashboard. Related apparatus, systems, techniques and articles are also described.

Abstract: A document management system includes a list management application that manages one or more lists stored by the document management system. The list management application exposes list management functionality to users that access the lists in the document management system. The lists are stored as list management application files.

Abstract: Methods and systems are provided for procuring functions, including Web service functions, for use in a spreadsheet application. A Web service function manifest can be managed by a function marketplace. A client device running a spreadsheet application can request available functions from the function marketplace. Information about available functions can be received by the client device. A selection of a function can be made in order to receive the manifest associated with the selected function. A local copy of the manifest may be stored for repeated invocation.

Abstract: Spreadsheet functions are provided that enable interactivity with web services and manipulation of data retrieved from a web service call. One function takes a URL as an argument and performs an HTTP GET request asynchronously to return the response into the spreadsheet application. Another function URL encodes its argument. The URL encoded argument can then be used as part of the URL of the web service call. Yet another function is a filtering function that takes XML, JSON, HTML, and other forms of data that may be returned via a web service call to obtain specific data such as via an XPath standard when XML is used. These functions may be used together or separately.

Abstract: A spreadsheet application or other application supporting formulaic cells that automatically provides support for a number of diverse formulaic functions. The automatically provided diverse formulaic functions include a function returning the value of the formula logic if the logic can be evaluated without an error. Another function finds a value in a formulaic cell that is in the same row as a particular value from the first column and the same column as a particular value in the first row. Other functions allow a selection of a set of multiple lookup rows and columns for matching the values used as variables in the function. The spreadsheet application is further configured to automatically supply other functions in addition to those described.

Abstract: Embodiments of the invention include a method of implementing a touch screen optimized pivot table. The method includes providing a view of a hierarchal table on a touch screen. The hierarchal table includes hierarchal levels and each of hierarchal levels includes corresponding data. The method further includes mapping each of the hierarchal levels to each of a corresponding region on the touch screen. Each region's view displays the corresponding data for the mapped hierarchal level. The method further includes displaying on the touch screen the corresponding data for each of the hierarchal levels in each of the mapped regions, receiving at the touch screen input to manipulate at least one of the regions on the touch screen, and in response to the received input, causing each subordinate region to the at least one manipulated region to update the corresponding data displayed in each of the subordinate regions.

Abstract: An apparatus according to the present invention comprises: a region extraction unit configured to extract region data for each object from document image data including tables; a table structure analysis unit configured to analyze the region data relating to table objects out of the extracted region data and extract table structure information on each of the table objects; a sheet generation unit configured to generate a display sheet for reproducing a layout of the object in the document image data and an edit sheet for each table for editing the table, by using the region data and the table structure information on each object; and an electronic-document generation unit configured to generate an electronic document which associated the display sheet with the edit sheet.

Abstract: In a method for the implementation of a medical examination via the user interface of at least one imaging device, parameter values in a group of measurement parameters are determined, and are entered via an input device of the user interface. Spatially resolved image information are generated by the at least one imaging device depending on the group of measurement parameters, and the image information is stored on a storage medium. The image information are presented as a data symbol on a screen of the user interface. In order to present the parameters and dependencies to enable a more efficient work process, each measurement parameter of the group of measurement parameters is respectively presented on the screen in a measurement parameter cell of a matrix with multiple rows and multiple columns. The measurement parameters can be contained at least in part in multiple measurement parameter cells.

Abstract: A device receives text that includes data values, and parses the text to identify data types associated with the data values. The device generates, based on the data values and the data types, a graphical representation of the text that includes data cells corresponding to the data values, and provides the graphical representation for display. The device receives one or more selections of one or more data cells in the graphical representation, stores the one or more selections as a selection history, and provides the selection history for display.

Abstract: A request for differential data relative to a first data element within a group of data elements is received via a user input device. A first differential data value for each of the group of data elements relative to the first data element is calculated. The first differential data value for each of the group of data elements relative to the first data element are displayed on a display in response to the received request. This abstract is not to be considered limiting, since other embodiments may deviate from the features described in this abstract.

Abstract: Business management system and method which uses a database and regular spreadsheets such as Excel for collecting, processing and distributing data and information using electronic forms, including display fields and data input fields, according to the access level of the user. In addition to interfaces for information input, for defining the structure and the information output the system includes a specific application for the management of information flow and interfaces, as well as the generation of synthetic graphs defined according to the user.

Abstract: A render engine for a spreadsheet application is described. The render engine facilitates the rendering of cell regions containing data that are maintained by both a spreadsheet application (user-defined cell region) and/or a third-party application (application-defined cell region). In particular, an embodiment of the render engine facilitates the repositioning of one or more existing cell regions within a spreadsheet interface, when the insertion of a new cell region is determined to cause a layout conflict with one or more existing cell regions. Repositioning of the existing cell regions is achieved without overwriting any cell information, and without breaking any formulas contained within an affected cell.

Abstract: A computing module and method for corporate performance management (CPM) is disclosed. A spreadsheet is determined for inclusion in a CPM software application. Dimensional members associated with the spreadsheet are captured, and hierarchies associated with the spreadsheet based on the captured dimensional members and formulas in the spreadsheet are determined. A spreadsheet template associated with the spreadsheet is determined and data from the spreadsheet is obtained. The spreadsheet template, dimensional members, hierarchies, and data are then published into the CPM software application.

Abstract: Tools for updating business objects. The tools include an update utility that can allow a user to identify a selection tool to select a population to be updated. Further, the update utility can provide an interface to allow any of a number of available update tools to be used to update the selected data population. In some cases, the update utility adheres to a framework that employs metadata to identify available update tools, their capabilities, and/or their requirements. This framework can allow the utility to be configured to support new update tools without requiring extensive modification of the underlying framework or its implementing software.

Abstract: Users are enabled to navigate a spreadsheet document presented by a web service in a similar fashion to a locally executed spreadsheet application by retrieving blocks of grid data asynchronously in order to display or refresh the area(s) of the spreadsheet currently being viewed by the user as the user navigates the spreadsheet grid or dynamic updates occur. The blocks are laid out in the browser's user interface to fill the user's viewport as well as a predefined buffer around the edge of the viewport. As such, when the user scrolls or updates occur, data associated with blocks are added, updated, or removed in the browser as required to fill the user's viewport.

Abstract: Methods and computerized apparatus for shared business modeling involving multiple spreadsheet-based business models in a network of computers, report generation involving consolidation from at least two different spreadsheet-based business models as well as report generation involving multiple different spreadsheet-based business models are described.

Abstract: Aspects of the present invention provide a tool for extracting schema from a spreadsheet. In an embodiment, a set of data that is stored in an uncataloged tabular format, such as a spreadsheet, is retrieved. The structure of the retrieved set of data is surveyed to determine the dataset schema thereof. Then, data elements within the dataset schema are analyzed to obtain information regarding the data elements. Based on dataset schema and the element information, an interface can be constructed that allows remote access to the set of data.

Abstract: Embodiments provide electronic spreadsheet viewing and interaction features and functionalities, but the embodiments are not so limited. In an embodiment, a computer-implemented method can be configured to provide a cell view launch indicator or interface that alerts a user that a selected cell includes additional content not being currently displayed. The cell view launch indicator can be activated and use a cell view mode to launch a separately controllable cell view window or portion. Other embodiments are included.

Abstract: A method to synchronize data between a spreadsheet application and a marketplace application is disclosed. The method includes receiving a request to synchronize data items between the spreadsheet application and the marketplace application, the data items relating to a type of listing of items associated with the marketplace application. Additionally, the method includes executing a process to synchronize the data items between the spreadsheet application and the marketplace application, the process to include at least one of downloading one of the data items from the spreadsheet application and uploading one of the plurality of data items to the marketplace application, the executing of the process to occur independently of the executing of the spreadsheet application. Furthermore, the method includes displaying a status of the executing of the process in a native user interface element of the spreadsheet application.

Abstract: A graphical user interface for creating a data summary table includes a field pane including a list of a plurality of fields, and a layout pane including a plurality of zones. The zones represent areas of the data summary table, and the layout pane allows a field of the plurality of fields from the field pane to be added to a first zone of the zones. A data summary table is updated upon the field being added to the layout pane.

Abstract: In general, the subject matter described in this specification can be embodied in methods, systems, and program products for mapping an object type to a document type. A computer system stores configuration templates that each identify a mapping of an object type to a markup language document type. The computer system displays a graphical user interface that permits a user of the computing system to select a configuration template. The computer system displays a list of the at least some attributes and, for each of the attributes, the associated markup language attribute or element that is identified by the selected configuration template. The computer system receives second user input that changes an association of one of the attributes so that the attribute is instead associated with a different markup language attribute or element. The computer system stores an updated mapping of the object type to the markup language document type.

Abstract: A method for use with a spreadsheet includes storing a cell object, where the cell object includes a location in the spreadsheet of a cell to which the cell object relates and a process associated with the cell, and performing the process on a complex object to produce a result, where the complex object includes a construct comprised of data and code. A display is generated for the cell that is based on the result.

Abstract: The invention discloses a data organization method for a change oriented spreadsheet application. In one embodiment, the valid updates to cells and the update times are stored with the cell positions as the primary index, and the valid updates to the same cell are arranged in the order of time. In another embodiment, the valid updates to cells are stored with the update time points of the valid updates of the cells as the primary index, and all the valid updates at the same valid update time point are arranged into an update table, the update table having the same cell structure as the spreadsheet file. In yet another embodiment, data structures organized in both manners are maintained at the same time.

Abstract: A system including spreadsheet sheets, makes calculations and data transformations, which is available through a programming interface, and conforms to the grammar and syntax of a target software development language is presented. The system includes an Object Model with Data Structures representing entities involved in spreadsheets. The system includes a Parser and Code Generator that extracts data from a body of spreadsheet data, instantiates instances of Data Structures of the Object Model to represent the spreadsheet data, parses the data and formulas contained in the cells of the spreadsheets, iterates through the instantiated instances of the Data Structures, and generates source code that performs the calculations and data transformations embodied in the spreadsheet data. The system includes a Calculation Engine with software base classes that implement the common structural and data access features of spreadsheet data, and further implement the operations of common spreadsheet functions and operators.

Abstract: To implement at least one functionality, a template having one or more logic components corresponding to the at least one functionality is provided. The template and a data collection are accessed to load the one or more logic components and data into a closure document. The closure document is provided to enable updating of data in the closure document using the one or more logic components.

Abstract: Concepts and technologies are described herein for displaying temporal information in a spreadsheet application. In accordance with the concepts and technologies disclosed herein, spreadsheet data can be obtained at a computer system. The spreadsheet data can include data values, temporal information, and geographic information. The computer system can generate a visualization of the spreadsheet data based, at least partially, upon the data values, the temporal information, and the geographic location information. The computer system also can output the visualization.

Abstract: Systems, methods and machine-readable mediums for defining and executing new commands in a spreadsheet application are provided. A method may include receiving a declaration command in a first spreadsheet cell. The declaration command identifying a command name for the new command and operations performed for the command name based on a plurality of second spreadsheet cells. A system may include a processor programmed to evaluate the declaration command in the first spreadsheet cell according to the instructions stored in a storage device, receive the command name and at least two parameters identifying at least one input spreadsheet cell and at least one output spreadsheet cell of the spreadsheet application, create a new command for the spreadsheet application, and evaluate the new command as identified by the command name in a second spreadsheet cell for execution. The computer readable mediums provide instructions to cause the processor to perform the operations above.

Abstract: System, apparatus and method for printing color image print data selectably as a color image or as a black-and-white image are described.

Abstract: Method and system for conditionally transmitting changes to information in a collaborative environment are provided. A system comprises a display, a change tracking module, and a rendering module. The change tracking module is configured to detect changes by a modifying user to information as a propagating or a non-propagating change. The rendering module transmits first view data to enable altering a first view based on the modification as part of a graphical user interface on the display presented to the modifying user and transmits second view data to enable altering a second view presented to a group of users, not including the modifying user, based on the modification if the modification comprises the propagating change. The second view data is not transmitted if the modification comprises the non-propagating change.

Abstract: A trading application can receive price and quantity information for tradeable objects. The trading application can compute implied price and quantity information for spreads of the tradeable objects. Direct and indirect price and quantity information for the spreads can be displayed in a manner that shows the relationship with each other and with the price and quantity information for the tradeable objects.

Abstract: A spreadsheet environment is used as a graphical user interface for depicting and interacting with the various aspects of a system. In particular, the spreadsheet environment supports using OMG SysML to model a system and to execute tasks associated with the systems engineering process.

Abstract: A device receives text that includes data values, and parses the text to identify data types associated with the data values. The device generates, based on the data values and the data types, a graphical representation of the text that includes data cells corresponding to the data values, and provides the graphical representation for display. The device receives one or more selections of one or more data cells in the graphical representation, stores the one or more selections as a selection history, and provides the selection history for display.

Abstract: A system and method for displaying a scroll-bar or toggle-button-set to control a display of data of an individual column and/or row. A table of intersecting columns and rows is displayed, each intersection forming a cell, and a scroll-bar or toggle-button-set is displayed for an individual column and/or row if a cell of the column and/or row contains data, the display settings of the data requiring for a display of the data an area that is larger than an area allotted to the cell.

Abstract: Block properties and improved calculated columns properties are provided in a spreadsheet application. Once block properties are set for a group of spreadsheet cells or a spreadsheet list, the properties may be applied to the entire group of selected cells or list as opposed to requiring application of properties to individual cells. If rows or columns are added to the group of selected cells or list, properties applied to the group of cells or list are automatically applied to the new rows or columns. Block properties also provide for intelligent-behaving list borders where list borders are not corrupted by the movement or changing of columns or rows sharing edges with a list border. Calculated columns are a type of block property that extends the functionality of formulas throughout an entire column of an associated group of cells or list.

Abstract: An author of a document may be enabled to specify viewing preferences for displaying a document in a reading view. The author may be enabled to define or select among available options for document viewing preferences such as transitions, animations, display of selected elements, layout features, embedded objects, and comparable ones. A reader of the document may be enabled to specify similar viewing preferences on their end. The author's preferences may also include customization of viewing rules based on a device, application, or version of application through which the document is viewed. In case of conflict between the author's and reader's preferences, one may prevail depending on permission levels and similar attributes.

Abstract: Methods, systems, and apparatus, including computer programs stored on computer storage media, for retrieval and display of information from an electronic document collection. One aspect can be embodied in machine-implemented methods that include the actions of receiving description data describing a preexisting structured presentation, comparing characteristics of the preexisting structured presentation with content of electronic documents in an unstructured collection of electronic documents to locate electronic documents that identify a new attribute that is relevant to the preexisting structured presentation, adding an identifier of the new attribute to the preexisting structured presentation to form an expanded structured presentation, and outputting instructions for presenting the expanded structured presentation.

Abstract: Disclosed are systems for and methods of categorizing wines, recommending sipping wines, pairing wines with foods, and arranging wines in a systematic display. In some embodiments, the disclosed systems and methods evaluate and incorporate individual taste profiles. Defining a set of wine flavor characteristics facilitates comparisons and categorization. Recommendations are facilitated by substantially correlating the individual taste profiles to the wine flavor characteristics. Likewise, wine-food pairings are facilitated by substantially correlating the known food flavors to the wine flavor characteristics. Computer-implemented embodiments allow authorized user input and consumer access via wireless devices.

Abstract: A panorama display application shows objects from a spreadsheet such as charts in primary screen of a mobile device adjoined by left and right virtual screens. The application overlays interaction controls such as sort and filter functions on the object. The application also provides additional interaction controls for the object on the left virtual screen and associated objects links on the right virtual screen. The application may expose the additional interaction controls and the associated objects links by overlaying portions of the virtual screens on the primary screen. The application fluidly shifts content from virtual screens to the primary screen subsequent to detected user action on the overlaid portions.

Abstract: A system and method for enabling users of a multi-user network-based OLAP system to present reports generated by the OLAP system using a spreadsheet application within a network user interface. A client-side network user interface is presented to a user over the network so that the user may submit a request for a report. The server-side system receives the request and processes the report. When the server-side system completes the report processing, the report is communicated to the client-side network user interface. The report may then be presented to the user(s) that submitted requests for that report. The client-side network user interface comprises a spreadsheet application that may be used to display the report to the user.

Abstract: Methods and computerized apparatus for shared business modeling involving multiple spreadsheet-based business models in a network of computers, report generation involving consolidation from at least two different spreadsheet-based business models as well as report generation involving multiple different spreadsheet-based business models are described.

Abstract: A collection of data includes a plurality of records having values assigned to different fields, each field corresponding to an attribute of the data. The data is manipulated by importing the data into an application that displays the data and generating a first table via the application, the first table including content which summarizes at least a portion of the data based on one or more of the fields. A second table is generated from the first table, and content of the second table is modified independent of the first table. The data imported into the application is automatically revised based on the modifications made to the content of the second table so that the data imported into the application incorporates the modifications.

Abstract: This invention is for a method to make sense of XML (Extensible Markable Language) data when it is imported into spreadsheets without the use of a stylesheet and to accurately capture that data automatically into the appropriate fields. When it is imported into spreadsheets without a stylesheet, the rows and columns are unspecifiable, and even for similar XML files having different sets of data, the rows and columns may not always correspond exactly, as it would with form data where each data field always has a place holder. The method developed by this claim uniquely addresses the issue of absorbing this data by cross indexing all descendant elements and attributes pillared around a mandatory element and attribute for one direction, and keeping an open spring like data sensing mechanism in the vertical direction, with resulting data read being instantly captured accurately, associated with the proper data field and validated.

Abstract: Tools providing a flexible selection framework for automated processes. The framework can allow end-users to define their own selection criteria to select a data population to be processed (for example, by a business application). Hence, the tools provide enhanced control over what data is provided to which process. Some such tools employ metadata to define what information the client process needs, how the results will be returned to the client process, and/or what selection tools should be available to select data for the client process, as well as the available data selection tools, which can include both tools provided with a business application as well as third-party and/or user supplied selection tools. The framework might also provide an application programming interface that ensures consistent communication between the population selection engine and the selection tools themselves.

Abstract: Methods to facilitate the processing of color information in spreadsheets described using markup languages are presented. In some embodiments, a method for storing color information for objects in a spreadsheet document described in a markup language may comprise obtaining distinct color values from a plurality of spreadsheet color table objects. The color values in the plurality of spreadsheet color table objects are referenced by spreadsheet objects through a plurality of indexes and each index corresponds to a distinct color table object. The distinct color values are stored in a color palette table object and are accessed using a color palette index. Index values in each of the plurality of color tables are mapped to the color palette index, if the index value and the color palette index value point to the same color value. The mapping permits objects to reference color values in the color palette object table.

Abstract: Systems and methods may operate to display a plurality of data containers or bubbles within a user interface so that they do not overlap. Data containers are associated with a pointer or association indicium of fixed size that indicates the relationship between the data container and a target item. They systems and methods include, among other things, determining that two or more data containers will overlap if displayed in the user interface and performing a shift of the data containers, a resizing of the data containers, a shifting of the pointer, or a combination of the above. Additional apparatus, systems, and methods are disclosed.

Abstract: A system and method for mapping payload data to a spreadsheet list. The present invention comprises a system for mapping payload data to a spreadsheet list while supporting the implementation of nested tables, without the use of a schema. After receiving a spreadsheet list, the present invention generates the parent path of each field path defined in the spreadsheet list. The longest parent path may be used to generate a set of nodes from the payload data. If more than one unique parent path qualifies as the longest parent path, then such parent patents may be designated as branch bottom paths. All other parent paths may then be associated with an appropriate branch bottom path. During the binding process, each branch bottom path may be evaluated to generate result nodes, which may be used to obtain the values of the fields of the spreadsheet list.

Abstract: An email client and file manager provides combined file management and communications management in a single interface. An interface allows documents, email messages, contact information, web links or pages, and user-attached notes to be stored in the same folders. This facilitates communication by email and fax. The interface permits the user to combine this data in folders which the user categorizes according to a folder tree created by the user. In one embodiment of the invention, the client, in its email function, communicates with a dedicated host which in turn communicates with external servers according to standard internet protocol.

Abstract: A method, system, and apparatus are provided for exposing and calling workbook models via remote function calls. According to the system, a client computer executes a spreadsheet program for creating a workbook model. The workbook model may be published to a server computer along with data defining a function name and the cells that should be used as inputs and outputs to the model. The system also includes a server computer that receives and responds to remote function calls directed toward workbook functions. When a function call is received at the server computer for a workbook function, the server computer populates the cells in the workbook identified as inputs with input parameters received with the function call and recalculates the workbook. The data contained in the output cells is then returned as a reply to the remote function call.