Package overit.geocall.basic.ui.xlsx

Class XlsxColumnDate

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

All Implemented Interfaces:

Serializable, Identified

@Component
public class XlsxColumnDate
extends XlsxColumn

This class extends XlsxColumn.
The class implements and represent the column Date 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 boolean	_hasDateFormat
protected int	_hoursFormat
protected int	_range
static final String	FROM
static final String	TO

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

Method Summary

Modifier and Type	Method	Description
int	getHOURSFORMAT()	Gets the hour format of the column. By default the get value is the "12 hours format" e.g.10PM or 10AM.
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
boolean	hasDateFormat()	Gets if the XlsxColumnDate is represent as a real Date format into the excel sheet or not.
void	setCELLFORMAT(String s)
void	setDATEFORMAT(String s)	Sets if the XlsxColumnDate is represent as a real Date format into the excel sheet or not. If this attribute it's set to true or '1', the column's XSSFCellStyle will be set as Date into the sheet and also their values will be set as Date object. In this way the excel sheet will treat the data in the cells, from the column, as dates and no longer as text strings (for example in the definition of a filter on the column).
void	setFORMAT(String s)	Sets the number type format of the cell.
void	setHOURSFORMAT(int hoursFormat)	Sets the hour format of the column. By default the set value is the "12 hours format" e.g. 10PM or 10AM.
void	setRANGE(String s)	Define the range of the date, a "from" range or a "to" range.

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

FROM

public static final String FROM

See Also:

• Constant Field Values

TO

public static final String TO

See Also:

• Constant Field Values

_range

protected int _range

_hasDateFormat

protected boolean _hasDateFormat

_hoursFormat

protected int _hoursFormat

Constructor Details

XlsxColumnDate

public XlsxColumnDate()

Method Details

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.

setCELLFORMAT

public void setCELLFORMAT(String s)

setRANGE

public void setRANGE(String s)

Define the range of the date, a "from" range or a "to" range.

Parameters:

s - The range to set, the possible values are "FROM" and "TO".

setDATEFORMAT

public void setDATEFORMAT(String s)

Sets if the XlsxColumnDate is represent as a real Date format into the excel sheet or not.
If this attribute it's set to true or '1', the column's XSSFCellStyle will be set as Date into the sheet and also their values will be set as Date object.
In this way the excel sheet will treat the data in the cells, from the column, as dates and no longer as text strings (for example in the definition of a filter on the column).

Parameters:

s - A string that represents a boolean value ("true" or "1", "false" or "0").

hasDateFormat

public boolean hasDateFormat()

Gets if the XlsxColumnDate is represent as a real Date format into the excel sheet or not.

Returns:

true or "1", false or "0".
If this columns has a date format, its XSSFCellStyle will be set as Date into the sheet and also their values will be set as Date object.
In this way the excel sheet will treat the data in the cells, from the column, as dates and no longer as text strings (for example in the definition of a filter on the column).

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

setHOURSFORMAT

public void setHOURSFORMAT(int hoursFormat)

Sets the hour format of the column.
By default the set value is the "12 hours format" e.g. 10PM or 10AM.

Parameters:

hoursFormat - The format to use for the column. For Example, using the Calendar class, possible value are "Calendar.HOUR" or "Calendar.HOUR_OF_DAY".

getHOURSFORMAT

public int getHOURSFORMAT()

Gets the hour format of the column.
By default the get value is the "12 hours format" e.g.10PM or 10AM.

Returns:

The hour format of the column.