Abstract: According to some embodiments, demonstration data is received via a front-end application associated with a business information enterprise system. The demonstration data may then be interpreted in accordance with at least one rule to generate business data. A query may be received at a back-end application associated with the business information enterprise system. At least a portion of the business data may then be presented in accordance with the received query.

Abstract: A method for exporting-importing the content of input cells from a source scalable template instance in a source multi-dimensional spreadsheet to a destination scalable template instance in a destination multi-dimensional spreadsheet comprises the steps of: detecting a command for exporting-importing input cells from a source scalable template instance in a source spreadsheet to a destination scalable template instance in a destination spreadsheet; identifying the source scalable template associated with the source scalable template instance; identifying cells, if there are any, defined as input cells in the element profile of the source scalable template; identifying the destination scalable template associated with the destination scalable template instance; identifying cells, if there are any, defined as input cells in the element profile of the destination scalable template; copying cell per cell, the content of each input cell of the source scalable template instance in each input cell of the destination

Abstract: Pasting a set of cells is disclosed. In some embodiments, a selection of an option to paste a set of cells in a paste destination is received; and in response to determining that the paste destination is not large enough to accommodate a paste operation associated with the selected option, the paste destination is automatically expanded so that the paste destination is large enough to accommodate the paste operation.

Abstract: A method for exporting-importing the content of input cells from a source scalable template instance in a source multi-dimensional spreadsheet to a destination scalable template instance in a destination multi-dimensional spreadsheet comprises the steps of: detecting a command for exporting-importing input cells from a source scalable template instance in a source spreadsheet to a destination scalable template instance in a destination spreadsheet; identifying the source scalable template associated with the source scalable template instance; identifying cells, if there are any, defined as input cells in the element profile of the source scalable template; identifying the destination scalable template associated with the destination scalable template instance; identifying cells, if there are any, defined as input cells in the element profile of the destination scalable template; copying cell per cell, the content of each input cell of the source scalable template instance in each input cell of the destination

Abstract: Methods to facilitate the processing of formatting information for cells in a spreadsheet document described in a markup language are presented. For spreadsheet documents that include a plurality of style objects, cell formatting information may be obtained from a master style object that stores master formatting information. In addition, named style information may be obtained from a style name object that stores named styles. Further, cell specific formatting information, which can override master formatting information, may be obtained from a cell-specific style object that includes cell specific formatting information. Combined cell formatting information for cells may be stored in a cell format object, wherein the combined cell formatting information can comprise named styles, cell-specific formatting information that overrides formatting information in the master style object, and master formatting information that has not been overridden by the cell-specific formatting information.

Abstract: A method of automatic data input/output to/from another document format or data file with a high visibility and an easy document format definition operation, even in a document format having a derivative area as a second data description area in a single cell. The method includes performing an item definition for correlating data or a data field with an item name in a document format, and specifying a difference condition as a description condition unique to the derivative area against a main area as a first description area in the same cell, for the data field having the derivative area as a second data area in a single cell. According to the specified item definition and the difference condition, data or a record as a set of data description areas to be simultaneously referenced at the document data input/output is identified for each of the derivative areas.

Abstract: A method and system for displaying hierarchical data. An orthogonal table structure, which includes a row structure S1, a column structure S2, and an array structure S3, is displayed. S1 and S2 include hierarchical levels of a first hierarchy E1 and a second hierarchy E2, respectively, of linked non-numeric data items. S3 is an array of cells such that every combination of a linear path through S1 and a linear path through S2 has an intersection disposed in the orthogonal table structure at a unique cell of S3. An assignment icon is depicted at each cell of S3, such that selection of the assignment icon at each cell results in displaying data items of a flat vector E3 of non-numeric data items. One of data items of E3 may be selected for insertion or replacement in each cell.

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: A method, system, apparatus, and computer-readable medium for managing and administering a spreadsheet-driven additional living expense calculators are disclosed. Third party data provides data input to the dynamic calculator and validation rules are implemented to preserve data integrity for calculating additional living expenses for policyholders.

Abstract: A method for multi-dimensional performance analysis may be provided. A plurality of data may be displayed in a butterfly diagram comprising a data grid, a histogram associated with column sorting criteria, and a histogram associated with row-sorting criteria. Additional information depth may be provided with conditional formatting of the cells of the data grid.

