Page breaks not detected with excel exporter

[hemparashar]

Hi,

I am using Jaspersoft studio 5.1.0 to publish reports on jasperserver 5.5.0

I want to export the report to excel with multiple sheets. I am setting exporter properties onePagePerSheet=true, and setting properties Ignore Pagination=false

,net.sf.jasperreports.export.xls.break.before.row=true and

 net.sf.jasperreports.export.xls.break.after.row=true.

But all these properties are proving of no use.

I am getting everything on single sheet only.

Please help

[bhanubebo]

Facing same problem... Any one pls help....