How to freeze only top row

when exporting a report to xls, I set the "net.sf.jasperreports.export.xls.freeze.row.edge" property to Bottom. But when I open the report in excel, I have 8 lines pinned, instead of the highlighted 1 with headers. How to solve the problem? how to freeze only the top row?
a.number27's picture
Joined: Sep 23 2021 - 1:42am
Last seen: 1 day 17 hours ago

1 Answer:


Add  <property name="net.sf.jasperreports.export.xls.freeze.row" value="4"/>     (Freeze Row #3)

bigalex's picture
Joined: Apr 12 2019 - 9:15am
Last seen: 1 week 14 hours ago