PipeDream has a wide range of commands which enable you to edit your document to make changes and improvements and to correct mistakes. Some editing commands, such as those to insert or delete a column or row, affect the layout of the document. Others enable you to make changes to individual words or letters.
You can insert a new blank line in just one column, or as a row of lines across all the columns on the document. Likewise, you can delete any line from a column, or the row of cells across the whole document.
1. Position the caret where you want the blank row.
2. Give the Insert Row command:
Menu | Command | Ctrl-sequence | Key |
---|---|---|---|
Edit | Insert row | N | F7 |
For example:
1. Position the caret in cell B3:
A | B | C | |
---|---|---|---|
1 | one | one | one |
2 | two | two | two |
3 | three | ![]() |
three |
4 | four | four | four |
5 | five | five | five |
6 |
2. Give the Insert Row command.
A | B | C | |
---|---|---|---|
1 | one | one | one |
2 | two | two | two |
3 | ![]() |
||
4 | three | three | three |
5 | four | four | four |
6 | five | five | five |
The caret will be in a blank cell and the previous text in all columns will move down.
1. Position the caret where you want the blank cell.
2. Give the Insert Row in Column command:
Menu | Command | Ctrl-sequence | Key |
---|---|---|---|
Edit | Insert row in column | EIRC |
3. The caret will now be in a blank cell, and the previous text will move down.
For example:
1. Position the caret in cell B3.
2. Give the Insert Row in Column command.
A | B | C | |
---|---|---|---|
1 | one | one | one |
2 | two | two | two |
3 | three | ![]() |
three |
4 | four | three | four |
5 | five | four | five |
6 | five |
3. The caret will be in a blank cell and the previous text in column B will move down.
Position the caret on the last line and press Enter.
1. Position the caret in the row of cells you wish to delete.
2. Give the Delete Row command to delete the whole row or the Delete Row in Column command to delete a cell from just the one column containing the caret.
Menu | Command | Ctrl-sequence | Key |
---|---|---|---|
Edit | Delete row | Y | F8 |
Delete row in column | EDRC |
For example:
1. Position the caret in cell B3.
2a. If you give the Delete Row command, row 3 is deleted and the rows beneath it move up.
2b. If you give the Delete Row in Column command, only cell B3 is deleted and the other cells in column B move up.
You can insert a new column to the left of an existing column, add a new column at the right-hand side of the document, or delete an existing column.
1. Position the caret in the column.
2. Give the Insert Column command:
Menu | Command | Ctrl-sequence | Key |
---|---|---|---|
Edit | Insert column | EIC |
3. The column containing the caret will move right, and a new column will be inserted with an initial width of 12 characters.
Give the Add Column command:
Menu | Command | Ctrl-sequence | Key |
---|---|---|---|
Edit | Add column | EAC |
3. The caret will be in the new column which is created with a width of 12 characters, and a right margin of zero. Note that when a column has a right margin of zero, the text wraps at the end of the column.
1. Position the caret in the column you wish to delete.
2. Give the Delete Column command:
Menu | Command | Ctrl-sequence | Key |
---|---|---|---|
Edit | Delete column | EDC |
If you change your mind about deleting the column or if you want to move it to another position, you can recover it using the Paste command.
You can split a line of text so that the second part of the line moves to the next row of the document. You may want to split a line when you want to perform a block operation on text that starts or ends in the middle of a line. You can also join the next line onto the end of the line you are on.
1. Position the caret just behind the first character that you want to move to the next line.
2. Give the Split Line command:
Menu | Command | Ctrl-sequence | Key |
---|---|---|---|
Edit | Split line | ESL |
1. Position the caret on the first of the two lines.
2. Give the Join Lines command:
Menu | Command | Ctrl-sequence | Key |
---|---|---|---|
Edit | Join lines | EJL |
3. The text on the next line will be moved up to the end of the line with the caret on it.
The Split Line and Join Lines commands use the Insert on wrap setting in the Options dialogue box to determine how to maintain alignment over the document.
Another way to split and join lines is to turn on the Insert on Return option in the Options dialogue box. Then pressing Enter splits a line at the caret position and either giving the Delete Character command at the end of a line or pressing Backspace at the beginning of a line join lines.
You can add text or blank lines anywhere in the document. Text is always entered at the caret position. PipeDream provides two alternative ways to type text into a document. By default, text you type is inserted before the character at the caret position. If you switch to overtyping, text types over any text previously on the line.
The
sub-menu has an option called , which has a tick next to it by default to show that all text you type will be inserted. To change to overtyping, click Select on the option. The tick will disappear and what you type will overwrite what was there before.You can alter text which you have typed in from upper-case to lower-case and vice versa with the Swap Case command:
Menu | Command | Ctrl-sequence | Key |
---|---|---|---|
Edit | Swap case | SS |
1. Use the mouse to move the pointer to the required position in the document.
2. Click Select to position the caret at the required position.
3. If you are currently inserting, just type in the text. If you are currently overtyping, give the Insert Space command to make space for the new text:
Menu | Command | Ctrl-sequence | Key |
---|---|---|---|
Edit | Insert space | U |
You can insert any 'top-bit-set' character. These are characters you may not find on the keyboard, such as foreign letters and accented characters. To insert such a character, position the caret where you want the character to appear. Find !Chars in the RISC OS Apps directory. Double-click Select on the !Chars icon to activate it. You will see a window which displays all the characters available in the system font. If you wish you can change the font displayed by !Chars by bringing up a menu in the !Chars window and clicking Select on the font. Click Select on the character you want to insert. It will appear in your PipeDream document at the caret position.
Another way to insert 'top-bit-set' characters is to hold down the Alt key whilst you type in the ASCII value of the 'top-bit-set' character, using the numeric keypad. Tables of ASCII values can be found in your RISC OS User Guide.
The Backspace key (Rubout) deletes anything to the left of the caret.
The Delete Word and Delete Character commands can be used to delete words and characters respectively.
The Delete to End of Cell command deletes all the contents of the cell to the right of the caret.
Text deleted with the Delete Row, Delete Word, Delete Column, Delete Block, Delete to End of Cell and Delete Row in Column commands can be retrieved with the Paste command:
Menu | Command | Ctrl-sequence | Key |
---|---|---|---|
Edit | Paste | I | F9 |
For example:
1. Position the caret at the beginning of a sentence.
2. Give the Delete Word command repeatedly until the sentence disappears.
3. Give the Paste command repeatedly and the sentence will reappear.
With Delete to End of Cell, if the cell deleted is a number cell, when it is recovered using the Paste command, the formula it contained will be pasted in as text. Give the Edit Formula command to make it into a formula again.
Very often, you may want to repeat a command that you have just performed. For example, you might want to use the Add Column command to add 15 columns to your spreadsheet. You can do this in one of three ways:
Menu | Command | Ctrl-sequence | Key |
---|---|---|---|
Files | Repeat command | J | F5 |
This has the effect of repeating the last command given and is probably the easiest method to use.
For information on | See |
---|---|
Deleting blocks of text | Block Operations |
Other uses of the Paste command | Paste |