Abstract: A tool, using an expressly programmed computer which is programmed with executable instructions, that utilizes data mined from web queries to populate a decision matrix for finding an outcome to a query. The decision matrix is a displayed spreadsheet having rows representing fields that are typical for the query. The web yields data that is extracted and stored in the fields for a plurality of such sites. Calculators or operator methods are used for displaying a desired outcome using the fields. The field data may be entered manually when not found on websites. Data may be changed from actual data to represent hypothetical situation or a data field may be deleted. Columnar data is operated upon to determine different outcomes for comparison.

Abstract: Computer-implemented systems and methods are disclosed for providing a business rule repository in a memory. An exemplary method includes displaying, on a display device, a graphical user interface (GUI) for creating a business rule, and receiving, in a computer, via the GUI user input relating to an input variable of the business rule, and user input relating to an action required by the business rule based on the input variable. The method further includes generating, by the computer, a text document associated with the business rule based on the input, and storing the text document associated with the business rule in the business rule repository.

Abstract: A workflow includes an activity that takes advantage of spreadsheet calculations. For a spreadsheet activity, calculation and extraction of values from a spreadsheet is performed. Thus, spreadsheet calculations are integrated into workflows without user intervention. Values from previous activities in the workflow may be obtained and provided to the spreadsheet (e.g., cell values are set, modified, or adjusted). The spreadsheet may then be recalculated using these obtained values. Moreover, values from the spreadsheet may be used in subsequent parts of the workflow. Also, any number of spreadsheet activities may be incorporated into a workflow, and one spreadsheet activity may provide values to a second spreadsheet activity in the workflow.

Abstract: A method and computer system for transforming a portion (e.g., a view) of a database into a custom spreadsheet. The transforming includes determining whether to omit in the custom spreadsheet a column that is in the view, determining whether to add to the custom spreadsheet a column that is not in the view, or both. The transforming may also include implementation of rules that control how various portions of the custom spreadsheet are configured.

Abstract: A system provides an electronic patient parameter Flowsheet offering the flexible features of a paper chart by enabling user configurability of a Flowsheet trend indicative display to incorporate and locate desired patient parameters and associated data items and properties and to hide non-critical supplementary data. A system configures a user interface presenting patient medical parameter data in a trend indicative display indicating a time period comprising user selectable acquisition time intervals. An acquisition processor acquires, from a patient monitoring device, data representing a patient parameter.

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: An improved electronic spreadsheet is provided for applications requiring conditional expression execution behavior. Each cell having an executable expression is cooperative with an implicit conditional execution wrapper. The execution of each cellular expression is implicitly conditioned on the state of an individually assigned logical switch expression. The improved electronic spreadsheet also includes a user interface by which a user can assign logical switch expressions to a cell, or to a range of cells. The improved electronic spreadsheet facilitates the use of spreadsheets for wider range of applications than was possible with conventional electronic spreadsheets.

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: A graphical application developing and managing environment is described capable of representing and editing program modules using multiple display formats, which include embedding source code written in a functional language into a spreadsheet-like format. Methods are described for enabling the sharing of program modules by defining standardized interfaces into program modules and existing documents and by centrally locating module definitions. A patchwork mechanism is described requiring only basic spreadsheet editing skills on behalf of the user, enabling a user of the environment to connect external documents and program modules into a new program application. The invention allows complicated programming and simple end-user programming to be achieved within a unified environment and allows the execution of program modules and tracing of variables simultaneously with the writing of a program application.

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: A computer-implemented method includes designating selected spreadsheet cells within a spreadsheet document. Spreadsheet function source code characterizing the functionality associated with the selected spreadsheet cells is generated. The spreadsheet function source code is incorporated into a source code application.

Abstract: Data cells in a spreadsheet report are collapsed and expanded without disrupting other spreadsheet data. A user may want to drill down on data corresponding to a parent member of the report to display more detailed information about the parent member. Likewise, a user may want to drill up the displayed information corresponding to the parent member to hide detailed information associated with the parent member. Before expanding or collapsing a report, the spreadsheet is scanned for information to determine whether the display of other data in the spreadsheet would be disrupted by the expansion/collapse. The information may include cross-join information associated with the parent member, the number of child members associated with the parent member, the dimension of the report created by the parent member and the associated child members, and other reports that may be linked to the report that includes the parent member.

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

Abstract: According to some embodiments, demonstration data is received via a front-end application associated with a business information enterprise system. The demonstration data may then be interpreted in accordance with at least one rule to generate business data. A query may be received at a back-end application associated with the business information enterprise system. At least a portion of the business data may then be presented in accordance with the received query.

