Jump to content
Changes to the Jaspersoft community edition download ×

How net.sf.jasperreports.export.xls.one.page.per.sheet work ?


gabriel.nadoroski

Recommended Posts

Hi,
I do a post recently about xls, I'm doing a report was printed every sales of the company in all year and I need divide the pages in months, the report worked but I don't know how I divide the sheets,  The solution they gave me does not work, I go to propriets of the report, and I put the net.sf.jasperreports.export.xls.one.page.per.sheet like true, I mark the "no pagination" and put a break in a group, every time the field month change the page was supposed to break, but this don't work, I try dismark the "no pagination" but don't change nothing, he make 16 pages, I'm printing just 2 months, it was right to print only two pages.

Anyone knows how this work ? 

this is the last post: https://community.jaspersoft.com/questions/1111626/sheets-xlsx

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

I will start this thread with the config reference : http://jasperreports.sourceforge.net/config.reference.html

net.sf.jasperreports.export.xls.one.page.per.sheet
Property that specifies whether each report page should be written in a different XLS sheet. 
Its value is used as default for the isOnePagePerSheet() Excel export configuration setting.

API:    PROPERTY_ONE_PAGE_PER_SHEET 
Default:    false
Scope:    Global | Context | Report
Since:    2.0.1
 

 

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