Brother International WP7550JPLUS Owner's Manual - English - Page 101

Format, Marks, Maximum, Length

Get Brother International WP7550JPLUS PDF manuals and user guides View all Brother International WP7550JPLUS manuals
Add to My Manuals
Save this manual to your list of manuals

Page 101 highlights

Format Marks A default single quote mark appears automatically in the input area when the spreadsheet recognizes your data as alphanumeric. If you delete it, it will automatically reappear when the alphanumeric data is confirmed. Instead of typing the format mark for right alignment ("9, you may press CODE + R. The format mark for centering (") does not appear on the keyboard, you must use CODE + F. If you press these keys while in Command mode, the machine switches to the Input/ Edit mode and the corresponding mark appears in the input area. Format marks are typed before the data and tell the spreadsheet application that whatever follows is alphanumeric and is not to be calculated. Format marks also tell the spreadsheet application how to position the data in the cell. You can use one of these four format marks: (single quote) to align the data to the left of the cell. (double quote) to align the data to the right of the cell (CODE + R). A to center the data in the cell (CODE + F). fills the cell by repeating the character following the mark. Format marks are displayed in the input area only (They never appear in the cell). The above characters are interpreted as format marks when they are entered in the first position of the input area. If they are entered in the middle of the data, they are considered as common characters and will appear in the cell. Maximum Length of Data The maximum length of the input area is 240 characters (1 format mark and 239 characters). When alphanumeric data cannot fit into the cell, it will use the next cells of the worksheet unless these cells are already occupied. This convenient feature is used for long titles (when you do not want to disturb the layout of the spreadsheet by increasing the width of a column). It should be noted that entering many long pieces of alphanumeric data may cause the memory to become full before all cells are filled. Also, adjusting the width of many columns to display long pieces of alphanumeric data may cause truncation of the rows when the spreadsheet is printed. Spreadsheet 93

  • 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
  • 211
  • 212
  • 213
  • 214
  • 215
  • 216
  • 217
  • 218
  • 219
  • 220
  • 221
  • 222
  • 223
  • 224
  • 225
  • 226
  • 227
  • 228
  • 229
  • 230
  • 231
  • 232
  • 233
  • 234
  • 235
  • 236
  • 237
  • 238
  • 239
  • 240
  • 241
  • 242
  • 243
  • 244
  • 245
  • 246
  • 247
  • 248
  • 249
  • 250
  • 251
  • 252
Format
Marks
A
default
single
quote
mark
appears
automatically
in
the
input
area
when
the
spreadsheet
recognizes
your
data
as
alphanumeric.
If
you
delete
it,
it
will
automatically
reappear
when
the
alphanumeric
data
is
confirmed.
Instead
of
typing
the
format
mark
for
right
alignment
("9,
you
may
press
CODE
+
R.
The
format
mark
for
centering
(")
does
not
appear
on
the
keyboard,
you
must
use
CODE
+
F.
If
you
press
these
keys
while
in
Command
mode,
the
machine
switches
to
the
Input/
Edit
mode
and
the
corresponding
mark
appears
in
the
input
area.
Format
marks
are
typed
before
the
data
and
tell
the
spreadsheet
application
that
whatever
follows
is
alphanumeric
and
is
not
to
be
calculated.
Format
marks
also
tell
the
spreadsheet
application
how
to
position
the
data
in
the
cell.
You
can
use
one
of
these
four
format
marks:
A
(single
quote)
to
align
the
data
to
the
left
of
the
cell.
(double
quote)
to
align
the
data
to
the
right
of
the
cell
(CODE
+
R).
to
center
the
data
in
the
cell
(CODE
+
F).
fills
the
cell
by
repeating
the
character
following
the
mark.
Format
marks
are
displayed
in
the
input
area
only
(They
never
appear
in
the
cell).
The
above
characters
are
interpreted
as
format
marks
when
they
are
entered
in
the
first
position
of
the
input
area.
If
they
are
entered
in
the
middle
of
the
data,
they
are
considered
as
common
characters
and
will
appear
in
the
cell.
Maximum
Length
of
Data
The
maximum
length
of
the
input
area
is
240
characters
(1
format
mark
and
239
characters).
When
alphanumeric
data
cannot
fit
into
the
cell,
it
will
use
the
next
cells
of
the
worksheet
unless
these
cells
are
already
occupied.
This
convenient
feature
is
used
for
long
titles
(when
you
do
not
want
to
disturb
the
layout
of
the
spreadsheet
by
increasing
the
width
of
a
column).
It
should
be
noted
that
entering
many
long
pieces
of
alphanumeric
data
may
cause
the
memory
to
become
full
before
all
cells
are
fi
lled.
Also,
adjusting
the
width
of
many
columns
to
display
long
pieces
of
alphanumeric
data
may
cause
truncation
of
the
rows
when
the
spreadsheet
is
printed.
Spreadsheet
93