Summary: | [PATCH] patch for missing function Hex2Dec | ||
---|---|---|---|
Product: | POI | Reporter: | Cédric Walter <cedric.walter> |
Component: | POI Overall | Assignee: | POI Developers List <dev> |
Status: | RESOLVED FIXED | ||
Severity: | normal | ||
Priority: | P2 | ||
Version: | 3.10-dev | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | All | ||
Attachments: |
Hex2DecFunctionTestCaseData.xls
hex2dec patch Hex2Dec missing apache header in previous patch Add additional sanity check/integration test FormulaEvalTestData.xls |
Created attachment 30389 [details]
hex2dec patch
Created attachment 30390 [details]
Hex2Dec missing apache header in previous patch
Created attachment 30456 [details]
Add additional sanity check/integration test FormulaEvalTestData.xls
|
Created attachment 30388 [details] Hex2DecFunctionTestCaseData.xls Converts a hexadecimal number to decimal. Number cannot contain more than 10 characters (40 bits). The most significant bit of number is the sign bit. The remaining 39 bits are magnitude bits. Negative numbers are represented using two's-complement notation. If number is not a valid hexadecimal number, HEX2DEC returns the #NUM! error value.