page breaks

Apr 28, 2010 at 8:12 PM
Is there a way to add horizontal page breaks and detect the number of breaks? Or a different way control the page flow. My spreadsheet is split into small sections with a one row padding between them. If it flows to the next page then I want to push the entire section to the next page. with the interop library I could use HPageBreaks.Count to get num of page breaks, and if the count is greater then in the beginning of the section i could use HPageBreaks.Add and add the break above the section. Any ideas? Thanks
Coordinator
Apr 29, 2010 at 6:58 AM

Next version, but you can download the latest source and try it. You have a Pagebreak property on the row and column object. No count at the moment, so you have to check the rows/columns to get the pagebreak value (boolean). You can use the dimension property to get the min/max row/column of the worksheet.