[jbossseam-issues] [JBoss JIRA] Commented: (JBSEAM-4189) Seam excel exporter doesn't show the footer defined in a dataTable and only works for single UIOutput per cell.

Wed May 27 15:48:56 EDT 2009

    [ https://jira.jboss.org/jira/browse/JBSEAM-4189?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12469404#action_12469404 ] 

Gary Hu commented on JBSEAM-4189:
---------------------------------

The column level header is exported from the dataTable to the excel spreadsheet. 

However, the table level head and footer as well as the column level footer don't show up in the excel spreadsheet.

The following is the code modified slightly to reproduce the issue:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
> <html xmlns="http://www.w3.org/1999/xhtml"
>       xmlns:ui="http://java.sun.com/jsf/facelets"
>       xmlns:h="http://java.sun.com/jsf/html"
>       xmlns:f="http://java.sun.com/jsf/core"
>       xmlns:s="http://jboss.com/products/seam/taglib"
>       xmlns:a4j="http://richfaces.org/a4j"
>       xmlns:rich="http://richfaces.org/rich">
>
>     <ui:composition template="layout/template.xhtml">
>        <ui:define name="body">
>          <h:form id="myForm">
>               <rich:dataTable id="dlist"
>                     value="#{stringList}"
>                     var="myString"
>                     width="100px"
>                     >
>                      <f:facet name="header">
>                          <rich:columnGroup>
>                                <rich:column colspan="2">
>                                    <h:outputText value="Table Header "/>
>                                </rich:column>
>                          </rich:columnGroup>
>                      </f:facet>
>                     <rich:column>
>                            <f:facet name="header">
>                                <h:outputText value="String value"/>
>                            </f:facet>
>                            <h:outputText value="#{myString}"/>
>                     </rich:column>
>
>                      <rich:column>
>                            <f:facet name="header">
>                                <h:outputText value="String value2"/>
>                            </f:facet>
>
>                            <h:outputText value="#{myString}_1"/>
>                            <h:outputText value="#{myString}_2"/>
>
>
>                     </rich:column>
>                      <f:facet name="footer">
>
>                              <rich:columnGroup>
>                                <rich:column colspan="2">
>                                    <h:outputText value="Table Footer "/>
>                                </rich:column>
>                              </rich:columnGroup>
>
>                      </f:facet>
>              </rich:dataTable>
>             <h:commandLink value="Export"
> action="#{excelExporter.export('myForm:dlist')}"/>
>         </h:form>
>
>        </ui:define>
>     </ui:composition>
>
> </html>
>

> Seam excel exporter doesn't show the footer defined in a dataTable and only works for single UIOutput per cell.
> ---------------------------------------------------------------------------------------------------------------
>
>                 Key: JBSEAM-4189
>                 URL: https://jira.jboss.org/jira/browse/JBSEAM-4189
>             Project: Seam
>          Issue Type: Feature Request
>    Affects Versions: 2.1.1.GA
>            Reporter: Gary Hu
>             Fix For: 2.2.0.CR1
>
>
> We have found two issues in the current Seam 2.1.1.GA Excel exporter support.
> 1) It only works for a single UIOutput per cell. That means for each cell you can only define one UIOutput per column in the dataTable.
> 2) The footer doesn't show in the excel spreadsheet.
> The following code could be used to reproduce the issue:
> xhtml:
> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
> <html xmlns="http://www.w3.org/1999/xhtml"
> xmlns:ui="http://java.sun.com/jsf/facelets"
> xmlns:h="http://java.sun.com/jsf/html"
> xmlns:f="http://java.sun.com/jsf/core"
> xmlns:s="http://jboss.com/products/seam/taglib"
> xmlns:a4j="http://richfaces.org/a4j"
> xmlns:rich="http://richfaces.org/rich">
> <ui:composition template="layout/template.xhtml">
> <ui:define name="body">
> <h:form id="myForm">
> <rich:dataTable id="dlist"
> value="#{stringList}"
> var="myString">
> <rich:column>
> <f:facet name="header">
> <h:outputText value="String value"/>
> </f:facet>
> <h:outputText value="#{myString}"/>
> </rich:column>
> <rich:column>
> <f:facet name="header">
> <h:outputText value="String value2"/>
> </f:facet>
> <h:outputText value="#{myString}_1"/>
> <h:outputText value="#{myString}_2"/>
> <f:facet name="footer">
> <h:outputText value="my footer3" style="font-weight: bold" >
> </h:outputText>
> </f:facet>
> </rich:column>
> </rich:dataTable>
> <h:commandLink value="Export" action="#{excelExporter.export('myForm:dlist')}"/>
> </h:form>
> </ui:define>
> </ui:composition>
> </html>
> java code:
> import java.util.ArrayList;
> import java.util.List;
> import org.jboss.seam.ScopeType;
> import org.jboss.seam.annotations.Factory;
> import org.jboss.seam.annotations.Name;
> import org.jboss.seam.annotations.Scope;
> @Name("sample")
> @Scope(ScopeType.SESSION)
> public class Sample {
> @Factory("stringList")
> public List<String> getStrList(){
> List<String> strList = new ArrayList<String>();
> for(int i=0;i<20;i++) {
> strList.add("StringItem"+i);
> }
> return strList;
> }
> } 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira