Print titles rows...

[Mouries]

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]

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. 

Sample Link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/XlsIO_Sample251376155.zip  

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]

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]

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.    

     

https://www.syncfusion.com/account/login?ReturnUrl=%2fsupport%2fdirecttrac%2fincidents     

    

Please let us know if you have any concerns.   

   

Regards,   

Abirami.   

[David Prosser]

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]

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.     

      

https://www.syncfusion.com/account/login?ReturnUrl=%2fsupport%2fdirecttrac%2fincidents      

     

Please let us know if you have any concerns.    

    

Regards,    

Abirami.