Abstract: Systems, computer program products, and methods are described herein for providing a platform for generating published reports using report and worksheet building with position mapping identification. The present invention is configured to establish a reporting and analytics platform for a user interface and receive, from the user interface, a single-selection input referencing a set of system identification values associated with a first set of data in the reporting and analytics platform. The system may then display a plurality of formatting options for the set of system identification values on the user interface. The system can assign a selected formatting option to the system identification values and apply the selected formatting option to the first set of data in the reporting and analytics platform. The selected formatting options can be applied to additional sets of data based on system identification values.

Abstract: Methods, systems, and computer program products for extracting structure and semantics from tabular data are provided herein. A computer-implemented method includes processing tabular data comprising data cells and header cells, wherein the processing includes: identifying one or more regions within the tabular data, wherein each of the regions comprises one or more of the data cells; matching some of the regions to one or more of the header cells, wherein the matched header cells are semantically related to the data cells inside the matched region; and generating, based on the matching, an output describing semantic relationships between the data cells and the header cells. The method also includes creating, for each data cell, a tuple comprising semantic information contained within one or more of the header cells that pertains to the data cell.

Abstract: Data is processed iteratively by a database system with a first cache storing key-value data which resulted from previous iterations of processing input data and a second cache storing aggregated data which resulted from previous iterations of processing key-value data stored in the first cache. In a current iteration, the database system receives further input data related to the input data of the previous iterations, transforms the further input data into further key-value data and stores the further key-value data in the first cache in addition to the stored key-value data which resulted from previous iterations. The database system further processes the further key-value data and the aggregated data stored in the second cache to form updated aggregated data, and stores the updated aggregated data in the second cache for usage in further iterations. The database system also provides the updated aggregated data to at least one client.

Abstract: A system includes a repository storing trained machine learning models and metadata corresponding to the trained machine learning models. The system provides an interface for performing operations on the trained machine learning models and corresponding metadata stored in the repository, and evaluates trained machine learning models that are linked to the data sources and stored in the repository to obtain resulting predictions for a payload of records of data contained in the data sources. A method includes configuring one or more data sources, ingesting training data from the configured data sources, identifying a scenario for prediction, training one or more machine learning models on the ingested training data for the identified scenario, reviewing performance of the trained machine learning models and storing the trained machine learning models and corresponding metadata in A model repository, and dynamically creating a user interface for interacting with the stored trained machine learning models.

Abstract: Systems and methods are disclosed for performing multiple queries in a single graphical user interface (GUI) displayed in a client browser. The client browser causes the display of a first user interface field in a first area of the GUI, where the first user interface field can be used to enter or edit a first query. The client browser also causes first query results generated by a data intake and query system executing the first query to be displayed in the first area. The client browser further causes the display of a second user interface field in a second area of the GUI, where the second user interface field can be used to enter or edit a second query. The client browser also causes second query results generated by the data intake and query system executing the second query to be displayed in the second area.

Abstract: A method, system and/or computer program product changes the properties of a graphical object. One or more processors receive a graphical display data set including information for generating a graphical display of a spreadsheet, where the spreadsheet comprises a cell having a perimeter that is defined by a plurality of edges. In the cell, a property adjusted by selecting a constrained edge of the cell is identified. A graphical control for the identified property is created and displayed in response to a user selecting the constrained edge and requesting the graphical control from a context menu associated with the cell, where activating the graphical control increases a size of the cell beyond the boundary conditions of the spreadsheet. A user input selecting the graphical control is received. In response, the cell is expanded beyond the boundary conditions of the spreadsheet and the property is displayed on the graphical user interface.

Abstract: Methods and systems for providing an improved grid-based data processing experience are described. Using the improved grid-based data processing system, a user can edit cells in a way that is intuitive, and the system automatically checks and adjusts the grid to alleviate any circular references or violations of relationships among the cells of the grid. For example, if a user's edit to a target cell creates a circular reference or breaks a predefined relationship, the system can automatically edit one or more other cells of the grid to obviate the problem. Such automatic editing may involve deriving a new formula to populate one or more non-target cells.

