Abstract: Block properties and improved calculated columns properties are provided in a spreadsheet application. Once block properties are set for a group of spreadsheet cells or a spreadsheet list, the properties may be applied to the entire group of selected cells or list as opposed to requiring application of properties to individual cells. If rows or columns are added to the group of selected cells or list, properties applied to the group of cells or list are automatically applied to the new rows or columns. Block properties also provide for intelligent-behaving list borders where list borders are not corrupted by the movement or changing of columns or rows sharing edges with a list border. Calculated columns are a type of block property that extends the functionality of formulas throughout an entire column of an associated group of cells or list.

Abstract: A render engine for a spreadsheet application is described. The render engine facilitates the rendering of cell regions containing data that are maintained by both a spreadsheet application (user-defined cell region) and/or a third-party application (application-defined cell region). In particular, an embodiment of the render engine facilitates the repositioning of one or more existing cell regions within a spreadsheet interface, when the insertion of a new cell region is determined to cause a layout conflict with one or more existing cell regions. Repositioning of the existing cell regions is achieved without overwriting any cell information, and without breaking any formulas contained within an affected cell.

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

Abstract: A method of managing a spreadtree hierarchy comprises storing at least one spreadsheet in a network environment accessible to a plurality of users, and storing at least one data object in the network responsive to an edit of the at least one spreadsheet, the at least one data object having a unique ID and data associated with the edit. A spreadtree system comprises an application server configured to operate within a network (Internet or Intranet), and further configured to communicate with a plurality of clients and manage a spreadtree hierarchy. The spreadtree hierarchy comprises a plurality of linked spreadsheets having reference files stored within the network, and a plurality of data objects associated with the plurality of linked spreadsheets. Each data object of the plurality includes a change to at least one cell in at least one linked spreadsheet of the plurality. A method for operating a spreadtree hierarchy system is also disclosed.

Abstract: Block properties and improved calculated columns properties are provided in a spreadsheet application. Once block properties are set for a group of spreadsheet cells or a spreadsheet list, the properties may be applied to the entire group of selected cells or list as opposed to requiring application of properties to individual cells. If rows or columns are added to the group of selected cells or list, properties applied to the group of cells or list are automatically applied to the new rows or columns. Block properties also provide for intelligent-behaving list borders where list borders are not corrupted by the movement or changing of columns or rows sharing edges with a list border. Calculated columns are a type of block property that extends the functionality of formulas throughout an entire column of an associated group of cells or list.

Abstract: Table styles provide a way to format an entire spreadsheet table quickly and easily. According to described implementations, table styles can be created and customized for repeated use in a spreadsheet application. As a result, a user does not have to manually modify multiple formatting options for each table included in one or more spreadsheets. A graphical user interface is also described that provides simple user access to existing table styles that can be modified according to the user's requirements.

Abstract: Concepts and technologies are described herein for progressive loading for web-based spreadsheet applications. In accordance with the concepts and technologies disclosed herein, a user device can access data from a remote source such as a server computer. The user device can determine dimensions of a viewport corresponding to a viewable portion of the data, a window associated with the viewport, and a preloaded area associated with the window. The user device can request the data associated with the window and the preloaded area and store the data in a cache associated with the user device. The cached data can be used by the user device to generate UIs for displaying the spreadsheet. If the user device detects movement of the viewport, the user device can render a new UI in response to the movement. The user device also can be configured to update and/or clean the cache.

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: Described herein are mechanisms for automatically generating a computer-executable program that transforms a first table in a first format to a second table in a second format by way of user-provided examples. A user provides an exemplary input table of a first format, where the input table may be a portion of the first table. The user also provides an exemplary output table of a second format, wherein contents of the output table correspond to contents of the input table. Based upon these user-provided examples, a table transform program is automatically generated, wherein the table transform program, when executed over the first table generates the second table.

Abstract: The disclosed system and method apply stores of factual information to correct errors in digital text, for example, generated from OCR, speech and/or handwriting recognition devices, and other automatic recognition devices. A text produced by OCR, speech recognition, handwriting recognition, and others may be processed to extract discussed facts. Databases of facts are searched based on information in the text. After comparing facts asserted in the text with the factual data from the databases, suggested corrections of the text are produced.

Abstract: Disclosed herein are systems, methods, and non-transitory computer-readable storage media for managing spreadsheets with decision tables. The exemplary method includes generating an underlying data model associated with a visual data model of a spreadsheet containing a decision table, populating the underlying data model based on information contained in the visual data model and based on the decision table, generating a first index for mapping cells in the visual data model to cells in the underlying data model consistent with the decision table, and generating a second index for mapping cells in the underlying data model to cells in the visual data model consistent with the decision table.

