altered source with constructor taking HSSFWorkbook as a parm

HSSFDataFormat.java (text/plain), 10.83 KB, created by Elvira Gurevich on 2002-09-03 22:36:40 UTC

(hide)

Description: altered source with constructor taking HSSFWorkbook as a parm

Filename:

MIME Type:

Creator: Elvira Gurevich

Created: 2002-09-03 22:36:40 UTC

Size: 10.83 KB

patch

obsolete

>/* ==================================================================== > * The Apache Software License, Version 1.1 > * > * Copyright (c) 2002 The Apache Software Foundation. All rights > * reserved. > * > * Redistribution and use in source and binary forms, with or without > * modification, are permitted provided that the following conditions > * are met: > * > * 1. Redistributions of source code must retain the above copyright > * notice, this list of conditions and the following disclaimer. > * > * 2. Redistributions in binary form must reproduce the above copyright > * notice, this list of conditions and the following disclaimer in > * the documentation and/or other materials provided with the > * distribution. > * > * 3. The end-user documentation included with the redistribution, > * if any, must include the following acknowledgment: > * "This product includes software developed by the > * Apache Software Foundation (http://www.apache.org/)." > * Alternately, this acknowledgment may appear in the software itself, > * if and wherever such third-party acknowledgments normally appear. > * > * 4. The names "Apache" and "Apache Software Foundation" and > * "Apache POI" must not be used to endorse or promote products > * derived from this software without prior written permission. For > * written permission, please contact apache@apache.org. > * > * 5. Products derived from this software may not be called "Apache", > * "Apache POI", nor may "Apache" appear in their name, without > * prior written permission of the Apache Software Foundation. > * > * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED > * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES > * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE > * DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR > * ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, > * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT > * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF > * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND > * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, > * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT > * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF > * SUCH DAMAGE. > * ==================================================================== > * > * This software consists of voluntary contributions made by many > * individuals on behalf of the Apache Software Foundation. For more > * information on the Apache Software Foundation, please see > * <http://www.apache.org/>. > */ > >/* > * HSSFDataFormat.java > * > * Created on December 18, 2001, 12:42 PM > */ >package org.apache.poi.hssf.usermodel; > >import java.util.Vector; >import java.util.List; >import java.util.ListIterator; > >import org.apache.poi.hssf.model.Workbook; >import org.apache.poi.hssf.record.Record; >import org.apache.poi.hssf.record.FormatRecord; > >/** > * Utility to identify builin formats. Now can handle user defined data formats also. The following is a list of the formats as > * returned by this class.<P> > *<P> > * 0, "General"<P> > * 1, "0"<P> > * 2, "0.00"<P> > * 3, "#,##0"<P> > * 4, "#,##0.00"<P> > * 5, "($#,##0_);($#,##0)"<P> > * 6, "($#,##0_);[Red]($#,##0)"<P> > * 7, "($#,##0.00);($#,##0.00)"<P> > * 8, "($#,##0.00_);[Red]($#,##0.00)"<P> > * 9, "0%"<P> > * 0xa, "0.00%"<P> > * 0xb, "0.00E+00"<P> > * 0xc, "# ?/?"<P> > * 0xd, "# ??/??"<P> > * 0xe, "m/d/yy"<P> > * 0xf, "d-mmm-yy"<P> > * 0x10, "d-mmm"<P> > * 0x11, "mmm-yy"<P> > * 0x12, "h:mm AM/PM"<P> > * 0x13, "h:mm:ss AM/PM"<P> > * 0x14, "h:mm"<P> > * 0x15, "h:mm:ss"<P> > * 0x16, "m/d/yy h:mm"<P> > *<P> > * // 0x17 - 0x24 reserved for international and undocumented > * 0x25, "(#,##0_);(#,##0)"<P> > * 0x26, "(#,##0_);[Red](#,##0)"<P> > * 0x27, "(#,##0.00_);(#,##0.00)"<P> > * 0x28, "(#,##0.00_);[Red](#,##0.00)"<P> > * 0x29, "_(*#,##0_);_(*(#,##0);_(* \"-\"_);_(@_)"<P> > * 0x2a, "_($*#,##0_);_($*(#,##0);_($* \"-\"_);_(@_)"<P> > * 0x2b, "_(*#,##0.00_);_(*(#,##0.00);_(*\"-\"??_);_(@_)"<P> > * 0x2c, "_($*#,##0.00_);_($*(#,##0.00);_($*\"-\"??_);_(@_)"<P> > * 0x2d, "mm:ss"<P> > * 0x2e, "[h]:mm:ss"<P> > * 0x2f, "mm:ss.0"<P> > * 0x30, "##0.0E+0"<P> > * 0x31, "@"<P> > * > * > * @author Andrew C. Oliver (acoliver at apache dot org) > */ > >public class HSSFDataFormat >{ > private static Vector builtinFormats; > > private Vector formats = new Vector(); > private Workbook workbook; > private boolean movedBuiltins = false; // Flag to see if need to > // check the built in list > // or if the regular list > // has all entries. > > /** > * Construncts a new data formatter. It takes a workbook to have > * access to the workbooks format records. > * @param workbook the workbook the formats are tied to. > */ > public HSSFDataFormat(Workbook workbook) { > this.workbook = workbook; > if (builtinFormats == null) populateBuiltinFormats(); > } > > /** > * Construncts a new data formatter. It takes a HSSFWorkbook to have > * access to the workbooks format records. > * @param workbook the workbook the formats are tied to. > */ > public HSSFDataFormat(HSSFWorkbook hworkbook) { > workbook = hworkbook.getWorkbook(); > if (builtinFormats == null) populateBuiltinFormats(); > } > > private static synchronized void populateBuiltinFormats() > { > builtinFormats = new Vector(); > builtinFormats.add(0, "General"); > builtinFormats.add(1, "0"); > builtinFormats.add(2, "0.00"); > builtinFormats.add(3, "#,##0"); > builtinFormats.add(4, "#,##0.00"); > builtinFormats.add(5, "($#,##0_);($#,##0)"); > builtinFormats.add(6, "($#,##0_);[Red]($#,##0)"); > builtinFormats.add(7, "($#,##0.00);($#,##0.00)"); > builtinFormats.add(8, "($#,##0.00_);[Red]($#,##0.00)"); > builtinFormats.add(9, "0%"); > builtinFormats.add(0xa, "0.00%"); > builtinFormats.add(0xb, "0.00E+00"); > builtinFormats.add(0xc, "# ?/?"); > builtinFormats.add(0xd, "# ??/??"); > builtinFormats.add(0xe, "m/d/yy"); > builtinFormats.add(0xf, "d-mmm-yy"); > builtinFormats.add(0x10, "d-mmm"); > builtinFormats.add(0x11, "mmm-yy"); > builtinFormats.add(0x12, "h:mm AM/PM"); > builtinFormats.add(0x13, "h:mm:ss AM/PM"); > builtinFormats.add(0x14, "h:mm"); > builtinFormats.add(0x15, "h:mm:ss"); > builtinFormats.add(0x16, "m/d/yy h:mm"); > > // 0x17 - 0x24 reserved for international and undocumented > builtinFormats.add(0x17, "0x17"); > builtinFormats.add(0x18, "0x18"); > builtinFormats.add(0x19, "0x19"); > builtinFormats.add(0x1a, "0x1a"); > builtinFormats.add(0x1b, "0x1b"); > builtinFormats.add(0x1c, "0x1c"); > builtinFormats.add(0x1d, "0x1d"); > builtinFormats.add(0x1e, "0x1e"); > builtinFormats.add(0x1f, "0x1f"); > builtinFormats.add(0x20, "0x20"); > builtinFormats.add(0x21, "0x21"); > builtinFormats.add(0x22, "0x22"); > builtinFormats.add(0x23, "0x23"); > builtinFormats.add(0x24, "0x24"); > > // 0x17 - 0x24 reserved for international and undocumented > builtinFormats.add(0x25, "(#,##0_);(#,##0)"); > builtinFormats.add(0x26, "(#,##0_);[Red](#,##0)"); > builtinFormats.add(0x27, "(#,##0.00_);(#,##0.00)"); > builtinFormats.add(0x28, "(#,##0.00_);[Red](#,##0.00)"); > builtinFormats.add(0x29, "_(*#,##0_);_(*(#,##0);_(* \"-\"_);_(@_)"); > builtinFormats.add(0x2a, "_($*#,##0_);_($*(#,##0);_($* \"-\"_);_(@_)"); > builtinFormats.add(0x2b, "_(*#,##0.00_);_(*(#,##0.00);_(*\"-\"??_);_(@_)"); > builtinFormats.add(0x2c, > "_($*#,##0.00_);_($*(#,##0.00);_($*\"-\"??_);_(@_)"); > builtinFormats.add(0x2d, "mm:ss"); > builtinFormats.add(0x2e, "[h]:mm:ss"); > builtinFormats.add(0x2f, "mm:ss.0"); > builtinFormats.add(0x30, "##0.0E+0"); > builtinFormats.add(0x31, "@"); > } > > public static List getBuiltinFormats() > { > if (builtinFormats == null) > { > populateBuiltinFormats(); > } > return builtinFormats; > } > > /** > * get the format index that matches the given format string > * @param format string matching a built in format > * @return index of format or -1 if undefined. > */ > > public static short getBuiltinFormat(String format) > { > if (builtinFormats == null) > { > populateBuiltinFormats(); > } > short retval = -1; > > for (short k = 0; k < 0x31; k++) > { > String nformat = ( String ) builtinFormats.get(k); > > if ((nformat != null) && nformat.equals(format)) > { > retval = k; > break; > } > } > return retval; > } > > /** > * get the format index that matches the given format string. > * Creates a new format if one is not found. > * @param format string matching a built in format > * @return index of format. > */ > > public short getFormat(String format) > { > ListIterator i; > int ind; > if (!movedBuiltins) { > i = builtinFormats.listIterator(); > while (i.hasNext()) { > ind = i.nextIndex(); > formats.add(ind, i.next()); > } > movedBuiltins = true; > } > i = formats.listIterator(); > while (i.hasNext()) { > ind = i.nextIndex(); > if (format.equals(i.next())) > return (short)ind; > } > > ind = workbook.getFormat(format, true); > if (formats.size() <= ind) > formats.setSize(ind + 1); > formats.add(ind, format); > > return (short)ind; > } > > /** > * get the format string that matches the given format index > * @param index of a format > * @return string represented at index of format or null if there is not a format at that index > */ > > public String getFormat(short index) > { > if (movedBuiltins) > return ( String ) formats.get(index); > else > return (String) (builtinFormats.get(index) != null ? builtinFormats.get(index) : formats.get(index)); > } > > /** > * get the format string that matches the given format index > * @param index of a built in format > * @return string represented at index of format or null if there is not a builtin format at that index > */ > > public static String getBuiltinFormat(short index) > { > if (builtinFormats == null) > { > populateBuiltinFormats(); > } > return ( String ) builtinFormats.get(index); > } > > /** > * get the number of builtin and reserved builtinFormats > * @return number of builtin and reserved builtinFormats > */ > > public static int getNumberOfBuiltinBuiltinFormats() > { > if (builtinFormats == null) > { > populateBuiltinFormats(); > } > return builtinFormats.size(); > } >} View Attachment As Raw

This is ASF Bugzilla: the Apache Software Foundation bug system. In case of problems with the functioning of ASF Bugzilla, please contact bugzilla-admin@apache.org. Please Note: this e-mail address is only for reporting problems with ASF Bugzilla. Mail about any other subject will be silently ignored.

• • Home
  • | New
  • | Browse
  • | Search
  • |
    [?]
  • | Reports
  • | Help
  • | New Account
  • | Log In
    Remember [x]
  • | Forgot Password
    Login: [x]