Patent US6549878B1 successfully refreshed from Google Patents.
US6549878B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
System and method for editing a spreadsheet via an improved editing and cell selection model
Assignee: Microsoft Technology Licensing LLC
•
Filing: 1998-12-31
•
Granted: 2003-04-15
•
Expires: 2018-12-31
Abstract
Abstract Editing cells within a spreadsheet to change the contents of a spreadsheet. To enter edit mode and alter the contents of a cell, the user first selects a cell by single clicking a mouse button while the mouse indicator is positioned above the cell. The user then initiates another single click when the mouse indicator is positioned above the selected cell. Once edit mode is active, the user may change the contents of the cell from within the web browser window as desired. Edit mode can be exited through one of three methods: an “exit and save” signal, an “exit and discard” signal, or a click and drag maneuver. The exit and save signal prompts the invention to save all changes to the cell that the user has made. The exit and discard signal prompts the invention to discard any changes made to the cell by the user, revert to the pre-edit mode contents of the edit cell, and exit edit mode. Finally, a click and drag maneuver not only exits edit mode, but selects a range of cells. The click and drag is performed by depressing a mouse button while the mouse indicator is positioned over the edit cell, moving the mouse while holding the mouse button depressed, and releasing the mouse button when the end of the desired range of cells is reached. The range of cells selected will then start with the edit cell and continue to the cell over which the mouse indicator was positioned when the mouse button was released.
Inventors
- 👤 Kent R. Lowry
- 👤 Mark S. Igra
- 👤 Brian Frank
- 👤 Jeanell D. Sullivan
- 👤 Justin M. Maguire, III
- 👤 Matthew J. Androski
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-08 09:49
CPC Classifications
G; G06; G06F; G06F40/00; G06F40/10; G06F40/166; G06F40/177; G06F40/18
Claims Analysis
Total Claims: 20
Claim 1
Independent Claim
141 words
A method for editing a spreadsheet comprising a plurality of cells, comprising the steps: displaying the spreadsheet; when a cursor is positioned over one of the cells of the spreadsheet, receiving a first single click; in response to the first single click, selecting the one of the cells and causing the cursor to have a first predetermined shape when the cursor is positioned over the selected cell and a second predetermined shape when the cursor is not positioned over the selected cell; when the cursor is positioned over the selected cell, receiving a second single click; and in response to the second single click, entering an edit mode for editing the contents of the selected cell and inserting an edit curser in the selected cell at a position above which the cursor was located when the second single click was received.
Claim 2
Independent Claim
141 words
A method for editing a spreadsheet comprising a plurality of cells, comprising the steps: displaying the spreadsheet; when a cursor is positioned over one of the cells of the spreadsheet, receiving a first single click; in response to the first single click, selecting the one of the cells and causing the cursor to have a first predetermined shape when the cursor is positioned over the selected cell and a second predetermined shape when the cursor is not positioned over the selected cell; when the cursor is positioned over the selected cell, receiving a second single click; and in response to the second single click, entering an edit mode for editing the contents of the selected cell and inserting an edit curser in the selected cell at a position above which the cursor was located when the second single click was received.
Claim 3
Dependent Claim
16 words
The method of claim 1 , wherein positioning of the cursor is controlled by a mouse.
Claim 4
Dependent Claim
24 words
The method of claim 2 , wherein the first predetermined shape comprises a plus symbol, and wherein the second predetermined shape comprises an I-bar.
Claim 5
Dependent Claim
120 words
The method of claim 1 , further comprising the steps: when the cursor is positioned over the selected cell, receiving a click and drag operation indication; in response to the click and drag operation indication, providing a first position indication corresponding to the position of the cursor when the click and drag operation indication was received; and in response to the cursor being moved to a second position over a cell other than the selected cell while the click and drag operation indication is maintained, exiting the edit mode, entering a cell selection mode, and providing visual feedback corresponding to a selected region, the selected region including a rectangular area extending from the first position indication to the second position.
Claim 6
Dependent Claim
31 words
The method of claim 1 , further comprising the step of in response to the selection of the one of the cells, displaying a first visual indication around the selected cell.
Claim 7
Dependent Claim
15 words
The method of claim 1 , wherein the spreadsheet is displayed within a web browser.
Claim 8
Dependent Claim
19 words
The method of claim 1 , wherein the spreadsheet is remotely accessible and editable across the World Wide Web.
Claim 9
Dependent Claim
242 words
A computer system for editing a spreadsheet comprising a plurality of cells, comprising: a processing unit; an input device connected to the processing unit; a memory storage device operative for storing a program module; a display device, coupled to the processing unit, operative to display the spreadsheet on a display screen; an input device indicator, operative to move across the display screen in response to a signal from the input device; and a processing unit, responsive to instructions from the program module running on the computer system, operative to: display the spreadsheet within a web browser window; receive from the input device a first single click specifying one of the cells for selection; in response to the first single click, select the specified cell; receive from the input device an indication that the input device indicator is positioned over the selected cell; in response to the indication that the input device indicator is positioned over the selected cell, change the input device indicator to a predetermined icon indicating that an edit mode may be entered for the selected cell; receive from the input device a second single click indicating that the edit mode is desired for the selected cell; and in response to the second click, enter an edit mode for editing the contents of the selected cell and inserting an edit cursor in the selected cell at a position in the selected cell above which the input device indicator is positioned.
Claim 10
Dependent Claim
242 words
A computer system for editing a spreadsheet comprising a plurality of cells, comprising: a processing unit; an input device connected to the processing unit; a memory storage device operative for storing a program module; a display device, coupled to the processing unit, operative to display the spreadsheet on a display screen; an input device indicator, operative to move across the display screen in response to a signal from the input device; and a processing unit, responsive to instructions from the program module running on the computer system, operative to: display the spreadsheet within a web browser window; receive from the input device a first single click specifying one of the cells for selection; in response to the first single click, select the specified cell; receive from the input device an indication that the input device indicator is positioned over the selected cell; in response to the indication that the input device indicator is positioned over the selected cell, change the input device indicator to a predetermined icon indicating that an edit mode may be entered for the selected cell; receive from the input device a second single click indicating that the edit mode is desired for the selected cell; and in response to the second click, enter an edit mode for editing the contents of the selected cell and inserting an edit cursor in the selected cell at a position in the selected cell above which the input device indicator is positioned.
Claim 11
Dependent Claim
13 words
The system of claim 8 , wherein the input device is a mouse.
Claim 12
Dependent Claim
151 words
The system of claim 8 , further operative to: receive from the input device a click and drag operation indication when the input device indicator is positioned over the selected cell; in response to receiving from the input device the click and drag operation indication, providing a first position indication corresponding to a first position of the input device when the click and drag operation indication was received from the input device; in response to the input device being moved from the first position to a second position while the click and drag indication operation is maintained, providing visual feedback corresponding to a selection region, the selection region including a rectangular area extending from the first position to the second position; in response to an indication that the click and drag operation has ended, selecting a range of cells that are included in the selection region and exiting the edit mode.
Claim 13
Dependent Claim
34 words
The system of claim 10 , further operative to, in response to the selection of the specified cell, provide a first indication around the selected cell indicating that the selected cell has been selected.
Claim 14
Dependent Claim
257 words
A computer-readable medium on which is stored a program module for editing a spreadsheet comprising a plurality of cells, the program module comprising instructions which, when executed by a computer, performs the steps of: displaying the spreadsheet; receiving an indication that a cell has been selected; in response to the indication that the cell has been selected, displaying a first visual indication around the selected cell; receiving an indication that a selected cell has been selected; in response to the indication that the selected cell has been selected, entering an edit mode for editing the contents of the selected cell, the edit mode indicated by displaying a second visual indication around the edit cell; receiving position data from an input device, the position data indicative of the position of an input device indicator; receiving from the input device an indication that the edit cell has been selected; in response to the indication that the edit cell has been selected, providing a first position indication corresponding to the position of the input device indicator when the third input signal was initiated; in response to the input device being moved while the indication that the edit cell has been selected is maintained, providing visual feedback corresponding to a selection region, the selection region including a rectangular area extending from the first position indication through the current position data; in response to the input signal terminating, selecting the range of cells that are included in the selection region; and in response to selecting the range of cells, exiting edit mode.
Claim 15
Dependent Claim
257 words
A computer-readable medium on which is stored a program module for editing a spreadsheet comprising a plurality of cells, the program module comprising instructions which, when executed by a computer, performs the steps of: displaying the spreadsheet; receiving an indication that a cell has been selected; in response to the indication that the cell has been selected, displaying a first visual indication around the selected cell; receiving an indication that a selected cell has been selected; in response to the indication that the selected cell has been selected, entering an edit mode for editing the contents of the selected cell, the edit mode indicated by displaying a second visual indication around the edit cell; receiving position data from an input device, the position data indicative of the position of an input device indicator; receiving from the input device an indication that the edit cell has been selected; in response to the indication that the edit cell has been selected, providing a first position indication corresponding to the position of the input device indicator when the third input signal was initiated; in response to the input device being moved while the indication that the edit cell has been selected is maintained, providing visual feedback corresponding to a selection region, the selection region including a rectangular area extending from the first position indication through the current position data; in response to the input signal terminating, selecting the range of cells that are included in the selection region; and in response to selecting the range of cells, exiting edit mode.
Claim 16
Dependent Claim
55 words
The computer-readable medium of claim 12 , further comprising the steps of: receiving an indication that the input device indicator is positioned over the selected cell; in response to the input device indicator being positioned over the selected cell, changing the input device indicator to a predetermined icon indicating that the cell may be edited.
Claim 17
Dependent Claim
23 words
The computer-readable medium of claim 13 , in which the predetermined icon indicating that the cell may be edited comprises an “I” bar.
Claim 18
Dependent Claim
24 words
The computer-readable medium of claim 14 , in which the indication that the user has selected the selected cell is a single mouse click.
Claim 19
Dependent Claim
58 words
The computer-readable medium of claim 12 , further comprising the step of: analyzing whether the contents of the edit cell extend beyond the initial boundaries of the edit cell; and extending the boundaries of the edit cell as necessary to accommodate more data in the edit cell than can be accommodated within the initial boundaries of the cell.
Claim 20
Dependent Claim
26 words
The computer-readable medium of claim 12 , in which the spreadsheet is stored remotely from the program module and is displayed within a web browser window.
References Cited (Backward Citations)
US4723211A
Cited
US5021973A
Cited
US5253362A
Cited
US5848187A
Cited
US6112214A
Cited
US5623282A
Cited
US5590259A
Cited
US5450539A
Cited
US5581686A
Cited
US6259446B1
Cited
US5717877A
Cited
US5550563A
Cited
US5604854A
Cited
US5603021A
Cited
US5721847A
Cited
US5598519A
Cited
US6157934A
Cited
US6301586B1
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2006-04-14 | 2006-10-14 | 2007-04-15 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2010-04-14 | 2010-10-14 | 2011-04-15 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2014-04-14 | 2014-10-14 | 2015-04-15 | $7700.00 | Window Closed / Lapsed |