PrintTitleRows does not work with an apostrophe in the worksheet name

[Ram Thatikonda]

Hi Syncfusion,

It looks like if the sheet name has an apostrophe, the PrintTitleRows setting fails.

I am providing a sample code below.

private static void CreateExcelReport3()
{
ExcelEngine excelEngine = null;
IApplication application = null;
IWorkbook workbook = null;
IWorksheet sheet = null;

try
{
#region syncfusion XlsIO definition
//New instance of XlsIO is created.[Equivalent to launching MS Excel with no workbooks open].
//The instantiation process consists of two steps.

//Step 1 : Instantiate the spreadsheet creation engine.
excelEngine = new ExcelEngine();
//Step 2 : Instantiate the excel application object.
application = excelEngine.Excel;
#endregion

workbook = application.Workbooks.Create(3);

sheet = workbook.Worksheets[0];
sheet.Name = "Nitin'S attachement testing";

for (int i = 1; i <= 10; i++)
{
sheet[i, 1].Text = "some text...";
}

sheet.PageSetup.PrintTitleRows = "$1:$5";

//save the excel workbook
workbook.Version = ExcelVersion.Excel2007;
workbook.SaveAs(@".\Sample.xlsx", ExcelSaveType.SaveAsXLS);
System.Diagnostics.Process.Start(@".\Sample.xlsx");

workbook.Close();
excelEngine.Dispose();
}
catch
{
throw;
}
finally
{
//TODO:
}
}

I would appreciate Syncfusion looking into this.

Thanks!

[Sridhar]

Hi Ram,

Thank you for using Syncfusion products.

We are able to reproduce the reported issue at our side and suspect this could be a defect.

So we request you to open a new direct-trac incident with a simple issue reproducing sample for further follow up on this issue.

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

Please, let us know if you require any further clarifications.

Thanks,
Sridhar.S