Escaping special characters in Kendo PivotGrid for JQuery V1

[JRC.T.6]

Hi there,

Legacy PivotGrid does not support special characters in the column field headers (and possibly elsewhere), e.g. '&'. Is there a recommended escaping strategy - for example if I have a 'you & me' string, how do I transform it? and should I do it before datasource-ing the Pivot or in a header template?

(Looks like PivotGrid V2 does support this out of the box)

Thanks,
Georgi

[Neli]

Hello Alessio,

You can use the columnHeaderTemplate that renders the content of the column header cell and add the needed text there.

- https://docs.telerik.com/kendo-ui/api/javascript/ui/pivotgrid/configuration/columnheadertemplate

<script id="columnTemplate" type="text/x-kendo-template">
    # if (member.name === "[Date].[Calendar].[Year].&[2005]") { #
        <h2>#: member.caption # </h2>
    # } else { #
        text & % $ #: member.caption # 
    # } #
</script>

Here is a Dojo example where the above is demonstrated.

I hope this helps.

Regards,

Neli
Progress Telerik

[JRC.T.6]

Hi Neli,

Thanks for your reply.

In my case the problem is when member.caption has special symbols in it, e.g. when member.caption = 'you & me', then you get

 

If you can please help me to solve this?

 

Regards,

i Vesela Koleda,

Georgi

 

[Peter Milchev]

Hi Georgi, Весела Коледа и на теб!

We have tried to change the caption to the value you suggested but that did not cause any JS errors:

• https://dojo.telerik.com/@pmilchev/AwUzotaJ/3 

Could you please check if updating to the latest version would resolve the issue?

Also, it would be great if you are able to modify the shared dojo or another dojo example to replicate the issue and send it back to us.

Another option would be to make a capture with our new Fiddler Jam browser extension and share the produced link in a private support ticket. A correct capture would allow us to mock the page rendering locally and investigate further.

• https://docs.telerik.com/kendo-ui/fiddler-jam-integration 

[JRC.T.6]

Hi Petar and Neli,

Щастлива и успешна нова година!

One easy way to replicate the problem in the context of your dojo would be to rename all occurrences of 'Beverages' in your products.js file to 'Beverages & more', then click on the caption to expand and you'll get...

 

This works in Pivot grid v2. What would be the recommended strategy to escape the dynamically sourced data in your experience?

Best,
Georgi

 

[Neli]

Hi Alessio,

Thank you for providing additional infromation on how to replicates the issue. There is such bug logged in our official GitHub repository and below you will find a link to the item:

- https://github.com/telerik/kendo-ui-core/issues/3367

In the item there is also a suggested workaround.

Based on your report I have increased the priority of the item.

Regards,

Neli