Abstract: A method for converting a spreadsheet into a data model includes: obtaining the spreadsheet including a plurality of cells containing data; identifying local structures within the spreadsheet using attributes of the data in the spreadsheet; combining the local structures of the spreadsheet into a generic multi-dimensional model comprising dimensions and data cubes; generating the data model using the generic multi-dimensional model by mapping elements of the generic multi-dimensional model to elements of the data model; and displaying, on a display and to a user, the data model. The dimensions and the data cubes are the elements of the generic multi-dimensional model.

Abstract: A descriptor of a dynamically materialized view is stored. The descriptor includes a query to select a subset of cells from a data sheet, and a result of executing the query. In response to an update directed to the data sheet, the result stored in the descriptor is modified based on re-executing the query, and a notification is transmitted to an execution platform at which an application whose output depends on the dynamically materialized view runs.

Abstract: A method and apparatus for displaying a picture including obtaining n columns of containers; obtaining a height of each column of containers, and taking a maximum value of the obtained heights as a first height; for each target column of containers, determining a height increment of each container in the target column of containers according to a difference between a height of the target column of containers and the first height, and adjusting an ordinate of each container and a height of each container in the target column of containers according to the height increment of each container in the target column of containers; for each column of containers, adjusting a width of each container in the column of containers according to a second height, a ratio of a height of the column of containers to the second height, a preset container gap, the number n of columns, and a width of a display interface; and displaying a corresponding picture in each container after the height, width, abscissa, and ordinate are adj

Abstract: A method may include receiving, from a client, an indication that a first display level includes a first attribute from a first dimension of data and that a second display level includes a second attribute from the first dimension. The data may be stored at a database. A user interface may be generate for displaying at least a portion of the data at the client. The user interface may include a table having a first column corresponding to the first attribute. In response to the client requesting to change from the first display level to the second display level, the user interface may be updated by inserting, into the table, a second column corresponding to the second attribute. Related systems and articles of manufacture are also provided.

Abstract: In an embodiment, a data platform implements a two-sided N dimensional interval join using an N dimensional band join followed by a filter that applies a predicate of the interval join. The data platform generates first and second modified relations from first and second input relations. Each modified relation includes a copy of each row from the corresponding input relation for each input-domain cell that overlaps, in each of N dimensions, a bounding polygon of intervals determined from the row of the corresponding input relation. The data platform inserts, in each row in each modified relation, an input-domain-cell identifier of the corresponding overlapping input-domain cell and uses a hash-equality join that receives the first and second modified relations and that is keyed on the input-domain-cell identifiers. The data platform obtains results of a query by executing a query-execution plan that includes the query-plan section.

Abstract: Embodiments are directed to visualizing data. A graphical user interface (GUI) that includes a shelf panel and a display panel may be generated. Column fields may be generated and displayed in the shelf panel based on a data source or a table specification. The table specification may be employed to generate a table view that may be displayed in the display panel such that the table view includes columns that correspond to each column field. Data items may be determined based on the data source and the column fields such that each column field corresponds to a portion of the data items. Each portion of the data items may be displayed in a column of the table view that corresponds to the column field that corresponds to the portion of the data items.

Abstract: Techniques are described herein for generating and managing Web applications. Embodiments include receiving organized data and analyzing the organized data to determine one or more data types contained in the organized data. Based on the one or more data types, suggested widgets are determined, including determining whether a particular data type can be split into two or more data types and suggesting widgets for each split data type. The suggested widgets are presented to a user, and in response to user input accepting the suggested widgets, a Web application comprising the suggested widgets is generated.

Abstract: A method for designing a logic flow for a user interface is provided. The method comprises receiving from a first task for an automation process file from a user. The automation process file defines a set of system activities. The first task is added to the automation process file and submitted to a machine learning engine, which determines a number of suggested tasks to be performed after the first task. The suggested tasks are based on frequencies with which previous users have used each task after the first task. The suggested tasks are then presented to the user. A second task is received from the user to be performed after the first task. The second task may be selected from the suggested tasks but not necessarily so. The second task is then added to the automation process file.