Abstract: Displaying tabular information in a user interface (UI) on a display screen is enhanced by freezing selected non-adjacent columns (rows). Freezing ensures the display of the selected non-adjacent columns (rows) when scrolling to bring other columns (rows) into the table for display. Border rows (columns) may also be frozen when scrolling. A table in a document navigable by moving a focus to scroll the document may be displayed by a UI control configured to automatically display the frozen border rows (columns). When scrolling a focus in the document at an edge of the display screen to bring the UI control into the display, the UI control aligns a portion of the table with the edge and paints the frozen border row (column). The UI control maintain the display of the border row (column) when scrolling through the table.

Abstract: For applications of web-based analytics and business intelligence reporting, methods and systems are provided for exporting a data table as a spreadsheet pivot table by automatic creation of formatted spreadsheet pivot tables with application specific initial views. The views are specified by templates allowing a user to view multiple pivot tables in a single spreadsheet book. Pivot tables are created by a remote server that performs the exporting of the data table so that a user can save the pre created pivot table in his/her local machine. In one embodiment of the invention, the data table on which a pivot table is subject to have a limited number of rows of a spreadsheet data sheet. In another embodiment, the data table on which a pivot table is subject to can exceed the limit of the number of rows of a spreadsheet data sheet.

Abstract: Systems and methods for generating presentationally-rich email messages having imagery and variable height content entry areas that are compatible across multiple email readers.

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: 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: Under the present invention, when a user resizes or otherwise hides a column in the electronic table, a graphical indicia is displayed that represents the hidden column(s). If a user interacts with the indicia (e.g., by hovering a mouse/input device over it), a pop-window will be displayed that identifies the hidden column(s). The pop-up window can include icons representing each hidden column or an associated function. By manipulating the listing contained in the pop-up window, the user can un-hide the hidden table column(s), change their order in the electronic table, etc. In addition, the indicia can be formatted (e.g., boldfaced, colored, or otherwise altered) to reflect a status of an entry or cell in one of the hidden column(s).

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: A system and method for determining business partner value by creating weighted metrics for identifying, evaluating and selecting a business partner for a company; creating a business agreement and weighted metrics for evaluating the agreement; creating weighted metrics for ongoing management of the partner; and managing the partner by ongoing periodic evaluation of the weighted metrics for partner selection, agreement, and management. Both company and partners may participate in the evaluation on an ongoing basis (e.g., once per month or once per quarter) rather than an annual review. In one embodiment, weighted metrics of partner selection, agreement, and management are reported, charted and graphed providing for visual evaluation and side-by-side comparison of the perceptions of company and partner for optimization of the business relationship and prediction of future performance.

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: In a method for identifying cells, line graphics are converted into vectors (12) having a canonical form without vector overlaps or crossings. Connecting vectors (22, 24, 26, 30, 32) are associated, including (i) forking vectors (22) having common starting points, and (ii) meeting vectors (24) having common ending points. A set of vectors is identified including at least two forking vectors and two meeting vectors cooperatively defining a cell.

Abstract: An application entity may be created and defined by a user at an application. Related service entities managed by different service applications may be matched and consolidated. The application entity may be associated with one or more related service entities. Metadata corresponding to the associated service entities may be provided to the application. Such metadata may enable the associated service entities to be managed from within the application.

Abstract: The present invention relates to a display method. The display method includes displaying a labeled column chart on a graphical user interface, where the column chart having a plurality of labels. The display method further includes entering a first modification of one of the labels via a graphical user interface by a user and starting execution of labeling instructions that implement a labeling algorithm for generating a first modified labeled column chart in response to the entry of the first modification. The first modified labeled column chart is displayed.

Abstract: A computer-readable recording medium stores therein a spreadsheet generating program that causes a computer to execute acquiring information related to layout positions of items in a form; column-sorting the items in ascending order, according to column-related coordinate values of the items; determining a column width for each of the items, based on a distance to the previous item in the column-sorted items; row-sorting the items in ascending order, according to row-related coordinate values of the items; determining a row height for each of the items, based on a distance to the previous item in the row-sorted items; designating, for each of the items and from among cells having the determined column widths and the determined row heights, a cell corresponding to a layout position indicated in the acquired information; and outputting a spreadsheet related to layout of the form by a provision of the items to the designated cells.

Abstract: Some aspects include selection of a cell of a report section, the cell associated with a data dimension and with a context of the report section, and association of the cell with an input parameter of a software service. Aspects may include identification of a contextual report specification associated with a software service and with one or more report elements, at least one of the one or more report elements being associated with an input parameter of the software service, determination of data corresponding to a plurality of the one or more report elements, generation of a script to invoke the software service and to pass contents of the at least one of the one or more report elements as the input parameter to the software service, and generation of a report output based on the data and the script.

