🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: alt.uu.math.misc
Article #9

Packed Decimal Question

#9
From: Niles Mills
Date: Wed, 30 Dec 1992 18:30
31 lines
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!root

Show 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