Examples of jxl.write.NumberFormat

jxl.write.NumberFormat
A custom user defined number format, which may be instantiated within user applications in order to present numerical values to the appropriate level of accuracy. The string format used to create a number format adheres to the standard java specification, and JExcelAPI makes the necessary modifications so that it is rendered in Excel as the nearest possible equivalent. Once created, this may be used within a CellFormat object, which in turn is a parameter passed to the constructor of the Number cell

  }


  protected NumberFormat getNumberFormat(String pattern, boolean isComplexFormat)
  {
    String convertedPattern = getConvertedPattern(pattern);
    NumberFormat cellFormat = (NumberFormat) numberFormats.get(convertedPattern);
    if (cellFormat == null)
    {
      if(isComplexFormat)
      {
        cellFormat = new NumberFormat(convertedPattern,NumberFormat.COMPLEX_FORMAT);
      }
      else
      {
        cellFormat = new NumberFormat(convertedPattern);
      }
      numberFormats.put(convertedPattern, cellFormat);
    }
    return cellFormat;
  }

View Full Code Here


    l = new Label(0,3,"+/- Pi - custom 3dps", 
                  wrappedText);
    s.addCell(l);


    NumberFormat dp3 = new NumberFormat("#.###");
    WritableCellFormat dp3cell = new WritableCellFormat(dp3);
    n = new Number(1,3,3.1415926535,dp3cell);
    s.addCell(n);


    n = new Number(2,3,-3.1415926535, dp3cell);
    s.addCell(n);


    l = new Label(0,4,"+/- Pi - custom &3.14", 
                  wrappedText);
    s.addCell(l);


    NumberFormat pounddp2 = new NumberFormat("&#.00");
    WritableCellFormat pounddp2cell = new WritableCellFormat(pounddp2);
    n = new Number(1,4,3.1415926535,pounddp2cell);
    s.addCell(n);


    n = new Number(2,4,-3.1415926535, pounddp2cell);
    s.addCell(n);


    l = new Label(0,5,"+/- Pi - custom Text #.### Text", 
                  wrappedText);
    s.addCell(l);


    NumberFormat textdp4 = new NumberFormat("Text#.####Text");
    WritableCellFormat textdp4cell = new WritableCellFormat(textdp4);
    n = new Number(1,5,3.1415926535, textdp4cell);
    s.addCell(n);


    n = new Number(2,5,-3.1415926535, textdp4cell);
    s.addCell(n);


    // Integers
    l = new Label(4,0,"+/- Bilko default format");
    s.addCell(l);
    n = new Number(5, 0, 15042699);
    s.addCell(n);
    n = new Number(6, 0, -15042699);
    s.addCell(n);


    l = new Label(4,1,"+/- Bilko float format");
    s.addCell(l);
    WritableCellFormat cfi1 = new WritableCellFormat(NumberFormats.FLOAT);
    n = new Number(5, 1, 15042699, cfi1);
    s.addCell(n);
    n = new Number(6, 1, -15042699, cfi1);
    s.addCell(n);


    l = new Label(4,2,"+/- Thousands separator");
    s.addCell(l);
    WritableCellFormat cfi2 = new WritableCellFormat
      (NumberFormats.THOUSANDS_INTEGER);
    n = new Number(5, 2, 15042699,cfi2 );
    s.addCell(n);
    n = new Number(6, 2, -15042699, cfi2);
    s.addCell(n);


    l = new Label(4,3,"+/- Accounting red - added 0.01");
    s.addCell(l);
    WritableCellFormat cfi3 = new WritableCellFormat
      (NumberFormats.ACCOUNTING_RED_FLOAT);
    n = new Number(5, 3, 15042699.01, cfi3);
    s.addCell(n);
    n = new Number(6, 3, -15042699.01, cfi3);
    s.addCell(n);


    l = new Label(4,4,"+/- Percent");
    s.addCell(l);
    WritableCellFormat cfi4 = new WritableCellFormat
      (NumberFormats.PERCENT_INTEGER);
    n = new Number(5, 4, 15042699, cfi4);
    s.addCell(n);
    n = new Number(6, 4, -15042699, cfi4);
    s.addCell(n);


    l = new Label(4,5,"+/- Exponential - 2dps");
    s.addCell(l);
    WritableCellFormat cfi5 = new WritableCellFormat
      (NumberFormats.EXPONENTIAL);
    n = new Number(5, 5, 15042699, cfi5);
    s.addCell(n);
    n = new Number(6, 5, -15042699, cfi5);
    s.addCell(n);


    l = new Label(4,6,"+/- Custom exponentional - 3dps", wrappedText);
    s.addCell(l);
    NumberFormat edp3 = new NumberFormat("0.000E0");
    WritableCellFormat edp3Cell = new WritableCellFormat(edp3);
    n = new Number(5,6,15042699,edp3Cell);
    s.addCell(n);
    n = new Number(6,6,-15042699,edp3Cell);
    s.addCell(n);


    l = new Label(4, 7, "Custom neg brackets", wrappedText);
    s.addCell(l);
    NumberFormat negbracks = new NumberFormat("#,##0;(#,##0)");
    WritableCellFormat negbrackscell = new WritableCellFormat(negbracks);
    n = new Number(5,7, 15042699, negbrackscell);
    s.addCell(n);
    n = new Number(6,7, -15042699, negbrackscell);
    s.addCell(n);


    l = new Label(4, 8, "Custom neg brackets 2", wrappedText);
    s.addCell(l);
    NumberFormat negbracks2 = new NumberFormat("#,##0;(#,##0)a");
    WritableCellFormat negbrackscell2 = new WritableCellFormat(negbracks2);
    n = new Number(5,8, 15042699, negbrackscell2);
    s.addCell(n);
    n = new Number(6,8, -15042699, negbrackscell2);
    s.addCell(n);


    l = new Label(4, 9, "Custom percent", wrappedText);
    s.addCell(l);
    NumberFormat cuspercent = new NumberFormat("0.0%");
    WritableCellFormat cuspercentf = new WritableCellFormat(cuspercent);
    n = new Number(5, 9, 3.14159265, cuspercentf);
    s.addCell(n);
    


    // Booleans
    l = new Label(0,10, "Boolean - TRUE");
    s.addCell(l);
    Boolean b = new Boolean(1,10, true);
    s.addCell(b);


    l = new Label(0,11, "Boolean - FALSE");
    s.addCell(l);
    b = new Boolean(1,11,false);
    s.addCell(b);


    l = new Label(0, 12, "A hidden cell->");
    s.addCell(l);
    n = new Number(1, 12, 17, WritableWorkbook.HIDDEN_STYLE);
    s.addCell(n);


    // Currencies
    l = new Label(4, 19, "Currency formats");
    s.addCell(l);


    l = new Label(4, 21, "UK Pound");
    s.addCell(l);
    NumberFormat poundCurrency = 
      new NumberFormat(NumberFormat.CURRENCY_POUND + " #,###.00", 
                       NumberFormat.COMPLEX_FORMAT);
    WritableCellFormat poundFormat = new WritableCellFormat(poundCurrency);
    n = new Number(5, 21, 12345, poundFormat);
    s.addCell(n);


    l = new Label(4, 22, "Euro 1");
    s.addCell(l);
    NumberFormat euroPrefixCurrency = 
      new NumberFormat(NumberFormat.CURRENCY_EURO_PREFIX + " #,###.00", 
                       NumberFormat.COMPLEX_FORMAT);
    WritableCellFormat euroPrefixFormat = 
      new WritableCellFormat(euroPrefixCurrency);
    n = new Number(5, 22, 12345, euroPrefixFormat);
    s.addCell(n);


    l = new Label(4, 23, "Euro 2");
    s.addCell(l);
    NumberFormat euroSuffixCurrency = 
      new NumberFormat("#,###.00" + NumberFormat.CURRENCY_EURO_SUFFIX, 
                       NumberFormat.COMPLEX_FORMAT);
    WritableCellFormat euroSuffixFormat = 
      new WritableCellFormat(euroSuffixCurrency);
    n = new Number(5, 23, 12345, euroSuffixFormat);
    s.addCell(n);


    l = new Label(4, 24, "Dollar");
    s.addCell(l);
    NumberFormat dollarCurrency = 
      new NumberFormat(NumberFormat.CURRENCY_DOLLAR + " #,###.00", 
                       NumberFormat.COMPLEX_FORMAT);
    WritableCellFormat dollarFormat = 
      new WritableCellFormat(dollarCurrency);
    n = new Number(5, 24, 12345, dollarFormat);
    s.addCell(n);


    l = new Label(4, 25, "Japanese Yen");
    s.addCell(l);
    NumberFormat japaneseYenCurrency = 
      new NumberFormat(NumberFormat.CURRENCY_JAPANESE_YEN + " #,###.00", 
                       NumberFormat.COMPLEX_FORMAT);
    WritableCellFormat japaneseYenFormat = 
      new WritableCellFormat(japaneseYenCurrency);
    n = new Number(5, 25, 12345, japaneseYenFormat);
    s.addCell(n);


    l = new Label(4, 30, "Fraction formats");
    s.addCell(l);


    l = new Label(4,32, "One digit fraction format", wrappedText);
    s.addCell(l);


    WritableCellFormat fraction1digitformat = 
      new WritableCellFormat(NumberFormats.FRACTION_ONE_DIGIT);
    n = new Number(5, 32, 3.18279, fraction1digitformat);
    s.addCell(n);


    l = new Label(4,33, "Two digit fraction format", wrappedText);
    s.addCell(l);


    WritableCellFormat fraction2digitformat = 
      new WritableCellFormat(NumberFormats.FRACTION_TWO_DIGITS);
    n = new Number(5, 33, 3.18279, fraction2digitformat);
    s.addCell(n);


    l = new Label(4,34, "Three digit fraction format (improper)", wrappedText);
    s.addCell(l);


    NumberFormat fraction3digit1 = 
      new NumberFormat(NumberFormat.FRACTION_THREE_DIGITS, 
                       NumberFormat.COMPLEX_FORMAT);
    WritableCellFormat fraction3digitformat1 = 
      new WritableCellFormat(fraction3digit1);
    n = new Number(5, 34, 3.18927, fraction3digitformat1);
    s.addCell(n);


    l = new Label(4,35, "Three digit fraction format (proper)", wrappedText);
    s.addCell(l);


    NumberFormat fraction3digit2 = 
      new NumberFormat("# " + NumberFormat.FRACTION_THREE_DIGITS, 
                       NumberFormat.COMPLEX_FORMAT);
    WritableCellFormat fraction3digitformat2 = 
      new WritableCellFormat(fraction3digit2);
    n = new Number(5, 35, 3.18927, fraction3digitformat2);
    s.addCell(n);

