Jump to content

Ireport generated excel cells empty(no values) but not blank


Recommended Posts

Hi - I am in tricky situtaion and need some help.


I designed a report using ireport 5.5.1 and able to generate an excel output. So here in excel output the cells with no values are not exactly blank.

Example: Here is Column1 with 12 rows






blank(no value)

blank(no value)


blank(no value)



blank(no value)

blank(no value)



So generally when we use Ctrl+ down arrow in excel on row1 it will take to 3, then to 4, then to 6 and then to 7. 

But it is not working as same in excel generated by ireport. when pressed Ctrl+down arrow on 1 it take to 7 (considering those cells have some value). we can test if we press delete on blank cells and try again.

This is not the case with same report generated by a different reporting tool.


So guessing this should have something to do with ireport. Please help me if there is any setting or property which i can use to eliminate this ??

Link to comment
Share on other sites

  • 5 months later...
  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

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...