Package overit.geocall.basic.ui.xlsx

Class XlsxColumnDouble

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

All Implemented Interfaces:

Serializable, Identified

Direct Known Subclasses:

XlsxColumnMeasure

@Component
public class XlsxColumnDouble
extends XlsxColumnLong

This class extends XlsxColumnLong.
The class implements and represent the column Double 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 DecimalFormat	_df
protected boolean	_forcedFormat
protected boolean	_forceDouble
protected boolean	_forcedSymbols
protected String	_symbols

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

Method Summary

Modifier and Type	Method	Description
protected static DecimalFormat	createDecimalFormat(String s, String f)
static char	getNextChar(StringBuilder sb)	Extract the first characther form the symbol String.
static int	getNextInt(StringBuilder sb)	Extract the positive integer from the stirng symbol head, if the string is empty return -1.
static String	getNextString(StringBuilder sb, String delim)
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 Double	giveCellValue(Object val)
void	setFORCEDOUBLE(String s)	Sets if you want to force the number value to double or not.
void	setFORMAT(String s)	Sets the column double format.
void	setSYMBOLS(String s)	Sets the symbol to display.

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

_symbols

protected String _symbols

_df

protected DecimalFormat _df

_forcedFormat

protected boolean _forcedFormat

_forcedSymbols

protected boolean _forcedSymbols

_forceDouble

protected boolean _forceDouble

Constructor Details

XlsxColumnDouble

public XlsxColumnDouble()

Method Details

setFORMAT

public void setFORMAT(String s)

Sets the column double format.

Overrides:

setFORMAT in class XlsxComponent

Parameters:

s - The format to set.

setSYMBOLS

public void setSYMBOLS(String s)

Sets the symbol to display.

Parameters:

s - The symbol to set.

setFORCEDOUBLE

public void setFORCEDOUBLE(String s)

Sets if you want to force the number value to double or not.

Parameters:

s - 'true' or '1' if you want to force conversion to double, '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

giveCellValue

protected Double giveCellValue(Object val)

createDecimalFormat

protected static DecimalFormat createDecimalFormat(String s,
 String f)

getNextChar

public static char getNextChar(StringBuilder sb)

Extract the first characther form the symbol String.

Parameters:

sb - The string form which extract the first character.

Returns:

The first characther form the symbol string.

getNextInt

public static int getNextInt(StringBuilder sb)

Extract the positive integer from the stirng symbol head, if the string is empty return -1.

Parameters:

sb - The string from which extract the positive number, if exists.

Returns:

The positive integer from the stirng symbol head, if the string is empty return -1.

getNextString

public static String getNextString(StringBuilder sb,
 String delim)