Style Intelligence v12.0

inetsoft.report.lens
Class CalcTableLens

java.lang.Object
  extended by inetsoft.report.lens.AbstractTableLens
      extended by inetsoft.report.lens.AttributeTableLens
          extended by inetsoft.report.lens.DefaultTableLens
              extended by inetsoft.report.lens.CalcTableLens
All Implemented Interfaces:
StyleConstants, TableFilter, TableLens, XConstants, XTable, Serializable, Cloneable

public class CalcTableLens
extends DefaultTableLens

The CalcTableLens provides an extended interface for a fixed size table. It can contain formulas on a per cell basis. Each formula can reference any other cell in the table similar to a spread sheet.

See Also:
Serialized Form

Nested Class Summary
protected static class CalcTableLens.Adjuster
          Interface for adjusting row/column index.
protected  class CalcTableLens.CalcTableLensDataDescriptor
          FreehandTableLens data descriptor.
protected static class CalcTableLens.Formula
          Class to hold a cell formula.
 
Field Summary
static int DEFAULT_MODE
          Regular edit mode.
protected  FormulaTable elem
           
static int EXPAND_HORIZONTAL
          Expand cells horizontally to new columns.
static int EXPAND_NONE
          Don't expand cell.
static int EXPAND_VERTICAL
          Expand cells vertically to new rows.
static int FORMULA_MODE
          Edit mode that shows full formula string.
static int NAME_MODE
          Edit mode that shows cell names and groups.
static String ROOT_GROUP
          This is a pseudo group that is a non-repeating root of all groups.
 
Fields inherited from class inetsoft.report.lens.AttributeTableLens
alignmap, attritable, backgroundmap, cache, check, colborderCmap, colbordermap, fontmap, foregroundmap, insetsmap, linkmap, presentermap, rowborderCmap, rowbordermap, table, wrapmap
 
Fields inherited from class inetsoft.report.lens.AbstractTableLens
descriptor, isLeftAlign
 
Fields inherited from interface inetsoft.report.TableLens
BREAK_BORDER, NULL
 
Fields inherited from interface inetsoft.uql.XTable
EOT
 
