Abstract: A method comprising obtaining a plurality of values from tabular data, computing a plurality of visual parameters, responsive to an associated data value, each visual parameter determined according to one or more of a user-specified selection of cells, a user-specified color visual effect, a user-specified range of color variation, and a corresponding user-specified range of data values, automatically calculating one or more variations of the color visual effect, controlling the color visual effect rendered on at least a portion of the tabular data responsive to the at least one visual parameter, and rendering the color effect within the cells of the portion of the tabular data to visually supplement the display of the portion of the tabular data responsive to at least one data value comprised by the user specified selection of cells.

Abstract: A networked version of a spreadsheet application can be automatically created from an existing “conventional” spreadsheet. In one implementation, a server may obtain a data file, where the data file represents a networked version of a spreadsheet application that was converted from the “conventional” application and the data file defines characteristics of the networked version of the spreadsheet application including logic and interactivity attributes of cells in the networked version of the spreadsheet application. A remote request may be received from a client to access the networked version of the spreadsheet application. In response, the server may transmit a document to the client that represents a portion of the networked version of the spreadsheet application that the interactivity attributes specify as being displayable to the client.

Abstract: Systems and methods for providing filters for collaborative spreadsheets include storing a spreadsheet on a server, where the spreadsheet comprises a plurality of sheets, granting a plurality of client computers concurrent access to the spreadsheet, and receiving from the plurality of client computers a plurality of filters to be applied to a first sheet in the plurality of sheets. The plurality of filters are stored on the server, and the plurality of filters is associated with the first sheet. The plurality of filters are provided to each client computer. When a user on a first client computer in the plurality of client computers applies a first filter in the plurality of filters to the first sheet, the display of the first sheet on a second client computer in the plurality of client computers is independent of the filter application on the first client computer.

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

Abstract: A method and apparatus for displaying data. In one embodiment, the method displays a summary icon at an intersection of a row and a column in a first display state. The method similarly displays the summary icon and the data represented by the summary icon by expanding a display pane to accommodate the data in a second display state.

Abstract: User interfaces for navigating structured content. In one example embodiment, a user interface for navigating structured content includes a grid and a plurality of multi-dimensional cells each having a unique position in the grid. Each cell is configured to display only a first dimension of structured content before selection and display one or more additional dimensions of structured content upon selection.

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: Methods, systems, and machine-readable mediums are disclosed for viewing multiply-dimensioned data. In one embodiment, a method is disclosed which comprises displaying multiply-dimensioned data in a table format, the table format having a plurality of rows, a plurality of columns, and a plurality of cells displaying data, a first column of the plurality of columns including data having at least two hierarchical levels. Data for at least a first set of the plurality of cells is displayed in a graphical format, the first set including cells in the first column, the graphical format of the cells in the first set in the first column indicating a hierarchical level associated with the cell data and a mechanism is displayed for a first one of the rows to display at least one additional row having data in the first column associated with a lower hierarchical level of the first row data.

Abstract: A system, method and computer-readable medium are disclosed for providing improved display of a host terminal application interface. A host application translator reads characters stored in a character buffer of a computer host terminal application that is displayed to a user as a table of horizontal rows and vertical columns of characters. The host application translator receives a preference that determines which vertical columns are to be displayed and a second preference that determines the order in which the vertical columns are to be displayed. The host application translator reconfigures the display of the characters by displaying the vertical columns indicated by the first preference in the order indicated by the second preference and displaying information corresponding to the vertical columns that are not indicated by the first preference, thus providing user-selectable controls to expand or collapse this information.

Abstract: A method, apparatus and program product for focusing the display of tabular data wherein the display has multiple rows and columns of cells. A computer running a tabular data application includes a display for displaying the tabular data. The tabular data application includes a routine for defining a user defined area in the tabular data display in a focused display. The routine places indicators at the top, bottom, right side and left side of the focused display. The indicators may be one of an expand indicator or a collapse indicator. A movable cursor in the tabular data display is used to select at least one of the indicators for focusing the display. The routine in the tabular data application expands or collapses the display of tabular data to give a focused display. The expanding or collapsing of the display is determined by whether the selected indicator is an expand indicator or a collapse indicator.

