Package overit.geocall.basic.ui.xlsx

Class XlsxColumnLookup

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.XlsxColumnLookup

All Implemented Interfaces:

Serializable, Identified

@Component
public class XlsxColumnLookup
extends XlsxColumn

The class extends XlsxColumn.
The class implements and represent the column's cells with a look up inside, of an Excel sheet.

See Also:

• Serialized Form

Nested Class Summary

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

XlsxColumn.RowMergeUtil

Field Summary

Fields

Modifier and Type	Field	Description
protected String[]	_columnLabel
protected DBView	_dbvSv
protected boolean	_ignoreDecodeError
protected int	_nLabel
protected StaticView	_staticView
protected int[]	_staticViewFieldPos
protected TextFormat	_tf

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
XlsxColumnLookup()

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
protected void	initCellFormat()
void	setCOLUMNLABEL(String s)	Sets the column label array.
void	setFORMAT(String s)	Sets the number type format of the cell.
void	setIGNOREDECODEERROR(String s)	Sets if you want to ignore decode error.
void	setSTATICVIEW(String s)	Sets Static View from which take datas.
void	setupMetaData(HashMap dbfields)	Method used for the field init starting from a resultSet.
void	setupMetaData(DBView dbfields)	Method used for the field init starting from the DBView.

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, 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, 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

_staticView

protected StaticView _staticView

_dbvSv

protected DBView _dbvSv

_tf

protected TextFormat _tf

_nLabel

protected int _nLabel

_ignoreDecodeError

protected boolean _ignoreDecodeError

_columnLabel

protected String[] _columnLabel

_staticViewFieldPos

protected int[] _staticViewFieldPos

Constructor Details

XlsxColumnLookup

public XlsxColumnLookup()

Method Details

setIGNOREDECODEERROR

public void setIGNOREDECODEERROR(String s)

Sets if you want to ignore decode error.

Parameters:

s - 'true' or '1' if you want to egnore decode error, 'false' or '0' otherwise.

setSTATICVIEW

public void setSTATICVIEW(String s)

Sets Static View from which take datas.

Parameters:

s - The Static View to set.

setFORMAT

public void setFORMAT(String s)

Description copied from class: XlsxComponent

Sets the number type format of the cell.

Overrides:

setFORMAT in class XlsxComponent

Parameters:

s - Allow format are:

• '%' - Percent float format.
• 'i' - Integer format.
• 'f' - Float format.
• 'e' - Accounting red float format.
• default - Account float format.

setCOLUMNLABEL

public void setCOLUMNLABEL(String s)

Sets the column label array.

Parameters:

s - The string with the column's list separated by comma.

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

setupMetaData

public void setupMetaData(DBView dbfields)

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:

dbfields - The DBView for the init

initCellFormat

protected void initCellFormat()

Overrides:

initCellFormat in class XlsxComponent

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 XlsxColumn

Parameters:

sheet - The sheet

row - The list of rows

rowNum - The number of row

colNum - The cell number

cs - The XSSFCellStyle

Returns:

The cell