Abstract: A user interface is provided for allowing a user to quickly and easily connect to data and other informational sources. A user can use a user interface to interact with a collection of connection files to quickly and easily connect to various data sources and other informational sources. The user interface is configured to make data sources available at a glance, providing a user with a convenient and comprehensive display of the data sources. The user interface is designed to be a simplified experience for data import that is helpful to both novice and more experienced users in that the data is presented simply without a lot of extraneous information.

Abstract: Modifying a chart may be provided. Chart elements are pictorially presented to a user for use by the user in modifying a generated standard chart. The chart elements may be presented to the user in a chart ribbon.

Abstract: Methods and systems provide for bi-directional communication between a spreadsheet application worksheet and a database data source that allows modified data to be written from a spreadsheet application to source data in a database data source from which the original pre-modified data was obtained. Offline data changes in a spreadsheet application are cached by a data provider application and are published to a remote data source when the spreadsheet application is synchronized with the data source. Error conditions and data conflicts resulting from new or modified data published to a database data source from a spreadsheet application worksheet are reported to a user of the spreadsheet application worksheet through a data provider application to allow the user an opportunity to resolve error conditions and data conflicts between the user's data changes and other data changes made to the same source data contained in the database data source.

Abstract: An electronic spreadsheet is provided for automatically creating, expanding, and validating lists of cells. A list is created by receiving a user request for selecting a cell range, identifying a list range for the selected cell range, determining a header row for the list range, and generating a border for surrounding the list range. A list is expanded by determining that one or more cells are adjacent to the list and automatically expanding the list to include the new cells. A list is validated by determining a data type of data entered into the list and comparing the data type of the data entered into the list to a list data type. If, as a result of the comparison, the data type of the data entered into the list does not match the list data type, then the data type of the data entered into the list is invalid.

Abstract: An error checker identifies spreadsheet errors by traversing a spreadsheet cell-by-cell and comparing each cell's contents to a list of error rules. When a cell's contents satisfy an error rules, then the cell is identified as containing a potential spreadsheet error. The error checker identifies potential spreadsheet errors and marks the cells containing the potential errors with an error indicator. A drop-down menu is provided that includes an element identifying the error rule that was invoked by the cell's contents and may include one or more recommended actions to resolve the identified error.

Abstract: An interactive tooltip provides access to help information and enhanced editing capabilities. The interactive tooltip is especially useful for a user editing a function within a spreadsheet formula. The present invention integrates HTML-like interactivity with a conventional tooltip to provide a new interface for working with the associated data. The interactivity of the tooltip provides additional levels of help or documentation when requested and provides additional editing navigation functionality within the associated data. The present invention provides a tooltip in close proximity to the associated data, while the associated data is being edited. In the case of a spreadsheet, a tooltip will be provided when the user begins editing a function within a spreadsheet cell.

Abstract: An error checker identifies spreadsheet errors by traversing a spreadsheet cell-by-cell and comparing each cell's contents to a list of error rules. When a cell's contents satisfy an error rule, then the cell is identified as containing a potential spreadsheet error. The error checker operates in both background and foreground modes. In background mode, the error checker identifies potential spreadsheet errors and marks the cells containing the potential errors with an error indicator. A drop-down menu is provided that includes an element identifying the error rule that was invoked by the cell's contents and may include one or more recommended actions to resolve the identified error. The menu can also include selections for referencing a help facility for more information about the identified error, ignoring the error, accessing the cell to edit the cell's contents, and accessing a debugging utility for evaluating and modifying a spreadsheet formula.

Abstract: An interactive tooltip provides access to help information and enhanced editing capabilities. The interactive tooltip is especially useful for a user editing a function within a spreadsheet formula. The present invention integrates HTML-like interactivity with a conventional tooltip to provide a new interface for working with the associated data. The interactivity of the tooltip provides additional levels of help or documentation when requested and provides additional editing navigation functionality within the associated data. The present invention provides a tooltip in close proximity to the associated data, while the associated data is being edited. In the case of a spreadsheet, a tooltip will be provided when the user begins editing a function within a spreadsheet cell.

Abstract: A slurry composed of paper fibers, water, and cement that can then be used for a variety of construction applications is prepared. After draining the majority of the water, the slurry may be molded into blocks, sheets, or any other desired shape to be used as a construction material, or it can be sprayed onto wire shapes to form custom structures. The slurry product can be used as a mortar in conjunction with building blocks that have been made from the slurry, and it can be used as a plaster when mixed with conventional cement and sand mortar. The slurry can also be poured into forms in the same manner as concrete to form blocks for construction applications.