View Full Code Here

      lc.setString(lc.getString() + " - mod");
    }


    // Change cell B10 to display 7 dps
    cell = sheet.getWritableCell(1,9);
    NumberFormat sevendps = new NumberFormat("#.0000000");
    cf = new WritableCellFormat(sevendps);
    cell.setCellFormat(cf);


    
    // Change cell B11 to display in the format 1e4
    cell = sheet.getWritableCell(1,10);
    NumberFormat exp4 = new NumberFormat("0.####E0");
    cf = new WritableCellFormat(exp4);
    cell.setCellFormat(cf);
    
    // Change cell B12 to be normal display
    cell = sheet.getWritableCell(1,11);

View Full Code Here

      cfRight.setAlignment(Alignment.RIGHT);
      
      WritableCellFormat cfRightBold = new WritableCellFormat(wfBold);
      cfRightBold.setAlignment(Alignment.RIGHT);
      
      DisplayFormat df = new NumberFormat("###,##0.00");
      WritableCellFormat cfNumber = new WritableCellFormat(wfNormal, df);
      cfNumber.setAlignment(Alignment.RIGHT);
      
      WritableCellFormat cfNumberBold = new WritableCellFormat(wfBold, df);
      cfNumberBold.setAlignment(Alignment.RIGHT);
      
      DisplayFormat df_ = new NumberFormat("########0");
      WritableCellFormat cfIntNumber = new WritableCellFormat(wfNormal, df_);
      cfIntNumber.setAlignment(Alignment.RIGHT);
      
      WritableCellFormat cfIntRightBold = new WritableCellFormat(wfBold, df_);
      cfIntRightBold.setAlignment(Alignment.RIGHT);

