src/org/tiefaces/components/websheet/utility/CellStyleUtility.java
private static String getSymbolPositionFromFormat(final Cell cell) {
		CellStyle style = cell.getCellStyle();
		if (style == null) {
			return "p";
		}
		String formatString = style.getDataFormatString();
		if (formatString == null) {
			return "p";
		}
		int symbolpos = formatString.indexOf('$');
		int numberpos = formatString.indexOf('#');
		if (numberpos < 0) {
			numberpos = formatString.indexOf('0');
		}
		if (symbolpos < numberpos) {
			return "p";
		} else {
			return "s";
		}
	}
private static String getSymbolPositionFromFormat(final Cell cell) {
		CellStyle style = cell.getCellStyle();
		if (style == null) {
			return "p";
		}
		String formatString = style.getDataFormatString();
		if (formatString == null) {
			return "p";
		}
		int symbolpos = formatString.indexOf('$');
		int numberpos = formatString.indexOf('#');
		if (numberpos < 0) {
			numberpos = formatString.indexOf('0');
		}
		if (symbolpos < numberpos) {
			return "p";
		} else {
			return "s";
		}
	}
private static String getSymbolPositionFromFormat ( final Cell cell ) { CellStyle style = cell . getCellStyle ( ) ; if ( style == null ) { return "p" ; } String formatString = style . getDataFormatString ( ) ; if ( formatString == null ) { return "p" ; } int symbolpos = formatString . indexOf ( ' ' ) ; int numberpos = formatString . indexOf ( ' ' ) ; if ( numberpos < 0 ) { numberpos = formatString . indexOf ( ' ' ) ; } if ( symbolpos < numberpos ) { return "p" ; } else { return "s" ; } }
get symbol position from format string e.g. [$CAD] #,##0.00 will return
p. While #,##0.00 $ will return s

@param cell
the cell
@return symbol position of the formatted string
get symbol position from format string e . g . [ $CAD ] # ##0 . 00 will return p . While # ##0 . 00 $ will return s