Telerik report. Export to Excel. Ampersand (&) doubling.

[Andrey]

Hello,

  There is a text box in the report "PageHeaderSection" section.
  The text box contains following value:

   textBoxPageInfo.Value = "&P";
   textBoxPageInfo.Format = "";

  The "DefaultPageHeader" is set to "true" (page header renders into excel header):
  deviceInfo.Add("DefaultPageHeader", true);

  But after exporting in the Excel the value contains two ampersands: "&&P" (see picture).

  How can I avoid that?

  Do you have some ideas?

Thanks,
-Andrey Popov

[Peter]

Hi Andrey,

The ampersand is a special character in Excel’s headers and footers. For instance, if you enter the date or the time, Excel puts an ampersand before the entry. In order to show a one literal ampersand in the header or footer, two ampersands are used in excel editor. Check out Microsoft article on the topic: Use headers and footers in worksheet printouts.

Greetings,
Peter
the Telerik team

[Andrey]

Hello Peter,

  Than you for your reply.

  The "&P" is a Excel multilanguage macros which returns the page number in the header or footer (http://msdn.microsoft.com/en-us/library/bb225426(v=office.12).aspx) and I need to get it in a header.
  If I am trying two ampersands (textBoxPageInfo.Value = "&&P";) Excel shows 4 ampersands: "&&&&P", I do not need that.

  Is there a way how to export into the Excel the "&P" command (see picture)?

  Please help me with that issue.

Thanks,
-Andrey Popov

[Peter]

Hello Andrey,

The excel commands are only supported in Excel but Telerik Reporting renders reports in multiple formats. In this line of thoughts specific functionality dedicated to one rendering extensions such as VBA codes/commands are not supported.

Regards,
Peter
the Telerik team