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

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

gabriel.nadoroski's picture
Joined: Oct 1 2018 - 2:05pm
Last seen: 4 years 5 months ago

1 Answer:

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
 

 

vchiem's picture
36587
Joined: May 1 2017 - 5:33pm
Last seen: 6 days 2 hours ago
Feedback