Abstract: Systems, methods, and computer-readable media for automatic generation of customized lower-level table templates based on data in an associated higher-level table structure are disclosed.

Abstract: A file management system may include a file server that performs calculations of a spreadsheet file instance to generate a dataset that includes values in the spreadsheet file instance. The file management system also may include an application operating at a client device that is in communication with the file server via a network. The application may receive, via the network, a version of the dataset comprising the values generated by the calculations performed by the server. The application may visualize a spreadsheet at the user interface. The visualized spreadsheet may display at least a subset of the values. In one case, protected contents of one or more cells in the spreadsheet may be converted to other values when displayed at the user interface.

Abstract: Flexible yet efficient “find” operations search source code for matches to a general pattern after a developer provides an example string that matches the pattern, without requiring the developer to write a regular expression or script that will implement the desired pattern. Example-driven find-replace functionality uses regular expressions or other pattern match codes, and scripts or other transforms, which are synthesized automatically from examples provided by a developer. This technology allows the developer to focus on workflow inside an integrated development environment instead of breaking focus to search for external documentation, or unfortunately foregoing the flexibility and power of regular expressions and scripts. Synthesizer outputs may be directly or indirectly ranked through user feedback, allowing their refinement. Find match generality may be controlled, e.g., by specifying regex star positions or star counts. Entry of guiding examples may be assisted by autocompletion.

Abstract: Systems and methods for charting images and/or attributes of images associated with a spreadsheet are provided. For instance, when an image is associated with a spreadsheet, the image may be treated as a new type of data within the spreadsheet. In some aspects, a plurality of images may be associated with a spreadsheet, e.g., within a single cell or within a range of cells. In some aspects, the images themselves, as well as image data (e.g., pixelated data, etc.), image attributes (e.g., opacity, color palette, resolution, aspect ratio, image dimensions, author, creation date and/or time, file name, tags, file size, GPS location information, etc.), and/or spreadsheet data (e.g., values in cells, user comments, etc.) may be incorporated into a report (e.g., a chart) using a spreadsheet charting function, either automatically or by user selection.

Abstract: A computing device is provided, including a display configured to display a graphical user interface (GUI). The GUI may include a table including a plurality of fields arranged in a plurality of primary rows. The GUI may further include a secondary row display selector associated with a primary row. The computing device may further include a user input device. The computing device may further include a processor configured to receive, from the user input device, a first user input selecting the secondary row display selector. In response to the first user input, the processor may output one or more secondary rows associated with the primary row for display in the GUI. The one or more secondary rows may be displayed in the table adjacent to the primary row. The plurality of primary rows and the one or more secondary rows may be displayed in a visually distinguishable manner.

Abstract: A descriptor of a dynamically materialized view is stored. The descriptor includes a query to select a subset of cells from a data sheet, and a result of executing the query. In response to an update directed to the data sheet, the result stored in the descriptor is modified based on re-executing the query, and a notification is transmitted to an execution platform at which an application whose output depends on the dynamically materialized view runs.

Abstract: Various systems and methods are provided for accessing and traversing one or more complex data structures and generating a functional user interface that can enable non-technical users to quickly and dynamically edit and generate detailed reports. The user interfaces are interactive such that a user may make selections, provide inputs, and/or manipulate outputs. In response to various user inputs, the system automatically accesses and traverses complex data structures (including, for example, a mathematical graph having nodes and edges), calculates complex data based on the traversals, displays the calculated complex data to the user, and/or enters the calculated complex data into the reports. The reports may be automatically updated based on a context selected by the user, and the system may automatically publish reports in multiple contexts.

Abstract: The present disclosure provides methods and apparatuses for setting application property and message processing. Based on a setting instruction, an object for the setting instruction is determined. The object is a preset group including at least one application. Properties of all the applications in the group are set uniformly in accordance with the setting instruction. With the above setting process, after a message has been received, a group to which the application as the recipient of the message belongs is determined, a property common to the applications in the group is obtained and the message is processed based on the public property.