Abstract: Systems and methods for providing, sharing, storing and playing widgets and associated media content on a personal audiovisual device, such as a digital photo frame, are described. In one implementation, widgets may be selected by a user for rendering based on capabilities of a user's device, with the widgets then provided to the device for playback. Digital content such as audio files, images, and/or video may be rendered in conjunction with playback of the widget. Widgets may be shared between users so as to facilitate sharing of media content.

Abstract: An application is executed which provides a grid display and which includes: a spreadsheet generator for generating a screen comprising a group of display elements; a scroll controller for accepting a scroll operation of a screen displayed on a display device and for controlling the scrolling of the screen. If a cell is excluded from and a cell is newly included in a visible region displayed on the display device as a result of a scrolling operation, the scroll controller causes the cell included in the visible region to be displayed on the display device by modifying a content of an attribute, including location information, of a display element used to display the cell excluded from the visible region to a content for displaying the cell included in the visible region.

Abstract: Disclosed is a display control device including a selection information acquiring part 2 for acquiring a program ID showing a program currently being selected from among a plurality of cells which construct an electronic program guide, a cell searching part 3 for referring to attribution information stored in a cell attribute information storage unit 1 to search through the plurality of programs for programs each having the same attribute as the program currently being selected, and a reallocation processing part 4 for deleting the cells other than the cell currently being selected and one or more cells found by the cell searching part 3 from the plurality of cells, and for shifting the cell currently being selected and the one or more cells found by the cell searching part 3 forward in a vertical direction or in a horizontal direction to display these cells.

Abstract: Described herein are mechanisms for automatically generating a computer-executable program that transforms a first table in a first format to a second table in a second format by way of user-provided examples. A user provides an exemplary input table of a first format, where the input table may be a portion of the first table. The user also provides an exemplary output table of a second format, wherein contents of the output table correspond to contents of the input table. Based upon these user-provided examples, a table transform program is automatically generated, wherein the table transform program, when executed over the first table generates the second table.

Abstract: A method and system that generate reproducible reports describing one or more analytical functions are disclosed. The reports describe a sequence of analytical functions and allow subsequent executions of the sequence of analytical functions. The matrix space that is inherent in worksheets is used to record a sequence of operations as a tabular report that can be interpreted by a computer program.

Abstract: A sortable and space efficient graphical user interface and a system for the efficient display of sortable data are disclosed herein. The graphical user interface may include at least one column, at least one row and a data cell defined by the intersection of at least one column and at least one row. First and second data may be displayed in the data cell. A first header is associated with the first column and identifies the first data. A second header is associated with the first column and identifies the second data. In the system for displaying sortable data, a graphical user interface is displayed upon a graphical display. A table is displayed as at least a portion of the graphical user interface, the table having a column with a plurality of rows, each row displaying first and second data and a first header associated with a first data and a second header associated with the second data.

Abstract: A system applies an interactive filter. The system includes a data storage device, a display device, a user interface input device, and a processor. The data storage device stores data. The display device displays an initial representation of the data. The user interface input device facilitates a localized selection of a portion of the initial representation displayed on the display device. The localized selection is determined by hovering a navigation icon in alignment with a selection area corresponding to the portion of the initial representation. The processor dynamically applies a filter parameter to the portion of the initial representation based on the localized selection from the user interface input device.

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: 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: Touch input is used for multi-selection of cells within a spreadsheet. For example, a user may drag a finger across the cells of the spreadsheet that they would like to select. The multi-selection of cells may include cells within one or more rows and one or more columns of the spreadsheet. The multi-selection may be adjusted to select more or fewer cells within the multi-selection. The multi-selection of cells may be used for different purposes. For example, the cells within the multi-selection may be used to display summary information related to the multi-selection (e.g. sum, average, median, min, max, count, and the like). The multi-selection may also be used to provide input to a formula that is currently being edited (e.g. a range of cells).

Abstract: One embodiment of the present invention sets forth a method for providing access to a data object from within a spreadsheet included in a spreadsheet application. The method includes associating the data object with a first cell of the spreadsheet, wherein the data object is related to a parameter, and the first cell is identified by a cell reference, receiving an input that is related to a second cell of the spreadsheet and includes an expression that specifies the parameter and the first cell reference, and replacing the first cell reference specified by the expression with the data object, wherein a value for the second cell may be determined by applying the parameter to the data object specified in the expression.

