Desk accessory version: You have to press key to get the pseudo menu for the desk accessory version of SHEET. Many menu options can be selected by using and the operations between PRG and ACC are the same. The desk accessory version has only one window, no commands and the resource file is embedded inside (it means CALC.RSC is not required and that is why the program size of ACC version is bigger than the PRG version). New features for version 1.4: The only thing that I changed is the user interface. It is necessary for ACC users and it is simpler to operate with. Change the width of a single column: There are two ways to do this. You can either select menu item "Width" or use the COLUMN BAR (the one under the line editor) and mouse. You may notice there is a small white gap between each column reference. To change the width of COLUMN A - move the mouse to the white gap between COLUMN A and B, - press the left mouse button (do not release it) - to expand the column width, drag the mouse to right and release the button - to shrink the column width, drag the mouse to left and release the button. - if your column width is 1 character wide, then the column reference will push on the next column. BLOCKS: Each time, you can defined up to 18 blocks for CELLS ERASE, REFORMAT, COPY and MOVE; ROW/COLUMN insertion and deletion. COPY and MOVE only takes 2 blocks. If more or less than 2 blocks have been selected, they simply refuse to do anything (by the way, the COPY and MOVE commands described in version 1.3 will not work. I was forced to upload version 1.3 because a user told me he found version 1.2 was not working properly. The bug is due to I rewrote the redraw routine for 4 windows support. After the screen redrawing, I simply forgot to reset the clipped area for output to current working area. That is why the system seems being locked up. You can bypass this bug by changing window size. I think users may be more happy to use a fixed version than using it inconveniently. That is why you see version 1.3 and that is the way I test the COPY and MOVE commands. I have to say sorry to those who downloaded version 1.2 and 1.3 ). Block selection: The following is the steps for selecting block B5..C14: Starting a block: - move the mouse cursor within the cell B5 - press key and the left mouse button simoutaneously - If you do not choose stopping cell, the current starting cell will be the stopping cell. Stopping a block: - move the mouser cursor within the cell C14 - press key and the left mouse button simoutaneously - You can always change the last stopping cell by the above method. If you are defining the first block, you can use the above method or - move the mouse cursor within the cell B5 - press the left mouse button and drag until you reach cell C14 - release mouse button. Row/Column selection: The following is the steps for selecting COLUMN D: - move the mouse cursor on top of the COLUMN BAR with COLUMN reference D - press the mouse button once. Use the similar procedure to choose a row. De-selecting blocks: Selecting any cell by mouse click without / key will de-select all the blocks being selected. Multiple ranges ERASE: To erase several non-contiguous blocks: - select blocks using above Block selection method - Press or choose menu item Erase under CELLS Multiple ranges REFORMAT: To reformat several non-contiguous blocks: - select blocks using above Block selection method - Press or choose menu item Reformat COPY one block to another block: To copy one block to another block: - select 2 blocks (the first block is the source block and the second is destination block) - Press or choose menu item Copy Note: A block can be single cell (A2), part of a column (A1..A20),part of a row (B20..E20) or a range (A4..C10). The following describes how the program handle different types of block COPY. Source is the first block and destination is the second block. Result is the range size chosen by COPY. Source Destination Result --------------------------------------------------------- Single cell any kind of block the largest range column reference any kind of block the largest range row referenece any kind of block the largest range A range reference any kind of block the source range Example: - If you want to COPY C1 to C2..C20 * Control and mouse click on cell C1 * Control and mouse click on cell C2 * Shift and mouse click on cell C20 * Control C Move a block: Operations is similar to COPY. The range size chosen by MOVE is the range size of source block. Row insertion/deletion: - choose the row by Row/Column selection or choose part of the row by block selection - choose menu item Insert/Delete from menu title Row/Col Column insertion/deletion: - choose the column by Row/Column selection or choose part of the column by block selection - choose menu item Insert/Delete from menu title Row/Col Apology: Someone (Stan50) in GEnie asked me about graph stuff I mentioned in early documentation. I said I could not recall I had mentioned graph capability and simply refused to add graph functions in the spreadsheet program. In preparing this documentation, I referred to early documentation and found I did mention it. Sorry to Stan50. To keep my word, I start working on graph functions now. You can draw graphs on next version. I do want people happy about my product, but the support I got is not comparable to the effort I made. So, please do donate if you like it. Am I asking too much? String starts with "!" COMMAND: Strin