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

Template Marker display blank instead of NULL for nullable types

Thread ID:





116188 Apr 22,2014 06:32 AM UTC May 2,2014 12:30 PM UTC WPF 3
Tags: XlsIO
Benjamin Rogers
Asked On April 22, 2014 06:32 AM UTC

I have a class with nullable types that I am binding to template markers. When the nullable type field is null the ApplyMarkers routine displays NULL. Is there anyway to get it to display an empty string instead. Eg: I have the following field

public int? GoalClicks;

When GoalClicks is null ApplyMarkers displays NULL in the Excel spreadsheet cell. I want it to display nothing instead. At the moment it is doing

Goal (Imps)   Goal (Clicks)  Goal(Acqs)

4,000              NULL             NULL

I want it to do

Goal (Imps)   Goal (Clicks)  Goal(Acqs)


Any help with this would be appreciated. Thank you

Regards Ben

Saravanan M [Syncfusion]
Replied On April 25, 2014 07:37 AM UTC

 Hi Benjamin,

 Thank you for contacting Syncfusion support,

Could you please tell your control name with us? It would be helpful to analyze this query further and provide better solution to you.



Benjamin Rogers
Replied On April 27, 2014 10:06 PM UTC

It is the ITemplateMarkersProcessor interface on Syncfusion.XlsIO. Eg:

IWorkbook workbook


ITemplateMarkerProcessor marker = workbook.CreateTemplateMarkersProcessor();

marker.AddVariable("CampaignDetails", new CampaignDetail[] { dataSource.CampaignDetail });



Prasanth M [Syncfusion]
Replied On May 2, 2014 12:30 PM UTC

Hi Benjamin,

We have created an incident 124503 for the above query. We would like to inform you, to follow the incident 124503 for further updates.



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