Package overit.geocall.basic.ui.xlsx

Class XlsxColumnFormula

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

All Implemented Interfaces:

Serializable, Identified

@Component
public class XlsxColumnFormula
extends XlsxColumn

The class extends XlsxColumn.
The class implements and represent the column's cell with a function, 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 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
XlsxColumnFormula()

Method Summary

Modifier and Type	Method	Description
protected Object	cleanValue(Object value)
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)	#sval will be substituted with the value NAME of the DBView and quoted #val will be substituted with the value NAME of the DBView e.g. function="CLEAN("#val")" take in the db the field RAGIONESOCIALE='mario ' obtaining the function 'mario' #scol will be substituted with the column letter #srow will be substituted with the number of the row
protected String	parseFunction(ArrayList row, int rowNum, int colNum, org.apache.poi.xssf.usermodel.XSSFCellStyle cs)
void	setFUNCTION(String s)	Sets the function to insert into the cell.

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

Constructor Details

XlsxColumnFormula

public XlsxColumnFormula()

Method Details

setFUNCTION

public void setFUNCTION(String s)

Sets the function to insert into the cell.

Parameters:

s - The function to set.

giveCell

public 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)

#sval will be substituted with the value NAME of the DBView and quoted #val will be substituted with the value NAME of the DBView e.g. function="CLEAN("#val")" take in the db the field RAGIONESOCIALE='mario ' obtaining the function 'mario' #scol will be substituted with the column letter #srow will be substituted with the number of the row

Overrides:

giveCell in class XlsxColumn

Parameters:

sheet - The sheet

row - The list of rows

rowNum - The number of the row

colNum - The number of the column

cs - The XSSFCellStyle

Returns:

The cell

parseFunction

protected String parseFunction(ArrayList row,
 int rowNum,
 int colNum,
 org.apache.poi.xssf.usermodel.XSSFCellStyle cs)

cleanValue

protected Object cleanValue(Object value)