Just want to ask if there any way to exclude the last page footer in the filter list in excel? For example, when we want to filter a column, I would not like to have the page footer in the options so that it won't be filtered.
just take a look here... https://community.jaspersoft.com/wiki/how-can-i-suppress-page-headers-and-footers-when-exporting-xls
there is described, how to exclude some bands for xls(x) exporting
hth + regards
To exclude header and footer for xls and xlsx use these property shown on desc:
just change from xls to xlsx in property name if you need xlsx report or for xls just use same property
it will work...
Guys, I'm not looking for excluding the page footer when export to xlsx format but looking for excluding the band from being filtered when i am performing a filter in excel. This is because in excel when we are going to filter a column, the field of the page footer will be show in the list and it will be filtered if it is not checked which means after filter it will not be shown at the bottom which is the scenario I not looking for.
To exclude the cells from your AutoFilter one possible way is indeed to exclude the whole band ... you just asked us, if such a way is possible!??!!? Anyway...
..so perhaps you could try to ignore the "stupid" AutoFilter Feature of excel but use an own filter of the correct row range (so except the last row) .
Where should excel know if the last row should be excluded?
You could try to set a SubTotal-formula to your sum field as additinal xls export properties in page footer and look, if this is being passed correctly to excel. As far as I know the SubTotals formula is excluded by the AutoFilter (see here: https://www.extendoffice.com/documents/excel/4055-excel-filter-exclude-bottom-row.html)
hth + regards