Package overit.geocall.basic.ui.xlsx

Class XlsxColumnCurrency

java.lang.Object

overit.geocall.platform.ui.UINode

overit.geocall.basic.ui.xlsx.XlsxComponent

overit.geocall.basic.ui.xlsx.XlsxCell

overit.geocall.basic.ui.xlsx.XlsxColumn

overit.geocall.basic.ui.xlsx.XlsxColumnLong

overit.geocall.basic.ui.xlsx.XlsxColumnCurrency

All Implemented Interfaces:

Serializable, Identified

@Component
public class XlsxColumnCurrency
extends XlsxColumnLong

The class extends XlsxColumnLong.
The class implements and represent the column currency of an Excel sheet.

See Also:

• Serialized Form

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
protected class	XlsxColumnCurrency.Symbols

Nested classes/interfaces inherited from class overit.geocall.basic.ui.xlsx.XlsxColumn

XlsxColumn.RowMergeUtil

Field Summary

Fields

Modifier and Type	Field	Description
protected String	_currency
protected String	_precision
protected XlsxColumnCurrency.Symbols	_symbols
protected String	_symbolsString
protected boolean	_useGroupingSeparator

Fields inherited from class overit.geocall.basic.ui.xlsx.XlsxColumnLong

_numberformat

Fields inherited from class overit.geocall.basic.ui.xlsx.XlsxColumn

_bkgColorName, _breakCellFormatClass, _breakFormat, _breakFunction, _ffBkgColorSwitch, _ffFontVariantSwitch, _ffGroup, _ffName, _fontVariantName, _forcedBkgColor, _forcedFontVariant, _group, _stylesMap, _titlespan, _tmBkgColorSwitch, _tmFontVariantSwitch, commentName, ffCommentSwitch, ffFillPatternSwitch, fillPatternName, forcedComment, forcedFillPattern, tmCommentSwitch, tmFillPatternSwitch

Fields inherited from class overit.geocall.basic.ui.xlsx.XlsxCell

_cellstyle, _columnspan, _delim, _endfunction, _endLabel, _fixedsize, _lines4Row, _size

Fields inherited from class overit.geocall.basic.ui.xlsx.XlsxComponent

_align, _cellFormat, _cellFormatClass, _font, _format, _valign, _warning

Constructor Summary

Constructors

Constructor	Description
XlsxColumnCurrency()

Method Summary

Modifier and Type	Method	Description
protected org.apache.poi.ss.usermodel.Cell	giveCell(org.apache.poi.ss.usermodel.Sheet sheet, ArrayList row, int rowNum, int colNum, org.apache.poi.xssf.usermodel.XSSFCellStyle cs)	Method to implement that allows to set the orientation, the font etc
void	setCURRENCY(String c)	Sets the active currency in use.
void	setPRECISION(String p)	Sets the precision with which the numeric values ??
void	setSYMBOLS(String s)	Sets the symbol string.
protected void	setSymbolsString()
void	setupMetaData(HashMap dbfields)	Method used for the field init starting from a resultSet.
void	setupMetaData(DBView dbv)	Method used for the field init starting from the DBView.
void	setUSEGROUPING(String s)	Sets if you want to allow grouping the columns

Methods inherited from class overit.geocall.basic.ui.xlsx.XlsxColumn

getBreakCell, getCell, getDBVFieldPos, getForcedColor, getForcedComment, getForcedFillPattern, getForcedFontVariant, getHeaderColor, getHeaderFontColor, getTitleSpan, groupCell, initFormat, isGroup, isHeaderNOTVisible, makeCellStyle, parseFunction, setBKGCOLORNAME, setBKGCOLORSWITCH, setBREAKCELLFORMATCLASS, setBREAKFUNCTION, setCOLUMNSPAN, setCOMMENTNAME, setCOMMENTSWITCH, setFILLPATTERNNAME, setFILLPATTERNSWITCH, setFONTVARIANTNAME, setFONTVARIANTSWITCH, setForcedStyle, setGroup, setGROUP, setGROUPNAME, setHEADERCOLOR, setHEADERFONTCOLOR, setHEADVISIBLE, setLABEL, setTITLESPAN

Methods inherited from class overit.geocall.basic.ui.xlsx.XlsxCell

