BYE DESIGN LTD

A Microsoft Windows Mobile Solutions Partner

Electronic mail address: stephenbye@byedesign.co.uk
Copyright Bye Design Ltd 1999. Last revised: April 30, 2006.

How do I use my Excel files with SpreadCE?

The latest version of SpreadCE can read and write Excel 95/97 files directly, but you may instead want to store them in Pocket Excel format on your P/PC because they will take up less space (but see below regarding usable functions).

Set up the file conversions as follows:

Make sure that you are using ActiveSync 3.0 or later (available free from Microsoft's web site) to connect your desktop PC to your P/PC.
Select the ActiveSync Tools -> Options menu option,
select the Rules tab,
press the Conversion Settings button,
select the Desktop to Device tab,
select Microsoft Excel Worksheet in the listbox,
press the Edit button,
select Pocket Excel 2.0 in the drop-down list box,
and press the OK button.
Then select the Device to Desktop tab,
select Pocket Excel Workbook in the listbox,
press the Edit button,
select Excel 95 or 97 or 2000 in the drop-down listbox,
and press the OK button.

Now when you drag & drop files from the desktop computer to/from the P/PC they will be converted automatically between the Excel and Pocket Excel formats.

You will need to store the files on the P/PC in the My Documents folder, either in the main memory or on the Compact Flash memory expansion card.

Note that the Pocket Excel file format only supports the following 109 functions, other functions will be replaced with their result values when the conversion from Excel to Pocket Excel takes place. If you need to use functions that are not in this list then do not use the Pocket Excel file format.

ABS
ACOS
AND
ASIN
ATAN
ATAN2
AVERAGE
CHOOSE
COLUMNS
COS
COUNT
COUNTA
COUNTBLANK
COUNTIF
DATE
DATEVALUE
DAVERAGE
DAY
DCOUNT
DCOUNTA
DDB
DEGREES
DGET
DMAX
DMIN
DPRODUCT
DSTDEV
DSTDEVP
DSUM
DVAR
DVARP
ERROR.TYPE
EXACT
EXP
FACT
FALSE
FIND
FV
HLOOKUP
HOUR
IF
INDEX
INT
IRR
ISBLANK
ISERR
ISERROR
ISLOGICAL
ISNA
ISNONTEXT
ISNUMBER
ISTEXT
LEFT
LEN
LN
LOG
LOG10
LOWER
MATCH
MAX
MID
MIN
MINUTE
MOD
MONTH
N
NA
NOT
NOW
NPER
NPV
OR
PI
PMT
POWER
PRODUCT
PROPER
PV
RADIANS
RAND
RATE
REPLACE
REPT
RIGHT
ROUND
ROWS
SECOND
SIN
SLN
SQRT
STDEV
STDEVP
SUBSTITUTE
SUM
SUMIF
SYD
T
TAN
TIME
TIMEVALUE
TRIM
TRUE
TRUNC
UPPER
VALUE
VAR
VARP
VLOOKUP
YEAR