Hi,
I am exporting an UltraWinGrid to excel and have managed to achieve all the formatting changes I require but one. I would like to be able to add page breaks to my excel sheet so that each seperate region on the report prints on a separate page.
Could you let me know if it is possible to add page breaks automatically, and if so, how?
Thanks
Hello ,
Please do not hesitate to contact us if you have any other questions.
Well, you learn something new every day. I'm using Office2010 and that options doesn't show up on the insert tab, so I wonder if it was just moved somewhere else or maybe removed.
Anyway, I looked into this and our Excel engine currently does not support page breaks, but it's a pretty common feature request. I recommend that you Submit a feature request to Infragistics.
The more requests we get, the more likely the feature is to be implemented.
It is exactly the same as in Word as far as I am aware. If you select a row and click on insert you are able to insert a page break.
I have a report that runs over a couple of pages. It is split down into different regions. In a hierarchical format, with the hierarchy being region. So you the report layout is similar to the below
New York
Header Information
Lines of Data
London
Asia
As this report runs over several pages it would make it far more readable if a page break was placed at the end of each region. I can do this manually in excel, however if I could automate it, then all the user would need to do is print the data if they so wished.
Do you know if this is possible
As far as I am aware, Excel does not have any concept of pages or support for page breaks.
Are you talking about splitting the grid up into multiple worksheets?
Or is this a feature of Excel that I have never encountered?