Environment.NewLine in CenterFooter

Aspose.Cells Product Family
1

Please advise on the following problem.


I am inserting a &P + Environment.NewLine + text into a Sheet Footer (either by code or via the Excel UI),

and exporting this sheet to PDF with the code

wb.Save(pdfFileName, Aspose.Cells.SaveFormat.Pdf);


The problem is that the exported PDF footer shows

1_x000D_text,

instead of

1

text

2

Hi,


Please see the following sample code for your requirements:

Sample code:
Workbook workbook = new Workbook(“e:\test\Book1.xls”);
PageSetup pageSetup = workbook.Worksheets[0].PageSetup;
pageSetup.SetFooter(1, “&P\ntest”);
workbook.Save(“e:\test2\outfooters_test.xls”);


Thank you.