Problem with tab space export

[luknowak]

Hi,

I exported some text with tab character (e.g. \tSampleText) to Excel (.xlsx). Why after opening the file in Excel 2007 the cell shows a question mark icon instead of tab space (s. screenshot in attachment)?

I have template Excel (ExcelTemplateResource) file in Assembly (e.g. test1.xls). I read this file from assembly and fill with Marker.AddVariable method.
I set InputVersion = ExcelVersion.Excel97to2003.
I save this input version into OutputVersion = ExcelVersion.Excel2007.

Code:
string resourceLocation = this.GetType().Namespace + "." + ExcelTemplateResource;
Stream stream = Assembly.GetExecutingAssembly().GetManifestResourceStream(resourceLocation);
IWorkbook workbook = excelEngine.Excel.Workbooks.Open(stream);
workbook.Version = OutputVersion;
Marker = workbook.CreateTemplateMarkersProcessor();
this.CreateMarkers(); // private method which use the method Marker.AddVariable()
this.Marker.ApplyMarkers(UnknownVariableAction.Skip);
workbook.SaveAs("outTest.xlsx");

I use Syncfusion.XlsIO.Base.dll v. 9.203.0.137.

excel cell_73c0a0d7.zip

[Manikandan M]

Hi luknowak,

Thanks for using Syncfusion products.

We are afraid that we are not able reproduce the issue "" from our side. We have attached the sample ,which we used to reproduce the issue, in the below link.

Sample link:SilverlightApplication_TemplateMarker.zip

If the above sample does not meet with your sample scenario, please modify the above sample to reproduce the issue and revert back us.

Thank you very much for your patience.

Please let us know if you need any clarifications.

Thanks,
Manikandan.M