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

ITemplateMarkersProcessor and Localization

Thread ID:

Created:

Updated:

Platform:

Replies:

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

Hello,

I'm using the ITemplateMarkersProcessor with generic List of business objects which have a Property
[DataMember]
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 6.2.0.40.

How can I preserve the localisation?

Bye
Andreas


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:


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


Here is the sample for your reference:

http://websamples.syncfusion.com/samples/XlsIO.Windows/F-73327/main.htm


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?


Regards,
G.Yavana




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

;