Abstract: Methods, systems, and apparatus, including computer programs encoded on computer storage media, for adaptive column selection. One of the methods includes obtaining a size of a display area. The method includes obtaining column descriptors, each column descriptor identifying a column and a column width. The method includes determining a set of columns to present, including comparing the column width of a column to an available size remaining, and including the column in the set in response to determining that the column size is less than the available size. The method includes calculating an aggregate width of all the columns in the set. The method includes allocating a portion of the size to each column in the set of columns based on a ratio of width of the respective column and the aggregate width. The method also includes presenting the columns in the set of columns on the display area.

Abstract: User interface (UI) manipulations may be performed by eliminating noticeable process boundaries associated with or generated by different applications. The techniques herein describe dynamically splitting manipulations across multiple pieces of content without regard to various types and/or states of the user interface manipulations and/or without regard to whether the multiple pieces of content are associated with different individual processes. In at least one example, the techniques described herein enable quick, responsive, and seamless UI manipulations with complex configurations of content on a UI and/or with multiple pieces of content associated with more than one application. Additionally, the techniques described herein further enable content on a UI to “stick” to the user input manipulation or move with the user input manipulation such that the content appears to stay directly in contact with the user input manipulation.

Abstract: Systems, methods, and computer-readable mediums are presented that may provide for an interface to a relational database. A request may be received for data stored in a relationship database, wherein the request is received from a spreadsheet application. In response to the request for data stored in the relational database, a plurality of tables in the relational database may be accessed to retrieve the data indicated in the request. The retrieved data may be translated from the plurality of tables of the relational database into a format for output to the spreadsheet application. The translated data may be output to the spreadsheet application.

Abstract: The programming notebook system, methods, and user interfaces described herein provide software developers with enhanced tools by which a programming notebook workflow and session history associated with code cells in a programming notebook may be tracked and maintained. As a developer progresses through a development workflow, the developer can select an option to save a program code card representing some or all of the program code cell inputs. A card editor user interface may present an aggregated listing of all program code the developer has provided across multiple code cells during the current session which the developer can edit, refine, and/or comment. The card editor may also allow the developer to add associated user interface code to display a UI component associated with the program code card, and allow the developer to add a description and tags for the card so that the card can be searched for and reused.

Abstract: A computer-implemented method includes receiving, from a first network application, a first unbounded list of objects of a first type and a second unbounded list of objects of a second type, wherein the second type is distinct from the first type, and producing a third unbounded list of objects of a third type, wherein the third type is distinct from both the first type and the second type. The computer-implemented method further includes providing the third unbounded list to a second network application. A corresponding computer program product and computer system are also disclosed.

Abstract: This disclosure describes systems, methods, and apparatus for expanding a row or column in an existing report, sourced from a relational database, where a column or row, respectively, of an opposite axis has already been expanded. Such a need often arises in reports sourced from a SQL database, and overcomes the storage-draining need to pre-compute all possible arrangements of data from the database prior to displaying the report. In some embodiments, a client can make a request for a multi-axis expansion, and a server can create filters for use in sub queries, one for each level of expansion in an axis of the report opposite to the axis where expansion is requested, the sub queries can be executed, results sets can be combined/formatted to form a new report, and the new report can be returned to the client for stitching into the existing report.

Abstract: The techniques described herein use statistical reasoning to determine whether a spreadsheet (e.g., cells) includes potential errors. The techniques determine a partition within a spreadsheet where the partition includes cells that share characteristics (e.g., same row or column, same type of content, same formatting, etc.). Once determined, the partition is evaluated based on defined properties. A property is applied to generate property values so that an anomaly can be identified. An anomaly can occur when a cell in the partition has a property value that is inconsistent with other property values of other cells in the same partition (e.g., an intra-partition anomaly). An anomaly can also occur when a cell in the partition has a property value that is inconsistent with property values of cells in a different partition (e.g., an inter-partition anomaly). The techniques analyze the anomalies to determine a priority value indicative of a likelihood of a potential error.

Abstract: An information processor includes a defining unit that defines a set of metadata items, and a set of data values of metadata corresponding to the set of metadata items, the set of metadata items and the set of data values being associated with each of multiple specifying areas displayed on a screen, and an associating unit that associates two or more sets of data values with actual data, the two or more sets of data values being each defined for each of two or more specifying areas specified from among the multiple specifying areas.

