LG KS20 User Manual page 90

ProGrAMS
Formulas and functions. If an Excel
v
file contains a function that is not
supported by Excel Mobile, the
function is removed, and only the
returned value of the function
appears. The following formulas are
also converted to values: formulas
entered as an array or containing
an array argument, for example,
=SUM({1;2;3;4}); formulas containing
external link references or an
intersection range reference; and
formulas containing references past
row 1634 are replaced with #rEF!
Protection settings. Most worksheet
v
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
100
opened. You must remove the
password protection in Excel on the
PC and then synchronize to open
the file on the device.
Zoom settings. Are not retained.
v
Excel supports a per worksheet
zoom setting, while the Excel Mobile
zoom setting is applied to the entire
workbook.
Worksheet names. names that
v
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.