Method and system for the direct manipulation of cells in an electronic spreadsheet program or the like

A method of manipulating data in a computer system, the computer system having a display device and a user controllable pointer positioning device with signal generating means, the pointer positioning device controlling movement of a pointer displayed on the display device, wherein a program is operating on the computer system, the program using a worksheet to store and manipulate data, the worksheet consisting of a grid of intersecting columns and rows, wherein the intersection of each column and row is a cell capable of containing data manipulable by the program, the method comprising the acts of:

• in response to input, selecting a cell or a plurality of cells in the worksheet;
• in response to movement of the pointer positioning device, positioning the pointer over the selected cell or plurality of cells;
• activating a drag mode in response to both the selection of the cell or plurality of cells and the activation of the signal generating means while the pointer is positioned over the selected cell or plurality of cells;
• in response to movement of the pointer positioning device while the drag mode is activated, positioning the pointer over a cell or a plurality of cells in a new area of the worksheet;
• in response to deactivation of the signal generating means, deactivating the drag mode;
• and
• in response to deactivating the drag mode, moving the data contained in the selected cell or plurality of cells to the cell or plurality of cells in the new area of the worksheet thereby enabling the program to modify the moved data.

In a computer system having a display device, a mouse having a predefined mouse button and controlling movement of a pointer displayed on the display device as a first shape, and a spreadsheet having a plurality of cells, wherein at least one cell contains data manipulable by the spreadsheet, the spreadsheet being displayed on the display device, a method of transferring spreadsheet-manipulable contents associated with a first cell into a second cell, the method comprising acts of:

• in response to input, drawing an outside border around the first cell in the spreadsheet;
• in response to movement of the mouse, positioning the pointer over the first cell and changing appearance of the pointer to a second shape to indicate that the outside border may be dragged across the spreadsheet;
• in response to depression of the predefined mouse button while the pointer appears as the second shape and movement of the mouse with the predefined mouse button depressed, dragging the outside border to the second cell;
• and
• in response to a release of the predefined mouse button, moving the contents associated with the first cell into the second cell.