Fields inherited from interface inetsoft.report.StyleConstants
ARROW_LINE_1, ARROW_LINE_2, ARROW_LINE_3, BACKGROUND_CENTER, BACKGROUND_TILED, BOX_RECTANGLE, BOX_ROUNDED_RECTANGLE, CENTER, CHART_3D_BAR, CHART_3D_BAR_3D, CHART_3D_PIE, CHART_3D_STACK_BAR, CHART_AREA, CHART_BAR, CHART_BUBBLE, CHART_CANDLE, CHART_CURVE, CHART_FILL_RADAR, CHART_GANTT, CHART_INV_BAR, CHART_INV_CURVE, CHART_INV_LINE, CHART_INV_POINT, CHART_INV_STACK_BAR, CHART_LINE, CHART_MAX_USER, CHART_PARETO, CHART_PIE, CHART_PIE_EXPLODED_ALL, CHART_PIE_EXPLODED_FIRST, CHART_PIE_EXPLODED_NONE, CHART_POINT, CHART_RADAR, CHART_RIBBON, CHART_SCATTER, CHART_SPEEDOMETER, CHART_STACK_AREA, CHART_STACK_BAR, CHART_STICK, CHART_STOCK, CHART_SURFACE, CHART_USER, CHART_VOLUME, CHART_WATERFALL, CHART_XY_LINE, CIRCLE, CROSS, CURRENCY, DASH_LINE, DASH_MASK, DEFAULT_PAGE_SIZE, DIAMOND, DOT_LINE, DOUBLE_3D_LOWERED, DOUBLE_3D_RAISED, DOUBLE_LINE, DOUBLE_MASK, FILL, FILLED_CIRCLE, FILLED_DIAMOND, FILLED_SQUARE, FILLED_TRIANGLE, FRACTION_WIDTH_MASK, H_ALIGN_MASK, H_CENTER, H_CURRENCY, H_LEFT, H_LINE, H_RIGHT, LANDSCAPE, LARGE_DASH, LEFT, LINECAP_BUTT, LINECAP_ROUND, LINECAP_SQUARE, LINEJOIN_BEVEL, LINEJOIN_MITER, LINEJOIN_ROUND, LOWERED_3D, LOWERED_MASK, LT_ANGLE, MEDIUM_DASH, MEDIUM_LINE, NIL, NO_BORDER, NONE, PAPER_10X11, PAPER_10X14, PAPER_11X17, PAPER_15X11, PAPER_9X11, PAPER_A_PLUS, PAPER_A2, PAPER_A3, PAPER_A3_EXTRA, PAPER_A3_EXTRA_TRANSVERSE, PAPER_A3_TRANSVERSE, PAPER_A4, PAPER_A4_EXTRA, PAPER_A4_PLUS, PAPER_A4_TRANSVERSE, PAPER_A4SMALL, PAPER_A5, PAPER_A5_EXTRA, PAPER_A5_TRANSVERSE, PAPER_B_PLUS, PAPER_B4, PAPER_B5, PAPER_B5_EXTRA, PAPER_B5_TRANSVERSE, PAPER_CSHEET, PAPER_DSHEET, PAPER_ENV_10, PAPER_ENV_11, PAPER_ENV_12, PAPER_ENV_14, PAPER_ENV_9, PAPER_ENV_B4, PAPER_ENV_B5, PAPER_ENV_B6, PAPER_ENV_C3, PAPER_ENV_C4, PAPER_ENV_C5, PAPER_ENV_C6, PAPER_ENV_C65, PAPER_ENV_DL, PAPER_ENV_INVITE, PAPER_ENV_ITALY, PAPER_ENV_MONARCH, PAPER_ENV_PERSONAL, PAPER_ESHEET, PAPER_EXECUTIVE, PAPER_FANFOLD_LGL_GERMAN, PAPER_FANFOLD_STD_GERMAN, PAPER_FANFOLD_US, PAPER_FOLIO, PAPER_ISO_B4, PAPER_JAPANESE_POSTCARD, PAPER_LEDGER, PAPER_LEGAL, PAPER_LEGAL_EXTRA, PAPER_LETTER, PAPER_LETTER_EXTRA, PAPER_LETTER_EXTRA_TRANSVERSE, PAPER_LETTER_PLUS, PAPER_LETTER_TRANSVERSE, PAPER_LETTERSMALL, PAPER_NOTE, PAPER_QUARTO, PAPER_STATEMENT, PAPER_TABLOID, PAPER_TABLOID_EXTRA, PATTERN_0, PATTERN_1, PATTERN_10, PATTERN_11, PATTERN_12, PATTERN_13, PATTERN_14, PATTERN_15, PATTERN_16, PATTERN_17, PATTERN_18, PATTERN_19, PATTERN_2, PATTERN_3, PATTERN_4, PATTERN_5, PATTERN_6, PATTERN_7, PATTERN_8, PATTERN_9, PATTERN_NONE, PORTRAIT, RAISED_3D, RAISED_MASK, REMAINDER, RIGHT, RIGHT_ANGLE, SOLID_MASK, SQUARE, STAR, THICK_LINE, THIN_LINE, THIN_THIN_LINE, TRAY_AUTO, TRAY_CASSETTE, TRAY_ENVELOPE, TRAY_ENVMANUAL, TRAY_FORMSOURCE, TRAY_LARGECAPACITY, TRAY_LARGEFMT, TRAY_LOWER, TRAY_MANUAL, TRAY_MIDDLE, TRAY_ONLYONE, TRAY_SMALLFMT, TRAY_TRACTOR, TRAY_UPPER, TRIANGLE, ULTRA_THIN_LINE, V_ALIGN_MASK, V_ANGLE, V_BASELINE, V_BOTTOM, V_CENTER, V_LINE, V_TOP, WIDTH_MASK, X
 