Abstract: Lists of tradeable objects may be generated and displayed to enable a user to define a trading strategy having multiple legs. The lists of tradeable objects may be used to define and display different combinations of the tradeable objects that are included in each of the lists. Each combination of tradeable objects may define the different legs of a spread that may be tradeable on one or more exchanges. A combination of tradeable objects may be selected to display contract information associated with the different legs of the spread. The contract information for each leg may be used to define and display spread information for the legs of the trading strategy. The spread information may allow the user to view information related to the spreads for different combinations of tradeable objects in a display.

Abstract: Disclosed herein is a method of controlling data display device. The method includes: loading a monitoring view to initialize it; determining whether to display a tabular view; setting a tabular module if it is determined that the tabular view is to be displayed; displaying the tabular view according to set conditions; and checking whether to perform a view update mode during the displaying the tabular view.

Abstract: A method for creating a spreadsheet template to facilitate creation of a spreadsheet is disclosed. The method comprises marking a cell in the range of cells as being a potential record cell; and creating a save map to define attributes to be assembled into a record for an actual record cell.

Abstract: A method for creating a spreadsheet template to facilitate creation of a spreadsheet is disclosed. The method comprises determining at least one dimension for the spreadsheet; creating logic to dynamically determine a dimension range for each dimension when the spreadsheet template is run, and saving said logic in a memory device; and creating logic to map each cell within each dimension range to a remote application object.

Abstract: An electronic device is configured to perform a method for editing an object. The method includes determining one or more edit references with respect to one or more objects displayed on a display unit, detecting a motion input, and editing the one or more objects based on at least one of the one or more edit references and a characteristic of the motion input.

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: Systems and methods for generating a two-dimensional graphical grid representation of the treatment of a document are disclosed. A method includes receiving a request to generate the two-dimensional graphical grid representation of the treatment of the document with respect to at least one variable. In response to the received request, the method further includes retrieving, by a computer, treatment information associated with the document with respect to the at least one variable from a database. The method further includes generating a message containing the retrieved treatment information of the document with respect to the at least one variable, transmitting the generated message, and providing for display the two-dimensional graphical grid representation of the treatment of the document with respect to the at least one variable based on the transmitted message.

Abstract: A smart fill feature is provided, which may be utilized to provide suggestions to a user and to prepopulate fill results in a spreadsheet. Characteristics associated with a set of data may be recognized and used to help determine fill results Suggestions may be determined from internal and or/external data sources, and may use contextual information in a data set to determine what a user may be trying to accomplish. External data sources may include one or more Internet data sources or internal corporate databases, providing a large amount of data from which to search for potential fill results. A split column command may be used to split a column into two or more columns. Data may be split between columns or combined by various methods, which may include, by example, by direct manipulation via tokens, or via a slider UI.

Abstract: The present disclosure includes techniques pertaining to computer implemented systems and methods for data usage monitoring. In one embodiment, user manipulations of spreadsheets are translated into backend actions and executed against spreadsheet data. The actions of users on different spreadsheets automatically generate data records to track each action. The data records are stored in a data structure and portions of the records may be accessed to generate usage information.

Abstract: A computer-implemented method, system, and program product for selecting tabulated data are provided, which include: displaying a tabulated data structure on a computer display, the tabulated data structure including a plurality of data fields; receiving a user input indicative of a selection of one of the data fields; searching the tabulated data structure to generate at least one set of data fields, the data fields in each set sharing a relationship with the user-selected data field; and highlighting the at least one set of data fields in the displayed tabulated data structure, in which each of the highlighted sets of data fields is user-selectable.

Abstract: Systems and methods provide for data management and governance to enforce proper usage of data. Data is tagged with data governance metadata dictating usage of the data. Standard types of data governance metadata are set forth with each type having predefined options such that applications can share data and understand the associated data governance metadata. For a given data, one or more options are selected for each type of data governance metadata and tagged to the data to control usage of the data.

Abstract: Disclosed is a computer-implemented method of generating a plurality of selectable design experiments in a design of experiments (DOE) process for analyzing at least one data set from a process to determine a relationship of a plurality of process factors of interest to a process output of interest. The method entails receiving as user input into a computing apparatus, a base number of trials and a number of center point trials. From the computing apparatus, a graphical user interface is generated on a display connected with the computing apparatus. This includes presenting a display containing a plurality of experiment each defined, at least partially, by a combination of number of replicates (replicates count) and effect size. The display further includes a predicted power value for each combination of replicates count and effect size.

Abstract: Computer programming is aided by way of automatic code generation, and more specifically generation of deployment code automatically. An application can be analyzed and deployment code, including installation, maintenance (e.g., update/upgrade), and removal (e.g., un-install) code, can be generated as a function of the analysis as well as a particular execution environment.

