LG MS25, User Manual, Page: 90 / 124

100
v
Formulas and functions. If an Excel
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 16384 are replaced with #REF!
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 synchronize 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
P
rogr
ams