Article View: alt.uu.math.misc
Article #9Packed Decimal Question
From: Niles Mills
Date: Wed, 30 Dec 1992 18:30
Date: Wed, 30 Dec 1992 18:30
31 lines
1527 bytes
1527 bytes
Greetings. And Help. I am writing a utility that converts Microsoft Works spreadsheets into text format. Ie., the same format that Microsoft Works itself writes when you save a spreadsheet in text format. I am unable to decipher the storage format for integers. From other documentation I've read, it appears that all (or nearly all) spreadsheet manufacturers have elected to store numbers as IEEE standard (8087) Packed Decimal Numbers, 10 bytes to the cell, using the last byte to indicate an exponent. Can anyone describe an algorithm that converts the BCD data into displayable ASCII? Or perhaps point me towards a reference? Or am I completely off the track regarding the storage method? If you would email me directly at the address below, I'd sure appreciate it, as my site does not receive this newsgroup as part of its daily newsfeed. Thanks, kindly, in advance for your help. Regards, Niles Mills -- Connect Software | Voice 919/240-0132 | Internet root@Connect.COM 3213 Old Gate Road | FAX 919/240-0091 | UUCP uunet!connect!root Morehead City, NC | v.32bis 919/240-0192 | MCI Mail 220-5814 28557-3167 USA | BBS 919/240-0392 |
Technical Details
Message-ID:
<HP0LwB1w163w@connect.com>Path:
arc1-ca.pugleaf.net!sparky!uunet!connect!rootShow Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!sparky!uunet!connect!root From: root@connect.com (Niles Mills) Newsgroups: alt.uu.math.misc Subject: Packed Decimal Question Keywords: Packed Decimal Message-ID: <HP0LwB1w163w@connect.com> Date: Wed, 30 Dec 92 14:30:28 EDT Distribution: world Organization: Connect Software, Morehead City, NC Lines: 31