DataTable with Dynamic Footer?

[leoTotvs]

Hi guys!

I'm using Primefaces 5.0 and Primefaces Extensions 3.1.0 and I try to export multiple dataTables to Excel. It's works, but not works how I wished..

In a web page I have 3 dataTables( "Classificação - ANUAL", "Incidente - Período" and "Grau do Incidente - Período"). The dataTables which have "Período" on the name have dynamics columns, where I use the rendered component, including the footers. But when I see de file exported, the footers of that dataTables have all columns exported, not only the columns which I see on my web page.

I tried to use exported="#{meuBean.boolean}, rendered=#{meubean.boolean} (the same way to I used for rendered the columns), but nothing happened with the footer on the file exported.

Here is my footer code:

Code: Select all

<p:columnGroup type="footer">
						<p:row>
							<p:column colspan="1" style="text-align:right"
								footerText="Total Período:" />
							<p:column exportable="#{relatoriosMB.janeiro}"
								footerText="#{relatoriosMB.qtdTotalMesesObjeto1Periodo[1]}"
								rendered="#{relatoriosMB.janeiro}"/>
							<p:column exportable="#{relatoriosMB.fevereiro}"
								footerText="#{relatoriosMB.qtdTotalMesesObjeto1Periodo[2]}"
								rendered="#{relatoriosMB.fevereiro}"/>
							<p:column exportable="#{relatoriosMB.marco}"
								footerText="#{relatoriosMB.qtdTotalMesesObjeto1Periodo[3]}"
								rendered="#{relatoriosMB.marco}"/>
							<p:column exportable="#{relatoriosMB.abril}"
								footerText="#{relatoriosMB.qtdTotalMesesObjeto1Periodo[4]}"
								rendered="#{relatoriosMB.abril}"/>
							<p:column exportable="#{relatoriosMB.maio}"
								footerText="#{relatoriosMB.qtdTotalMesesObjeto1Periodo[5]}"
								rendered="#{relatoriosMB.maio}"/>
							<p:column exportable="#{relatoriosMB.junho}"
								footerText="#{relatoriosMB.qtdTotalMesesObjeto1Periodo[6]}"
								rendered="#{relatoriosMB.junho}"/>
							<p:column exportable="#{relatoriosMB.julho}"
								footerText="#{relatoriosMB.qtdTotalMesesObjeto1Periodo[7]}"
								rendered="#{relatoriosMB.julho}"/>
							<p:column exportable="#{relatoriosMB.agosto}"
								footerText="#{relatoriosMB.qtdTotalMesesObjeto1Periodo[8]}"
								rendered="#{relatoriosMB.agosto}"/>
							<p:column exportable="#{relatoriosMB.setembro}"
								footerText="#{relatoriosMB.qtdTotalMesesObjeto1Periodo[9]}"
								rendered="#{relatoriosMB.setembro}"/>
							<p:column exportable="#{relatoriosMB.outubro}"
								footerText="#{relatoriosMB.qtdTotalMesesObjeto1Periodo[10]}"
								rendered="#{relatoriosMB.outubro}"/>
							<p:column exportable="#{relatoriosMB.novembro}"
								footerText="#{relatoriosMB.qtdTotalMesesObjeto1Periodo[11]}"
								rendered="#{relatoriosMB.novembro}"/>
							<p:column exportable="#{relatoriosMB.dezembro}"
								footerText="#{relatoriosMB.qtdTotalMesesObjeto1Periodo[12]}"
								rendered="#{relatoriosMB.dezembro}"/>
							<p:column footerText="#{relatoriosMB.totalGeralObjeto1Periodo}"/>
						</p:row>
					</p:columnGroup>

Web Page:

https://www.dropbox.com/s/6aktwgm4zilt ... .jpg?dl=0

Screenshot Exported File:

https://www.dropbox.com/s/4tfzorlit609 ... .jpg?dl=0



What should I do?

PS: in the exportable, like "exportable="#{relatoriosMB.dezembro}", I use the boolean atributte. This is the same for the rendered the columns of datTables("- Periodo")

[samplergroup]

Did Anybody solve that problem or is there any workaround??

I've got the same with p:column in footer.
When exportable attribute is set to false, p:column is still rendered in pdf.

Code: Select all

<p:column footerText="#{text['common.total']}: " style="text-align:right; right" exportable="false"/>