nxopen

Interface SpreadsheetCellData

All Superinterfaces:

Remote, TransientObject

public interface SpreadsheetCellData
extends TransientObject

Represents a class for Spreadsheet cell data. The data type held in the cell can be obtained from the type() . And then the value can obtained from the correct accessor. The value and type of the cell will be changed when calling the set methods. That is if a cell was a formula, but the setDoubleValue(double) is called, the type will be changed as well. It should be noted the cell value on the sheet will not updated, by calling a set method on this class. The object must then be passed into the appropriate method on SpreadsheetManager .
Usable only on Windows

Created in NX11.0.0

Nested Class Summary

Nested Classes

Modifier and Type	Interface and Description
static class	SpreadsheetCellData.Types Data types enum

Method Summary

Modifier and Type	Method and Description
double	doubleValue() Returns the double value stored in the cell.
String	formulaValue() Returns the formula stored in the cell.
int	intValue() Returns the integer value stored in the cell.
boolean	logicalValue() Returns the logical value stored the cell.
void	setDoubleValue(double doubleValue) License requirements: None.
void	setFormulaValue(String formulaValue) License requirements: None.
void	setIntValue(int intValue) License requirements: None.
void	setLogicalValue(boolean logicalValue) License requirements: None.
void	setStringValue(String stringValue) License requirements: None.
void	setType(SpreadsheetCellData.Types cellType) License requirements: None.
String	stringValue() Returns the string value stored in the cell.
SpreadsheetCellData.Types	type() Returns the type of data in the cell.

Methods inherited from interface nxopen.TransientObject

_value, dispose, printTestData, printTestData

Method Detail

type

SpreadsheetCellData.Types type()
                        throws NXException,
                               RemoteException

Returns the type of data in the cell.
License requirements: None.

Created in NX11.0.0

Returns:

Type of value in cell

Throws:

NXException

RemoteException

setType

void setType(SpreadsheetCellData.Types cellType)
      throws NXException,
             RemoteException

License requirements: None.

Created in NX11.0.0

Parameters:

cellType -

Throws:

NXException

RemoteException

doubleValue

double doubleValue()
            throws NXException,
                   RemoteException

Returns the double value stored in the cell.
License requirements: None.

Created in NX11.0.0

Returns:

numeric value of the cell

Throws:

NXException

RemoteException

setDoubleValue

void setDoubleValue(double doubleValue)
             throws NXException,
                    RemoteException

License requirements: None.

Created in NX11.0.0

Parameters:

doubleValue -

Throws:

NXException

RemoteException

intValue

int intValue()
      throws NXException,
             RemoteException

Returns the integer value stored in the cell.
License requirements: None.

Created in NX11.0.0

Returns:

numeric value of the cell

Throws:

NXException

RemoteException

setIntValue

void setIntValue(int intValue)
          throws NXException,
                 RemoteException

License requirements: None.

Created in NX11.0.0

Parameters:

intValue -

Throws:

NXException

RemoteException

formulaValue

String formulaValue()
             throws NXException,
                    RemoteException

Returns the formula stored in the cell.
License requirements: None.

Created in NX11.0.0

Returns:

formula of the cell

Throws:

NXException

RemoteException

setFormulaValue

void setFormulaValue(String formulaValue)
              throws NXException,
                     RemoteException

License requirements: None.

Created in NX11.0.0

Parameters:

formulaValue -

Throws:

NXException

RemoteException

stringValue

String stringValue()
            throws NXException,
                   RemoteException

Returns the string value stored in the cell.
License requirements: None.

Created in NX11.0.0

Returns:

sting value of the cell

Throws:

NXException

RemoteException

setStringValue

void setStringValue(String stringValue)
             throws NXException,
                    RemoteException

License requirements: None.

Created in NX11.0.0

Parameters:

stringValue -

Throws:

NXException

RemoteException

logicalValue

boolean logicalValue()
              throws NXException,
                     RemoteException

Returns the logical value stored the cell.
License requirements: None.

Created in NX11.0.0

Returns:

boolean value of the cell

Throws:

NXException

RemoteException

setLogicalValue

void setLogicalValue(boolean logicalValue)
              throws NXException,
                     RemoteException

License requirements: None.

Created in NX11.0.0

Parameters:

logicalValue -

Throws:

NXException

RemoteException