1. Home
  2. Forum
  3. Blazor
  4. Excel filter for column with template

Excel filter for column with template

Hi,
I have a column that displays an elapsed number of seconds in a formatted string: 
I'm trying to use the Excel filter menu, but it shows the "unformatted" value: 


Is there a way to control the format of the items in the filter menu?

Thanks

3 Replies
RS Renjith Singh Rajendran Syncfusion Team April 15, 2020 01:41 PM UTC

Hi Patrice, 

Thanks for contacting Syncfusion support. 

We are not clear about your Grid model class and the way you are displaying 3m05s in Grid. So we need more details to further proceed on this and provide you a solution as early as possible. Kindly get back to us with the following details for better assistance. 
  1. Share the complete Grid code, or kindly share the sample which you have tried from your side.
  2. Share the model class codes. As we need to check the type of the column with the formatted string.
  3. Are you using template to display the formatted string 3m05s in Grid? If so share those details.

Please get back to us if you need further assistance. 

Regards, 
Renjith Singh Rajendran. 


PT Patrice Tremblay April 27, 2020 04:22 PM UTC

Hi. Sorry for the delay in replying. 

I whipped up a quick sample, starting from the default server-side Blazor app: 
- Replaced the index page with the DataGrid getting started example
- Enabled Excel-type filters
- Added an "AgeInMinutes" calculated field and column - the undelying type is int
- Defined a Column template that uses special formatting for the AgeInMinutes column.

==> The column displays as defined by the template, but when opening the filter dialog, the pick list of items shows the underlying values, not the formatted values.

Is there a way for the filter to display the formatted values?



Attachment: ColumnTemplateSample_6311ec33.zip

RN Rahul Narayanasamy Syncfusion Team April 29, 2020 03:25 AM UTC

Hi Patrice, 
 
Thanks for sharing the details. 
 
We have validated your query with provided sample and we can able to achieve your requirement by using Item template. But currently we do not have support for this requirement. We have considered this “need to provide item template support in blazor” as an feature and added this feature request to our database. We are always trying to make our products better and feature requests like yours are a key part of our product growth efforts. 
 
You can now track the current status of your request, review the proposed resolution timeline, and contact us for any further inquiries through this link.  
 
 
This feature will be included in our upcoming Volume 2, 2020 release. Until then we appreciate your patience.  

Regards,
Rahul 
 


Loader.
Up arrow icon