src/org/tiefaces/components/websheet/utility/CellStyleUtility.java
private static String getSymbolFromFormat(final Cell cell) {
		CellStyle style = cell.getCellStyle();
		if (style == null) {
			return null;
		}
		String formatString = style.getDataFormatString();
		if (formatString == null) {
			return null;
		}
		if (formatString.indexOf(TieConstants.CELL_ADDR_PRE_FIX) < 0) {
			return null;
		}
		int ipos = formatString.indexOf("[$");
		if (ipos < 0) {
			// only $ found, then return default dollar symbol
			return "$";
		}
		// return specified dollar symbol
		return formatString.substring(ipos + 2,
				formatString.indexOf(']', ipos));
	}
private static String getSymbolFromFormat(final Cell cell) {
		CellStyle style = cell.getCellStyle();
		if (style == null) {
			return null;
		}
		String formatString = style.getDataFormatString();
		if (formatString == null) {
			return null;
		}
		if (formatString.indexOf(TieConstants.CELL_ADDR_PRE_FIX) < 0) {
			return null;
		}
		int ipos = formatString.indexOf("[$");
		if (ipos < 0) {
			// only $ found, then return default dollar symbol
			return "$";
		}
		// return specified dollar symbol
		return formatString.substring(ipos + 2,
				formatString.indexOf(']', ipos));
	}
private static String getSymbolFromFormat ( final Cell cell ) { CellStyle style = cell . getCellStyle ( ) ; if ( style == null ) { return null ; } String formatString = style . getDataFormatString ( ) ; if ( formatString == null ) { return null ; } if ( formatString . indexOf ( TieConstants . CELL_ADDR_PRE_FIX ) < 0 ) { return null ; } int ipos = formatString . indexOf ( "[$" ) ; if ( ipos < 0 ) { // only $ found, then return default dollar symbol
 return "$" ; } // return specified dollar symbol
 return formatString . substring ( ipos + 2 , formatString . indexOf ( ' ' , ipos ) ) ; }
get symbol from format string e.g. [$CAD] #,##0.00 will return CAD. While
$#,##0.00 will return $

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