Abstract: To prevent spreadsheet errors, a solution is disclosed that provides a multiple-region spreadsheet including additional representations, providing readily usable creation and editing of computational structure operations, without altering the conventional grid representation of a spreadsheet or its formula syntax. The multiple-region spreadsheet may include a traditional row-column arrangement of cells in a grid format, along with a calculation view pane intended to display underlying formulas used in the grid along with truncated cell assignments.

Abstract: To prevent spreadsheet errors, a solution is disclosed that provides a multiple-region spreadsheet including additional representations, providing readily usable creation and editing of computational structure operations, without altering the conventional grid representation of a spreadsheet or its formula syntax. The multiple-region spreadsheet may include a traditional row-column arrangement of cells in a grid format, along with a calculation view pane intended to display underlying formulas used in the grid along with truncated cell assignments.

Abstract: A spreadsheet application or other application supporting formulaic cells that automatically provides support for a number of diverse formulaic functions. The automatically provided diverse formulaic functions include a function returning the value of the formula logic if the logic can be evaluated without an error. Another function finds a value in a formulaic cell that is in the same row as a particular value from the first column and the same column as a particular value in the first row. Other functions allow a selection of a set of multiple lookup rows and columns for matching the values used as variables in the function. The spreadsheet application is further configured to automatically supply other functions in addition to those described.

Abstract: A spreadsheet application or other application supporting formulaic cells that automatically provides support for a number of diverse formulaic functions. The automatically provided diverse formulaic functions include a function returning the value of the formula logic if the logic can be evaluated without an error. Another function finds a value in a formulaic cell that is in the same row as a particular value from the first column and the same column as a particular value in the first row. Other functions allow a selection of a set of multiple lookup rows and columns for matching the values used as variables in the function. The spreadsheet application is further configured to automatically supply other functions in addition to those described.

Abstract: A spreadsheet application or other application supporting formulaic cells that automatically provides support for a number of diverse formulaic functions. The automatically provided diverse formulaic functions include a function returning the value of the formula logic if the logic can be evaluated without an error. Another function finds a value in a formulaic cell that is in the same row as a particular value from the first column and the same column as a particular value in the first row. Other functions allow a selection of a set of multiple lookup rows and columns for matching the values used as variables in the function. The spreadsheet application is further configured to automatically supply other functions in addition to those described.