poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 47282] The data format string is incorrect for Accounting style
Date Thu, 11 Jun 2009 11:45:07 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=47282


jimmy422@rediffmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |NEW




--- Comment #9 from jimmy422@rediffmail.com  2009-06-11 04:45:02 PST ---
(In reply to comment #8)
> (In reply to comment #7)
> > The parsing logic is written as per the Excel formats which has the space.
> 
> Which parsing logic?  Excel's? POI's? Have you written your own parsing logic? 
> If so, is it easy enough to share a small part of that code which exposes the
> bug?
Vijayendra - The parsing logic is written externally. No Excel's or POI's
parsing logic is used.
I cannot disclose the code, since it is complex and huge.

> 
> 
> 
> > As Michael Zalewski
> > (https://issues.apache.org/bugzilla/show_bug.cgi?id=47282#c2)
> > pointed correctly, after parsing as per current format string in POI,
> > it gives the value as #0.00 at my end.
> 
> 'it gives' - which app are you talking about?  Probably not Excel, because
> Excel would actually give a result of #,0.00.
Vijayendra - The custom application
> 
> 
> 
> > If the space is removed while debugging, it parses the currencies as perfectly.
> 
> I guess you mean 'If the space is *added* while debugging...'
Vijayendra - Yeah. Sorry. If space *added*.
> 
> 
> 
> > The standard formats does have space after * and I think POI should follow the
> > same.
> 
> POI *will* be changed to match Excel.  That was never in question.  Instead,
> please help us understand the reasoning behind the change.

To summarize the logic, it parse the format string and tries to collect various
formats (represented by custom java classes) in sequence, which later helps in
formatting the value.
The logic is written as per the standard formats. So cannot change it for a
single value. So while parsing the string, if the space is not found, it makes
the formatting messy.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message