Abstract: A computer implemented method includes receiving one or more data sequences and formula sequences, each formula referencing one or more of the data values of the data sequences; providing a GUI enabling a user to define a pattern including at least one data element representing a data sequence and at least one formula element representing a formula sequence, the GUI enabling the user to define the spatial relationship of the data elements and formula elements in the pattern, applying the pattern on a canvas of an electronic document multiple times, thereby filling canvas elements mapped to a data element with data values and filling canvas elements mapped to a formula element with formulas or formula results, until all data values of one of the data sequences or all formulas of one of the formula sequences have been filled once into the canvas.

Abstract: The invention relates to a cell-based computing platform that may be specifically used for website development and management. This cell-based computing platform may further be responsive to an external device, program, or operation such that changes in the value parameter of one or more cells may dynamically trigger an external response.

Abstract: Systems, methods, and devices for tracking spreadsheet table cells from a base table to an organized table/organized table view, and updating of a formula reference based on the tracked cells are provided. In some embodiments, cells may be tracked to convert a first range of cells in the base table into a second range of cells in the organized table/organized table view, such that the second range of cells includes the same cells as the first range of cells, despite any reorganization of rows and columns. In some embodiments, a summary reference cell that provides a sub-group summary based upon the grouping within the organized table/organized table view may also be provided.

Abstract: A document preview system provides previews of a native document to client devices. To generate the preview of a document, the document preview system generates a preview document that presents the native document in a browser-compatible format including elements that correspond to fields in the native document. The document preview system also identifies a mapping between fields of the native document and the elements of the preview. The document preview system also identifies a formula listing for the elements of the preview code. When a user edits a document, the edits may be committed to the document preview system and in parallel generate a preview to update the user's display. When an updated preview is available, the updated preview is rendered in a hidden frame and the user's input context is captured and reproduced when the updated preview replaces the prior preview.

Abstract: A collaborative content management system allows for the mutual-synchronization of content within a spreadsheet and within a document in which a set of spreadsheet cells are embedded. When a user modifies the embedded set of cells, the spreadsheet is updated to reflect the modification. A set of tasks, for instance each associated with descriptive text and one or more interactive elements, can be incorporated into a set of spreadsheet cells such that a user can interact with the tasks. A data value from a spreadsheet cell can be embedded into a document such that when the spreadsheet is updated and the data value changes, the corresponding embedded data value within the document can be changed. Spreadsheets can also include comments that can be navigated using a movable interface element that changes position within the spreadsheet based on a location of a set of cells corresponding to a comment.

Abstract: A method and apparatus for passing functional spreadsheet data by reference is provided. Passing functional spreadsheet data by reference may include identifying information associated with a first cell of a first sheet of an electronic spreadsheet, the information associated with the first cell including a formula, the formula including a function call, the function call including an argument, the argument indicating a cell identifier associated with a second cell of the electronic spreadsheet; identifying information associated with the second cell, the information associated with the second cell including a function identifier; determining, by a processor in response to instructions stored on a tangible non-transitory computer readable medium, a result of the formula based on the function identifier; and transmitting information including the result of the formula for display in the first cell.

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: A method and system for entry of data into content of cells belonging to an output field. Entered into cells of a multidimensional table located within a header record in the table are: input field labels respectively corresponding to input fields in the table entered into a respective unique cell within the header record; and an output label corresponding to the output field entered into a specifically unique cell within the header record and expressed as a mathematical expression of input field labels. The mathematical expressions are translated into the cell address of the cell containing each input field label and then pasted in each cell of the output field. The cell address of the cell containing each input field label is replaced in the pasted mathematical expression by the corresponding cell address of each input field in the same record that contains each cell of the output field.

Abstract: Systems and methods are disclosed herein for computing, applying, and displaying document deltas. Snapshots are stored of documents, and the stored snapshots are flattened. Deltas of the flattened snapshots are computed. The deltas are converted to representations of changes in the document by inverting the flattening. The representations of changes are displayed to a user via a feed. Users of the systems and methods can accept, reject, and comment on the changes.

Abstract: The compilation of a transformation chain of a recalculation user interface that displays an electronic canvas that contains one or more displayed result of a transformation chain. The transformation chain includes transforms between a respective data source and data sink. User editing of the recalculation user interface could cause one or more of the transforms to be re-executed, thereby causing recalculation. The compilation involves analyzing the transformation chain of the recalculation user interface for dependencies to create a dependency graph of dependencies between entities. For instance, some dependencies might be between entities so as to indicate that if one entity is evaluated, then the other should be also. The dependency graph is then used to create a lower level of execution steps. The dependency graph is further provided to a runtime for the program, so that the dependency graph may be available during operation of the recalculation user interface.

Abstract: Described are methods, systems and computer readable media for GUI display effect formatting.

Abstract: Technologies pertaining to fact lookup queries are described herein. A relational database is automatically built by extracting attribute identities and attribute values from a one dimensional table, wherein the one dimensional table does not include an entity identity that corresponds to the attribute identity and the attribute value. The entity identity is inferred, and the attribute value is indexed in a relational database by the entity identity and the attribute identity. When a query is issued by a user that includes the entity identity and the attribute identity, the corresponding attribute value in the relational database is returned to the user.

Abstract: A technique is described for table grid detection and separation during the analysis and recognition of documents containing table contents. The technique includes the steps of table detection, grid separation, and table cell extraction. The technique is characterized by the steps of detecting the grid lines of a table using, for example, inverse cell detection, separating noise and touching text from the grid lines, and extracting the cell contents for OCR recognition.

Abstract: A system may include reception, from a planning application, of a spreadsheet including a plurality of values, presentation of the plurality of values, reception of a first instruction to change a first value of the plurality of values to a second value, presentation, in response to the instruction, of a visual indication in association with the second value, the visual indication indicating that the second value is a fixed value, reception of a second instruction to refresh the spreadsheet, and in response to the second instruction, determination of one or more of the plurality of values of the spreadsheet, each of the determined one or more of the plurality of values presented in association with a visual indication indicating that the value is a fixed value, and transmission of the determined one or more of the plurality of values and a request to refresh the spreadsheet to the planning application.

Abstract: Green printing is utilized to repurpose a document. An indication is received that a printout of a document from a printer has been requested. The document has content with a format that would result in a first quantity of pages being printed. The content is grouped into one or more regions. Further, one or more transformations are applied to the content for each region such that the printer prints the document with the content in a transformed format that results in a second quantity of pages being printed without falling below a predetermined readability threshold. The second quantity of pages is less than the first quantity of pages. Further, the one or more transformations being applied to the document may result in a second quantity of ink being utilized to print the document such that the second quantity of ink being less than the first quantity of ink.

Abstract: Example systems, methods, and data structures are directed at synchronizing documents. One example data structure includes receiving a request from a first client to edit a document, and sending short-term check out metadata to the first client to begin an editing session. The data structure includes a plurality of cells and a plurality of data objects defining content of the document. Each data object is associated with one of the cells and has an object identifier that uniquely identifies the data object within the associated cell, and is configured to communicate with other cells and with objects within the associated cell. In addition, each of the cells is defined so that each other cell remains unaffected by changes to data objects of the cell.

Abstract: The present invention relates to a method and apparatus for explicit filtering in ambiguous text entry. The invention provides embodiments including various explicit text entry methodologies, such as 2-key and long pressing. The invention also provides means for matching words in a database using build around methodology, stem locking methodology, word completion methodology, and n-gram searches.

Abstract: A field attraction module attracts/detracts interaction to/from particular fields of a digital document. The module detects interaction in the digital document corresponding to a plurality of fields of the digital document is detected. The module determines field attraction weights associated with the plurality of fields. The field attraction weights represent a degree to which presentation of the digital document is modified for selectively attracting interaction to at least one of the plurality of fields. The module determines that a first of the plurality of fields is associated with a greatest of the field attraction weights. The module modifies presentation of the digital document to attract interaction to the first field in the digital document in accordance with the greatest of the field attraction weights.

Abstract: Some embodiments provide a system for displaying cells of a table. During operation, the system can receive a sort-and-merge request for sorting the rows of the table using a sort column. Next, the system can sort the rows of the table based at least on cell values in the sort column to obtain a sorted table. The system can then merge a set of consecutive cells in a merge column of the sorted table to obtain a merged cell, wherein the set of consecutive cells are associated with the same cell value. Note that the sort column and the merge column can be the same column, or they can be different columns. Next, the system can display the merged cell and other cells in the sorted-and-merged table. Displaying a cell can involve positioning the cell's value in a visible area of the cell.

