Abstract: A system and method facilitating diagramming is provided. The diagram system includes a diagram that stores shape element(s) and an application program interface (API) that includes a control that facilitates access to the diagram. The control maintains state information associated with the diagram. For example, application(s) can employ the API to access and/or modify the diagram. The system employs a rich framework to support both document and diagram state. Because the same framework is used to manipulate the state in a consistent way, it becomes much easier to keep the diagram synchronized with the underlying data than with conventional system(s).

Abstract: Methods and systems are provided for bounding data entered into one or more spreadsheet application cells. A bounding function is applied to a given cell that places bounds on values or formula results that may be entered into the cell. If a user enters a value to a bounded cell that exceeds or otherwise violates the bounds applied to the cell, or if a formula directed to the cell evaluates a value to the bounded cell that exceeds or otherwise violates the bounds applied to the cell, the value entered into the cell will be a value most closely approximating the desired value or evaluated value, but that does not exceed or otherwise violate the bounds set for the cell.