Abstract: In the case of editing document data that has a plurality of fields, by allowing the user to identify a field that is closely related to the selected field, operability of the editing operation of the document data is improved. A selection field detecting unit detects one of the fields according to the operation of the user. An automatic level allocating process executing unit decides the relation degrees between the detected selection field and the other fields. A field enlarging/contracting unit and a display screen control unit switch display control regarding those other fields based on the relation degrees.

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: In one aspect, the present invention relates to utilizing a spreadsheet by defining a parameter external to the spreadsheet and associating the parameter with the spreadsheet to define a parameterized workbook. In one embodiment, this utilization further comprises storing a location of the spreadsheet and storing the name of the parameter in the same storage module as the location. In another embodiment, it includes defining a result external to the spreadsheet, the result referencing one or more cells within the spreadsheet. In another embodiment, this utilization further comprises receiving a value for the parameter and generating the result based at least in part on the value and the spreadsheet. In another embodiment, it further comprises associating a type with the parameter. The type can define a range of values or attributes associated with the parameter.

Abstract: A method, system, and apparatus are provided for exposing and calling workbook models via remote function calls. According to the system, a client computer executes a spreadsheet program for creating a workbook model. The workbook model may be published to a server computer along with data defining a function name and the cells that should be used as inputs and outputs to the model. The system also includes a server computer that receives and responds to remote function calls directed toward workbook functions. When a function call is received at the server computer for a workbook function, the server computer populates the cells in the workbook identified as inputs with input parameters received with the function call and recalculates the workbook. The data contained in the output cells is then returned as a reply to the remote function call.

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 scheduling application prints a portable pocket sized hardcopy of information items such as scheduled items and task lists, and prints the information onto the pocket sized hardcopy in a consistent manner on each visible side of the hardcopy by rotating and inverting the printed material in anticipation of subsequent folding. The consistent manner encompasses inverting and arranging portions of the hardcopy along fold lines to enable folding that results in an upright orientation to the displayed text and figures. Conventional scheduling mechanisms are typically unwieldy to quickly initiate and enter a single item or entry. Electronic mediums need to be powered on, a keystroke, stylus, or pointing device sequence applied to access the corresponding scheduling or notepad application, and the information entered. Conventional paper mediums tend to be bulky and thus typically in a briefcase or purse, and often have binders or covers as well as page tabbing systems that need to be navigated.

Abstract: An enhanced find and replace feature for a spreadsheet program module is disclosed. The enhanced find and replace feature allows users to search for terms and attributes across multiple sheets of a workbook. The find and replace feature also allows searches to be performed based on the formatting attributes of a cell as well as the textual or numerical contents of a cell. The enhanced find and replace feature also allows users to perform bulk formatting of cells (even cells without text) in a spreadsheet. In another aspect, the enhanced find and replace feature lists all the results of the find operation in a results list so that the user may choose which result(s) to view and edit.

Abstract: The present invention includes a method and system for persistently self-replicating multiple ranges of cells through a copy-paste operation, in a multi dimensional spreadsheet. A set of ranges of cells is defined, wherein each range of cells has the same size. Each time the content of a range of cells belonging to this set is changed, a self-replication operation is performed automatically. The self-replication operation includes the steps of copying the changed range of cells onto a buffer; determining the set of ranges of cells to which the changed range of cells belongs; identifying the ranges of cells belonging to the set; and pasting the content of the buffer in each of the identified range of cells belonging to the set.

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: Described herein are mechanisms for automatically generating a computer-executable program that transforms a first table in a first format to a second table in a second format by way of user-provided examples. A user provides an exemplary input table of a first format, where the input table may be a portion of the first table. The user also provides an exemplary output table of a second format, wherein contents of the output table correspond to contents of the input table. Based upon these user-provided examples, a table transform program is automatically generated, wherein the table transform program, when executed over the first table generates the second table.

Abstract: Data formatting rules to convert data from one form to another form are automatically determined based on a user's edits. A machine learning heuristic is applied to a user's edits to determine a data formatting rule that may be applied to data. For example, a user may make edits that add/remove characters from data, concatenate data, extract data, rename data, and the like. The machine learning heuristic may be automatically triggered in response to an event (e.g. after a predetermined number of edits are made to a same type of data) or manually triggered (e.g. selecting a user interface option). The data formatting rule may be applied to other data and the results of the formatting reviewable by the user. Based on further edits/reviews, the data formatting rule may be updated. The data formatting rules may be stored for later use.

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: An enhanced find and replace feature for a spreadsheet program module is disclosed. The enhanced find and replace feature allows users to search for terms and attributes across multiple sheets of a workbook. The find and replace feature also allows searches to be performed based on the formatting attributes of a cell as well as the textual or numerical contents of a cell. The enhanced find and replace feature also allows users to perform bulk formatting of cells (even cells without text) in a spreadsheet. In another aspect, the enhanced find and replace feature lists all the results of the find operation in a results list so that the user may choose which result(s) to view and edit. In another aspect, the find and replace feature is modeless so that a user can search for terms or attributes, view a results list, exit the find and replace feature, perform editing functions in the document and then return to the find and replace feature.

