Free Support Forum -



Im working on the PageSetup, but i have a problem with "PrintTitleRows". The selected Rows don't appear and the property does not appears on the Properties page. Please note that the selection under "*1" contains merged cells (1 cell over 2 rows). Do I something wrong? If i select the rows under the properties page it works fine (after i created the file (i have no template file)).

(Version is 4.4.2)

private void xlsPageSetup(Workbook wb, int sheetIndex, bool printTitleRows, string rowFrom,string rowTo)


PageSetup pageSetup = wb.Worksheets[sheetIndex].PageSetup;

// this is ok

pageSetup.SetFooter(0, "&A");

pageSetup.SetFooter(1, "Page &P from &N");

pageSetup.SetFooter(2, "&D");

// this work not:

// *1

//pageSetup.PrintTitleRows = "$" + rowFrom + ":$" + rowTo;

// *2

pageSetup.PrintTitleRows = "$6:$6";



Could you try the latest version (4.4.3) as I tested it works fine.

If the problem still persists, kindly post your template excel file with deatil.

Thank you.

thx, looks good.