Fields inherited from interface inetsoft.uql.XConstants
AM_PM_DATE_GROUP, AM_PM_OF_DAY_DATE_GROUP, AVERAGE_FORMULA, CALC_FORMULA, COLUMN, CONCAT_FORMULA, CONDITION_EMPTY_STRING, CONDITION_NULL_STRING, CONDITION_NULL_VALUE, CONDITION_REAL_NULL, CORRELATION_FORMULA, COUNT_FORMULA, COVARIANCE_FORMULA, CURRENCY_FORMAT, CURRENT_REP_CHANGED, CURRENT_REP_WILL_CHANGE, DATE_FORMAT, DAY_DATE_GROUP, DAY_OF_MONTH_DATE_GROUP, DAY_OF_WEEK_DATE_GROUP, DAY_OF_YEAR_DATE_GROUP, DECIMAL_FORMAT, DISTINCTCOUNT_FORMULA, FIRST_FORMULA, FULL_JOIN, GREATER_EQUAL_JOIN, GREATER_JOIN, GROUP_OTHERS, HOUR_DATE_GROUP, HOUR_OF_DAY_DATE_GROUP, INNER_JOIN, JOIN, LAST_FORMULA, LEAVE_OTHERS, LEFT_JOIN, LESS_EQUAL_JOIN, LESS_JOIN, MAX_FORMULA, MEDIAN_FORMULA, MESSAGE_FORMAT, MILLISECOND_DATE_GROUP, MIN_FORMULA, MINUTE_DATE_GROUP, MODE_FORMULA, MONTH_DATE_GROUP, MONTH_OF_YEAR_DATE_GROUP, NONE_DATE_GROUP, NONE_FORMULA, NOT_EQUAL_JOIN, NTHLARGEST_FORMULA, NTHMOSTFREQUENT_FORMULA, NTHSMALLEST_FORMULA, PARAM_PREFIX, PART_DATE_GROUP, PERCENT_FORMAT, PERCENTAGE_BY_COL, PERCENTAGE_BY_ROW, PERCENTAGE_NONE, PERCENTAGE_OF_COL_GRANDTOTAL, PERCENTAGE_OF_COL_GROUP, PERCENTAGE_OF_GRANDTOTAL, PERCENTAGE_OF_GROUP, PERCENTAGE_OF_ROW_GRANDTOTAL, PERCENTAGE_OF_ROW_GROUP, POPULATIONSTANDARDDEVIATION_FORMULA, POPULATIONVARIANCE_FORMULA, PRODUCT_FORMULA, PTHPERCENTILE_FORMULA, QUARTER_DATE_GROUP, QUARTER_OF_YEAR_DATE_GROUP, RIGHT_JOIN, SECOND_DATE_GROUP, SET_FORMULA, SORT_ASC, SORT_DESC, SORT_NONE, SORT_ORIGINAL, SORT_SPECIFIC, SORT_VALUE_ASC, SORT_VALUE_DESC, STANDARDDEVIATION_FORMULA, SUB_QUERY_PARAM, SUM_FORMULA, SUMSQ_FORMULA, SUMWT_FORMULA, VARIANCE_FORMULA, WEEK_DATE_GROUP, WEEK_OF_MONTH_DATE_GROUP, WEEK_OF_YEAR_DATE_GROUP, WEIGHTEDAVERAGE_FORMULA, YEAR_DATE_GROUP
 
Constructor Summary
CalcTableLens()
          Create an empty table.
CalcTableLens(int rows, int cols)
          Create a table width specified number of rows and columns.
CalcTableLens(Object[][] data)
          Create a table with initial data.
CalcTableLens(TableLens lens)
          Create a copy of a table lens.
CalcTableLens(TableLens lens, boolean dataonly)
          Create a copy of a table lens.
 
Method Summary
protected  void adjust(CalcTableLens.Adjuster adjuster)
          Adjust the row or column index.
 void cancel()
          Cancel the runtime calc table generation.
 void clearPageBreaks()
          Clear all page breaks.
 Object clone()
          Make a copy of this table lens.
protected  Object cloneObject(Object obj)
          Perform object level post clone operation.
 Map createNameMap()
          Create a map from cell names to CalcAttr.
 inetsoft.report.internal.table.SpanMap createSpanMap()
          Create a spanmap of the table.