View Full Code Here

            }
            else
            {
               try
               {
                  cellFormat = new WritableCellFormat(new NumberFormat(cellStyle.formatMask));
               }
               catch (IllegalArgumentException e)
               {
                  throw new ExcelWorkbookException(Interpolator.instance().interpolate("Could not create number format for mask {0}", cellStyle.formatMask), e);
               }

View Full Code Here

        {
            return displayFormat;
        }
        try 
        {
            displayFormat = new NumberFormat(formatMask);
        } 
        catch (IllegalArgumentException e) 
        {
            // no-op, it was worth a try;
        }

View Full Code Here

            }
            else
            {
               try
               {
                  cellFormat = new WritableCellFormat(new NumberFormat(cellStyle.formatMask));
               }
               catch (IllegalArgumentException e)
               {
                  throw new ExcelWorkbookException(Interpolator.instance().interpolate("Could not create number format for mask {0}", cellStyle.formatMask), e);
               }

View Full Code Here

TOP

Related Classes of jxl.write.NumberFormat

it.pdor.webapp.contabilita.stampeContabili.bilancio.BilancioExcel

jxl.demo.ReadWrite

jxl.demo.Write

net.sf.jasperreports.engine.export.JExcelApiExporter

org.jboss.seam.excel.jxl.JXLHelper

java.text.DecimalFormat

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.