Jump to content

Rows are staggered in Excel

Go to solution Solved by Ankur Gupta,

Recommended Posts

I am using Jaspersoft Studio to generate an Excel report. The final Excel file always shows extra blank lines between rows. It also puts certain rows on two combined Excel rows and staggers certain rows in Excel. How can I format the report so the Excel file needs no formatting (meaning each row in Jaspersoft is on exactly one row in Excel)?

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

  • Solution


The solution suggested by robsil would actually work upto the extent when all the data in a particular column in excel does not exceed the width alloted.

But in order to make your excel full proof and the flawless, I would suggest that you can follow these things.

1. Make sure that all the text fields in the detail band have the height same to each of them preferred in case of excel only output.

2. To apply the the word wrap functionality you will have to make following properties true found in the property pane.

   - Stretch Type (found under appearance)  for all the text feilds in the detail band should be made Relative to the tallest object, so that all the fields stretch according to max width column so that uniformity prevails.

   - Check the box Stretch with overflow (found under the text field in properties) , this will ensure that all the data in the text field gets printed.

Hope that this helps!!



Ankur Gupta




Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...