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. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

PrintTitleRows does not work with an apostrophe in the worksheet name

Thread ID:

Created:

Updated:

Platform:

Replies:

98398 Feb 24,2011 04:11 PM UTC Feb 25,2011 12:25 PM UTC ASP.NET Web Forms (Classic) 1
loading
Tags: XlsIO
Ram Thatikonda
Asked On February 24, 2011 04:11 PM UTC

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 [Syncfusion]
Replied On February 25, 2011 12:25 PM UTC

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



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

;