Path: utzoo!attcan!uunet!bnrgate!bnr!bcrka125.bnr.ca!jimdean
From: jimdean@bcrka125.bnr.ca (Jim Dean 1574326)
Newsgroups: comp.sys.apple
Subject: AppleWorks Spreadsheet File Values Format
Message-ID: <25@bcrka80.bnr.ca>
Date: 12 Jan 90 18:38:09 GMT
Sender: cadnews@bnr.CA
Reply-To: jimdean@bcrka125.bnr.ca (Jim Dean 1574326)
Distribution: na
Organization: bnr
Lines: 35

Can anybody tell me how to turn AppleWorks spreadsheet file
values into decimal numbers, using a high-level language?
  
When writing to a file, AppleWorks stores spreadsheets values 
in something called "8 bytes of binary log format"; I want to 
write a program in C to read spreadsheet files but I do not 
understand how to convert the 8-byte AppleWorks spreadsheet 
number to something that I'd recognize, like a regular 
decimal number.

Further to this problem, I wrote a spreadsheet reader in 
BASIC, and to convert the spreadsheet number to AppleSoft
BASIC, I used a machine language routine I found in Nibble.
That routine converted the "8 bytes of binary log format"
to the 5-byte storage used by AppleSoft variables, but I
do not understand what the routine was doing.  The program
worked but was slow.

Please reply by e-mail, or here if you think interest would warrant.

---------------------------------------------------------------------------
Jim Dean        |    Bell-Northern Research, Ltd    |  Ph.: (613) 763-2135
                |      P.O. Box 3511, Station C     |  Fax: (613) 763-8825
                |  Ottawa, Ontario, Canada, K1Y 4H7 |
---------------------------------------------------------------------------
BITNET/NETNORTH: jimdean@bnr.ca   
---------------------------------------------------------------------------
Any opinions expressed herein are my own and not necessarily shared by my
employer, Bell-Northern Research.
---------------------------------------------------------------------------

---------------------------------------------------------------------------
Jim Dean        |    Bell-Northern Research, Ltd    |  Ph.: (613) 763-2135
                |      P.O. Box 3511, Station C     |  Fax: (613) 763-8825
                |  Ottawa, Ontario, Canada, K1Y 4H7 |