Hi,
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";
}