LG KS20 User Guide - Page 109

accurately, but names that refer

Page 109 highlights

v Protection settings. Most worksheet and workbook protection features are disabled but not removed. However, support for password protection has been removed. Workbooks that are passwordprotected or workbooks in which one or more worksheets are password-protected cannot be opened. You must remove the password protection in Excel on the PC and then synchronise to open the file on the device. v Zoom settings. Are not retained. Excel supports a per worksheet zoom setting, while the Excel Mobile zoom setting is applied to the entire workbook. v Worksheet names. Names that reference worksheets within the same workbook are displayed accurately, but names that refer to other workbooks, arrays, for example, ={1;2;3;4}, array formulas, or intersection ranges are removed from the name list. If a name is removed from the list, it is left in formulas and functions, causing those formulas to be resolved as "#NAME?"All hidden names are not hidden. Programs 107

  • 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

107
v
Protection settings. Most worksheet
and workbook protection features
are disabled but not removed.
However, support for password
protection has been removed.
Workbooks that are password-
protected or workbooks in which
one or more worksheets are
password-protected cannot be
opened. You must remove the
password protection in Excel on the
PC and then synchronise to open
the file on the device.
v
Zoom settings. Are not retained.
Excel supports a per worksheet
zoom setting, while the Excel Mobile
zoom setting is applied to the entire
workbook.
v
Worksheet names. Names that
reference worksheets within the
same workbook are displayed
accurately, but names that refer
to other workbooks, arrays, for
example, ={1;2;3;4}, array formulas,
or intersection ranges are removed
from the name list. If a name is
removed from the list, it is left in
formulas and functions, causing
those formulas to be resolved as
“#NAME?” All hidden names are not
hidden.
PROGRAMS