Hello,
In our application, we need to add header to each pages when exporting the grid(RadGridView) into the workbook using ExportToWorkBook.
I tried to use the option mentioned in "https://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/headers-and-footers#headerfootersection" to fix this, but it is not work as expected.
Please see the attached image of our requirement and provide information on how to achieve this ?
Thanks in advance.
Telerik Team,
Is there any lead for this issue ?
When I checked the document I have noticed the PrintTitles option which matches my requirement, To achieve this I tried to update my telerik dlls from this version https://www.telerik.com/support/whats-new/wpf/release-history/ui-for-wpf-r3-2022-sp1 .
But I got the following error
"Exception: Cannot find resource named 'Telerik.Windows.Controls.RadProgressBar'. Resource names are case sensitive."
Hello Martin,
Eventhough I have updated all the dll I encounter the following error, do you have any idea about this ?
System.TypeLoadException: 'Could not load type 'Telerik.Windows.Documents.Spreadsheet.Layout.Layers.ColorScaleRenderable' from assembly 'Telerik.Windows.Documents.Spreadsheet, Version=2022.3.1108.40, Culture=neutral, PublicKeyToken=5803cfa389c90ce7'.'
If possible could you tell me which release will support the PrintTitles options or can you share the dll files for this?
Thank you Martin, For now I will create sample solution with above error and share it to you.
Meanwhile is it possible for you to share the sample project in which PrintTitles option is implemented ? It will be helpful for me.
I've attached a small project showing this. The project is actually the PrintPreviewWithSpreadsheet SDK example, but with a slight modification in the CreateSpreadsheet() method.
private static RadSpreadsheet CreateSpreadsheet(RadGridView grid) { Workbook workbook = CreateWorkBook(grid); WorksheetPageSetup pageSetup = workbook.ActiveWorksheet.WorksheetPageSetup; pageSetup.PrintTitles.RepeatedRows = new RowRange(0, 1); pageSetup.PrintTitles.RepeatedColumns = new ColumnRange(0, 1); return new RadSpreadsheet() { Workbook = workbook }; }