Abstract: The invention that meets the needs identified above is a web browser plug-in or feature comprising a modification program (MP), a configuration program (CP), a table reduction program (TRP), algorithms and rules, that interacts with a web browser to analyze a web page for tables. The analysis consists of interrogating incoming hypertext markup language (HTML) for table structure <table>, <tr>, <th> and <td> tags, and incoming text for delimiters. The configuration program introduces controls into the text for each column and row delimeter that met a criteria for being hideable. In addition, the configuration program introduces controls into the HTML for each column and row tag that met a criteria for being hideable. The configuration program links the controls to a hiding algorithm so that when activated, the appropriate hiding algorithm will act on the row or column associated with the control. The controls are injected before the web browser renders the web page.

Abstract: A method for obtaining data from a user includes receiving a row selection in an input grid, where each column is associated with one of a plurality of primary input variables, and where each row is configured to display primary data corresponding with the plurality of primary input variables, receiving a request to expand the row to display an input form, where the input form comprises a plurality of fields, where each of the plurality of fields is associated with one of a plurality of supplementary input variables, and where the plurality of fields are configured to display supplementary data corresponding with the plurality of supplementary input variables. The method further includes expanding the row to display the input form, obtaining and storing supplementary data for the input form, collapsing the row to hide the input form, and displaying a summary of supplementary data stored for the input form.

Abstract: A method (300) of editing program code is proposed. The program code consists of main instructions written in a high-level language. Typically, the program code further includes one or more sets of service instructions, which are not directly connected to a desired algorithm (such as tracing instructions for debugging purposes, performance measuring instructions, and the like). In the solution of the invention, each set of service instructions is enclosed (321-322) between a pair of predefined comments defining a starting tag and an ending tag. An editor of the program code is provided with commands for automatically disabling (341) the service instructions (converting them into corresponding comments); at the same time, the disabled instructions are condensed (340) on the monitor. Additional commands are available for automatically enabling (368) and restoring (367) the service instructions.

Abstract: The present invention is directed to a method, system and program for displaying and/or hiding, in an electronic multi-dimensional spreadsheet on a user interface, elements of a range of cells, a range of cells having one or more contiguous elements aligned along a given spreadsheet dimension, an element of a range of cells having one or more cells along one or a plurality of spreadsheet dimensions.

Abstract: The present invention is directed to a method, system and program for displaying and/or hiding, in an electronic multi-dimensional spreadsheet on a user interface, elements of a range of cells, a range of cells having one or more contiguous elements aligned along a given spreadsheet dimension, an element of a range of cells having one or more cells along one or a plurality of spreadsheet dimensions.

Abstract: Methods, systems, and machine readable mediums are disclosed for viewing multidimensional data. In one embodiment, a method is disclosed which comprises displaying multidimensional data in a table format, the table format having a plurality of rows, a plurality of columns, and a plurality of cells displaying data, a first column of the plurality of columns including data having at least two hierarchical levels. Data for at least a first set of the plurality of cells is displayed in a graphical format, the first set including cells in the first column, the graphical format of the cells in the first set in the first column indicating a hierarchical level associated with the cell data and a mechanism is displayed for a first one of the rows to display at least one additional row having data in the first column associated with a lower hierarchical level of the first row data.

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: 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: Methods, systems, and computer program products dynamically filter an aggregate report based on values resulting from one or more filters previously applied to the aggregate report. A method involves maintaining a collection of filters to be applied in a designated evaluation order to the aggregate report, applying a first filter to the aggregate report, and evaluating values in the aggregate report to produce aggregate values resulting from applying the first filter. The method also involves applying a next filter to the aggregate report and evaluating the aggregate values in the aggregate report resulting from applying the first filter therein producing aggregate values resulting from applying the next filter to the aggregate report. Additionally, the method involves displaying the aggregate report wherein evaluating values resulting from previously applying any filter to the aggregate report involves evaluating visual values displayed in the aggregate report after each previous filter has been applied.

