Please define "page break" in Excel? (what do you mean by that term?)
You can use the XSLT to call cells by the RC notation in formulas:
XML Spreadsheet Reference
XML in Excel and the Spreadsheet Component
Dive into SpreadsheetML (parts 1 & 2)
There is a section in the "WorksheetOptions" of the Spreadsheet Markup Language that set the page set and print values used when printing.
If you are still using the XSLT as in your previous question:
see Lines 195-227
And you are getting into much more customization that may not fit well with this basic Example file and its XSLT that you are using.
So many factors come into play. How many rows to the page break? how many rows are data and not header and spacing, such that a summary row can be included before the rows run out for a "page"? etc.
Yes, I'm still using that file (still have to learn and it's a bit of a process that I wished I had learned earlier haha).
As for the customization, I figured it would be something a little bit more difficult, I figured I'd ask just to see, so I do appreciate your responses
For some of the questions you asked, it looks like there are 53 rows before a page break. The first page is the only one where the table has a header (that Roadrunner text) and that has 43 rows of data, 1 row of table header and 9 rows used at the top with the Roadrunner text.
Thanks again, for everything! I appreciate it all!
Note that where the page break occurs can depend on what page size, page orientation and even what printer is being used to print the document.