File: entering-data.texi

package info (click to toggle)
oleo 1.6-16
  • links: PTS
  • area: main
  • in suites: potato
  • size: 2,640 kB
  • ctags: 3,139
  • sloc: ansic: 39,221; yacc: 1,737; sh: 362; makefile: 88
file content (210 lines) | stat: -rw-r--r-- 6,162 bytes parent folder | download | duplicates (3)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
@node How to enter data, Making changes, Basics, Top
@chapter Entering Data






@menu
* Oleo values::                 
* Entering::                    Entering values in a cell
* Input Editing::               Editing in the input line
* Cell Motion::                 Moving to the next input cell while editing
@end menu

@node Oleo values, Entering, How to enter data, How to enter data
@section The different values in Oleo

A value can be a literal (an immediate value, like @code{"foo"},
@code{16}, or @code{#TRUE}), a function call, or another expression.
There are 5 types of values:

@itemize @bullet
 @item Integers.
 @item Floats, expressed in the usual format:
[@code{-}]@var{nnn}[@code{.}@var{nnn}][@code{e}[@code{-}]@var{nnn}],
e.g. -103.14e-7.
  @cindex String values
  @item Strings, which are surrounded by double quotes.  To include
unusual characters, you can either quote them with a backslash (e.g.
@w{@code{"This is \"quoted\"."}} or use an octal escape code: @samp{\@var{nnn}}
where @var{nnn} is the octal code for the ASCII value of the character.
@c an expression isn't really another type; it's a group of values:
@c @item Expressions, such as @code{@@sum(A1.B3)}, or @code{A1 + B2}.
 @item Errors, which have alphabetic names and start with a @samp{#}
sign.
 @item Booleans, which are "error" values of either @code{#TRUE} or
@code{#FALSE}.
  @cindex Boolean values
@end itemize



@node Entering, Input Editing, Oleo values, How to enter data
@section Entering values in a cell
To enter values into an empty cell, simply start typing.  
To replace the contents of a cell or of all cells in a region, use

@table @kbd
@item =
        Replace the contents of the current cell. (@code{set-cell})
@cmindex set-cell
@item M-=
        Replace the contents of a region. (@code{set-cell-region})
@cmindex set-cell-region
@end table
@kindex =
@kindex M-=

For example, to put the numbers 2,3,...,11 in the  cells from @code{B1} to
@code{B10}, type
@example
        @key{M-=}  B1.B10   @key{RET}   @@row()+1   @key{RET}
@end example


@node Input Editing, Cell Motion, Entering, How to enter data
@section Editing in the input line

When the spreadsheet is reading text input, you can use a few
text-editing commands.  Note that there in no history mechanism and no
yank command.  If you accidentally type @kbd{C-u}, the text is @emph{erased}.
@footnote{This will be improved in the future.}

While the input area is active, the commands that move the cell cursor
are disabled.  If you want to move the cell cursor, use the
other-window command (@kbd{C-X o}) to leave and later reenter the input area.

@table @kbd
@item M-a
Insert/over-write an absolute reference to the
current cell/region. (@code{insert-abs-ref})
@cmindex insert-abs-ref
@item M-r
Insert/over-write a relative reference to the
current cell/region. (@code{insert-rel-ref})
@cmindex insert-rel-ref
@item C-e
Insert/over-write the expression in the
current cell into the input area. (@code{insert-cell-expression})
@cmindex insert-cell-expression
@item M-e
Insert/over-write the value (not the formula) of the current
cell into the input area. (@code{insert-cell-value})
@cmindex insert-cell-value
@item C-a
Move the cursor to the beginning of the text. (@code{cursor-begin-line})
@cmindex cursor-begin-line
@item C-e
Move to the end of the text. (@code{cursor-end-line})
@cmindex cursor-end-line
@item C-b
Move the cursor back a character. (@code{cursor-back-char})
@cmindex cursor-back-char
@item M-b
Move back a word. (@code{cursor-back-word})
@cmindex cursor-back-word
@item C-f
Move forward a character. (@code{cursor-fwd-char})
@cmindex cursor-fwd-char
@item M-f
Move forward a word. (@code{cursor-fwd-word})
@cmindex cursor-fwd-word
@item C-d
Delete the character under the cursor. (@code{delete-next-char})
@cmindex delete-next-char
@item M-d
Delete the word under the cursor.  (@code{delete-next-word})
@cmindex delete-next-word
@item C-?
Delete the character to the left of the cursor. (@code{delete-prev-char})
@cmindex delete-prev-char
@item M-C-?
Delete the word to the left of the cursor. (@code{delete-prev-word})
@cmindex delete-prev-word
@item C-k
Delete from the cursor to the end of the text. (@code{delete-to-end})
@cmindex delete-to-end
@item C-o
Move the cursor into the cell area.
@end table
@kindex M-e
@kindex C-e
@kindex M-a
@kindex M-r
@kindex C-a
@kindex C-e
@kindex C-b
@kindex M-b
@kindex C-f
@kindex M-f
@kindex C-d
@kindex M-d
@kindex C-?
@kindex M-C-?
@kindex C-k
@kindex C-o

The following commands are not bound to any keys
@table @code
@item toggle-overwrite
@cmindex toggle-overwrite
Toggle between overwrite and insert mode.
@item delete-to-start
@cmindex delete-to-start
 Deletes from the cursor to the beginning of the line
@end table

@cindex Input Defaults

Almost all editing commands remember what you typed the last time you used
that command, and start you up editing a copy of that text.  If you want to
type in something completely new, just type @kbd{C-x} (or @kbd{C-u}) and
type in your new text.

@node Cell Motion,  , Input Editing, How to enter data
@comment  node-name,  next,  previous,  up
@section Moving to the next input cell while editing

When you are finished entering data in a cell, you type @key{RET}. If
you wish to enter data in the cell below, type @kbd{C-i}, and you are
placed in the next cell, waiting for input.  If you type @kbd{C-j}, you
move to the right.  The direction of @kbd{C-i} can be changed - the
commands are  given below.  For example, if you wish to move upwards when you
type @kbd{C-i}, type @code{C-x m ^}.

@table @kbd
@item C-i
Enter the data, and move to next cell
(@code{next-edit})
@cmindex next-edit
@item C-j
Enter the data, and move to next cell in alternative direction
(@code{next-edit-set})
@cmindex next-edit-set
@item C-x m ^
@code{auto-move-up}
@item C-x m v
@code{auto-move-down}
@item C-x m <
@code{auto-move-left}
@item C-x m >
@code{auto-move-right}
@item C-x m `
@code{auto-move-up-left}
@item C-x m '
@code{auto-move-up-right}
@item C-x m /
@code{auto-move-down-left}
@item C-x m \\
@code{auto-move-down-right}
@item C-x m  
@code{auto-move-no-motion}
@end table