[richfaces-issues] [JBoss JIRA] Commented: (RF-6279) Seam excel generating problem with rich dataTable sorting and filtering features.

[Mikhail Vitenkov (JIRA)]

    [ https://jira.jboss.org/jira/browse/RF-6279?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12453720#action_12453720 ] 

Mikhail Vitenkov commented on RF-6279:
--------------------------------------

The same issue for extendedDataTable. Use following code:
<rich:extendedDataTable value="#{excel.dataModel}" var="dat"
									id="theDataTable">
									<rich:column sortable="true" sortBy="#{dat}" filterBy="#{dat}"
										filterEvent="onblur">
										<f:facet name="header">
											<h:outputText value="Header" />
										</f:facet>
										<h:outputText value="#{dat}" />
										<f:facet name="footer">
											<h:outputText value="Footer" />
										</f:facet>
									</rich:column>
								</rich:extendedDataTable>

> Seam excel generating problem with rich dataTable sorting and filtering features.
> ---------------------------------------------------------------------------------
>
>                 Key: RF-6279
>                 URL: https://jira.jboss.org/jira/browse/RF-6279
>             Project: RichFaces
>          Issue Type: Bug
>    Affects Versions: 3.3.0
>         Environment: IE6, IE7, FF 3.1.3, Safari 3.1, Opera 9.62, Chrome 1.0.154.43(3.3.0.GA, seam 2.0.2.GA)
>            Reporter: Mikhail Vitenkov
>            Assignee: Nick Belaevski
>
> #1. Put jboss-seam-excel.jar and jxl.jar in your project lib folder.
> #2. Configure web.xml following way:
> <servlet>
>       <servlet-name>Document Store Servlet Excel</servlet-name>
>       <servlet-class>org.jboss.seam.excel.DocumentStoreServlet</servlet-class>
>    </servlet>
>    
>    <servlet-mapping>
>       <servlet-name>Document Store Servlet Excel</servlet-name>
>       <url-pattern>*.xls</url-pattern>
>    </servlet-mapping>  
>    
>    <context-param>
>         <param-name>webAppRootKey</param-name>
> 	<param-value>seam-excel</param-value>
>    </context-param>
> #3. Configure components.xml. Add following string:
> In taglib: xmlns:excel="http://jboss.com/products/seam/excel"
> <excel:document-store use-extensions="true"/>
> #4. Add following code on the page:
> <h:form id="theForm">
> <rich:dataTable value="#{excel.dataModel}" var="dat"
> 									id="theDataTable">									
> 									<rich:column sortBy="#{dat}" selfSorted="true"
> 										filterBy="#{dat}" filterEvent="onblur">
> 										<h:outputText value="#{dat}" />
> 									</rich:column>
> 								</rich:dataTable>
> <h:commandLink value="Export"
> 									action="#{org.jboss.seam.excel.excelExporter.export('theForm:theDataTable')}" />
> </h:form>
> #5. Navigate to the page and sort dataTable data descending by click on column header.
> #6. Click "Export" and verify excel exported data. - data in initial order present.
> #7. Make filtering, click "Export" and verify excel exported data again. - all rows are present regardless of data filtering.
> Actual behavior: filtering and sorting don't have an influence on excel exported data.

-- 
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