Abstract: Context sensitive delimiter insertion when adding references is disclosed. In some embodiments, a plurality of indications of selections of a cell or cell range while in a formula editing mode in a host cell into which a formula is being entered is successively received, and in response to receiving each indication of selection of the plurality a reference to the selected cell or cell range is successively inserted into the formula, wherein the references inserted into the formula are delimited by a first delimiter type if in a first context and wherein the references inserted into the formula are delimited by a second delimiter type if in a second context.

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: A plurality of time series having corresponding sets of data over time are received. Visual indicators for display in a display region are presented for values of at least a first attribute of the plurality of time series in corresponding cell-based lines, where the cell-based lines have cells to display the corresponding visual indicators for the values of the at least first attribute over time. The plurality of time series in the display region are ordered according to an aggregate of at least one attribute of the plurality of time series.

Abstract: A VCI (visual context indicator) color is assigned deterministically and proactively at runtime to user data contexts, and is not stored in the database, spreadsheet, or other context. VCI colors can be high contrast friendly colors. The same color is assigned to a given context each time the application runs unless the context's identifying property has changed. Color assignments are not made by users or by the application's designer, but are done instead by hashing from a context's identifying property into a VCI color palette containing, e.g., eight to sixteen colors. Unlike text-selection coloring, VCI coloring is based on the user data context's identifying property. The color assignment visually indicates context by displaying the context's name in the VCI color, or by displaying a graphical element in the VCI color near the context name. VCI color assignment also shows the occurrence and result of changes in user data context.

Abstract: Systems and methods are described to manage the exchange of information between multiple networked devices in a shared electronic document environment. In an embodiment, a computer implemented method of exchanging information in a collaborative networked environment is performed. The method may include receiving a first active region from a first client, receiving indicia of a change to a shared electronic document, and determining that the first client requires an update. The determining step may include determining the change will affect the first active region, and determining the relevant-change data to send to the first client. Additionally, the method may include sending the relevant-change data to the first client.

Abstract: Seamless grid and canvas integration in a spreadsheet application is provided. One or more data items may be pulled from a grid-structured spreadsheet and may be allowed to “float” on the grid-structure spreadsheet without regard to the underlying grid. The floating object may be pushed or inserted back into the grid of the same or different spreadsheet at any location. A pulled data object also may be dropped onto a grid-less canvas user interface object and may be moved about on the canvas object in a free form manner. References between data and computations in the moved data object are structured and maintained so that the data object may be manipulated and increased/decreased without adversely affecting the underlying grid and such that both data and computational references between the data object and the underlying grid are maintained.

Abstract: Natural gestures for interacting with spreadsheet documents are provided. A user may interact with a spreadsheet document using a variety of touch-based gestures. Gestures applied to a spreadsheet document may be used for making structural and display changes to the document. For example, gestures may be used on the spreadsheet document for inserting new columns and rows; for revealing hidden columns and rows; for deleting columns and rows; for extending functionalities across columns and rows; for moving objects displayed in a spreadsheet document; and for navigating various parts of a spreadsheet document.

Abstract: A smart selection engine is provided. The smart selection engine may run in the context of a spreadsheet application on any device, service, or general endpoint capable of running the spreadsheet application. The smart selection engine reduces the cognitive load and complexity for performing spreadsheet operations by clearly presenting the user with easy to use and understand options that are big, simple, and lend themselves nicely to natural user interfaces, touch enabled devices, and devices with small displays as well as with graphical user interfaces, larger displays, and traditional input devices. By making contextually based suggestions, the smart selection engine reduces or eliminates the need for the user to be aware of the available operations or how to perform the operations. Further, the smart selection engine improves the consistency and efficiency of working with a spreadsheet.

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: Provided is an information processing apparatus including a position determination unit for determining whether or not a position of an information input area included in a display area of a first application and a position of an information output area included in a display area of a second application satisfy a predetermined first positional relationship, and a coordination processing unit for inputting, in a case it is determined that the predetermined first positional relationship is satisfied, output information of the second application that is associated with the information output area to the first application as input information associated with the information input area.

