Package overit.geocall.basic.ui.xlsx

Class XlsxColumnSwitch

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

All Implemented Interfaces:

Serializable, Identified

@Component
public class XlsxColumnSwitch
extends XlsxColumn

This class extends XlsxColumn.
The class implement and represent the column/cell switch 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 XlsxCell[]	_childCols
protected HashMap	_switch

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

Method Summary

Modifier and Type	Method	Description
protected void	_calcChildCols()
org.apache.poi.ss.usermodel.Cell	giveCell(org.apache.poi.ss.usermodel.Sheet sheet, ArrayList row, int rowNum, int cellNum, org.apache.poi.xssf.usermodel.XSSFCellStyle cs)	Method to implement that allows to set the orientation, the font etc
void	setSWITCH(String s)	Sets the switch with the datas to the cell/column.

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

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

_switch

protected HashMap _switch

_childCols

protected XlsxCell[] _childCols

Constructor Details

XlsxColumnSwitch

public XlsxColumnSwitch()

Method Details

setSWITCH

public void setSWITCH(String s)

Sets the switch with the datas to the cell/column.

Parameters:

s - The set of datas to populate the switch, seprarated by comma.

_calcChildCols

protected void _calcChildCols()

giveCell

public org.apache.poi.ss.usermodel.Cell giveCell(org.apache.poi.ss.usermodel.Sheet sheet,
 ArrayList row,
 int rowNum,
 int cellNum,
 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

cellNum - The cell number

cs - The XSSFCellStyle

Returns:

The cell