diff options
| author | Dominik Stadler <centic@apache.org> | 2024-04-22 06:43:20 +0000 |
|---|---|---|
| committer | Dominik Stadler <centic@apache.org> | 2024-04-22 06:43:20 +0000 |
| commit | 601c5e2671243db42306de8fe94c3ebfb6024408 (patch) | |
| tree | 044b8c72c575dc0456a442ce264351979c753ef3 /poi-examples/src/main/java/org | |
| parent | 51242877e59ec528a99ba66903a7c3b5cb524b6c (diff) | |
| download | poi-601c5e2671243db42306de8fe94c3ebfb6024408.tar.gz poi-601c5e2671243db42306de8fe94c3ebfb6024408.zip | |
XLS(X) -> CSV: Wrap formatted numbers in quotes if necessary
e.g. German locale uses "comma" instead of point, e.g. 1,23 instead of 1.23
so we may need to quote formatted numbers
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1917257 13f79535-47bb-0310-9956-ffa450edef68
Diffstat (limited to 'poi-examples/src/main/java/org')
| -rw-r--r-- | poi-examples/src/main/java/org/apache/poi/examples/hssf/eventusermodel/XLS2CSVmra.java | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/poi-examples/src/main/java/org/apache/poi/examples/hssf/eventusermodel/XLS2CSVmra.java b/poi-examples/src/main/java/org/apache/poi/examples/hssf/eventusermodel/XLS2CSVmra.java index 55dc578915..d3b879c9f8 100644 --- a/poi-examples/src/main/java/org/apache/poi/examples/hssf/eventusermodel/XLS2CSVmra.java +++ b/poi-examples/src/main/java/org/apache/poi/examples/hssf/eventusermodel/XLS2CSVmra.java @@ -253,6 +253,10 @@ public class XLS2CSVmra implements HSSFListener { // Format thisStr = formatListener.formatNumberDateCell(numrec); + if (thisStr.contains(",")) { + thisStr = '"' + thisStr + '"'; + } + break; case RKRecord.sid: RKRecord rkrec = (RKRecord) record; |