Home / Questions / 29673
Accepted
Ralsho
Asked: 2020-10-26 03:54:15 +0800 CST 2020-10-26 03:54:15 +0800 CST

JSF Primefaces: Bug when exporting selected rows (excel, pdf)

  • 772

I have a table on which I can select several rows through checkboxwhat would be the column selector:

<p:dataTable    value="#{cityBean.cities}" var="city" id="dt_cities" widgetVar="w_cities"
                filteredValue="#{cityBean.filteredCities}"
                selection="#{cityBean.selectedCities}" 
                rowKey="#{city.id}"
                rowSelectMode="add"
                scrollable="true" scrollHeight="300">
    <p:column id="selector" selectionMode="multiple" style="text-align:center" />
    <p:column headerText="Name" sortBy="#{city.name}" filterBy="#{city.name}"  filterMatchMode="contains">
        <h:outputText value="#{city.name}" />
    </p:column>
</p:dataTable>

Then I have two buttons with which I can export the selected rows (using the selectionOnly="true") in two ways: XLSor PDF.

<h:commandLink >
   <p:graphicImage url="#{resource['icons/excel_exports.png']}" />
   <p:dataExporter type="xls" target="dt_cities" fileName="list_cities" selectionOnly="true" />
</h:commandLink>
<h:commandLink>
   <p:graphicImage url="#{resource['icons/pdf_exports.png']}" />
   <p:dataExporter type="pdf" preProcessor="#{cityBean.pdfLandscape}" 
                            target="dt_cities" fileName="list_cities" 
                            selectionOnly="true"/>
</h:commandLink>

The bugone I find is that for example: I have a 10 elementosnumbered list of 1 al 10, I select the elements 9, 8, 5 y 2. When clicking on the export buttons they appear to me 4 elementosbut they do not correspond to your selection, the elements appear 1, 2, 3 y 4.

It recognizes how many elements are selected but does not know how to interpret which ones they are.

I am currently using: JSF 2.2and Primefaces 5.1 RC1.

jsf

2 Answers

  1. Best Answer

    It's probably a bug of Primefaces 5.1.

    For the case of export to PDF :

    I suggest you add to your project, primefaces-extensions 3.0.0 , which is the version compatible with Primefaces 5.1 . If you use Maven this would be like this:

    <dependency>
    <groupId>org.primefaces.extensions</groupId>
    <artifactId>primefaces-extensions</artifactId>
    <version>3.0.0</version>
</dependency>

    In your XHTML add the following namespace:

    xmlns:pe="http://primefaces.org/ui/extensions"

    ...and in your button, instead of using p:dataExporter, use pe:exporter.

    <h:commandLink>
   <p:graphicImage url="#{resource['icons/pdf_exports.png']}" />
   <pe:exporter type="pdf" preProcessor="#{cityBean.pdfLandscape}" 
                            target="dt_cities" fileName="list_cities" 
                            selectionOnly="true"/>
</h:commandLink>

    The tag pe:exporteralso allows you to export to Excel , but it only does so to XLSX and not to XLS .

    • 2

  2. Add a column and check that ideach field cityis unique. For example:

    <p:column id="cityId" value="#{city.id}" />
    • 0