×

Method and system for detecting and correcting errors in a spreadsheet formula

  • US 5,842,180 A
  • Filed: 03/28/1996
  • Issued: 11/24/1998
  • Est. Priority Date: 03/28/1996
  • Status: Expired due to Term
First Claim
Patent Images

1. In association with a computer system, a method for detecting and correcting an error in a formula in a cell of a spreadsheet, comprising the steps of:

  • creating a token for each character entered in the formula;

    adding each token to a formula token stack;

    for each token in the formula token stack, parsing the token to determine whether an error exists in the formula; and

    if an error exists in the formula that is one of a predetermined type of error;

    assigning an error class code based on the type of error; and

    applying an error corrector rule to identify a correction to the error.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×