Borland International, Inc.

Percy L Spencer, Ii

Weikuo Liaw

Steven Ray Boye

David A Orton

Max E Montgomery

Michael J Watson

An electronic spreadsheet system of the present invention includes a Formula Composer having a preferred interface and methods for assisting a user with composing spreadsheet formulas. The Composer provides the user with simultaneous formula outline and subexpression (text) views of a given formula. Using the formula outline view, the user may isolate a particular portion (subexpression) of a formula for editing. The Formula Composer also provides a Formula Expert, which is displayed by the system upon the user selecting a spreadsheet function in a formula being edited. In addition to providing specific information about the selected spreadsheet function, the Formula Expert provides input fields which are specific for the arguments of the selected function. Moreover, the Formula Expert includes mode expressions or 'templates' for assisting users in inputting correct argument information. Using pattern matching technique, the system may employ the templates for eliminating common user input mistakes. Methods are described for synchronizing the various views of the Formula Composer, so that a modification to the formula being edited by the user in one view is automatically and immediately propagated to the other views. In this fashion, all views remain synchronized during formula editing, thus allowing the user to easily switch among the views.

Methods for composing formulas in an electronic spreadsheet system

An electronic spreadsheet system of the present invention includes a notebook interface having a plurality of notebook pages, each of which may contain a spread of information cells, or other desired page type (e.g., Graphs page). Methods are provided for rapidly accessing and processing information on the different pages, including displaying a plurality of page identifiers for selecting individual pages, and further including a preferred syntax for referencing information. Additional methods are described for in-memory management and persistent storage of notebooks and their pages.

Growing community of inventors

Scotts Valley, CA, United States of America

Percy L Spencer, Ii