org.apache.cocoon.poi.hssf.usermodel: public class: HSSFDataFormat

org.apache.cocoon.poi.hssf.usermodel
public class: HSSFDataFormat [javadoc | source]

java.lang.Object
   org.apache.cocoon.poi.hssf.usermodel.HSSFDataFormat

Utility to identify builin formats. The following is a list of the formats as returned by this class.

0, "General"

1, "0"

2, "0.00"

3, "#,##0"

4, "#,##0.00"

5, "($#,##0_);($#,##0)"

6, "($#,##0_);[Red]($#,##0)"

7, "($#,##0.00);($#,##0.00)"

8, "($#,##0.00_);[Red]($#,##0.00)"

9, "0%"

0xa, "0.00%"

0xb, "0.00E+00"

0xc, "# ?/?"

0xd, "# ??/??"

0xe, "m/d/yy"

0xf, "d-mmm-yy"

0x10, "d-mmm"

0x11, "mmm-yy"

0x12, "h:mm AM/PM"

0x13, "h:mm:ss AM/PM"

0x14, "h:mm"

0x15, "h:mm:ss"

0x16, "m/d/yy h:mm"

// 0x17 - 0x24 reserved for international and undocumented 0x25, "(#,##0_);(#,##0)"

0x26, "(#,##0_);[Red](#,##0)"

0x27, "(#,##0.00_);(#,##0.00)"

0x28, "(#,##0.00_);[Red](#,##0.00)"

0x29, "_(*#,##0_);_(*(#,##0);_(* \"-\"_);_(@_)"

0x2a, "_($*#,##0_);_($*(#,##0);_($* \"-\"_);_(@_)"

0x2b, "_(*#,##0.00_);_(*(#,##0.00);_(*\"-\"??_);_(@_)"

0x2c, "_($*#,##0.00_);_($*(#,##0.00);_($*\"-\"??_);_(@_)"

0x2d, "mm:ss"

0x2e, "[h]:mm:ss"

0x2f, "mm:ss.0"

0x30, "##0.0E+0"

0x31, "@"

author: Andrew - C. Oliver (andyoliver@yahoo.com)

Method from org.apache.cocoon.poi.hssf.usermodel.HSSFDataFormat Summary:
getFormat, getFormat, getFormats, getNumberOfBuiltinFormats

Methods from java.lang.Object:
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method from org.apache.cocoon.poi.hssf.usermodel.HSSFDataFormat Detail:
public static short getFormat(String format) { if (formats == null) { populateFormats(); } short retval = -1; for (short k = 0; k < 0x31; k++) { String nformat = ( String ) formats.get(k); if ((nformat != null) && nformat.equals(format)) { retval = k; break; } } return retval; } get the format index that matches the given format string
public static String getFormat(short index) { if (formats == null) { populateFormats(); } return ( String ) formats.get(index); } get the format string that matches the given format index
public static List getFormats() { if (formats == null) { populateFormats(); } return formats; }
public static int getNumberOfBuiltinFormats() { if (formats == null) { populateFormats(); } return formats.size(); } get the number of builtin and reserved formats

Method from org.apache.cocoon.poi.hssf.usermodel.HSSFDataFormat Detail:

 public static short getFormat(String format) {
        if (formats == null)
        {
            populateFormats();
        }
        short retval = -1;
        for (short k = 0; k <  0x31; k++)
        {
            String nformat = ( String ) formats.get(k);
            if ((nformat != null) && nformat.equals(format))
            {
                retval = k;
                break;
            }
        }
        return retval;
}

get the format index that matches the given format string

 public static String getFormat(short index) {
        if (formats == null)
        {
            populateFormats();
        }
        return ( String ) formats.get(index);
}

get the format string that matches the given format index

 public static List getFormats() {
        if (formats == null)
        {
            populateFormats();
        }
        return formats;
}

 public static int getNumberOfBuiltinFormats() {
        if (formats == null)
        {
            populateFormats();
        }
        return formats.size();
}

get the number of builtin and reserved formats