diff options
| author | PJ Fanning <fanningpj@apache.org> | 2021-11-25 05:07:01 +0000 |
|---|---|---|
| committer | PJ Fanning <fanningpj@apache.org> | 2021-11-25 05:07:01 +0000 |
| commit | b9d1e9c27f12676e17464e3d52bf4734b93fbd52 (patch) | |
| tree | 4cd6aad5ab339b0f82c5989e4ae58773819805cd /poi/src/main | |
| parent | 82a33995ce1961a7c3889c425ff0887d78fc82d6 (diff) | |
| download | poi-b9d1e9c27f12676e17464e3d52bf4734b93fbd52.tar.gz poi-b9d1e9c27f12676e17464e3d52bf4734b93fbd52.zip | |
[bug-63211] fix issue with escaped % in custom number format
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1895312 13f79535-47bb-0310-9956-ffa450edef68
Diffstat (limited to 'poi/src/main')
| -rw-r--r-- | poi/src/main/java/org/apache/poi/ss/usermodel/DataFormatter.java | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/poi/src/main/java/org/apache/poi/ss/usermodel/DataFormatter.java b/poi/src/main/java/org/apache/poi/ss/usermodel/DataFormatter.java index a448b905fa..b8bd933a9a 100644 --- a/poi/src/main/java/org/apache/poi/ss/usermodel/DataFormatter.java +++ b/poi/src/main/java/org/apache/poi/ss/usermodel/DataFormatter.java @@ -313,7 +313,8 @@ public class DataFormatter { // int i = cellValue > 0.0 ? 0 : cellValue < 0.0 ? 1 : 2; // String formatStr = (i < formatBits.length) ? formatBits[i] : formatBits[0]; - String formatStr = formatStrIn; + // this replace is done to fix https://bz.apache.org/bugzilla/show_bug.cgi?id=63211 + String formatStr = formatStrIn.replace("\\%", "\'%\'"); // Excel supports 2+ part conditional data formats, eg positive/negative/zero, // or (>1000),(>0),(0),(negative). As Java doesn't handle these kinds |