ag.ion.bion.officelayer.text.table
Class TextTableCellNameHelper

java.lang.Object
  ag.ion.bion.officelayer.text.table.TextTableCellNameHelper

public class TextTableCellNameHelper
extends java.lang.Object

Helper in order to work with names of text table cells.

Method Summary

static int	getCellRangeEndColumnIndex(java.lang.String range) Returns the end column index of a cell range.
static int	getCellRangeEndRowIndex(java.lang.String range) Returns the end row index of a cell range.
static int	getCellRangeStartColumnIndex(java.lang.String range) Returns the start column index of a cell range.
static int	getCellRangeStartRowIndex(java.lang.String range) Returns the start row index of a cell range.
static java.lang.String	getColumnCharacter(int columnIndex) Returns column character(s) of the submitted index.
static java.lang.String	getColumnCharacter(java.lang.String cellName) Returns column characters of the submitted cell name.
static int	getColumnIndex(java.lang.String cellName) Returns column index of the submitted cell name.
static java.lang.String	getNextColumnName(java.lang.String columnName) Returns next column name on the basis of the submitted name of a column.
static java.lang.String	getRangeName(int startColumnIndex, int startRowIndex, int endColumnIndex, int endRowIndex) Creates the range name.
static int	getRowCounterValue(int rowIndex) Returns row counter value.
static int	getRowCounterValue(java.lang.String cellName) Returns row counter value.
static int	getRowIndex(java.lang.String cellName) Returns row index.
static java.lang.String	moveColumnIndex(int count, java.lang.String cellName) Moves column index.
static java.lang.String	moveColumnIndexTo(int newColumnIndex, java.lang.String cellName) Moves column to new submitted index.
static java.lang.String	moveRowCounterValue(int count, java.lang.String cellName) Moves row counter value.
static java.lang.String	moveRowCounterValueTo(int newRowCounterValue, java.lang.String cellName) Moves row counter value to submitted new row counter value.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

getRowIndex

public static int getRowIndex(java.lang.String cellName)

Returns row index. The first row has the index 0.

Parameters:

cellName - name of a text table cell

Returns:

row index

getRowCounterValue

public static int getRowCounterValue(java.lang.String cellName)

Returns row counter value. The first row has the row counter value 1.

Parameters:

cellName - name of a text table cell

Returns:

row counter value

getRowCounterValue

public static int getRowCounterValue(int rowIndex)

Returns row counter value.

Parameters:

rowIndex - row index to be used

Returns:

row counter value

moveRowCounterValue

public static java.lang.String moveRowCounterValue(int count,
                                                   java.lang.String cellName)
                                            throws TextException

Moves row counter value. Use positive count values in order to move the row counter value forward and negative values to move it backward.

Parameters:

count - difference value to be moved

cellName - name of a text table cell

Returns:

modified cell name

Throws:

TextException - if the new calculated row counter value is not valid

moveRowCounterValueTo

public static java.lang.String moveRowCounterValueTo(int newRowCounterValue,
                                                     java.lang.String cellName)
                                              throws TextException

Moves row counter value to submitted new row counter value.

Parameters:

newRowCounterValue - new row counter value

cellName - name of a text table cell

Returns:

modified cell name

Throws:

TextException - if the submitted row counter value is not valid

getColumnIndex

public static int getColumnIndex(java.lang.String cellName)

Returns column index of the submitted cell name.

Parameters:

cellName - name of a text table cell

Returns:

column index of the submitted cell name

getColumnCharacter

public static java.lang.String getColumnCharacter(int columnIndex)

Returns column character(s) of the submitted index.

Parameters:

columnIndex - index of the column to be converted

Returns:

column character(s) of the submitted index

getColumnCharacter

public static java.lang.String getColumnCharacter(java.lang.String cellName)

Returns column characters of the submitted cell name.

Parameters:

cellName - name of a text table cell

Returns:

column characters of the submitted cell name

moveColumnIndex

public static java.lang.String moveColumnIndex(int count,
                                               java.lang.String cellName)
                                        throws TextException

Moves column index. Use positive count values in order to move the column index forward and negative values to move it backward.

Parameters:

count - difference to be moved

cellName - name of a text table cell

Returns:

modified cell name

Throws:

TextException - if the new calculated column index is not valid

moveColumnIndexTo

public static java.lang.String moveColumnIndexTo(int newColumnIndex,
                                                 java.lang.String cellName)
                                          throws TextException

Moves column to new submitted index.

Parameters:

newColumnIndex - new column index to be used

cellName - name of a text table cell

Returns:

modified cell name

Throws:

TextException - if the submitted column index is not valid

getCellRangeStartRowIndex

public static int getCellRangeStartRowIndex(java.lang.String range)

Returns the start row index of a cell range.

Parameters:

range - the cell range

Returns:

the index of the start row

getCellRangeStartColumnIndex

public static int getCellRangeStartColumnIndex(java.lang.String range)

Returns the start column index of a cell range.

Parameters:

range - the cell range

Returns:

the index of the start column

getCellRangeEndRowIndex

public static int getCellRangeEndRowIndex(java.lang.String range)

Returns the end row index of a cell range.

Parameters:

range - the cell range

Returns:

the index of the end row

getCellRangeEndColumnIndex

public static int getCellRangeEndColumnIndex(java.lang.String range)

Returns the end column index of a cell range.

Parameters:

range - the cell range

Returns:

the index of the end column

getNextColumnName

public static java.lang.String getNextColumnName(java.lang.String columnName)

Returns next column name on the basis of the submitted name of a column.

Parameters:

columnName - name of the column to be used

Returns:

next column name on the basis of the submitted name of a column

getRangeName

public static java.lang.String getRangeName(int startColumnIndex,
                                            int startRowIndex,
                                            int endColumnIndex,
                                            int endRowIndex)

Creates the range name.

Parameters:

startColumnIndex - index of the start column

startRowIndex - index of the start row

endColumnIndex - index of the end column

endRowIndex - index of the end row

Returns:

the range name