Abstract: A broker consumer gateway may interface with a service consumer of a computing device consuming at least one service of at least one service provider, including receiving requests for forms, providing the forms, and receiving submitted forms. A service delivery manager may deliver the at least one service. The service delivery manager may include a consumer session manager that creates at least one consumer session to execute at least a portion of the at least one service, a consumer instance manager that creates at least one instance of the at least one service, and a service coordinator configured to coordinate the delivery of the at least one service, based on a coordination model characterizing the at least one service in which the forms are associated with service states of the at least one service and in which transitions between the service states are executed based on the submitted forms.

Abstract: A computer-implemented method for disaggregating data in a spreadsheet or other data structure hosted on a client computing device includes providing an analyzer module as a plug-in or add-in to a spreadsheet application on a client computing device. The analyzer module locally performs disaggregation and aggregation processes on data in the spreadsheet on the client computing device. The method includes parsing, by the analyzer module, content entered in a subject cell of the spreadsheet to determine if sets of special syntax characters corresponding to a disaggregation instruction or command precede an amount in the entered content, and accordingly disaggregating or aggregating data in the spreadsheet.

Abstract: The server apparatus according to an embodiment of the present invention improves convenience of a user while suppressing an increase of the load to enlarge a specific area within a business form page. The server apparatus includes a saving unit configured to save business form part information on a business form page, which includes information on a focus area to enlarge a specific area within the business form page. Further, the server apparatus includes a transmission unit configured to transmit the business form part information relating to a request to a client apparatus in response to the request from the client apparatus that displays the business form page. Based on the information on a focus area included in the business form part information, the specific area is enlarged on the client apparatus.

Abstract: A method of displaying a GUI including a multidimensional array of axes includes constructing a multidimensional array of axes, each axis comprising a plurality of entities located therealong, each entity configured to contain data for display on the axis; for a particular axis of the axes of the array, determining an entity first encountered in a first direction along the particular axis which contains data for display on the particular axis; displaying a view of the array of axes, which view comprises at least a portion of the particular axis that precedes the first encountered data-containing entity in the first direction; and, in conjunction with the displaying of the view of the array of axes, providing an indicator of an absence of data for display being contained in each entity of the particular axis preceding the first data-containing entity encountered in the first direction.

Abstract: A simulation system includes at least one processor configured to execute a computer program product, stored upon a storage medium. The computer program product includes a database application, a process simulation application, and an integration tool, where the database application and the process simulation application are discrete, stand alone products. The process simulation application can simulate industry processes using at least one flowsheet, which models a general flow of industry processes. The integration tool can map process simulation application objects and properties to database application objects, can convey information between mapped objects, can perform case management functions, and can perform orchestrated calculation functions.

Abstract: This disclosure provides various embodiments for providing UI services. An application-independent, reusable UI framework receives a request from a first application, to perform a first operation on a first set of data relating to presentation of the first set of data on a UI. A subset of the first set of data is received from a data provider independent of the UI framework. At least one first service is identified in response, the first service hosted by the UI framework and adapted to perform the first operation on the first set of data. The first operation is performed on the subset of the first set of data using the at least one identified first service to produce a first processed set of data adapted for presentation on a UI of the first application. The first processed set of data is sent to the first application.

Abstract: Approaches are described for displaying rotated character strings within cells of tables. In particular embodiments, the display of the rotated character string is handled such that the character string does not extend beyond the edges of the cell. Further, in certain implementations, the character string may be displayed as wrapped and rotated text within the cell, wherein each line of the wrapped character string does not extend beyond the edges of the cell.

Abstract: A system causes display of a visual representation of a cell-based calendar having cells representing data records, where the cells have corresponding visual indicators corresponding to values of the respective data records. The cells are arranged in plural blocks corresponding to time intervals of the cell-based calendar. Event visual indicators transparently overlay cells in at least some of the plural blocks, where the event visual indicators represent events that occurred in time intervals corresponding to the at least some blocks. The events are separate from activities represented by the data records. Providing the event visual indicators transparently overlaid over the cells in the at least some blocks depict a relationship and relative impact between the data records and the events.

