We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Print titles must be contiguous...

Thread ID:





88477 Jul 25,2009 08:52 PM UTC Jul 27,2009 11:50 AM UTC ASP.NET Web Forms (Classic) 1
Tags: XlsIO
Roderick Prince
Asked On July 25, 2009 08:52 PM UTC

Using XlsIO ver 7.303.0.20 and code like:
sheet.PageSetup.PrintTitleRows = "$A$1:$IV$5";

Leads to an Error in Excel 2007 of:
Print titles must be contiguous and complete rows or columns.

Anyone else experiencing this and know of a way to correct it?

Geetha M [Syncfusion]
Replied On July 27, 2009 11:50 AM UTC

Hi Roderick,

I was able to see the problem. This occurs as both Rows and Columns are used to Print Title. As mentioned in the forum linked below, please use Rows to print in the top and Columns to print in the left:


sheet.PageSetup.PrintTitleRows = "$1:$5";
sheet.PageSetup.PrintTitleColumns = "$A:$IV";

Please try this and let me know if you have any questions.



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon