The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Feb. 11, 1997
Filed:
Sep. 02, 1994
Percy L Spencer, Scotts Valley, CA (US);
Steven R Boye, Los Gatos, CA (US);
Max E Montgomery, Santa Cruz, CA (US);
Michael J Watson, Scotts Valley, CA (US);
Borland International, Inc., Scotts Valley, CA (US);
Abstract
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.