https://bz.apache.org/bugzilla/show_bug.cgi?id=63211
Bug ID: 63211
Summary: DataFormatter incorrectly formats data formats with
escaped percent character
Product: POI
Version: unspecified
Hardware: PC
Status: NEW
Severity: major
Priority: P2
Component: SS Common
Assignee: dev@poi.apache.org
Reporter: spdoo...@us.ibm.com
Target Milestone: ---
When a format contains an escaped percent character (i.e. \% or "%"), the
escaping is ignored and the resultant formatted value is 100 times larger than
it should be. Some examples to illustrate the problem:
// Should be 12.5% but is 1250.0%
new DataFormatter(Locale.US).formatRawCellContents(12.5, -1,
"0.0\\%;\\-0.0\\%");
// Should be 12.5% but is 1250.0%
new DataFormatter(Locale.US).formatRawCellContents(12.5, -1,
"0.0\"%\";\\-0.0\"%\"");
// Should be -12.5% but is -1250.0%
new DataFormatter(Locale.US).formatRawCellContents(-12.5, -1,
"0.0\\%;\\-0.0\\%");
// Should be -12.5% but is -1250.0%
new DataFormatter(Locale.US).formatRawCellContents(-12.5, -1,
"0.0\\%;\\-0.0\\%");
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
