Exporting from grid issue with Dollar sign ExcelML

[Jaesoon]

I have an issue with the grid exporter when trying to export into the ExcelML format.

 

I have a few columns which have strings but when exporting as the ExcelML format, the string kept being truncated at the same place.

 

Upon further investigation, it appears that for some reason, the Dollar sign ($) is used to signify the beginning and end of a string, hence the comments in the columns all began when it saw the $ sign.

 

I have tried exporting using the Html format and can see that the complete string exports correctly.

 

Is there a reason why exporting as an ExcelML treats $ characters as string begin and end and is there a way to escape this character?

 

 

I am currently using Telerik Silverlight version 2013.3.1016.1050

 

 

Thanks

[Dilyan Traykov]

Hello ,

The dollar sign is treated as a special character in Microsoft Excel. Good explanations of its purpose can be found in the following thread and this blog post.

I'm afraid I'm currently unable to reproduce the issue with the project I attached to my reply and Excel 2016. By default, the ShouldEncodeValue property of the GridViewElementExportingEventArgs is set to True, which means that special characters will be escaped if you do not explicitly set this property to False.

You can, however, manually escape this character by modifying the exported value in the ElementExporting event of the RadGridView control.

private void RadGridView_ElementExporting(object sender, GridViewElementExportingEventArgs e)
{
    var value = e.Value?.ToString();
    if (value != null && value.Contains("$"))
    {
        e.Value = "'" + value;
    }
}

Here's a thread which suggests possible approaches for escaping characters in Excel formulas.

If the aforementioned approach does not work for you, please let me know how this scenario differs from the setup you have at your end so that I can better assist you.

I'm looking forward to your reply.

Regards,
Dilyan Traykov
Progress Telerik