UTStarcom PPC-6700 Manuel d'utilisation

Page 155

Advertising
background image

Section 9: Using Other Applications

Section 9: Using Other Applications

149

Section 9: Using Other Applications

Section 9: Using Other Applications

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.

Zoom settings. Are not retained. Excel supports a per

worksheet zoom setting, while the Excel Mobile 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.

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

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 labels, 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 device: hidden sheets are not hidden; 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.

To get more help about Excel Mobile:

When in Excel Mobile, tap Start > Help.

Advertising