Abstract: Systems and methods for transferring a web content display from one container to another container are disclosed. A request to transfer a first web content display hosted in a first container having a first document object model (DOM) tree to a second container having a second DOM tree is received. The first web content display has a state comprising a plurality of state components. A second web content display hosted in the second container is created. If a first state component is dependent on a property of the first DOM tree associated with a host of the first web content display: the first state component is adjusted in the second web content display according to a corresponding property of the second DOM tree.

Abstract: One or more techniques and/or systems are provided for parsing tabular data of a document. That is, a document may comprise arbitrarily formatted content (e.g., an equipment inspection report generated by an engineer). Respective rows of the document may be clustered into one or more row clusters based upon row proximity and/or numeric content (e.g., rows having similar numeric content may comprise logically related information). One or more vertical clusters may be generated within respective row clusters based upon vertical overlap. In this way, row clusters and/or vertical clusters may be searched for one or more values that may be assigned to a search term. For example, a row cluster may comprise a search term “Average temp”. One or more vertical clusters within the row cluster may be searched for a word that matches a pattern criteria (e.g., a two digit number), which may be assigned to the search term.

Abstract: Lists of tradeable objects may be generated and displayed to enable a user to define a trading strategy having multiple legs. The lists of tradeable objects may be used to define and display different combinations of the tradeable objects that are included in each of the lists. Each combination of tradeable objects may define the different legs of a spread that may be tradeable on one or more exchanges. A combination of tradeable objects may be selected to display contract information associated with the different legs of the spread. The contract information for each leg may be used to define and display spread information for the legs of the trading strategy. The spread information may allow the user to view information related to the spreads for different combinations of tradeable objects in a display.

Abstract: The present disclosure includes techniques pertaining to computer implemented systems and methods for automatic generation of data transformations. In one embodiment, a user manipulates a spreadsheet of data in a user interface. On a backend, the user's manipulations trigger actions that cause the data to be modified. Actions may automatically cause data flow objects and data flow graphs to be produced. The transformations defined by the data flow graphs are automatically executed by a software engine and the results are displayed to the user. The user may access and manipulate data from a variety of data sources while the underlying complexities of the transformation process are performed in an automated manner.

Abstract: A method for focus management in a software application, wherein at least a subset of Node objects of said software application forms a hierarchy of Node objects and wherein each Node object of said hierarchy of Node objects of said software application comprises: a first routine that when returning true denotes that the Node object is a focused one; and a second routine that when returning true denotes that the Node object is a focused, or at least one of its descendants is a focused; a routine for handling an incoming event; the method comprising the steps of: providing, for each Node object of said hierarchy of Node objects a third routine, that when returning true denotes that the Node object and all descendants of the Node object, excluding these Node objects for which the third routine returns true, forms a single monofocus area having a single focus root.

Abstract: Hierarchical data can be consistently presented in multiple different views. One method involves extracting object information describing at least one object from a database. The object information includes hierarchical information indicating a position of the object within a hierarchy of objects and list information usable to sort of list of objects that includes the object. The method also generates a tree view and a list view for display within a hierarchical data presentation window. The tree view identifies the object, and generation of the tree view is based upon the hierarchical information. The list view identifies the at least one object, and generation of the list view is based upon the list information. The method provides the tree and list views to a display device for display within the hierarchical data presentation window.

Abstract: Systems and methods are disclosed herein for resolving a change to a table. A processing circuitry receives, from a user in a collaborative document editing environment, the change to the table, wherein the change comprises an expansion of a first cell in the table. A first state of the first cell is identified, wherein the state is indicative of a number of columns and a number of rows over which the first cell spans, and at least one of the number of columns and the number of rows is greater than one. A second state of a second cell that is adjacent to the first cell is identified, and the processing circuitry selects whether to allow the expansion of the first cell based on the second state of the second cell.

Abstract: The present disclosure includes techniques pertaining to computer implemented systems and methods for transforming data. In one embodiment, data sources are specified by a user and copies of specified data are received in local storage. Data is presented to the user as a spreadsheet of columns and rows and the user manipulates the data in the spreadsheet. The user manipulations are automatically translated into data flow objects and a data flow graph, which is executed to transform the data. The modified data is presented to the user.

