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.

Print titles must be contiguous...

Thread ID:

Created:

Updated:

Platform:

Replies:

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

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 07:50 AM

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:

Print

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

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

Regards,
Geetha

CONFIRMATION

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.

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.

;