ot: dropping zeros - not the same

GCC Consulting gccconsulting at comcast.net
Fri Feb 22 07:56:12 PST 2008



> -----Original Message-----
> From: filepro-list-
> bounces+gccconsulting=comcast.net at lists.celestial.com [mailto:filepro-
> list-bounces+gccconsulting=comcast.net at lists.celestial.com] On Behalf
> Of Fairlight
> Sent: Thursday, February 21, 2008 8:23 PM
> To: filepro-list at lists.celestial.com
> Subject: Re: ot: dropping zeros - not the same
> 
> On Thu, Feb 21, 2008 at 05:12:54PM -0500, Richard Kreiss, the prominent
> pundit,
> witicized:
> > One of my client's called and advised they are having trouble with an
> Excel
> > spreadsheet which lists their credits.  It appears that when the
> service
> > company transmits this to their customer in about 20% of credits
> loose a
> > zero.
> >
> > Here is the odd part: -88.70 is received as -8.87
> >
> > As was indicated to me, this only happens when the hundredths value
> is a
> > zero.
> >
> > Any idea why this happening.  There service company has no idea.  The
> sheet
> > looks correct prior to e-mailing it to the service company.
> 
> Is the sheet beeing assembled on your end, or on the remote end?  (ie.,
> into fP or out of fP?)
> 
> At any rate, that sounds suspiciously like an Excel bug, or a bug in
> the
> converter being used.  It shouldn't even matter what precision is used,
> the
> decimal place is being -shifted-, which is flat-out unacceptable.
> 
> What's doing the conversion?  A third party program, or Excel itself?
> 
> mark->

As this is an outside service, and I haven't spoken with them, I can't
answer this question.

It will be a moot point in about 4 weeks as I am bringing the edi in-house.


Most of the programming has been done and tested internally but I am going
away and this will have to wait until I return.

Richard 




More information about the Filepro-list mailing list