Abstract: First, second, and third sets of spreadsheet cells are defined in a display, the first and second sets being separated by a first boundary having a selected orientation, the second and third sets being separated by a second boundary having the selected orientation. A selected scrolling function is disabled within selected sets among the first, second and third sets of cells in accordance with an alternating pattern.

Abstract: A DataGrid user interface (UI) control is presented that is configured to display a table that includes columns corresponding to fields in a data source and rows corresponding to records in the data source. The DataGrid UI control is also configured to display a details section associated with each row in the table. One or all of the details sections can be displayed or hidden based upon properties specified by a developer or input made by a user. A property may also be set to cause the details section for a row to be displayed only when a user interface cursor is hovering over the row associated with the details section. A property may also be set to cause a details section for a row to be displayed only when the associated row is selected.

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: Implementing a digital contact sheet generator includes receiving input parameters from a remotely located user to create a table. The table includes one or more table cells, each of which comprises a text cell and an image cell. The input parameters define an appearance of the contact sheet and the table. Each table cell is formatted by selecting an image from a set of source media and calculating a size of the image cell associated with the particular table cell. A location of the image cell within the particular table cell is then determined and the image is resized. The image cell is repositioned and the resized image is drawn in the image 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: An electronic device receives a number of HTML files in a queue. The electronic device reads the HTML files in a spreadsheet format, whereby sets of test data in the HTML files are read as cells of a spreadsheet in EXCEL. Values and names are extracted from the sets of test data by the electronic device. The electronic device compiles the extracted values and names and generates a test report file from the complied values and names.

Abstract: A system and method are described for maintaining consistent table behavior when in different modes of operation. For example, a computer-implemented method according to one embodiment of the invention comprises: generating a table containing a selection column comprised of selectable cells, the table having a current lead selected row; providing a user with the option to select between an editable mode and a read only mode for the table, wherein, when in the editable mode the user is permitted to edit one or more cells within the table; detecting user input in relation to the table, wherein: if the user selects an editable cell when in the editable mode, allowing the user to edit the contents of the cell without changing the lead selected row; if the user selects a cell in read only mode, maintaining the current lead selected row; and changing to a new lead selected row in both the editable mode and the read only mode only if the user selects the new lead selected row from a cell within the selection column.

Abstract: A system that facilitates a grid-based approach to defining styles for a table. During operation, the system allows a user to define a new table style by specifying styles for cells in a two-dimensional grid of table cells, wherein a style for a given cell specifies one or more attributes for the given cell. The system then applies the new table style to a target table, wherein applying the new table style involves repeating or tiling a pattern of cell styles defined in the two-dimensional grid across the target table.

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 computing system performs a column adjustment process. The column adjustment process uses multiple threads to determine overall maximum column widths for each column in a set of target columns in a spreadsheet table. For each of the target columns, the overall maximum column width for the target column is based on the width of the widest textual representation of a value in any cell in the column. The set of target columns includes at least one column. The computing system then reflows the spreadsheet table such that each column in the set of target columns has a width based on the overall maximum column width for the column. A similar process is performed to adjust the height of rows.

Abstract: In one aspect, the present invention relates to utilizing a spreadsheet by defining a parameter external to the spreadsheet and associating the parameter with the spreadsheet to define a parameterized workbook. In one embodiment, this utilization further comprises storing a location of the spreadsheet and storing the name of the parameter in the same storage module as the location. In another embodiment, it includes defining a result external to the spreadsheet, the result referencing one or more cells within the spreadsheet. in another embodiment, this utilization further comprises receiving a value for the parameter and generating the result based at least in part on the value and the spreadsheet. In another embodiment, it further comprises associating a type with the parameter. The type can define a range of values or attributes associated with the parameter.

Abstract: The present invention relates to the field of information processing involving digital computers, embedded devices and more particularly, to a method and system for defining hierarchical data model and related computation and instructions rules using electronic spreadsheet like interface. The system and method of the invention are directed to user friendly, fast, development of multi-user, workflow enabled applications using spreadsheet as a tool for application modeling.

Abstract: To perform a sort operation on a spreadsheet table, data items in the spreadsheet table are divided into a plurality of blocks. Multiple threads are then used to sort the data items in the blocks. After the data items in the blocks are sorted, multiple threads are used to merge the blocks into a final block. The final block contains each of the data items in the spreadsheet table. A sorted version of the spreadsheet table is then displayed. Data items in the sorted version of the spreadsheet table have the same order as an order of data items in the final block.

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