<dvt:dataCell>

dvt:dataCell dataCell data cell

UIComponent class: oracle.adf.view.faces.bi.component.pivotTable.UIDataCell
Component type: oracle.dss.adf.pivotTable.DataCell

Each immediate child of a Pivot Table component must either be a <dvt:headerCell> or <dvt:dataCell> component. The Pivot Table should contain at most one headerCell component and at most one dataCell component. These components make it possible to customize the cell content via stamping. For example, each dataCell can contain non-editable content or editable content.

Data Cell Features

Stamping

Rather than having a separate child component for each cell in the pivot table, the child component of the dataCell component is repeatedly rendered (stamped) once per data cell. Because of this stamping behavior, only certain types of components are supported as children inside a Data Cell. Supported components include all components with no behavior and most components that implement the EditableValueHolder or ActionSource interfaces.

As the dataCell content is stamped, the data for the current cell is copied into an EL reachable property. The name of this property is defined by the var property on the Pivot Table. Once the Pivot Table has completed rendering, this property is removed (or reverted back to its previous value). In the following example, the data for each cell is placed under the EL property "cellData". Each data cell displays its content by getting further properties from the "cellData" property. See the <dvt:pivotTable> tagdoc for more information.

        
                        <dvt:pivotTable id="goodPT" var="cellData">
                            <dvt:dataCell id="dc1">
                                <af:outputText id="ot1" value="#{cellData.dataValue}" />
                            </dvt:dataCell>                   
                        </dvt:pivotTable>
        
        

Customized Cell Content and Style

For customizing data cell content, use DataFormat. DataFormat attribute returns instances of oracle.dss.adf.view.faces.bi.component.pivotTable.CellFormat. CellFormat instances allow specification of the following:

• a converter, javax.faces.convert.Converter, which is used to perform number/date/text formatting of a cell raw value
• a CSS style, which is used to change the CSS style of a cell
• a CSS text style, which is used to change the CSS style of a cell's text
• a new raw value, which is used to change the cell's underlying value that was returned from the data model

Data Cell content can be specified by using a logical component such as <af:switcher>.

The following example shows how Data Cell supports alternative cell content using <af:switcher> based on the stamping property. In other words, the stamping content is customized on a cell by cell basis depending on a variable value ("#{richPivotTableModel.stampFacet}"). The example also shows custom CSS styling using inlineStyle and contentStyle attributes of outputText and inputText respectively.

        
                <dvt:pivotTable id="goodPT"
                           value="#{richPivotTableModel.dataModel}"
                           var="cellData"
                           varStatus="cellStatus">           
        
                  <dvt:dataCell id="dc1"> 
                    <af:switcher id="sw1" facetname="O__richPivotTableModel_stampFacet_">
                      <f:facet name="outputText">         
                        <af:outputText id="ot1" value="#{cellData.dataValue}" inlineStyle="#{myBean.textStyle}"/>    
                      </f:facet>  
                      <f:facet name="inputText">  
                        <af:inputText id="ot2" value="#{cellData.dataValue}" contentStyle="#{myBean.textStyle}" />   
                      </f:facet>
                    </af:switcher>
                  </dvt:dataCell>
                </dvt:pivotTable>
        
        

The following example uses <af:switcher> to vary the type of stamped component by measure (i.e. different content for Sales, Weight, etc.). The example also shows different components that can be used as child tag of <dvt:dataCell>

        

          <dvt:pivotTable id="goodPT" var="cellData" varStatus="cellStatus" sizingManager="richPivotTable.sizingManager">
            <dvt:dataCell>                    
              <af:switcher id="sw" facetname="O__cellStatus_members_MeasDim_value_" defaultFacet="Other">
                <f:facet name="Sales">
                  <af:inputText id="idinputtext1" value="#{cellData.dataValue}"   />  
                </f:facet>
                <f:facet name="Units">
                  <af:inputText id="idinputtext2" value="#{cellData.dataValue}"   >      
                    <af:validateLength maximum="6" minimum="2" />
                  </af:inputText>
                </f:facet>
                <f:facet name="Weight">
                  <af:outputText id="idoutputtext1" value="#{cellData.dataValue}" />
                </f:facet>
                <f:facet name="Color">
                  <af:selectOneChoice id="idselectonechoice"
                                      value="#{cellData.dataValue}" label="Color">
                    <af:selectItem label="red" value="red" shortDesc="shortDesc sample"/>                                
                    <af:selectItem label="coffee" value="coffee" shortDesc="Sample shortDesc text"/>                            
                    <af:selectItem label="milk" value="milk" shortDesc="Another shortDesc sample"/>                            
                  </af:selectOneChoice>
                </f:facet>
                <f:facet name="Available">
                  <af:selectBooleanCheckbox id="idselectbooleancheckbox" label="Availability" text="Item Available"
                                            autoSubmit="true" value="#{cellData.dataValue}"/>                    
                </f:facet>
                <f:facet name="Supply_Date">
                  <af:inputDate id="idinputdate1" value="#{cellData.dataValue}"
                                 label="Change Date:" simple="true" >                        
                    <af:validateDateTimeRange maximum="2020-12-31" minimum="1980-12-31" />
                  </af:inputDate>
                </f:facet>
                <f:facet name="Link">
                  <af:commandLink text="#{cellData.dataValue}" immediate="true" action="guide" id="idcommandlink"/>
                </f:facet>
                <f:facet name="Size">
                  <af:inputComboboxListOfValues label="Size" id="idInputComboboxListOfValues"                                       
                             value="#{cellData.dataValue}"  searchDesc="Search Size"                                        
                             model="#{pivotTableEditBean.listOfValuesModel}"                            
                             columns="3"   />
                </f:facet>
                <f:facet name="Other">
                  <af:outputText id="idoutputtext2" value="#{cellData.dataValue}"   />  
                </f:facet>
              </af:switcher>
            </dvt:dataCell>
          </dvt:pivotTable>

        
        

Note that if you use different types of input components in a cell (as in the example above), you should use the SizingManager in Pivot Table to ensure that the height of the cells remains the same when editing from cell to cell. This is because the height of the input components might varies, and switching from one type of component to another would cause the Pivot Table to resize accordingly, and this could have a performance impact if the Pivot Table contains a lot of cells.

Supported Child Tags

Examples of components that are supported by <dvt:dataCell> include but are not limited to the following:

• <af:switcher>
• <af:outputText>
• <af:inputText>
• <af:selectBooleanCheckbox>
• <af:selectOneChoice>
• <af:inputDate>
• <af:commandLink>
• <af:inputComboboxListOfValues>
• <af:image>

The dataCell should have only one child component. If multiple children are desired, they should be wrapped in another component. If no layout is desired, <af:group> can be used, which simply renders its children without adding layout, and is consequently lightweight. If layout is desired, a layout component like <af:panelGroupLayout> can be used instead. If multiple children are present without being wrapped, the current behavior is to vertically stack the components, but no guarantees or support are provided for this usage. To achieve vertical stacking, consider <panelGroupLayout layout="vertical">.

Example

The following example shows a way to use stamping

        
                <dvt:pivotTable 
                      value="#{pivotTableEdit.dataModel}"                                         
                      var="cellData"
                      varStatus="cellStatus">
                  <dvt:dataCell id="dc1">                    
                    <af:outputText id="ot1" value="#{cellData.dataValue}"   />  
                  </dvt:dataCell>
                </dvt:pivotTable>
        
        

Events

Attributes