System and methods for improved spreadsheet interface with user-familiar objects

CAFC
  • US 5,784,545 A
  • Filed: 04/10/1995
  • Issued: 07/21/1998
  • Est. Priority Date: 04/08/1992
  • Status: Expired due to Fees
First Claim
Patent Images

1. In an electronic spreadsheet system for storing and manipulating information, a computer-implemented method of representing a three-dimensional spreadsheet on a screen display, the method comprising:

  • displaying on said screen display a first spreadsheet page from a plurality of spreadsheet pages, each of said spreadsheet pages comprising an array of information cells arranged in row and column format, at least some of said information cells storing user-supplied information and formulas operative on said user-supplied information, each of said information cells being uniquely identified by a spreadsheet page identifier, a column identifier, and a row identifier, said plurality of spreadsheet pages being stored in a single disk file;

    while displaying said first spreadsheet page, displaying a row of spreadsheet page identifiers along one side of said first spreadsheet page, each said spreadsheet page identifier being displayed as an image of a notebook tab on said screen display and indicating a single respective spreadsheet page, wherein at least one spreadsheet page identifier of said displayed row of spreadsheet page identifiers comprises at least one user-settable identifying character;

    receiving user input for requesting display of a second spreadsheet page in response to selection with an input device of a spreadsheet page identifier for said second spreadsheet page;

    in response to said receiving user input step, displaying said second spreadsheet page on said screen display in a manner so as to obscure said first spreadsheet page from display while continuing to display at least a portion of said row of spreadsheet page identifiers; and

    receiving user input for entering a formula in a cell on said second spreadsheet page, said formula including a cell reference to a particular cell on another of said spreadsheet pages having a particular spreadsheet page identifier comprising at least one user-supplied identifying character, said cell reference comprising said at least one user-supplied identifying character for said particular spreadsheet page identifier together with said column identifier and said row identifier for said particular cell.

View all claims
    ×
    ×

    Thank you for your feedback

    ×
    ×