jameis1120 Posted June 22, 2017 Share Posted June 22, 2017 This question was asked several years ago, but received no replies so I am hoping someone will have an answer now. I am exporting a report to Excel that needs to be able to perform a sum of every nth row in the detail band. I am able to use simple Excel fomulas, but I can't figure out how to enter an array formula. Does anyone know if this is even possible? Link to comment Share on other sites More sharing options...
Friendly User Posted June 27, 2017 Share Posted June 27, 2017 Hello,there is a text element property for storing formulas:http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.xls.formulaHave you tried that? Link to comment Share on other sites More sharing options...
jameis1120 Posted June 28, 2017 Author Share Posted June 28, 2017 Thanks for the reply. I have tried that property and I am using it for standard formulas, but it doesn't work for array formulas which are inserted by pressing Ctrl-Shift-Enter in Excel. I'm thinking that this just isn't possible to do. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now