Htc WIZA100 User Manual download pdf (Page 155)

Using Other Applications | 155

• 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 ﬁle 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 ﬁle 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 modiﬁed 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.

1 ... 154 155 156 ... 192

No comments

Htc WIZA100 User Manual Page 155