Jump to content
Changes to the Jaspersoft community edition download ×

How do i export the following formula when i export to .XLSX


Recommended Posts

Hello Everyone, 

I am trying to export the following formula in a cell of a paginated .XLSX file. However, when i export the report and then try to open the .xlsx file, that comes with errors and the pages which contain the formula are blank. 

The strange thing is that when i export to .XLS the formula is placed properly. 

The formula mentioned is this =SUMPRODUCT(SUMIF(INDIRECT("'"&$K$3:INDIRECT(ADDRESS(3,COLUMN()+J3))&"'!"&"K:K"),C6,INDIRECT("'"&$K$3:INDIRECT(ADDRESS(3,COLUMN()+J3))&"'!"&"I:I"))). 

It does make the sumif from multiple sheets of the workbook. 

Any ideas? 


Link to comment
Share on other sites

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic


Not sure what exact error you are getting while exporitng into .xlsx format.
But seems that for .xlsx format you need to change the formula.
The formula for .xls and .xlsx is slightly differs that why for .xlsx format you might be getting blank.

Try using & instead of & in formula to export in .xlsx format.

For more details you can refer to below article.

Hope this will help you.

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