countBreakLines, getColumnSpan, getDELIM, getEndFunction, getEndLabel, getFixedSize, getLines4Row, getSize, setAutoSize4Lines, setBorder, setDELIM, setENDFUNCTION, setENDLABEL, setFONTSIZE, setLines4Row, setLINES4ROW, setSheet, setSize, setSIZE, setUseBGColor

Methods inherited from class overit.geocall.basic.ui.xlsx.XlsxComponent

getAlign, getBgColor, getBoolean, getBorder, getBorder, getBorder, getBorderColor, getBorderStyle, getCellFormat, getCellStyle, getChildIterator, getChildSize, getColor, getColor, getComment, getDefault, getDocument, getFont, getFontSize, getIdentity, getKey, getLabel, getName, getRegistryName, getSheet, getStyleName, getVAlign, getWarning, hasFontSize, initCellFormat, initChilds, isBold, isEnabled, isForcedBoldState, isForcedFontSize, isHidden, isLocked, isShrinkToFit, isWrap, onInit, setALIGN, setBGCOLOR, setBOLD, setBORDER, setBorderColor, setBORDERCOLORRGB, setBorderStyle, setBORDERSTYLE, setCellFormat, setCELLFORMATCLASS, setCellStyle, setCOLOR, setCOMMENT, setDEFAULT, setENABLED, setFONT, setFORMAT, setHIDDEN, setIdentity, setKEY, setLabel, setLOCKED, setNAME, setREGISTRYNAME, setSHRINKTOFIT, setSTYLENAME, setUSEBGCOLOR, setUSEDECIMALSPERCENTAGE, setUseHeadColor, setUSEHEADCOLOR, setVALIGN, setWRAP, useBGColor, useDecimalsPercentage, useHeaderColor

Methods inherited from class overit.geocall.platform.ui.UINode

addChild, addChildText, getChildren, getNodeId, getParent, getRoot, getSchema, setNodeId, setParent, setSchema

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface overit.geocall.util.Identified

getIdentity, setIdentity

Field Details

_useGroupingSeparator

protected boolean _useGroupingSeparator

_symbols

protected XlsxColumnCurrency.Symbols _symbols

_precision

protected String _precision

_currency

protected String _currency

_symbolsString

protected String _symbolsString

Constructor Details

XlsxColumnCurrency

public XlsxColumnCurrency()

Method Details

setPRECISION

public void setPRECISION(String p)

Sets the precision with which the numeric values ??in the cells will be displayed.

Parameters:

p - The precision to set.

setCURRENCY

public void setCURRENCY(String c)

Sets the active currency in use.

Parameters:

c - The currency to set.

setSYMBOLS

public void setSYMBOLS(String s)

Sets the symbol string.

Parameters:

s - The symbol string to set.

setUSEGROUPING

public void setUSEGROUPING(String s)

Sets if you want to allow grouping the columns

Parameters:

s - 'true' or '1' if you want to allow grouping, 'false' or '0' otherwise.

giveCell

protected org.apache.poi.ss.usermodel.Cell giveCell(org.apache.poi.ss.usermodel.Sheet sheet,
 ArrayList row,
 int rowNum,
 int colNum,
 org.apache.poi.xssf.usermodel.XSSFCellStyle cs)

Description copied from class: XlsxCell

Method to implement that allows to set the orientation, the font etc

Overrides:

giveCell in class XlsxColumnLong

Parameters:

sheet - The sheet

row - The list of rows

rowNum - The number of row

colNum - The cell number

cs - The XSSFCellStyle

Returns:

The cell

setupMetaData

public void setupMetaData(DBView dbv)

Description copied from class: XlsxColumn

Method used for the field init starting from the DBView. The name of the column must be null in case the field is not in the DBView or in the ResultSet.

Overrides:

setupMetaData in class XlsxColumn

Parameters:

dbv - The DBView for the init

setupMetaData

public void setupMetaData(HashMap dbfields)

Description copied from class: XlsxColumn

Method used for the field init starting from a resultSet. The name of the column must be null in case the field is not in the DBView or in the ResultSet.

Overrides:

setupMetaData in class XlsxColumn

Parameters:

dbfields - The HashMap for the init

setSymbolsString

protected void setSymbolsString()