Abstract: To determine a table structure, a spatially ordered sequence of rectangular cells (42) disposed in a two dimensional region is derived. The ordered sequence of rectangular cells is parsed in accordance with a two-dimensional structural grammar (54) having terminal elements corresponding to cells and non-terminal elements corresponding to structural relationship operators. The parsing produces a grammatical expression (52) with the cells represented by terminal elements and structural relationships represented by non-terminal elements.

Abstract: A method for use with a spreadsheet includes storing a cell object, where the cell object includes a location in the spreadsheet of a cell to which the cell object relates and a process associated with the cell, and performing the process on a complex object to produce a result, where the complex object includes a construct comprised of data and code. A display is generated for the cell that is based on the result.

Abstract: Sensor nodes are programmed by representing a sensor node of a sensor network as a field on a displayed page, displaying a list of programs with which the sensor node can be programmed, and programming the sensor node in accordance with user selection of the field representing the at least one sensor node and a program from the list of programs. Also, a spreadsheet application can be configured to receive and display streaming sensor data from one or more sensor nodes of a sensor network.

Abstract: Multi-dimensional data in a relational database is accessed via a conventional spreadsheet application program such as MICROSOFT EXCEL®. The database can be accessed to either read information from the database and write it directly into the spreadsheet, or read information from the spreadsheet and write it directly into the database, i.e., without the data being stored in any intermediary data storage structure between the spreadsheet and database, thereby enhancing operational speed. Predetermined metadata is used to relate database organization to spreadsheet organization.

Abstract: A computer-implemented method and program product of modifying and presenting document data (150). Sub-elements (180) of document elements (TA) are marked as “fixed” elements. When the document data is presented in a visible document area of a computer program processing the document, the fixed elements are presented as long as their associated document elements are presented at least partially. An example for a document element is a table (TA), and its sub-elements can be table headers (180), table rows, and table columns. The associated data used for the presentation are called sliding table headers (430), sliding rows, and sliding columns.