protected  Object evaluate(int row, int col, CalcTableLens.Formula expr)
          Evaluate a formula for a cell.
 int getAlignment(int r, int c)
          Return the per cell alignment.
protected  Object getCachedValue(int r, int c)
          Get cached cell value.
 String getCellID(int row, int col)
          Get an unique cell identifier.
 Point getCellLocation(String name)
          Get the cell location with the specified cell name.
 String getCellName(int row, int col)
          Get the cell name.
 String[] getCellNames()
          Get all cell names (name set through setCellName()).
 String getColGroup(int row, int col)
          Get the column group of this cell.
 TableDataDescriptor getDescriptor()
          Get internal table data descriptor which contains table structural infos.
 int getEditMode()
          Get the current edit mode.
 FormulaTable getElement()
          Get the parent element.
 int getExpansion(int row, int col)
          Get the cell expansion type.
 String getFormula(int r, int c)
          Get the formula on a cell.
 String getMergeColGroup(int row, int col)
          Get the name of the column group cell for merging expanded cells.
 String getMergeRowGroup(int row, int col)
          Get the name of the row group cell for merging expanded cells.
 Object getObject(int r, int c)
          Return the value at the specified cell.
 inetsoft.report.internal.binding.OrderInfo getOrderInfo(int row, int col)
          Get the OrderInfo for a cell
 ReportSheet getReport()
          Get the report associated with this table.
 String getRowGroup(int row, int col)
          Get the row group of this cell.
 TableLens getScriptTable()
          Get the base table for the calc table.
 inetsoft.report.internal.binding.TopNInfo getTopN(int row, int col)
          Get the TopNInfo for a cell
protected  Object getValue(int r, int c)
          Return the value at the specified cell.
 void insertColumn(int col)
          Insert a new column to the left of the specified column.
 void insertRow(int row)
          Insert a new row above the specified row.
 void invalidate()
          Invalidate the table filter forcely, and the table filter will perform filtering calculation to validate itself.
 boolean isBound(int row, int col)
          Gets the flag that determines if a cell is bound to data.
 boolean isMergeCells(int row, int col)
          Check if expanded cells should be merged.
 boolean isPageAfter(int row, int col)
          Check if a page break should be inserted after this group.
 inetsoft.report.internal.table.RuntimeCalcTableLens process()
          Process the calc table.
 void removeColumn(int col)
          Remove a column at the specified location.
 void removeRow(int row)
          Remove the specified row.
 void setBound(int row, int col, boolean bound)
          Sets the flag that determines if a cell is bound to data.
protected  void setCachedValue(int r, int c, Object obj)
          Set the cached value.
 void setCellName(int row, int col, String name)
          Set the cell name.
 void setColGroup(int row, int col, String group)
          Set the column group of this cell.
 void setEditMode(int editMode)
          Set to editing mode, which control how the cell contents are shown.
 void setElement(FormulaTable elem)
          Set the parent element to be used as the scope of formulas.
 void setExpansion(int row, int col, int expansion)
          Set the cell expansion type.
 void setFormula(int r, int c, String formula)
          Set a formula on a cell.
 void setMergeCells(int row, int col, boolean merge)
          Set wheter expanded cells should be merged.
 void setMergeColGroup(int row, int col, String group)
          Set the column group for merging the cells.
 void setMergeRowGroup(int row, int col, String group)
          Set the row group for merging the cells.
 void setOrderInfo(int row, int col, inetsoft.report.internal.binding.OrderInfo order)
          Sets the OrderInfo for a cell
 void setPageAfter(int row, int col, boolean pageAfter)
          Set the page after flag.
 void setReport(ReportSheet report)
          Set the report associated with this table.
 void setRowGroup(int row, int col, String group)
          Set the row group of this cell.
 void setTopN(int row, int col, inetsoft.report.internal.binding.TopNInfo topN)
          Set the TopNInfo for a cell
 
