beautypg.com

Prod ucti vi ty, Number formats: microsoft, Excel – Sprint Nextel Palm Treo 800w User Manual

Page 273: More than 512 bytes, Office excel, Hidden sheets. hidden worksheets are displayed

background image

Section 5B: Increasing Your Productivity

273

Prod

ucti

vi

ty

Fonts and font sizes: The original font is listed on your Treo and is mapped to the closest
font available. Original fonts reappear on your computer.

Number formats: Microsoft

®

Excel

®

97 conditional formatting is displayed in number

format.

Formulas and functions: Unsupported functions are removed, and only the returned value
of the function appears. Formulas containing the following are also converted to values:

More than 512 bytes

An array or array argument, for example, =SUM({1;2;3;4}).

External link references or an intersection range reference.

References past row 16384 are replaced with #REF!.

Protection settings: Most protection features are disabled but are not removed. You must
remove the password protection in Microsoft

®

Office Excel

®

on your computer before

editing the file on your Treo. Rights-managed and password-protected files must be saved
only in their original file format.

Zoom settings: Worksheet-specific zoom settings are not retained. The zoom setting
applies to the entire workbook.

Worksheet names: Names that refer to other workbooks, arrays, array formulas, or
intersection ranges are removed from the name list, causing those formulas to be
resolved as “#NAME?” All hidden names are not hidden.

AutoFilter Settings: AutoFilters that cause rows to be hidden are supported. Use the
Unhide command to display hidden rows. Other AutoFilters are removed, but you can use
the AutoFilter command in Excel Mobile to perform similar functions.

Chart Formatting: All charts are saved as they appear in Excel Mobile. Unsupported chart
types are changed to one of these supported types: Column, Bar, Line, Pie, Scatter, and
Area. Background colors, grid lines, data labels, trend lines, shadows, 3D effects,
secondary axes, and logarithmic scales are turned off.

Hidden sheets. Hidden worksheets are displayed.

Tip

For simple calculations, use the

Calculator

(see “Calculator” on page 256).