Computer graphics processing and selective visual display system – Display driving control circuitry – Controlling the condition of display elements
Reexamination Certificate
1998-02-20
2001-05-01
Bayerl, Raymond J. (Department: 2773)
Computer graphics processing and selective visual display system
Display driving control circuitry
Controlling the condition of display elements
C345S950000, C707S793000
Reexamination Certificate
active
06225996
ABSTRACT:
BACKGROUND OF THE INVENTION
1. Field of the Invention
The present invention relates generally to software applications such as spreadsheets, and more particularly to a system and method of displaying a current value for the contents of a cell of a document, when the portion of the document containing the cell is not currently visible.
2. Description of Background Art
In many software applications, on-screen “windows” are employed to display documents or files. It is well known in the art to provide scrollable windows which are capable of displaying selected portions of such documents or files in response to user specification of scroll commands and resize commands. The user may click on on-screen buttons, or may use keyboard commands, to specify resizing and scrolling operations in various directions and thereby navigate within a document. In this manner, documents containing large amounts of information exceeding the display area of the screen may easily be viewed and edited.
Though such on-screen windows are very useful in facilitating visually intuitive navigation within a document, there are limitations inherent in such a scheme. In particular, the displayed portion of a document, specified by the size and position of the window in a larger “virtual” space comprising the entire document, is generally limited to a single contiguous rectangular region. Thus, for example, in a spreadsheet application containing a plurality of cells, the user may specify a size and position of an on-screen window and thereby obtain a view of a particular contiguous rectangular region within a spreadsheet document. However, conventional systems do not permit simultaneous display of a cell that does not belong to the contiguous region so specified.
In many applications, such display of a cell or cells that do not belong to the contiguous region currently being displayed would be very useful. In spreadsheet applications, for example, formulas may be entered in cells, so that a displayed result in a particular cell comprises a value that is dependent upon values entered in other cells. Thus, a user may wish to edit a value in one cell while observing the results of such editing operations on a second cell. When the second cell is located in close proximity to the first cell, it may be possible to view both cells within the same on-screen window. However, when the second cell is not located in close proximity to the first cell, the user cannot normally view both cells simultaneously. Thus, in order to view the results of the edit operation on the first cell, the user must manually scroll to the second cell, bringing it into view. In tasks involving multiple such edits, this manual scrolling operation is laborious and timeconsuming.
Of course, the user may simply enlarge the on-screen window so that it includes the cell being edited as well as the cell being viewed. However, such enlargement is typically limited by the size of the display screen. Large display screens are available, but they may be expensive and impractical, and may still be insufficiently large to display widely-separated cells in a document. Many spreadsheet applications have usable areas (such as 255 columns by 8,192 rows) far exceeding the display space of conventional screens.
Another solution is that the user may open a second window to display a second contiguous region of the document. Many software applications permit the use of multiple, independently scrollable windows for viewing the same document. However, since each such window typically includes its own title bar, scroll bars, and the like, considerable screen space is consumed by opening multiple windows. In addition, the windows may overlap, making operation and navigation difficult and confusing.
Some applications are capable of displaying a window in a split-pane format, wherein two noncontiguous areas of the document may be displayed in the same window. Each pane within the split-pane window can be independently scrollable along one or both axes. Such a technique may be useful for viewing two or more portions of the same document. However, as with the independently scrollable windows described above, considerable screen space may be consumed by the title bars and other overhead associated with the split-pane format. In addition, the split-pane format generally requires display of the entire displayable portion of a particular row or column, and therefore is not well suited to displaying a single cell in one of the panes, while simultaneously displaying a separate region of the document containing multiple rows and columns.
What is required, then, is a system and method of displaying contents of a cell that does not belong to the group of cells currently displayed in an on-screen window, without unduly reducing available screen space.
What is further required is a system and method of accepting user commands specifying which cell contents to display, in a manner that is user-friendly and does not require extensive user manipulation of on-screen controls and/or commands such as scrolling and resizing windows.
SUMMARY OF THE INVENTION
In accordance with the present invention, there is provided a system and method of displaying the contents of a cell regardless of whether the displayed on-screen window includes the cell. In this manner, a user can view contents of a cell simultaneously with the display of another area of the document. This is particularly useful in software applications, such as spreadsheets, where the contents of a first cell may depend upon values entered in other, widely separated cells, so that the user may wish to change values in some cells while viewing the results of such changes in the first cell.
The present invention provides a cell contents display field that is displayed on the screen or other display device. In one embodiment, the display field is located in a status bar and is therefore separate from the on-screen window showing the active document.
A particular cell is selected for display in the display field. The manner of selecting a cell depends upon the type of software application, but may be as simple as dragging the cell to the area of the screen containing the display field, or invoking a command from a menu or from the keyboard.
Once a cell has been selected, the contents of the cell are displayed, regardless of whether the cell is currently displayed in an on-screen window. If the user scrolls the on-screen window so that the cell is no longer visible, the display field nevertheless continues to display the cell contents. If the contents of the cell change, the display field is updated accordingly, to reflect the change. In this manner, the user is able to view the effects on the selected cell of any changes he or she makes to other areas of the document.
In one embodiment, as will be described below, the display field is editable. The user can then make changes to the contents of the selected cell by editing the display field. Such changes are reflected in the original location of the selected cell as well as in the display field.
REFERENCES:
patent: 5588105 (1996-12-01), Foster et al.
patent: 5715413 (1998-02-01), Ishai et al.
patent: 6055548 (2000-04-01), Comer et al.
Screen prints from MicroSoft Excel '97 application (pp. 1-5), 1997.
Freeman Thomas D.
Gibb Gary L.
Bayerl Raymond J.
Corel Corporation
Fenwick & West LLP
Luu Sy D.
LandOfFree
System and method for displaying a current value of a cell... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with System and method for displaying a current value of a cell..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for displaying a current value of a cell... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2532677