Abstract: In one embodiment, a method comprises: providing an electronic spreadsheet having a plurality of cells arranged in an array having a plurality of rows and a plurality of columns; receiving information defining a plurality of items, each of the plurality of items representing a respective set of data usable in populating at least a portion of the plurality of cells of the electronic spreadsheet, at least one of the plurality of items including a table having a plurality of rows and a plurality of columns; associating each of the plurality of items with a respective location in the electronic spreadsheet; associating each of the plurality of items with a respective position in a stack, each of the plurality of items being able to be associated with any position in the stack; and rendering the electronic spreadsheet in accordance with the information defining the plurality of items, the respective location associated with each item and the respective stack position associated with each item.

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: Rendering common cell formatting for adjacent cells is disclosed. In some embodiments, when rendering cells, a set of adjacent cells that have at least one type of cell formatting in common is identified, and the at least one type of cell formatting is rendered as a single entity rather than individually for each cell in the set to prevent visual artifacts between adjacent cells from arising.

Abstract: A method for increasing the information density in providing information on a progress of at least one project, comprises providing at least one project related goal and at least one project related information, the project related information being related to the project related goal. The information characterizing the project related goal is arranged in a first cell in one element of the group of the cells of a first row of a table and the cells of a first column of the table and the information characterizing the project related information is arranged in a second cell of the other element of the group. An information cell of the table is colored in a first color when the goal is achieved and in a second, different color when the goal is not achieved.

Abstract: A plurality of users participate (S1) in an interactive service. A subset of the users is determined (S2) according to the outcomes of the participation. The subset is then displayed in a further participation with the interactive service, within a broadcast.

Abstract: Generally described, embodiments of the present invention provide the ability to utilize dynamic thresholds and dynamic threshold values when generating variable formatting rules to be applied to a range of cells. Dynamic thresholds include, but are not limited to, “Highest Value,” “Middle Value,” “Lowest Value,” “Number,” “Percent,” “Percentile,” and “Formula.” When using a dynamic threshold, dynamic threshold values are determined based on values contained in a selected range of cells.

Abstract: Techniques to select and manipulate table borders as discrete objects are described. In particular, a table border may be selected without having to select a cell that includes the desired border. In one embodiment, for example, a technique may include detecting a selector in proximity to a border in a table. The border in proximity to the selector may be highlighted visually on a display to show which part of the table border may be selected. A selection may cause the highlighted border to be selected. The now-selected border may then be manipulated. Other embodiments are described and claimed.

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 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: Generally described, embodiments of the present invention provide the ability to utilize dynamic thresholds and dynamic threshold values when generating variable formatting rules to be applied to a range of cells. Dynamic thresholds include, but are not limited to, “Highest Value,” “Middle Value,” “Lowest Value,” “Number,” “Percent,” “Percentile,” and “Formula.” When using a dynamic threshold, dynamic threshold values are determined based on values contained in a selected range of cells.

Abstract: The present invention discloses a method for localized scrolling table display in a webpage. The method includes: dividing a table being displayed into at least a 2×2 array of an upper left table, a lower left table, an upper right table and a lower right table; setting the lower left table and the upper right table to hide portions that are beyond display area; and setting the lower right table to hide portions that are beyond the display area and to include a vertical scrollbar and a horizontal scrollbar. The upper right table and the lower right table are controlled by the horizontal scrollbar, and the lower left table and the lower right table are controlled by the vertical scrollbar. The present invention is able to display a table in a webpage with a localized scrolling display and a partial frozen display, and allows unlimited number of data columns and rows in the webpage and still maintains good readability.

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: Described herein are Interactive Size Tables, Variable Size Table Templates, Distributable Size Tables, and related systems and methods that execute and enable generating, publishing, distributing, displaying, modifying, viewing, and interacting with online Interactive Size Tables. Interactive Size Tables are client customizable size tables with interactive features, and, may be generated using Variable Size Table Templates. An example of an executable user interactive feature is size selection by tapping a size displayed on an Interactive Size Table. Another interactive feature is the multiple format feedback feature, which allows users to choose from several different feedback formats and to leave user feedback in sections proximate utilized Interactive Size Tables. User feedback is then made available online and reportable back to generating clients, along with other metrics and usage fees, through a client data purchase and billing interface.

