In an electronic document, merging cells in a table, adding an integrated header to a table, and adding a nested table to a table. A table erasing tool allows a user to merge cells in a table. An indication is received to merge certain cells. The indication indicates at least one cell border for deletion. Cells of the table are merged horizontally across each row that includes at least one indicated cell border. Cells of the table are merged vertically across each column that includes at least one indicated cell border. A determination is made whether there are any successful merges and, if so, the merging tasks are repeated until there are no further successful horizontal or vertical merges. A table drawing tool allows a user to add an integrated header row to a table or create a nested table.

A method and system for calculating values for fields interrelated by circular formulas in a data network is described. The system contains a first calculator for which a first field serves as an input value and a second field serves as an output and a second calculator for which the second field serves as an input value and the first field serves as an output. A conflict checker determines whether a circular conflict exists after input of the input value into the first field or the second field, and a conflict resolver resolves the conflict by suppressing the input value in the first field or second field upon determination of the circular conflict.

Web browser interaction with HTML files is modified to allow for columns of row headings to be defined as non-scrollable so that the headings will always be visible as the data rows are scrolled to the left or to the right. Multiple non-scrollable row headings may be in an adjacent position and certain row headings are allowed to displace other columns of row headings when they are in an adjacent position. A new HTML tag, referred to as the column scroll tag, identifies a column of row headings in a file as non-scrollable depending on the screen position of the column. When there is a column of headings that reach the left-most position of the screen, the columns become locked and remain on the screen. A column scroll tag also has the property of displacement or no displacement. Displacement means that once two non-scrollable columns are adjacent, the right-most non-scrollable column would immediately displace the left-most column non-scrollable column, when the data is scrolled to the left on a screen. When the data is scrolled to the right on a screen, displacement means that once two non-scrollable columns are adjacent, the left-most non-scrollable column would immediately displace the right-most column non-scrollable column, when the data is scrolled to the left on a screen. Non-displacement means that when two columns are adjacent and at the left-most or right-most column positions, they both become locked in such screen positions.

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 including one or more contiguous elements aligned along a given spreadsheet dimension, an element of a range of cells including one or more cells along one or more of the spreadsheet dimensions.

A calculation engine processes user-definable formulas to generate calculation results. A calculation engine may use the following types of data structures: table, column, row, and field. A sub table may be embedded within a row. Operations may be performed at various levels, such as at: table, column, and field. A calculation engine may operate on a calculation table having columns, which may each have an ordered list of formulas. Formulas within such an ordered list may be evaluated in the order specified until one of the formulas is successfully evaluated. A hierarchy of formulas may be formed by a column's formula depending on another column or table. A graph of data dependencies may be prepared for determining an order in which operands and operations should be evaluated and performed.