Juniper Systems Allegro CX Manual - Manual (Page 131)

Allegro CX Owner’s Manual 131
If the Excel fi le has graphics incorporated into it, the spreadsheet
cannot be converted to a PTab fi le. We recommend that you make
a copy of the Excel spreadsheet, remove the graphics, and then
convert the modifi ed copy.
Items Converted to / from Excel
PTab 3.0 can load/save MS Excel fi les (this includes Excel version
5.0/95/97/200/XP/2003). The following are the items that are
converted to and from Excel fi les when opened in PTab:
Cell values: numbers (incl. date/time values), texts, Boolean
values, error values
Formulas containing: numbers, date/time values, texts, Boolean
values, errors, +, -, *, /, ^, %, cell references, names, functions
supported by PTab
Formats: font (font style, size, color), background color, simple
borders, alignment (left, right, center, center across selection;
top, center, bottom), wrap text, merge cells, cell protection,
basic number formats (number of decimals, thousand separator,
currency symbol, text before and after the number), basic date/
time formats
Row height, column width, sheet names, titles freezing, zoom
Group and outline, data validation
Saving PTab Files
When you select File | Save or File | Save As, PTab automatically sets
the path to \C_Drive\C_MyDocs\. Your fi le is saved to the non-
volatile solid state storage. We recommend that you use the C_Drive
as the primary storage area.
Summary of PTab Features
The features of PTab version 3.0 are listed below.
Load/Save Microsoft Excel (.xls, Excel v. 5.0/95/97/2000/
XP/2003) fi les directly
Load/Save Microsoft Pocket Excel (.pxl) fi les directly
Import/Export TXT, CSV (Comma Separated Values), DBF
(dBase)
256 sheets x 65536 rows x 256 columns
Numeric, Text, Date/Time, Boolean values
249 built-in scientifi c, statistical, fi nancial, date/time, logical,
database, text and macro functions
Multiple Undo/Redo
‰
‰
‰
‰
‰
‰
▲
▲
‰
‰
‰
‰
‰
‰
‰