Abstract: A formatting tool enables “smart” copy and paste functions. The “smart” copy and paste functions can be invoked in a context-sensitive manner, depending on the conditions under which the copy and paste functions are implemented. The present invention will automatically include in a selection a paragraph marker at the end of a selected paragraph, if every other textual character in the paragraph has been selected. The present invention will discard a paragraph mark that is included in pasted text if the pasted text is pasted into the middle of another paragraph, indicating that the user prefers the formatting of the pasted-into paragraph. The present invention also reduces inconsistencies in formatting styles that may exist between source and target documents automatically redefining a style in the target document to conform to a corresponding style in the source document. The present invention also automatically adjusts paragraph spacing, in response to text being pasted into a target document.

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: Generally described, embodiments of the present invention relate to applying and evaluating conditional formatting rules to a given range of cells. Additionally, multiple conditional formatting rules may be evaluated to TRUE for the same cell contained in a user interface and multiple formats applied to that cell.

Abstract: A system and method for assisting a user to enter data are provided. The method includes detecting a user's selection of a moveable input zone on each of one or more input documents displayed on the user's screen and detecting a user's selection of a moveable target zone on a target document displayed on the user's screen. Data in the input zone(s) and the target zone is captured for one or more locations of the respective zones and a pattern is learned automatically for filling additional data in the target document based on the captured data. A fill arrangement for filling the additional data in the target document based on the learned pattern is generated, which can be presented to the user for validation.

Abstract: Lines drawn on a touch screen with an inputting window opened are recognized as ruled lines which are parallel with a row or column of a spreadsheet, and a square formed by the ruled lines is set to a cell in the spreadsheet when the square is formed. Consequently, it is possible to create the spreadsheet when a user of a computer simply draws a line with a fingertip or the like over the touch screen, and furthermore, it is also possible to input a value to the cell by specifying the square part drawn with the lines to carry out an operation for inputting data. Thus, there is provided a spreadsheet creating interface which makes the most of a visibility and an operability of the touch screen.

Abstract: Disclosed are methods and systems for cell content alignment. The methods and systems involve retrieving one or more table parameters, the one or more table parameters including size of currently invisible cells in a display window, size of merged cells, the display window size and text size in the merged cells, calculating a position of a text in a visible portion of merged cells based on the table parameters and displaying the text in the merged cells based on the calculated position of the text.

Abstract: Architecture for multi-level undo on a client in grid-based applications. The architecture is a control driven cascading changes system where change tracking works seamlessly in asynchronous (and synchronous) scenarios. A client application is associated with a grid object and, instantiates and configures the grid object. The application can initiate a change to data in the grid and/or the user can edit the data in the grid directly. A result of the change is a notification to the application, the notification including an order key. The application consumes the notification and can then append new changes based on synchronous or asynchronous computations by calling an update function using the order key. The application uses the key to attach further updates which are properly collected together for undo/redo.

Abstract: The invention relates to a method for expanding data cells in a spreadsheet or a report which is associated with a spreadsheet having a number of cells that are displayed in rows and columns wherein at least some of the cells may contain data which is member of a hierarchic structure comprising different hierarchic levels, the methods comprising the following steps: detecting a user request to expand a certain cell, wherein the user request comprises the selection of a cell to be expanded, further detecting a dragging movement performed by the user by means of an input means and expanding the selected cell in reaction to the dragging movement, thereby displaying one or more cells proximate to the selected cell, depending on the length of the dragging movement.

Abstract: The present invention comprises methods and user interfaces for organizing data displayed within a data application. Specifically, the present invention provides methods and systems for arranging the display of the data by a format applied to one or more portions of the data. The formats comprise different visual characteristics of the displayed data. In exemplary embodiments, the data application organizes the data by the fill color of the cell, the font color of the data within the cell, or the type of icon inserted into the cell. The organizations comprise any type of rearrangement of the data. In exemplary embodiments, the data application sorts or filters the displayed data according to the format.

Abstract: Formulas in dashboards can be executed at a client executing web technologies such as HTML5 and JavaScript. The formulas specified by a spreadsheet file are transformed into a pre-defined notation format and then recursively evaluated. Related apparatus, systems, techniques and articles are also 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: 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.