poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 57915] New: Dec2Hex returns wrong value when the cell contains long values
Date Mon, 11 May 2015 11:42:23 GMT
https://bz.apache.org/bugzilla/show_bug.cgi?id=57915

            Bug ID: 57915
           Summary: Dec2Hex returns wrong value when the cell contains
                    long values
           Product: POI
           Version: 3.11-FINAL
          Hardware: PC
            Status: NEW
          Severity: minor
          Priority: P2
         Component: POI Overall
          Assignee: dev@poi.apache.org
          Reporter: artiomsevciuc@gmail.com

I have a column which contains a formula:
="341575"&"3004"&RIGHT(0&"1",2)
The result of the formula is : "341575300401". 
After that the result is used by the dec2hex and the result for that formula
should be "4F87797531". But it is not working as needed and the result value is
"7FFFFFFF".
After some investigation I found that in the line 115 from Dec2Hex class we
have following call:
hex = Integer.toHexString(number1.intValue());
That is wrong, I guess that it is needed to use:
Integer.toHexString(number1.longValue());
In this case it will cover integer and long numbers.

-- 
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