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: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Problem with tab space export

Thread ID:

Created:

Updated:

Platform:

Replies:

106505 Jan 10,2013 01:06 PM UTC Jan 16,2013 12:32 PM UTC WinForms 1
loading
Tags: XlsIO
luknowak
Asked On January 10, 2013 01:06 PM UTC

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 [Syncfusion]
Replied On January 16, 2013 12:32 PM UTC

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

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

;