Path: utzoo!utgpu!jarvis.csri.toronto.edu!cs.utexas.edu!samsung!brutus.cs.uiuc.edu!apple!mattd
From: mattd@Apple.COM (Matt Deatherage)
Newsgroups: comp.sys.apple
Subject: Re: AppleWorks Spreadsheet File Values Format
Message-ID: <37901@apple.Apple.COM>
Date: 17 Jan 90 22:39:29 GMT
References: <25@bcrka80.bnr.ca>
Distribution: na
Organization: Apple Computer Inc, Cupertino, CA
Lines: 33

In article <25@bcrka80.bnr.ca> jimdean@bcrka125.bnr.ca (Jim Dean 1574326) writes:
>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.
>
>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 |

When I don't know if interest warrants, I post to the net just to be sure.  :)

AppleWorks uses SANE to do calculations, so the numbers are stored in SANE's
internal format.  This is described in academic ("boring and sleep-inducing")
detail in the Apple Numerics Manual.

Either edition will do for 8-bit SANE; only the Second Edition covers 65816
SANE (and 68881 SANE for the Mac family).


-- 
============================================================================
Matt Deatherage, Apple Computer, Inc. | "The opinions represented here are
Developer Technical Support, Apple II |  not necessarily those of Apple
Group.  Personal mail only, please.   |  Computer, Inc.  Remember that."
============================================================================