olteanra Posted August 9, 2010 Share Posted August 9, 2010 I'm desperately trying to export to excel but display 0 values as dashes(-).M$ Excel has a custom pattern for this and it looks like: _(*#,##0_);_(*(#,##0);_(* "-"_);_(@_)This pattern naturally does not comply with Java's DecimalFormat.I've failed in every way to make jasper reports pass this pattern over to excel for cell formatting.Any ideas on how I could do this? Cheers!Post Edited by olteanra at 08/09/2010 13:39 Link to comment Share on other sites More sharing options...
lucianc Posted August 14, 2010 Share Posted August 14, 2010 Did you try JRXlsAbstractExporterParameter.FORMAT_PATTERNS_MAP? Which of the Excel exporters are you using?Regards,Lucian 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