CODEWITHSUNDEEP
jasper-reportsapache-poiireport
Daniel Moses
Daniel Moses

Reputation: 5858

Jasper report excel cutting off cell

I want to export to excel, but I want the data to print in a cell irregardless of how much data it is. I have tried setting the "Stretch with Overflow" option and that appears to work, but it creates empty rows between actual data rows. I tried adding the IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS to true and it does not resolve my issue. I am also using IS_IGNORE_PAGINATION.

Ideally I want excel exports to just put all the data in a cell independent of the size of the cell.

Upvotes: 2

Views: 4306

Answers (2)

Marialvy Martínez
Marialvy Martínez

Reputation: 286

@DMoses: I had the problem of the empty rows a lot using the "Stretch with Overflow" and it was generated because I left unconsciously a space between the cell where I display the data and the margin of the report. Just put the cell at the edge of the margin and then you won't have that problem.

Upvotes: 0

Daniel Moses
Daniel Moses

Reputation: 5858

I found the answer. You need to set the net.sf.jasperreports.print.keep.full.text report parameter to true

Upvotes: 4

Related Questions