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.
Syncfusion Feedback

Print titles rows...

Thread ID:

Created:

Updated:

Platform:

Replies:

131576 Jul 17,2017 03:11 PM UTC Oct 13,2017 11:52 AM UTC Windows Forms 5
loading
Tags: XlsIO
Mouries
Asked On July 17, 2017 03:11 PM UTC

Hello ! 

Using XlsIO ver 15.2200.0.40 and code like:
     sheet.PageSetup.PrintTitleRows = "$A$1:$IV$5"
Leads to an Error in Excel 2016 of:
     Print titles must be contiguous and complete rows or columns.

If I try:
     sheet.PageSetup.PrintTitleRows = "$1:$5"
Excel ignore parameter and print all pages without title rows

If i try:
     sheet.PageSetup.PrintTitleRows = "$1:$5"
     sheet.PageSetup.PrintTitleColumns = "$A:$IV"
Again, Excel ignore parameter and print all pages without title rows

How to print correctly title rows ???

Thanks for your support.






Abirami Varadharajan [Syncfusion]
Replied On July 18, 2017 11:40 AM UTC

Hi Mouries, 

Thank you for contacting Syncfusion support. 

We are unable to reproduce the issue. PrintTitles are properly set at our end. We have shared sample for your reference which can be downloaded from the following link. 


Kindly modify and share us the issue reproducing sample which will be helpful for us to provide prompt solution at the earliest. 

Regards, 
Abirami. 


Mouries
Replied On July 19, 2017 01:33 PM UTC

Hi,

I agree you sample works but it use an existing excel file as model.

The problem arrives when you create an excel file from scratch.

Use the code bellow to check the problem :

                 Dim excelEngine As ExcelEngine = New ExcelEngine
        Dim Application As IApplication = excelEngine.Excel

        Application.DefaultVersion = ExcelVersion.Excel97to2003

        Dim MyWorkbook As IWorkbook = Application.Workbooks.Create(1)
        Dim MySheet As IWorksheet = MyWorkbook.Worksheets(0)

        MySheet.Range("A1:E5").Value = "Titles"
        MySheet.Range("A6:E100").Value = "Data"

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

        MyWorkbook.SaveAs("Result.xls")
        System.Diagnostics.Process.Start("Result.xls")

Try to preview or print the sheet... what is wrong in this code ?


Abirami Varadharajan [Syncfusion]
Replied On July 20, 2017 02:21 PM UTC

Hi Mouries 
 
Thank you for updating us. 
   
We are able to reproduce the issue. A support incident to track the status of this issuehas been created under your account. Please log on to our support website to check for further updates.    
     
    
Please let us know if you have any concerns.   
   
Regards,   
Abirami.   



David Prosser
Replied On October 13, 2017 12:51 AM UTC

Hi Abirami,

I am also requiring a fix for this issue. Whilst using the PrintTitleColumns seems to work ok,  the PrintTitleRows does not.

Can you please provide a status on when this will be fixed - or if there is a workaround I can use in the meantime.


Version: 15.3350.0.26


Regards,

David


Abirami Varadharajan [Syncfusion]
Replied On October 13, 2017 11:52 AM UTC

Hi David,   
  
Thank you for contacting Syncfusion support. 
    
A support incident to track the status of this issue has been created under your account. Please log on to our support website to check for further updates.     
      
     
Please let us know if you have any concerns.    
    
Regards,    
Abirami.    


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.

Warning Icon 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.Close Icon

;