Abstract: A method and system associate conditional formats with selected data points or groups of data points within a summary table. In one embodiment, related groups of data are determined based upon currently highlighted cells in a summary table. A user then selects from the groups and identifies conditional formats to be associated with the specified data points. The conditional formats are associated with currently displayed as well as non-displayed data within the summary table. The associated conditions are saved relative to the data points rather than the original cell positions so that the conditions remain associated with the data points following a reorganization of the summary table.

Abstract: A user interface element is displayed for in place editing of values within a document. For example, in response to selecting a value, a user interface is displayed near the value that receives a slide gesture for adjusting the value in place. The user interface may be configured to select one of the discrete parts of the value in response to changing a level of the slide gesture. For example, a user may move the swipe gesture from a level used for adjusting the day value to the level representing the year value. The user interface displayed and method(s) used to adjust the value may be based on the type of value and the structure and content of the document.

Abstract: A computer-implemented method for managing row height in an electronic document includes receiving, at a computing device, a request to display a portion of a document that defines a plurality of rows of content and that is represented by a document model; determining heights of the plurality of rows and saving information about the determined heights in a cache that correlates rows to the height information; and using the document model and the cache to generate a view of the document model having the determined row heights.

Abstract: The computer applications, user devices, methods, and/or systems described herein provide a user with automated tools to facilitate creating dynamic, interactive performances of visualizations that utilize datasets of various digital/web content provided from various data sources and types without loss of access to underlying data used to create the performance.

Abstract: A sequential series of methods for optimized searching within a text (or alphanumeric string) database to retrieve specific and relevant results, followed by optimized restructuring and parsing of text data (or alphanumeric string), followed by creation/application of a natural language processing engine, followed by the creation/application of an automated analyzer is presented.

Abstract: Described herein are systems and methods for generating user interfaces that include a meta-chart framework for organizing and analyzing multi-dimensional hierarchical data in an efficient and intuitive graphical user interface with which a user can explore and consume prepared analytical elements. The predetermined structure of such user interfaces can include customizable and scalable graphical and/or alphanumeric analytic elements with contextual controls that can guide a user on a preconfigured analytical path, or “drill-down path,” to better explore and understand the multidimensional data. Such embodiments provide a turnkey analytical framework from which users can both immediately understand data and learn how to explore the data in greater depth.

Abstract: In some embodiments, a computer-implemented spreadsheet management method is provided that automatically copies formatting and formulas from appropriate peer rows to an updated row. In some embodiments, the method automatically determines which peer rows, if any, should be used as the source of copied formatting and formulas. In some embodiments, the method automatically fixes formulas that are affected by the updated row in order to maintain consistency throughout the spreadsheet.

Abstract: The present invention relates to a method for controlling an electronic spreadsheet on a handheld touch device, comprising an operation procedure, a display procedure and a recovery procedure. The operation procedure comprises: receiving a selection touch control signal for selecting cells, determining selected cells in an electronic spreadsheet according to the selection touch control signal, calculating according to a preset processing method, and storing the calculation result. The display procedure comprises: receiving a first touch control signal for controlling movement of an electronic spreadsheet from an initial position of the electronic spreadsheet to an interim position, moving the electronic spreadsheet from the initial position of the electronic spreadsheet to the interim position according to the first touch control signal to expose a blank area, querying whether the calculation result exists or not, and if yes, displaying the calculation result in the blank area.

Abstract: Cross tabulation operation is performed within a columnar database management system. The columnar database management system receives a request to perform a cross-tabulation operation on a set of database tables. The columnar database management system determines values of cross tabulation operation for each row of the result. The columnar database management system determines a domain for each value of the row dimension corresponding to a row combination. The columnar database management system determines an intersection set of the domains corresponding to values of the row dimensions for the row combination. The columnar database management system determines a value for the result column for the row combination as an aggregate value based on the records of the intersection set.

Abstract: A character correcting method of a display apparatus includes displaying a sentence including at least two words in a character input window; displaying, if one of the at least two words is selected, a first user interface (UI) in which the at least one selected word is displayed by a character unit; and, displaying, if one of a plurality of characters displayed in the first UI is selected, a second UI around the selected character, the second UI is configured to edit the selected character.

Abstract: In the proposed approach cluster elements (bins) are made available as a keypad in the form of a cluster map. The user directly selects the cluster element (bin) with a mouse, touch or actual keypad. For each of the associated attributes, a cluster map is available that orders the attributes from high-to-low by color or shade intensity. When a cluster element is selected in one cluster map, that same cluster element is also highlighted in other cluster maps. For each of the cluster maps, a value axis is available which shows the value of the parameter for the selected cluster element. In the case of numerical values, the high/low attribute pattern across the cluster maps is easily visible. The selected data objects in the cluster map are displayed in a separate widget.