Abstract: A system architecture integrates spreadsheet functionality into text. The architecture allows insertion of discrete individual fields, referred to as “free floating fields”, inline with normal textual sentences. In an HTML document, for example, the free floating fields are elements constructed along with text elements and rendered together as an integrated document. Once rendered, the free floating fields present contents that resemble normal text consistent with the surrounding text. The free floating fields offer spreadsheet functionality, including the ability to handle complex formulas, reference values in a separate free floating field or table, and automatically recalculate the formulas when a source value changes.

Abstract: An image information control method and apparatus, the apparatus includes a receiving unit configured to receive bit map image data sent from an information process unit, and an accumulating unit configured to accumulate the image data received from the information process unit line by line. A blocked unit is configured to group a plurality of lines of the image data into a predetermined size block of image data. A converting unit is configured to convert the block of image data into a language command corresponding to the image forming apparatus and including the block of image data, and a sending unit is configured to send the language command to the image forming apparatus.

Abstract: A token representation of references and function arguments is disclosed. In some embodiments, an indication that a formula is being entered into a cell is received, and references and/or function arguments in the formula, if any, are represented as tokens. Each token comprises an atomic user interface object. In various embodiments, references are rendered as reference tokens and function arguments are rendered as argument tokens and/or mode tokens.

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: Defining custom cell formats is disclosed. In some embodiments, in response to receiving an indication of a selection of an option to define a custom cell format, a user interface to define the custom cell format is provided, wherein a format element in a definition of the custom cell format in the user interface is represented as a format element token.

Abstract: In many situations, the objective of data entry is to obtain a complex or structured value. This has traditionally been accomplished by providing a discrete entry field for each element of data entry. By extending the notion of an entry filter, and introducing the notion of a discrete editable element within an entry field, it is possible to apply a structure to that entry field. A management component enables one or more entry filters to be associated in turn with each editable element, and ensures that the entry filters are applied correctly to the appropriate elements.

Abstract: A method and system for facilitating information exchange between individuals and entities interacting on a shared project are provided, and more particularly to a method and system for horizontal. i.e. non-hierarchical, participation in and/or contribution to a spreadsheet-based project. The method and system is Web-based and utilizes conventional browser and spreadsheet technology to achieve collaborative exchanges of information on an enterprise-wide basis. The method and system also facilitate efficacious remote information access and exchange, e.g., over a computer network such as the Internet and/or the World Wide Web, through a caching function that combines individual queries initiated by a spreadsheet program before transmitting across a network to a server for consideration.

Abstract: Variable formatting for cells in computer spreadsheets, tables, and other documents is provided. For a selected range of cells, cell formats vary with the value in each cell (or an associated value). Formats can include color-scale backgrounds, in-cell elements (e.g., icons and data bars), and other cell formats that can be varied with a value.

Abstract: A spreadsheet package allows a base formula to be copied to at least one adjacent cell to form a referencing array. The package maintains a list of bound arrays, at least one cell of a bound array being referred to from a referencing array formula. If a formula within a referencing array cell includes a reference to a cell outside a bound array, the package indicates an error in the formula.

Abstract: Described is an information sharing method and mechanism used by a layout system to share information across related column and row user interface elements (corresponding to definitions). Definitions of a table or grid are grouped together with respect to sizing via a common group name. Scope values may be used to limit the grouping to selected subtrees of elements. When layout occurs, size sharing information is determined for the group-related definitions via a common size sharing object. Grouped definitions thus may be sized to the largest content to display of any one element. Elements corresponding to definitions may be manually sized by a user, or may be based on the size of a defined master element, such as the width of a header. The scope value of a group may be changed dynamically, such as by user interaction, which may cause groups to merge or split.

Abstract: A data cell included in a document supporting cell structured data is conditionally formatted according to data that is stored in a separate location from the document. A user is allowed to select from a drop-down menu of related data sets a particular data set for conditionally formatting the data cell. The data cell is formatted according to the data set and the condition without requiring that the data set be stored locally in the document.

Abstract: Input to the system is buffered by the forms manager to determine access to the tile/region and to check entered data. The tile/region will retain various information such as data entered, user, time, changes, etc. To display a form, the forms manager obtains a list of objects to be displayed. This list of objects is then edited to remove objects which are not utilized and to place the remaining objects in a prioritized order. The forms manager then generates the display.