Methods inherited from class inetsoft.report.lens.DefaultTableLens
addColumn, addRow, getSpan, insertColumn, insertRow, removeColumn, removeRow, setColCount, setData, setDimension, setHeaderColCount, setHeaderRowCount, setObject, setRowCount, setTable, setTrailerColCount, setTrailerRowCount, setXMetaInfo
 
Methods inherited from class inetsoft.report.lens.AttributeTableLens
cloneAttributes, containsLink, dispose, findColumn, format, getBackground, getBaseColIndex, getBaseRowIndex, getCellFormat, getCellFormat, getColBorder, getColBorderColor, getColCount, getColHeader, getColType, getColumnIdentifier, getColWidth, getData, getFont, getForeground, getFormat, getFormat, getFormat, getHeaderColCount, getHeaderRowCount, getHyperlink, getInsets, getObject0, getPresenter, getPresenter, getPresenter, getRowBorder, getRowBorderColor, getRowCount, getRowFormat, getRowHeight, getTable, getTrailerColCount, getTrailerRowCount, isColSuppressIfDuplicate, isColSuppressIfZero, isLineWrap, isSuppressIfDuplicate, isSuppressIfZero, moreRows, removeAllSpans, setAlignment, setAlignment, setBackground, setColAlignment, setColAutoSize, setColBackground, setColBorder, setColBorder, setColBorder, setColBorderColor, setColBorderColor, setColBorderColor, setColFont, setColForeground, setColHeader, setColInsets, setColLineWrap, setColSuppressIfDuplicate, setColSuppressIfZero, setColWidth, setData, setFont, setFont, setForeground, setFormat, setFormat, setFormat, setHyperlink, setInsets, setInsets, setLineWrap, setLineWrap, setPresenter, setPresenter, setPresenter, setRowAlignment, setRowAutoSize, setRowBackground, setRowBorder, setRowBorder, setRowBorder, setRowBorderColor, setRowBorderColor, setRowBorderColor, setRowFont, setRowForeground, setRowFormat, setRowHeight, setRowHeight, setRowInsets, setRowLineWrap, setRowPresenter, setSpan
 
Methods inherited from class inetsoft.report.lens.AbstractTableLens
addChangeListener, containsDrill, containsFormat, findColumnByIdentifier, fireChangeEvent, getBoolean, getByte, getDefaultFormat, getDouble, getFloat, getInt, getLong, getShort, getXDrillInfo, isNull, isPrimitive, removeChangeListener, setColumnIdentifier, setLeftAlign, setLocal
 
Methods inherited from class java.lang.Object
equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 
Methods inherited from interface inetsoft.report.TableLens
addChangeListener, containsDrill, containsFormat, getDefaultFormat, getXDrillInfo, removeChangeListener
 
Methods inherited from interface inetsoft.uql.XTable
getBoolean, getByte, getDouble, getFloat, getInt, getLong, getShort, isNull, isPrimitive, setColumnIdentifier
 

Field Detail

EXPAND_NONE

public static final int EXPAND_NONE
Don't expand cell.

See Also:
Constant Field Values

EXPAND_HORIZONTAL

public static final int EXPAND_HORIZONTAL
Expand cells horizontally to new columns.

See Also:
Constant Field Values

EXPAND_VERTICAL

public static final int EXPAND_VERTICAL
Expand cells vertically to new rows.

See Also:
Constant Field Values

DEFAULT_MODE

public static final int DEFAULT_MODE
Regular edit mode.

See Also:
Constant Field Values

NAME_MODE

public static final int NAME_MODE
Edit mode that shows cell names and groups.

See Also:
Constant Field Values

FORMULA_MODE

public static final int FORMULA_MODE
Edit mode that shows full formula string.

See Also:
Constant Field Values

ROOT_GROUP

public static final String ROOT_GROUP
This is a pseudo group that is a non-repeating root of all groups. It can be used as a row/column group name of a cell to disable the default (using left/top expanding cell as parent group).

See Also:
Constant Field Values

elem

protected FormulaTable elem
Constructor Detail

CalcTableLens

public CalcTableLens()
Create an empty table.


CalcTableLens

