Java Code Examples for org.apache.poi.util.LocaleUtil#getUserLocale()

/**
 * Returns a string representation of the cell
 *
 * This method returns a simple representation,
 * anything more complex should be in user code, with
 * knowledge of the semantics of the sheet being processed.
 *
 * Formula cells return the formula string,
 * rather than the formula result.
 * Dates are displayed in dd-MMM-yyyy format
 * Errors are displayed as #ERR<errIdx>
 */
public String toString() {
    switch (getCellTypeEnum()) {
        case BLANK:
            return "";
        case BOOLEAN:
            return getBooleanCellValue()?"TRUE":"FALSE";
        case ERROR:
            return ErrorEval.getText((( BoolErrRecord ) _record).getErrorValue());
        case FORMULA:
            return getCellFormula();
        case NUMERIC:
            //TODO apply the dataformat for this cell
            if (HSSFDateUtil.isCellDateFormatted(this)) {
                SimpleDateFormat sdf = new SimpleDateFormat("dd-MMM-yyyy", LocaleUtil.getUserLocale());
                sdf.setTimeZone(LocaleUtil.getUserTimeZone());
                return sdf.format(getDateCellValue());
            }
return  String.valueOf(getNumericCellValue());
        case STRING:
            return getStringCellValue();
        default:
            return "Unknown Cell Type: " + getCellTypeEnum();
    }
}
 

public ExcelStyleDateFormatter(String pattern) {
    super(processFormatPattern(pattern), LocaleUtil.getUserLocale());
}
 

/** Creates a new general formatter. */
public CellGeneralFormatter() {
    this(LocaleUtil.getUserLocale());
}
 

/**
 * Creates a formatter using the {@link Locale#getDefault() default locale}.
 */
public HSSFDataFormatter() {
    this(LocaleUtil.getUserLocale());
}
 

/**
 * Creates a formatter using the {@link Locale#getDefault() default locale}.
 *
 * @param emulateCSV
 *            whether to emulate CSV output.
 */
public DataFormatter1(boolean emulateCSV) {
    this(LocaleUtil.getUserLocale(), true, emulateCSV);
}
 

/**
 * Creates a formatter using the {@link Locale#getDefault() default locale}.
 *
 * @param  emulateCSV whether to emulate CSV output.
 */
public DataFormatter(boolean emulateCSV) {
    this(LocaleUtil.getUserLocale(), true, emulateCSV);
}
 

/**
 * Creates a new date formatter with the given specification.
 *
 * @param format The format.
 */
public CellDateFormatter(String format) {
    this(LocaleUtil.getUserLocale(), format);
}
 

/**
 * Creates a new cell number formatter.
 *
 * @param format The format to parse.
 */
public CellNumberFormatter(String format) {
    this(LocaleUtil.getUserLocale(), format);
}
 

/**
 * Create an object to represent a format part.
 *
 * @param desc The string to parse.
 */
public CellFormatPart(String desc) {
    this(LocaleUtil.getUserLocale(), desc);
}
 

/**
 * Creates a new formatter object, storing the format in {@link #format}.
 *
 * @param format The format.
 */
public CellFormatter(String format) {
    this(LocaleUtil.getUserLocale(), format);
}
 

/**
 * Creates a format tracking wrapper around the given listener, using
 * the {@link Locale#getDefault() default locale} for the formats.
 * 
 * @param childListener the listener to be wrapped
 */
public FormatTrackingHSSFListener(HSSFListener childListener) {
	this(childListener, LocaleUtil.getUserLocale());
}