When the contents of a page report are printed in Excel bold, italic missing

When the contents of a page report are printed in Excel bold, italic missing

Posted by: saravanakumar.ganesan on 20 October 2017, 12:58 am EST

• 

  saravanakumar.ganesan

  • Post Options:
  • Link
    Copy

  Posted 20 October 2017, 12:58 am EST

  When activereports of type page report is exported/printed to excel but the same content is properly printed in pdf.

  Sample Code, if the field is

  Title text:

  
  
  it gets printed properly in pdf as bolder but not in excel.

• 

  abdias.michael

  

  • Post Options:
  • Link
    Copy

  Posted 23 October 2017, 1:37 am EST

  I’m sorry I could not reproduce the behavior at my end. Could you specify which version of ActiveReports are you using and which method are you using to export to Excel?
  
  I’ve tested with AR11 SP2 and have attached the exported Excel file for your reference. Please check.

  If you’re using an older version, then please download the latest version from the following link: PageReport.zip

• 

  saravanakumar.ganesan

  • Post Options:
  • Link
    Copy

  Posted 23 October 2017, 7:52 pm EST

  Using Grapecity.Activereports.Export.Excel.v11 Abdias. Below is a sample code that we actually using.

  ---

  DataTable innerTable = emTable.GetInnerDataTable();
  
  reportDataSet.Tables.Add(innerTable);
  
  Pagereportmodel.body.ReportItems.Add(PagereportModel.table);

  The issue is we are assigning the data with html tags into a datatable and later assigning it into pagereport. Not sure why the html tags are not working.

• 

  abdias.michael

  

  • Post Options:
  • Link
    Copy

  Posted 24 October 2017, 10:16 pm EST

  I asked the method you’re using to export because there are two methods - one using ExportFilters and the other using RenderingExtenstions. Just wanted to make sure you’re using the right one.

  How are you assigning the html tags to the PageReport? Are you using FormattedText control? Can you attach your report file here for me to check, along with the html that you’re assigning to the PageReport?