Abstract: Systems and methods for editing online advertising campaigns from a summary interface. A summary interface can be provided. The summary interfaces shows filed fields associated with one or more advertising campaigns in a view mode. Upon receipt of a request to edit one or more of the fields, the summary interface transitions to an edit mode for editing of the selected fields and editing of hidden fields that are associated with the selected fields and that are not displayed in the view mode.

Abstract: A lightweight information user interface is provided for displaying information about a selected text item, data item or other object in an electronic document that minimizes interruption of workflow with the electronic document. Upon selection of an item in an electronic document a quick look-up function may be invoked for retrieving information from a local or remote information source about the selected item. Retrieved information, for example, dictionary definitions, translations, contacts information and research information, is displayed in close proximity to the selected item in a lightweight user interface.

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: The present invention is directed to a method, system and program for displaying and/or hiding, in an electronic multi-dimensional spreadsheet on a user interface, elements of a range of cells, a range of cells having one or more contiguous elements aligned along a given spreadsheet dimension, an element of a range of cells having one or more cells along one or a plurality of spreadsheet dimensions.

Abstract: A process is set forth for previewing a table attachment on a mobile communication device, and upon identifying table content of interest viewing and/or retrieving the entire table from an attachment server. In one embodiment, a small 4×4 row/column preview is presented on the device of every table found in a document attachment, with the cell content textual information limited to the requesting device display capabilities. This limitation avoids any requirement to download large amounts of individual cell content to the device. Thus, the user is able to quickly identify which tables are of interest and then request a full table download from the attachment server in an on-demand fashion. In this regard, the preview table itself preferably also functions as a link to the full table stored at the server to facilitate easy retrieval to the device for viewing in a spreadsheet view.

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: File formats, methods, and computer program products are provided for representing a workbook in a modular content framework. The modular content framework may include a file format container associated with modular parts. A file format includes logically separate modular parts that are associated with each other by one or more relationships where each modular part is associated with a relationship type. The modular parts include a workbook part operative as a guide for properties of the workbook and a worksheet part associated with the workbook part and operative to specify a definition of cells within a worksheet associated with the worksheet part. The modular parts may also include a document properties part containing built-in properties associated with the file format and a thumbnail part containing associated thumbnails. Each modular part is capable of being interrogated separately, extracted from the workbook, and/or reused in a different workbook.

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: The present invention is directed to a method, system and program for displaying and/or hiding, in an electronic multi-dimensional spreadsheet on a user interface, elements of a range of cells, a range of cells having one or more contiguous elements aligned along a given spreadsheet dimension, an element of a range of cells having one or more cells along one or a plurality of spreadsheet dimensions.

Abstract: In an electronic multidimensional spreadsheet, a method for displaying and/or hiding on a user interface including (A) detecting a command for hiding at least one element in a selected range of cells, the command identifying a display focus level selected among a plurality of ordered display focus levels defined for the selected range of cells; (B) identifying the selected range of cells comprising the element to hide; (C) identifying the selected display focus level; (D) identifying a table associated with the selected range of cells, the table associating each defined display focus level with at least one cell content criteria to apply to the content of the at least one cell; and (E) selectively displaying the element on the user interface based on the relationship of the selected display focus level with the display focus level associated with the element.

Abstract: The present invention is directed to a method for copying and pasting, in an electronic multi-dimensional spreadsheet, displayed elements of a source range of cells onto a destination range of cells, the source range of cells including one or more elements displayed on a user interface and one or more hidden elements, the elements being contiguous and aligned along a given spreadsheet dimension.

Abstract: A system and method for automatically completing a formula of a spreadsheet application, calculator application, accounting application, business application or banking application. One aspect of the present invention is a computer-implemented method for automatically completing formulaic cell data. The computer-implemented method includes a step for substantiating an autocomplete process in response to a user input of formulaic cell data and aggregating autocomplete options based on the user input. Another aspect of the present invention includes displaying a dynamic list of autocomplete options when the user input is a trigger.

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.