Deep Inside the Essbase Java API - Developing Essbase Applications - page 289

Table 8.3 Cell Content Type Constants

IEssGridView Constant Va l u e

CELL_ContEnt_tyPE_StrIng 1

CELL_ContEnt_tyPE_DouBLE 3

CELL_ContEnt_tyPE_BLAnk 4

CELL_ContEnt_tyPE_Error 6

CELL_ContEnt_tyPE_mISSIng 7

CELL_ContEnt_tyPE_zEro 8

CELL_ContEnt_tyPE_noACCESS 9

CELL_ContEnt_tyPE_mEmBEr 10

CELL_ContEnt_tyPE_mEmBErEx 19

CELL_ContEnt_tyPE_StrIngEx 18

CELL_ContEnt_tyPE_StrIngExwFormuLA 20

CELL_ContEnt_tyPE_FormuLAEx 21

CELL_ContEnt_tyPE_hyBrID_mEmBEr 22

CELL_ContEnt_tyPE_mEmBErwkEy 23

CELL_ContEnt_tyPE_FormuLA 11

CELL_ContEnt_tyPE_zErowFormuLA 12

CELL_ContEnt_tyPE_DouBLEwFormuLA 13

CELL_ContEnt_tyPE_BLAnkwFormuLA 14

CELL_ContEnt_tyPE_StrIngwFormuLA 15

CELL_ContEnt_tyPE_mISSIngwFormuLA 16

CELL_ContEnt_tyPE_noACCESSwFormuLA 17

CELL_ContEnt_tyPE_SmArtLISt 24

CELL_ContEnt_tyPE_DAtE 25

CELL_ContEnt_tyPE_mEAnIngLESS 26

from the add-ins and the information available to you as a developer. Some of the more
interesting values in this list include the values for missing and no access cells and the
value for smart lists. Smart list data cells are cells that contain a text measure. Smart
list data cells also have an associated smart list name which can be obtained using the
IEssCubeView.getSmartListName method.
he IEssGridView.getCell method returns an IEssCell instance. If the cell type
indicates that the cell contains a member, the IEssCell can be cast to a more specific
IEssMemberCell object, and if the cell type indicates that the cell is data, it can be cast to
a more specific IEssDataCell object. As mentioned earlier, there are numerous proper-
ties on these interfaces that provide the information used by Excel to apply formatting
styles. If the cell returned by the getCell method is a member cell, you can determine the
dimension number of the member it contains. to do so, modify the sample code with
the following changes:

// get the cell object
IEssCell cell = gv.getCell(row, col);

// if it is a member
if (cell.getCellType().equals(IEssCell.EEssCellType.MEMBER)) {

// cast to a member cell and print the dimension number