You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2015/05/11 13:42:23 UTC

[Bug 57915] New: Dec2Hex returns wrong value when the cell contains long values

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

[Bug 57915] Dec2Hex returns wrong value when the cell contains long values

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=57915

artiomsevciuc@gmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|minor                       |major
                 OS|                            |All

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

[Bug 57915] Dec2Hex returns wrong value when the cell contains long values

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=57915

Andreas Beeker <ki...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
          Component|POI Overall                 |SS Common

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

[Bug 57915] Dec2Hex returns wrong value when the cell contains long values

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=57915

Dominik Stadler <do...@gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |FIXED
             Status|NEW                         |RESOLVED

--- Comment #1 from Dominik Stadler <do...@gmx.at> ---
Fixed via r1703672, thanks for the hint of how it can be fixed, this is now
verified via some more unit-tests.

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