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