public CalcTableLens(int rows,
                     int cols)
Create a table width specified number of rows and columns.

Parameters:
rows - number of rows.
cols - number of columns.

CalcTableLens

public CalcTableLens(TableLens lens)
Create a copy of a table lens.


CalcTableLens

public CalcTableLens(TableLens lens,
                     boolean dataonly)
Create a copy of a table lens.

Parameters:
dataonly - true if only copy the data from table lens.

CalcTableLens

public CalcTableLens(Object[][] data)
Create a table with initial data. The dimension of the table is derived from the data array dimensions.

Parameters:
data - table data.
Method Detail

setReport

public void setReport(ReportSheet report)
Set the report associated with this table.


getReport

public ReportSheet getReport()
Get the report associated with this table.


setElement

public void setElement(FormulaTable elem)
Set the parent element to be used as the scope of formulas.


getElement

public FormulaTable getElement()
Get the parent element.


getScriptTable

public TableLens getScriptTable()
Get the base table for the calc table.


getAlignment

public int getAlignment(int r,
                        int c)
Return the per cell alignment.

Specified by:
getAlignment in interface TableLens
Overrides:
getAlignment in class AttributeTableLens
Parameters:
r - row number.
c - column number.
Returns:
cell alignment.

invalidate

public void invalidate()
Invalidate the table filter forcely, and the table filter will perform filtering calculation to validate itself.

Specified by:
invalidate in interface TableFilter
Overrides:
invalidate in class DefaultTableLens

process

public inetsoft.report.internal.table.RuntimeCalcTableLens process()
Process the calc table. If any cell expansion exists in the table, a new table with the expansion is generated to be used for runtime processing.


cancel

public void cancel()
Cancel the runtime calc table generation.


createNameMap

public Map createNameMap()
Create a map from cell names to CalcAttr.


createSpanMap

public inetsoft.report.internal.table.SpanMap createSpanMap()
Create a spanmap of the table.


getDescriptor

public TableDataDescriptor getDescriptor()
Get internal table data descriptor which contains table structural infos.

Specified by:
getDescriptor in interface TableLens
Specified by:
getDescriptor in interface XTable
Overrides:
getDescriptor in class DefaultTableLens
Returns:
table data descriptor.

getEditMode

public int getEditMode()
Get the current edit mode.


setEditMode

public void setEditMode(int editMode)
Set to editing mode, which control how the cell contents are shown.

Parameters:
editMode - one of DEFAULT_MODE, NAME_MODE, and FORMULA_MODE.

getObject

public Object getObject(int r,
                        int c)
Return the value at the specified cell.

Specified by:
getObject in interface XTable
Overrides:
getObject in class AttributeTableLens
Parameters:
r - row number.
c - column number.
Returns:
the value at the location.

getValue

protected Object getValue(int r,
                          int c)
Return the value at the specified cell. If this is a formula, the formula is evaluated.

Parameters:
r - row number.
c - column number.
Returns:
the value at the location.

getCachedValue

protected Object getCachedValue(int r,
                                int c)
Get cached cell value.


setCachedValue

protected void setCachedValue(int r,
                              int c,
                              Object obj)
Set the cached value.


setFormula

public void setFormula(int r,
                       int c,
                       String formula)
Set a formula on a cell.


getFormula

public String getFormula(int r,
                         int c)
Get the formula on a cell.


insertRow

public void insertRow(int row)
Insert a new row above the specified row.

Overrides:
insertRow in class DefaultTableLens

removeRow

public void removeRow(int row)
Remove the specified row.

Overrides:
removeRow in class DefaultTableLens

insertColumn

public void insertColumn(int col)
Insert a new column to the left of the specified column.

Overrides:
insertColumn in class DefaultTableLens

removeColumn

public void removeColumn(int col)
Remove a column at the specified location.

Overrides:
removeColumn in class DefaultTableLens

getCellID

public String getCellID(int row,
                        int col)
Get an unique cell identifier.


getCellLocation

public Point getCellLocation(String name)
Get the cell location with the specified cell name.

Returns:
cell location where x is column and y is row index.

