fill out remaining tests for FormatNumber

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1219 f203690c-595d-4dc9-a70b-905162fa7fd2

1 files changed, 5 insertions, 2 deletions

diff --git a/src/main/java/com/healthmarketscience/jackcess/impl/expr/DefaultFunctions.java b/src/main/java/com/healthmarketscience/jackcess/impl/expr/DefaultFunctions.java
index 2f71718..132daeb 100644
--- a/src/main/java/com/healthmarketscience/jackcess/impl/expr/DefaultFunctions.java
+++ b/src/main/java/com/healthmarketscience/jackcess/impl/expr/DefaultFunctions.java
@@ -310,9 +310,12 @@ public class DefaultFunctions
       }
 
       if(negParens) {
-        fmt.append(";(#)");
+        // the javadocs claim the second pattern does not need to be fully
+        // defined, but it doesn't seem to work that way
+        String mainPat = fmt.toString();
+        fmt.append(";(").append(mainPat).append(")");
       }
-
+      
       // Note, DecimalFormat rounding mode uses HALF_EVEN by default
       DecimalFormat df = new DecimalFormat(
           fmt.toString(), cfg.getDecimalFormatSymbols());