I have created a report in excel that is then converted to a pdf on the server without user interaction.
There are certain areas of the report where we don’t want page breaks. I am able to use page scaling to get the report to render just one page wide. Therefore, only vertical page breaks are at issue.
Can I programmatically determine where excel is thinking about putting the page breaks. If so then I can determine if the page break occurs in a “page break free zone” and move it to the start of the zone.
If there is another way to get the same functionality please feel free to share it.