|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
System.Objectxl.biff.RecordData
xl.biff.WritableRecordData
xl.biff.FormatRecord
xl.write.biff.NumberFormatRecord
xl.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 .NET specification, and Excel API 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
Field Summary | |
static xl.write.biff.NumberFormatRecord.NonValidatingFormat |
COMPLEX_FORMAT
Pass in to the constructor to bypass the format validation |
static System.String |
CURRENCY_DOLLAR
Constant format string for the US Dollar sign |
static System.String |
CURRENCY_EURO_PREFIX
Constant format string for the Euro currency symbol where it precedes the format |
static System.String |
CURRENCY_EURO_SUFFIX
Constant format string for the Euro currency symbol where it precedes the format |
static System.String |
CURRENCY_JAPANESE_YEN
Constant format string for the Japanese Yen sign |
static System.String |
CURRENCY_POUND
Constant format string for the UK pound sign |
static System.String |
FRACTION_HALVES
Constant format string for fractions as halves |
static System.String |
FRACTION_HUNDREDTHS
Constant format string for fractions as hundredths |
static System.String |
FRACTION_QUARTERS
Constant format string for fractions as quarter |
static System.String |
FRACTION_SIXTEENTHS
Constant format string for fractions as sixteenths |
static System.String |
FRACTION_TENTHS
Constant format string for fractions as tenths |
static System.String |
FRACTION_THREE_DIGITS
Constant format string for three digit fractions |
static System.String |
FRACTIONS_EIGHTHS
Constant format string for fractions as eighths |
Fields inherited from class xl.biff.FormatRecord |
biff7, biff8 |
Constructor Summary | |
NumberFormat( System .String format)
Constructor, taking in the .NET compliant number format |
|
NumberFormat( System .String format,
xl.write.biff.NumberFormatRecord.NonValidatingFormat dummy)
Constructor, taking in the non-.NET compliant number format. |
Methods inherited from class xl.biff.FormatRecord |
equals, getData, getDateFormat, getFormatIndex, getFormatString, getIndexCode, getNumberFormat, hashCode, initialize, isBuiltIn, isDate, isInitialized, isNumber |
Methods inherited from class xl.biff.WritableRecordData |
getBytes |
Methods inherited from class System.Object |
getClass, notify, notifyAll, toString, wait, wait, wait |
Methods inherited from interface xl.biff.DisplayFormat |
getFormatIndex, initialize, isBuiltIn, isInitialized |
Field Detail |
public static final xl.write.biff.NumberFormatRecord.NonValidatingFormat COMPLEX_FORMAT
public static readonly System
.String CURRENCY_EURO_PREFIX
public static readonly System
.String CURRENCY_EURO_SUFFIX
public static readonly System
.String CURRENCY_POUND
public static readonly System
.String CURRENCY_JAPANESE_YEN
public static readonly System
.String CURRENCY_DOLLAR
public static readonly System
.String FRACTION_THREE_DIGITS
public static readonly System
.String FRACTION_HALVES
public static readonly System
.String FRACTION_QUARTERS
public static readonly System
.String FRACTIONS_EIGHTHS
public static readonly System
.String FRACTION_SIXTEENTHS
public static readonly System
.String FRACTION_TENTHS
public static readonly System
.String FRACTION_HUNDREDTHS
Constructor Detail |
public NumberFormat(System
.String format)
format
- the format stringpublic NumberFormat(System
.String format,
xl.write.biff.NumberFormatRecord.NonValidatingFormat dummy)
format
- the format stringdummy
- dummy parameter
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |