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

ITemplateMarkersProcessor and Localization

Thread ID:





73327 May 1,2008 06:48 PM UTC May 2,2008 01:28 PM UTC WinForms 1
Tags: XlsIO
Andreas Haack
Asked On May 1, 2008 06:48 PM UTC


I'm using the ITemplateMarkersProcessor with generic List of business objects which have a Property
public DateTime Datum { get; set; }

The excel column where the values are be inserted is preformatted to display datetime values in the "Central European style" meaning that April, the 15th 2008 should outcome as "15.04.2008". The locale of the excel column is set to German (Germany).

But after having called ApplyMarkers the outcome is "04.15.2008".

The culture of the app is set to "de-DE". I am using VS 2008 Prof. (English Version) with Syncfusion Backofficestudio

How can I preserve the localisation?


Yavanaarasi G [Syncfusion]
Replied On May 2, 2008 01:28 PM UTC

Hi Andreas,

Thank you for your interest in Syncfusion products.

I am able to see the issue that you have mentioned. But this issue can be solved by setting the numberformat. Please refer the below code snippet:

sheet1.Range["B5:B14"].NumberFormat = "dd/mm/yyyy";
//Create Template Marker Processor
//Northwind customers table
ITemplateMarkersProcessor marker = workbook.CreateTemplateMarkersProcessor();
marker.AddVariable("NumbersTable", numbersDt);
//Process the markers in the template.

Here is the sample for your reference:


Please have a look at the above sample and if still the issue exists, could you please try reproducing it in the above sample and send us the modified sample so that we could sort out the cause of the issue and provide you a solution?



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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

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

Live Chat Icon For mobile
Live Chat Icon