Abstract: Users may collaborate on a document and be notified of changes (e.g. comments, changes) made to the document using different notification methods. A comment may be added to the document from within the document and/or externally from the document. A comment may also be added to a comment stream (e.g. a thread of related comments). The different notification mechanisms may include mechanisms such as: Short Message Service (SMS), Multimedia Messaging Service (MMS), electronic mail, phone call, Instant Messaging (IM), social network post/message, toast message, live tile, and the like. A user may configure the desired notification methods. A newsfeed may display a feed of collaboration items that reflect comments/changes to the document. The user may select a displayed collaboration item from the newsfeed to access the document. A user may also respond (e.g. comment) to a notification that may be added as a comment in the document.

Abstract: A spreadsheet is repurposed to save paper and ink. An indication that a printout of a spreadsheet from a printer has been requested is received. The spreadsheet has content with a format that would result in a first quantity of pages being printed. Further, a printable range for the spreadsheet is determined. In addition, an overlap analysis of the spreadsheet is performed to determine if any of the plurality of shapes in the spreadsheet overlap one another. Each print zone is isolated in the spreadsheet. The print zone includes a group of cells. Each print zone is transformed into a transformed print zone. Further, a green spreadsheet is generated, without falling below a predetermined readability threshold, based on each transformed print zone such that the green spreadsheet has a second quantity of pages that is less than the first quantity of pages.

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: Technologies are described herein for generating field sets of a data summary table. Multiple fields in a spreadsheet document are identified. Multiple field scores for each field of the plurality of fields are determined. A field set incorporating two or more of the plurality of fields is generated based on the plurality of field scores. The field set is inserted into the data summary table, thereby transforming the data summary table without the field set to the data summary table with the field set.

Abstract: A method is disclosed for data entry into the content of cells belonging to an output field, said data being expressed as a mathematical expression of the cell contents of at least one input field in a data multidimensional table used by a data management application.

Abstract: Embodiments of the present invention provide a table graphics management method and apparatus. The table graphics management method includes: displaying a table on a display apparatus; detecting a control track for the table input by an input device; determining a moving direction of the control track according to the detected control track; and along the moving direction of the control track, transposing original information in the frames of the row that are sequentially arranged along the first dimension into the frames of the column that are sequentially arranged along the second dimension, and transposing original information in the frames of the column that are sequentially arranged along the second dimension into the frames of the row that are sequentially arranged along the first dimension, so as to acquire a transposed table; and displaying a transposed table on the display apparatus.

Abstract: By means of this system, the interaction among spreadsheets is completely integrated within the Spreadsheet Management System whereas it does not require the usage of other tools supporting the communication over a network such as web browsers, mailers, and file transfer clients. The interaction is implemented by the Enabling Platform, integrated within the Spreadsheet Management System, and by the Service Platform, located on a computing system that can be reached over the Internet or on a different private network making the Service Platform's intervention not visible to users.

Abstract: A client receives data from a server that includes a dashboard generated at the server by converting each of a spreadsheet file and a dashboard structure file into a text-based, language-independent data interchange format. In addition, the dashboard includes at least one component dependent on at least one prompt. Thereafter, the at least one prompt is asynchronously rendered in a graphical user interface at the client. Data is later received that includes answers to one or more prompts. At least one query is subsequently executed based on the received answers. After results of the executed at least one query is received, the component having a corresponding received answer is rendered in the dashboard. Related apparatus, systems, techniques and articles are also described.

Abstract: According to one embodiment, a content synchronizing method includes: first transmitting when receiving an acquiring request for reference time to determine a timing to synchronize a plurality of pieces of content executed by a plurality of modules with each other from a first module out of the modules, the acquiring request for the reference time to a second module out of the modules; receiving source information indicating an acquisition source of the reference time from the second module; and acquiring reference time information indicating the reference time from the acquisition source indicated by the source information, wherein second transmitting to the first module, together with the reference time information, processing time information indicating processing time from receiving the acquiring request until transmitting the reference time information, the processing time information being used to calculate a time lag between time in the first module and the reference time.

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: 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 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: 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 data filtering system includes a display device and a data filtering engine coupled to the display device. The data filtering engine is configured to display a cell set containing data of a common data type on a display device with at least one cell containing a cell entry. The data filtering engine is further configured to display a filter icon within at least one cell of the cell set and apply a filter to the cell set in response to selection of the filter icon by a user.