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.
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.

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