Intermec cn30 User Guide
Chapter 2 — Windows Mobile Version 5.0
76
CN30 Computer Mobile User’s Manual
Unsupported Features in Excel Mobile
Excel workbooks created on your PC can be opened and edited on your
CN30 Computer. However, Excel Mobile does not fully support some fea-
tures such as formulas and cell comments. Some data and formatting may
be lost when you save the workbook on your CN30 Computer. Note the
following regarding these Excel Mobile formatting considerations:
CN30 Computer. However, Excel Mobile does not fully support some fea-
tures such as formulas and cell comments. Some data and formatting may
be lost when you save the workbook on your CN30 Computer. Note the
following regarding these Excel Mobile formatting considerations:
Alignment
Horizontal, vertical and wrap text attributes remain the same, but vertical text appears hor-
izontal.
izontal.
Borders
Appear as a single line.
Cell patterns
Patterns applied to cells are removed.
Fonts and font sizes
Fonts not supported by your device are mapped to the closest font available. The original
font is listed on your CN30 Computer. When the workbook is opened in Excel on your
PC again, the data is displayed in the original font.
font is listed on your CN30 Computer. When the workbook is opened in Excel on your
PC again, the data is displayed in the original font.
Number formats
Numbers formatted using the Microsoft Excel 97 conditional formatting feature are dis-
played in Number format.
played in Number format.
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!
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!
Protection settings
Most worksheet and workbook protection features are disabled but not removed. How-
ever, 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 syn-
chronize to open the file on the CN30 Computer.
ever, 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 syn-
chronize to open the file on the CN30 Computer.
Zoom settings
Are not retained. Excel supports a per worksheet zoom setting, while the Excel Mobile
zoom setting is applied to the entire workbook.
zoom setting is applied to the entire workbook.
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.
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.
AutoFilter settings
Are removed. However, you can use the AutoFilter command in Excel Mobile to perform
similar functions. If you have an AutoFilter applied to a worksheet that causes rows to be
hidden, the rows remain hidden when the file is opened in Excel Mobile. Use the Unhide
command to display the hidden rows.
similar functions. If you have an AutoFilter applied to a worksheet that causes rows to be
hidden, the rows remain hidden when the file is opened in Excel Mobile. Use the Unhide
command to display the hidden rows.
Chart formatting
All charts will be saved the way they are shown in Excel Mobile. Unsupported chart types
are changed to one of these supported types: Column, Bar, Line, Pie, Scatter, and Area.
Background colors, gridlines, data babels, trend lines, shadows, 3D effects, secondary axes,
and logarithmic scales are turned off.
are changed to one of these supported types: Column, Bar, Line, Pie, Scatter, and Area.
Background colors, gridlines, data babels, trend lines, shadows, 3D effects, secondary axes,
and logarithmic scales are turned off.
Worksheet features
The following features are not supported in Excel Mobile and are removed or modified
when a workbook is opened on the CN30 Computer: VBA modules, macro sheets, and
dialog sheets are removed and replaced with a place holder sheet; text boxes, drawing
objects, pictures, lists, conditional formats, and controls are removed; pivot table data is
converted to values.
when a workbook is opened on the CN30 Computer: VBA modules, macro sheets, and
dialog sheets are removed and replaced with a place holder sheet; text boxes, drawing
objects, pictures, lists, conditional formats, and controls are removed; pivot table data is
converted to values.