getCellName

public String getCellName(int row,
                          int col)
Get the cell name.


setCellName

public void setCellName(int row,
                        int col,
                        String name)
Set the cell name.


isMergeCells

public boolean isMergeCells(int row,
                            int col)
Check if expanded cells should be merged.


setMergeCells

public void setMergeCells(int row,
                          int col,
                          boolean merge)
Set wheter expanded cells should be merged.


getMergeRowGroup

public String getMergeRowGroup(int row,
                               int col)
Get the name of the row group cell for merging expanded cells. If it's set, only the cells within the same group are merged.


setMergeRowGroup

public void setMergeRowGroup(int row,
                             int col,
                             String group)
Set the row group for merging the cells.


getMergeColGroup

public String getMergeColGroup(int row,
                               int col)
Get the name of the column group cell for merging expanded cells. If it's set, only the cells within the same group are merged.


setMergeColGroup

public void setMergeColGroup(int row,
                             int col,
                             String group)
Set the column group for merging the cells.


isPageAfter

public boolean isPageAfter(int row,
                           int col)
Check if a page break should be inserted after this group.


setPageAfter

public void setPageAfter(int row,
                         int col,
                         boolean pageAfter)
Set the page after flag. This should only be set on a vertically expanding cell.


getOrderInfo

public inetsoft.report.internal.binding.OrderInfo getOrderInfo(int row,
                                                               int col)
Get the OrderInfo for a cell


setOrderInfo

public void setOrderInfo(int row,
                         int col,
                         inetsoft.report.internal.binding.OrderInfo order)
Sets the OrderInfo for a cell


getTopN

public inetsoft.report.internal.binding.TopNInfo getTopN(int row,
                                                         int col)
Get the TopNInfo for a cell


setTopN

public void setTopN(int row,
                    int col,
                    inetsoft.report.internal.binding.TopNInfo topN)
Set the TopNInfo for a cell


isBound

public boolean isBound(int row,
                       int col)
Gets the flag that determines if a cell is bound to data.

Parameters:
row - the row index of the cell.
col - the column index of the cell.
Returns:
true if bound; false otherwise.

setBound

public void setBound(int row,
                     int col,
                     boolean bound)
Sets the flag that determines if a cell is bound to data.

Parameters:
row - the row index of the cell.
col - the column index of the cell.
bound - true if bound; false otherwise.

getRowGroup

public String getRowGroup(int row,
                          int col)
Get the row group of this cell.


setRowGroup

public void setRowGroup(int row,
                        int col,
                        String group)
Set the row group of this cell. Setting the row group of a cell makes it a nested group/cell of the parent group. The parent group is expanded first.


getColGroup

public String getColGroup(int row,
                          int col)
Get the column group of this cell.


setColGroup

public void setColGroup(int row,
                        int col,
                        String group)
Set the column group of this cell. Setting the column group of a cell makes it a nested group/cell of the parent group. The parent group is expanded first.


getExpansion

public int getExpansion(int row,
                        int col)
Get the cell expansion type.


setExpansion

public void setExpansion(int row,
                         int col,
                         int expansion)
Set the cell expansion type. Use one of the expansion constants: EXPAND_NONE, EXPAND_HORIZONTAL, EXPAND_VERTICAL.


getCellNames

public String[] getCellNames()
Get all cell names (name set through setCellName()).


evaluate

protected Object evaluate(int row,
                          int col,
                          CalcTableLens.Formula expr)
Evaluate a formula for a cell.


clone

public Object clone()
Make a copy of this table lens.

Overrides:
clone in class DefaultTableLens
Returns:
the cloned AbstractTableLens if successful, null otherwise

cloneObject

protected Object cloneObject(Object obj)
Perform object level post clone operation.

Overrides:
cloneObject in class DefaultTableLens

adjust

protected void adjust(CalcTableLens.Adjuster adjuster)
Adjust the row or column index.


clearPageBreaks

public void clearPageBreaks()
Clear all page breaks.


Copyright © 1996-2014 InetSoft Technology Corp. All Rights Reserved.