Worksheet Page Setup - PrintTitle

1 Answer 66 Views
Spreadsheet
Harald
Top achievements
Rank 2
Harald asked on 27 Feb 2023, 04:07 PM

How can I repeat certain lines on each page of a workbook?

WorksheetPageSetup worksheetPageSetup = worksheet.WorksheetPageSetup;
worksheetPageSetup.PaperType = PaperTypes.A4;
worksheetPageSetup.PageOrientation = PageOrientation.Landscape;
worksheetPageSetup.FitToPages = true;
worksheetPageSetup.CenterHorizontally = true;
worksheetPageSetup.PrintTitle ...

Assignment via PrintTitle does not work.

1 Answer, 1 is accepted

Sort by
1
Accepted
Dimitar
Telerik team
answered on 28 Feb 2023, 06:43 AM

Hi Harald,

I have tested the PrintTitles and it works on my side. We do not have any reports that this functionality is not working as well. I would suggest opening a ticket and attaching your files along with how exactly you are setting this. 

Another approach would be to use a header: SpreadProcessing - Headers and Footers.

Let me know if you have additional questions.

Regards,
Dimitar
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Harald
Top achievements
Rank 2
commented on 28 Feb 2023, 01:44 PM

I used Telerik.Windows.Documents.Spreadsheet.Model.Printing.WorksheetPageSetup in version 2022.2.613.40.

The following error message is displayed: WorksheetPageSetup does not contain a definition for PrintTitle.
Dimitar
Telerik team
commented on 01 Mar 2023, 11:16 AM

Hi Harald

This was added in R3 2022 release. You need to upgrade to this or a newer version in order to use it.

Let me know if I can assist you further.

Tags
Spreadsheet
Asked by
Harald
Top achievements
Rank 2
Answers by
Dimitar
Telerik team
Share this question
or