Abstract: A method and computing device for managing models. The method and computing device receive a spreadsheet model, receive template management instructions on how to manage evaluations, create, from the spreadsheet model and the template management instructions, a model template, and deploy, in response to user action, an instance of the model template into a model relationship structure relating one or more spreadsheet model instances.

Abstract: A display control apparatus displays, together with an image on a display unit, items related to a plurality of objects in the image. At this time, for the plurality of objects in the image, the display control apparatus displays items related to the respective objects at display positions having a predetermined relative positional relationship with the objects. The display control apparatus decides the order of priority of the plurality of objects. In case that the area of a main object having a highest decided priority level and the display position having the predetermined relative positional relationship for an item related to another object overlap each other, the display control apparatus adjusts the display position of the item related to the other object to eliminate the overlapping, and displays the item related to the other object.

Abstract: Systems and methods for providing information responsive to a request. In an embodiment, a request from a requestor is received. A plurality of eligible information sources that are capable of providing data at least partially responsive to the information request are identified. For each identified information source, a data request according to a schema accepted by the identified information source is prepared and responses from the eligible information sources are received. The responses are homogenized according to a common schema and information from the homogenized responses are provided to the requestor.

Abstract: An FT diagram aid device is provided with an import portion for obtaining a connection relationship of ruled lines and character strings from first data which is data of an FT diagram expressing a tree structure by the ruled lines and the character strings on a sheet of a spreadsheet program, acquiring an event included in the FT diagram and a connection relationship between events from an obtained connection relationship of the ruled lines and the character strings, and generating second data describing the tree structure of the FT diagram in a markup language based on the same and an editing portion for editing the second data to generate third data describing the tree structure of the edited FT diagram in the markup language.

Abstract: Improved, re-arrangeable, and/or customizable data tree hierarchies, and methods of use thereof, are provided. In one embodiment, a method for customizing a data tree hierarchy includes providing, to a plurality of communication devices that are each associated with one or more respective users, access to a data tree hierarchy. The data tree hierarchy is adapted to include a plurality of data items, and each of the plurality of data items is positionable at one of a plurality of hierarchal levels. The method also includes receiving input from one or more of the communication devices to change a position of one or more of the plurality of data items in the data tree hierarchy, and changing the position of the one or more of the plurality of data items in the data tree hierarchy in response to receiving the input from the one or more of the communication devices.

Abstract: Embodiments are provided that include the use of an underlying grid structure as part of managing table operations and/or animation visualizations, but are not so limited. A method of an embodiment uses an underlying grid structure as part of an animation control reference or guide to provide table visualizations for display, including using one or more table borders and aspects of a reference grid column or row as part of controlling table features. A system of one embodiment includes a table manager to manage table actions and a grid manager to manage an underlying grid structure based in part on associated table actions and/or animations. Other embodiments are also disclosed.

Abstract: The present invention relates to a system comprising providing means for providing data to a user, comprising display means for displaying said provided data and comprising assessment means for assessing at least one characteristic of at least one of said displayed data, wherein the system further comprises at least one means for providing a color in at least one part of the area displayed by said display means, wherein the color or at least one characteristic of the color is dependend on said characteristic of said data.

Abstract: A method and system associate conditional formats with selected data points or groups of data points within a summary table. In one embodiment, related groups of data are determined based upon currently highlighted cells in a summary table. A user then selects from the groups and identifies conditional formats to be associated with the specified data points. The conditional formats are associated with currently displayed well as non-displayed data within the summary table. The associated conditions are saved relative to the data points rather than the original cell positions so that the conditions remain associated with the data points following a reorganization of the summary table.

Abstract: In an embodiment, a hierarchical user interface replaces a native one-dimensional horizontal navigation system with a multi-dimensional hierarchical tree structure for organizing and navigating spreadsheet workbooks. The interface allows users to visualize the full structure and content of workbooks, quickly navigate to and select sheets, and organize workbooks in a more logical manner than sequential tabs allow.

Abstract: An electronic messaging system and method with reduced traceability. Separate displays are provided at a recipient user device for separately displaying via the user device header information of an electronic message and message content including a media component. The message content and the header information are correlated with a unique identifier. The header information is displayed in a message list via a first display. The message content including a media component is displayed via a second display. The display of the header information via the first display does not include a display of the media component. Methods, systems, and computer readable media with separation of the display of media component and header information in various implementations may provide for reduced traceability of an electronic message.